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.

结果

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).

来源