Quick Overview
Quick Overview This workflow collects a CSV bank statement via an n8n form, detects stable recurring charges, and uses Google Gemini to classify subscriptions and recommend keep/review/cancel. It emails the results via Gmail and saves each subscription to Google Sheets for ongoing tracking. How it works Receives a form submission with the user’s email address and a CSV statement upload. Extracts transactions from the CSV and groups similar descriptions to detect recurring charges that appear at least twice with a stable amount. If no recurring charges are found, sends a Gmail message asking the user to upload a longer statement period. If recurring charges are found, sends the summarized list to Google Gemini to identify each service, estimate monthly/annual costs, and recommend keep/review/cancel, then parses the structured results. Emails the user a subscription audit summary, including total annual cost, potential savings, and which subscriptions to keep versus cancel or review. Splits the subscription list into individual items and appends or updates rows in a Google Sheets “Subscriptions” tab so repeated audits update existing entries. Setup Create and connect credentials for Google Gemini (PaLM) API, Gmail OAuth2, and Google Sheets OAuth2. Select the target Google Sheets spreadsheet and set the sheet/tab name to “Subscriptions” in the Google Sheets node. Share the n8n form URL and ensure users upload 3–12 months of statements as a CSV with Date, Description (or similar), and Amount (or similar) columns. An n8n automation workflow template by Oka Hironobu.
Oka Hironobu
web
free
Others in the same category, ranked by how often they are opened.
