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

说明与用途

使用 Notion API、Google Apps Script 和 n8n 自动化 SaaS 订阅审计，自动从邮件中提取发票数据，存入 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.

来源