This n8n workflow automates the process of syncing data from a MySQL database to a Google Sheet. It is scheduled to run every 15 minutes, querying for new or unsynced records from a ‘fifa25_customers’ table where the ‘sync’ column is 0. The workflow then appends these new records to a specified Google Sheet and updates the database rows to mark them as synced (setting ‘sync’ to 1). This automation ensures data consistency and saves manual effort in data management. It is useful for maintaining real-time or periodic data exports without duplication, ideal for reporting, analytics, or data sharing scenarios.
Automated MySQL to Google Sheets Synchronization Workflow
Node Count | 6 – 10 Nodes |
---|---|
Nodes Used | googleSheets, if, mySql, noOp, scheduleTrigger, stickyNote |
Reviews
There are no reviews yet.