Import Google Sheets Data to MySQL Weekly - n8n Workflow | Neura Market
Import Google Sheets Data to MySQL Weekly
Automates weekly import of data from Google Sheets into MySQL database using a cron trigger. Ideal for syncing sales or commission data effortlessly.
This workflow automates the periodic import of data from a Google Sheets spreadsheet into a MySQL database. It starts with a Cron node configured to trigger every week at 5 AM, ensuring hands-free operation. The Google Sheets node then reads data from a specified sheet using OAuth2 authentication, pulling columns like title and price. Finally, the MySQL node inserts this data into a 'books' table with options for ignoring duplicates and low-priority execution to avoid performance issues.
Key be
Platform
n8n
Category
Sales
Price
$5.99
Creator
Jordi Faber
Google Sheets
MySQL
Data Import
Cron Scheduler
Automation
Database Sync
Sales Tracking
Commission
Weekly Trigger
ETL
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.