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.

Результат

Automated ingestion of invoice emails into Notion reduces manual effort, provides real‑time cost analysis, and helps users decide whether to keep, downgrade, or cancel subscriptions.

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

• Search Gmail for invoice/receipt emails newer than one day
• Extract sender, date, and dollar amount via regex
• POST the extracted data to Notion API to create a page in the database
• Use Notion formulas to calculate monthly equivalent cost and cost per hour saved
• Flag each subscription as Keep, Downgrade, or Cancel based on cost per hour saved

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

Instead of paying for Zapier just to parse receipt emails, you can run a 40-line Google Apps Script on a daily time trigger inside your Google account:

Источник

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.

Источник

From there, a simple conditional formula flags each row as Keep, Downgrade, or Cancel (Unused).

Источник