Description:
This n8n template automates the process of syncing new records from a MySQL database table into a Google Sheet, ideal for reporting, backup, or lightweight dashboards.
It is designed for teams or individuals who need to periodically export new data rows from a custom database (e.g., CRM, registrations, surveys) into a structured Google Sheet for further analysis, sharing, or archiving—without duplicates.
sync = 0
) from a MySQL table (fifa25_customers
).sync = 1
) to avoid reprocessing.Create or select a Google Sheet and make sure the columns match the following:
id
, name
, phone
, birthdate
, email
, region
, gender
, datatime
Ensure your MySQL table (fifa25_customers
) has a sync
column (default = 0 for new rows).
Connect your MySQL and Google Sheets credentials inside n8n.
(Optional): Add custom filtering or column transformations as needed.
IF
node to prevent unnecessary processing