Developer & DevOps
Sync Google Sheets data with MySQL database
15 nodes
294
160
Automatic trigger
Workflow Description
An automation that transfers data between Google Sheets and MySQL databases, compares changes, and updates records automatically when modified or on a scheduled basis. This ensures data consistency across both platforms without manual intervention.
How it works
- 1.Trigger workflow manually or based on a scheduled timer
- 2.Fetch data from the specified Google Sheets table
- 3.Compare new data against existing MySQL database records
- 4.Insert or update differing records in the MySQL database
- 5.Log synchronization results and any errors encountered
Use cases
- Transfer customer data from planning sheets to production databases
- Keep inventory and pricing tables synchronized across systems
- Periodically update employee and payroll records
Requirements
- Google account with full access to Google Sheets
- MySQL connection credentials (host, user, password, database name)
- Matching column structure between sheet and database table
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Google Sheets
MySQL
Details
Trigger
Automatic trigger
Nodes
15
Apps
2
Views
294
Downloads
160
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (15)
/
When clicking "Execute Workflow"
Manual Trigger
Compare Datasets
Set
Send Notifications
No Op
Schedule Trigger
Schedule Trigger
Google Sheet Data
Google Sheets
SQL Get inquiries from Google
My Sql
Add MySQL records
My Sql
Rename GSheet variables
Set
No reply too long?
If
DB Status assigned?
If
Update GSheet status
Google Sheets
DB Status in sync?
If
Sync MySQL data
My Sql
Sticky Note
Sticky Note
Sticky Note1
Sticky Note