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

Stop Wasting Hours on Manual Data Entry—Automate MySQL to Google Sheets Now

If you're manually copying data from your MySQL database into Google Sheets every week—or worse, every day—you're not alone. But you’re also wasting precious time that could be spent growing your business, serving clients, or actually sleeping.

The good news? You can automate this entire process in under 15 minutes using n8n, a powerful, open-source workflow automation tool that connects your apps without requiring a single line of code.

Why Automate MySQL to Google Sheets?

Whether you're a freelancer tracking client projects, a small business owner managing inventory, or a developer building internal tools, keeping your Google Sheets in sync with your MySQL database is critical—but tedious.

• Eliminate manual errors: No more copy-paste mistakes or outdated rows.
• Save 5–10 hours per week: Automate daily or weekly syncs with a cron schedule.
• Make faster decisions: Always work with the latest data in your dashboards and reports.
• No coding needed: Built for freelancers and non-devs using n8n’s visual editor.

How This n8n Workflow Works

This automation uses three core n8n nodes:

• n8n-nodes-base.cron Triggers the workflow on a schedule (e.g., every morning at 8 AM).
• n8n-nodes-base.mySql Connects to your MySQL database and runs a SELECT query to fetch fresh data.
• n8n-nodes-base.googleSheets Writes the retrieved data directly into your specified Google Sheet—overwriting or appending as configured.

Step-by-Step: Set Up Your MySQL to Google Sheets Automation

Follow these steps to deploy your own Import data from MySQL into Google Sheets automation in n8n.

Step 1: Install the Pre-Built Workflow

Instead of building from scratch, use our tested template:

Step 2: Configure Your MySQL Connection

In the MySQL node, enter your database credentials:

• • Host (e.g., localhost or your cloud DB URL)
• • Database name
• • Username & password
• • Port (default: 3306)

Security note: Use environment variables or n8n’s credential system—never hardcode secrets.

Step 3: Set Up Google Sheets Access

Connect your Google account via OAuth. Then specify:

• • Spreadsheet ID (found in the URL)
• • Sheet name (e.g., Sheet1)
• • Whether to append or overwrite data

Step 4: Schedule with Cron

Use the cron node to define how often the sync runs. Examples:

// Every day at 8 AM
0 8 * * *

// Every Monday at 6 AM
0 6 * * 1

// Every 6 hours
0 */6 * * *

Step 5: Test & Activate

Click “Execute Workflow” to test. Check your Google Sheet—your MySQL data should appear instantly. Once confirmed, toggle the workflow to “Active.”

Who Is This For?

This n8n MySQL Google Sheets workflow is ideal for:

• Freelancers who track client projects or invoices in MySQL and report in Sheets.
• Small business owners managing inventory, orders, or CRM data.
• Developers building internal tools without relying on paid SaaS connectors.

Troubleshooting Common Issues

Even simple automations can hit snags. Here’s how to fix the most common ones:

❌ “MySQL Connection Failed”

Double-check your host, port, and firewall settings. If using a cloud DB (like AWS RDS), ensure public access is enabled or use SSH tunneling.

❌ “Google Sheets Permission Denied”

Re-authenticate your Google account in n8n. Make sure the spreadsheet is shared with the email linked to your Google OAuth.

❌ Data Not Updating

Verify your cron expression. Test with a shorter interval (e.g., every 5 minutes) during setup.

Why Choose n8n Over Zapier or Make?

While tools like Zapier offer similar functionality, n8n gives you more control, lower costs, and full ownership of your data.

Learn more about n8n vs Zapier or explore other free n8n templates to supercharge your workflows.

Final Thoughts: Automate Smarter, Not Harder

Manually moving data between MySQL and Google Sheets isn’t just tedious—it’s a bottleneck that slows down your entire operation. With this step-by-step n8n Import data from MySQL into Google Sheets tutorial, you’ve got everything you need to go from zero to automated in minutes.