{"product_id":"detect-saas-subscription-leaks-n8n-google-drive-gmail","title":"Detect SaaS Subscription Leaks: n8n Google Drive + Gmail","description":"\u003ch3\u003eDetect SaaS subscription leaks automatically—using your Google Drive, Gmail, and inventory data\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow audits SaaS spend by combining \u003cstrong\u003ecorporate card CSVs from Google Drive\u003c\/strong\u003e, \u003cstrong\u003einvoice\/receipt emails from Gmail\u003c\/strong\u003e (parsed with OpenAI), and your \u003cstrong\u003eSaaS Inventory in Google Sheets\u003c\/strong\u003e. It then flags likely subscription waste and generates a prioritized cancellation\/optimization plan—delivered to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eemail\u003c\/strong\u003e, and \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly or on-demand\u003c\/strong\u003e: Manual trigger or every Monday at 9 AM, loading configuration values (folder IDs, Google Sheet ID, thresholds, report email, and Slack channel).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses corporate card statements\u003c\/strong\u003e: Pulls statement \u003cstrong\u003eCSV files from Google Drive\u003c\/strong\u003e, downloads them, normalizes rows into consistent charge records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts SaaS invoice line items from Gmail\u003c\/strong\u003e: Fetches recent invoice\/receipt emails, batches them, and uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to extract structured SaaS invoice details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCross-references multiple sources\u003c\/strong\u003e: Merges card charges, extracted invoice data, and the \u003cstrong\u003e“SaaS Inventory”\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects subscription leaks\u003c\/strong\u003e: Flags issues such as \u003cem\u003ezombie charges\u003c\/em\u003e, \u003cem\u003eduplicate charges\u003c\/em\u003e, \u003cem\u003eunused tools\u003c\/em\u003e, \u003cem\u003eseat waste\u003c\/em\u003e, \u003cem\u003eprice increases\u003c\/em\u003e, \u003cem\u003eoverlapping tools\u003c\/em\u003e, and \u003cem\u003eshadow subscriptions\u003c\/em\u003e, calculating potential monthly and annual savings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReports only when needed\u003c\/strong\u003e: If leaks are found, generates a prioritized cancellation\/optimization plan and sends an HTML report via \u003cstrong\u003eGmail\u003c\/strong\u003e and a summary to \u003cstrong\u003eSlack\u003c\/strong\u003e. If none are found, it ends without sending reports.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly SaaS spend audits for automation engineers managing budgets across tools and vendors.\u003c\/li\u003e\n  \u003cli\u003eDetecting shadow subscriptions and duplicate billing when teams change seats or renewals.\u003c\/li\u003e\n  \u003cli\u003eQuarterly optimization reporting with prioritized cancellation guidance.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Drive, Gmail, Google Sheets, Slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI extraction\u003c\/strong\u003e: OpenAI (gpt-4o-mini) for invoice\/receipt line-item extraction and plan generation\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n node approach\u003c\/strong\u003e: if, set, code, no op, gmail, merge (plus Google credential setup via OAuth2)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114590032051,"sku":"N8N-20034","price":74.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PPvmPG5m1J6X1amvP4zi_VQYwKTxP.png?v=1790586140","url":"https:\/\/buyflowscripts.com\/products\/detect-saas-subscription-leaks-n8n-google-drive-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}