Daily cash flow reports with Google Sheets, Slack & Email for finance teams
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs on a schedule (cron expression). Along the way it connects Google Sheets, Google Drive, Slack and Pdfmonkey (community). It also calls api.accounting.com over HTTP.
How it runs
Trigger: On a schedule (cron expression).
- Get Cash Inflows (HTTP Request): calls api.accounting.com
- Get Cash Outflows (HTTP Request): calls api.accounting.com
- Calculate Inflows (Code): runs custom JavaScript code
- Calculate Outflows (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Calculate Net Cash Flow (Code): runs custom JavaScript code
- Save to Google Sheets (Google Sheets): append
- Generate HTML Report (Code): runs custom JavaScript code
- Convert to PDF (Pdf Monkey): uses Pdf Monkey
- Post to Slack (Slack): uses Slack
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: api.accounting.com
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-pdfmonkey is verified or supports 3.0 (used in Convert to PDF).
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - Send Email
n8n-nodes-base.emailSend - Google Drive
n8n-nodes-base.googleDrive - Slack
n8n-nodes-base.slack - Pdf Monkey
n8n-nodes-pdfmonkey.pdfMonkey
From the author
Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends…