Reconcile daily Google Drive CSV exports into a master file and send a Slack recap
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 12 nodes and runs on a schedule (cron 0 6 * * *). Along the way it connects Google Drive and Slack.
How it runs
Trigger: On a schedule (cron 0 6 * * *).
- List CSV Files in Folder (Google Drive): search (file folder)
- Download Each CSV (Google Drive): download (file)
- Parse CSV Rows (Extract from File): extracts data from a file (csv)
- Reconcile CSVs (Code): runs custom JavaScript code
- Master Rows (Code): runs custom JavaScript code
- Reject Rows (Code): runs custom JavaScript code
- Post Recap to Slack (Slack): post (message)
- Build Master CSV (Convert to File): converts data to a file (csv)
- Build Reject CSV (Convert to File): converts data to a file (csv)
- Upload Master CSV (Google Drive): upload (file)
…plus 1 more step. 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 (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Code
n8n-nodes-base.code - Convert to File
n8n-nodes-base.convertToFile - Slack
n8n-nodes-base.slack
From the author
Quick overview This workflow runs daily to reconcile multiple CSV exports from a Google Drive folder into a deduplicated master CSV, quarantine invalid or duplicate rows into a reject CSV, and post a run summary to a Slack channel. How it works 1. Runs every…