n8n Workflow: Import Data from Google Sheets into MySQL (Free Template)

Tired of copying and pasting data from Google Sheets into your MySQL database? Manually transferring customer info, sales leads, or inventory updates is not only tedious—it’s error-prone and wastes valuable time. What if you could automate this entire process with a simple, no-code workflow?

In this guide, you’ll learn how to build a powerful n8n workflow to import data from Google Sheets into MySQL—complete with scheduling, error handling, and a downloadable template. Whether you’re a freelancer managing client data, a small business owner tracking orders, or a developer streamlining backend processes, this automation will save you hours every week.

Why Automate Google Sheets to MySQL?

Manually moving data between spreadsheets and databases creates bottlenecks. Every copy-paste action introduces risk—typos, outdated records, or missed updates. For growing businesses, this inefficiency scales into real costs: wasted labor, delayed reporting, and inconsistent data.

Automating the import data from Google Sheets into MySQL process solves these problems by:

• Eliminating manual data entry errors
• Saving 5–10 hours per week on repetitive tasks
• Ensuring real-time or scheduled data synchronization
• Enabling scalable data pipelines without coding

How the n8n Workflow Works

This automation uses three core n8n nodes:

• n8n-nodes-base.cron Triggers the workflow on a schedule (e.g., every hour or daily)
• n8n-nodes-base.googleSheets Reads data from a specified Google Sheet range
• n8n-nodes-base.mySql Inserts or updates records in your MySQL database

The workflow pulls new or updated rows from your spreadsheet and pushes them into MySQL—automatically. You can configure it to run every 15 minutes, daily at midnight, or on-demand.

Step-by-Step: Build the Workflow in n8n

Follow these steps to create your own Google Sheets to MySQL automation:

1. Set Up the Cron Trigger

Add a Cron node to define when the import runs. For example:

• Mode: Every Hour
• Hour: 9–17 (business hours)

This ensures data syncs during active periods without overloading your system.

2. Connect Google Sheets

Use the Google Sheets node to read data:

• Resource: Sheet
• Operation: Get All Rows
• Spreadsheet ID: Paste your Sheet URL or ID
• Range: A1:Z1000 (adjust based on your data)

3. Configure MySQL Insert

Add the MySQL node to write data:

• Operation: Insert
• Database: Your target DB name
• Table: e.g., customers
• Columns: Map Sheet columns to DB fields (e.g., Name → name, Email → email)

n8n automatically matches column names if they’re identical. For custom mappings, use an IF or Set node to transform data before insertion.

4. Test & Deploy

Run the workflow manually first to verify data flows correctly. Check your MySQL table for imported records. Once confirmed, activate the cron schedule.

Common Errors & Troubleshooting

Even the best workflows hit snags. Here’s how to fix common issues:

• Authentication Failed: Reconnect Google Sheets and MySQL credentials in n8n
• Column Mismatch: Ensure Sheet headers match MySQL column names (case-sensitive)
• Duplicate Entries: Add a Merge node or use INSERT IGNORE in MySQL
• Timeout Errors: Reduce batch size or increase cron interval

Who Should Use This Workflow?

This automation is ideal for:

• Freelancers managing client leads or project tracking
• Small businesses syncing sales data from forms to databases
• Developers building no-code data pipelines

Final Thoughts

Automating data transfer between Google Sheets and MySQL isn’t just convenient—it’s a competitive advantage. By eliminating manual work, you reduce errors, save time, and ensure your database stays current without lifting a finger.

With n8n’s visual workflow builder, even non-developers can create robust automations in minutes. And with our free template, you’re just one click away from transforming how your business handles data.