Automating SaaS Subscription Audits with the Notion API, Google Apps Script, and n8n

Описание и применение

Автоматизация аудита SaaS‑подписок с помощью Notion API, Google Apps Script и n8n позволяет автоматически извлекать данные из писем‑счётов, сохранять их в базе Notion и оценивать стоимость подписки по часам, экономя время и деньги.

Задача

Freelancers and small projects often lose track of low‑cost SaaS and API subscriptions, leading to unnecessary spending.

Результат

The setup automatically logs invoice emails into Notion, calculates cost per hour saved, and flags subscriptions for action, eliminating manual entry and reducing wasted spend.

Рабочий процесс

• Search Gmail threads matching "subject:(invoice OR receipt) newer_than:1d".
• Extract sender name, date, and dollar amount via regex.
• Send a POST request to https://api.notion.com/v1/pages to append the row to the Notion database.
• (Optional) Use n8n: Gmail Trigger → OpenAI Chat Model (extract vendor, amount, billing cycle as JSON) → Notion Node (create page) → Slack Node (notify on yearly renewal).

Доказательства

One recurring issue when running small projects or freelancing is losing track of $10 to $49/mo SaaS and API subscriptions.

Источник

To fix this without paying for another recurring SaaS tool, I put together a lightweight setup that logs invoice emails into a Notion database automatically and calculates whether each tool is worth keeping.

Источник

Search Gmail threads matching subject:(invoice OR receipt) newer_than:1d.

Источник

Send a POST request to https://api.notion.com/v1/pages to append the row directly to the Notion database.

Источник