Templates / Sync Google Sheets data with MySQL

Sync Google Sheets data with MySQL

Ready for 3.0

by n8n Team ✓ · 9,467 views · created 2023-10-06 · Engineering

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 13 nodes and runs on a schedule (cron */30 6-22 * * 1-5) (plus 1 other trigger). Along the way it connects Google Sheets and MySQL.

How it runs

Trigger: On a schedule (cron */30 6-22 * * 1-5) (plus 1 other trigger).

  1. Google Sheet Data (Google Sheets): uses Google Sheets
  2. SQL Get inquiries from Google (MySQL): select
  3. Rename GSheet variables (Edit Fields (Set)): sets or maps fields
  4. Compare Datasets: uses Compare Datasets
  5. Add MySQL records (MySQL): create or update
  6. No reply too long? (If): checks a condition and branches into true / false
  7. DB Status assigned? (If): checks a condition and branches into true / false
  8. DB Status in sync? (If): checks a condition and branches into true / false
  9. Update GSheet status (Google Sheets): update
  10. Sync MySQL data (MySQL): update

Services it uses

Google SheetsMySQL

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (8)

From the author

This workflow performs several data integration and synchronization tasks between Google Sheets and a MySQL database. Here is a step-by-step description of what this workflow does: 1. Manual Trigger: The workflow starts when the user clicks "Execute…

Excerpt from n8n Team's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.