Scheduled Google Sheets data backup to Google Drive
Needs changesWhat this workflow does
This workflow has 3 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Sheets and Google Drive.
How it runs
Trigger: On a schedule (legacy Cron node).
- Read Google Sheet Data (Google Sheets): get many
- Upload Backup to Google Drive (Google Drive): uses Google Drive
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Daily Backup Schedule (2 AM): replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Daily Backup Schedule (2 AM) | Schedule Trigger |
Nodes used (3)
- Cron
n8n-nodes-base.cron - Google Sheets
n8n-nodes-base.googleSheets - Google Drive
n8n-nodes-base.googleDrive
From the author
Overview This workflow regularly backs up a Google Sheet by exporting its data and saving it as a new file (CSV or XLSX) in a specified folder within your Google Drive. This ensures data redundancy and historical versions. Use Case: Critical business data…