Detect SaaS subscription leaks with Google Drive, Gmail, OpenAI, and Slack
Ready for 3.0What this workflow does
This AI workflow has 23 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Drive, Gmail, OpenAI and Google Sheets and 1 more.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Config (Edit Fields (Set)): sets 10 fields: statementsFolderId, inventorySheetId, gmailQuery…
- Find Card Statements (Google Drive): work with file folder
- Fetch Invoice Emails (Gmail): get many
- Read SaaS Inventory (Google Sheets): uses Google Sheets
- Download Statement (Google Drive): download
- Prepare Invoice Batch (Code): runs custom JavaScript code
- Wait for All Sources (Merge): merges the data from its input branches
- Parse Statement CSV (Extract from File): extracts data from a file
- Extract Invoice Data (OpenAI): uses OpenAI
- Detect Leaks (Code): runs custom JavaScript code
…plus 10 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Slack
n8n-nodes-base.slack
From the author
Quick overview This workflow runs weekly (or manually) to audit SaaS spend by combining corporate card CSVs from Google Drive, invoice/receipt emails from Gmail parsed with OpenAI, and a SaaS inventory in Google Sheets, then flags potential waste and sends a…