Google Sheets and MySQL integration

n8n lets you integrate Google Sheets with MySQL to build powerful workflows. Design automation that extracts, transforms and loads data between your apps and services. You can choose from thousands of ready-made apps or use our universal HTTP connector to sync apps not yet in our library.

Integrate Google Sheets and MySQL

Get started

Build your own Google Sheets and MySQL integration

Create custom Google Sheets and MySQL workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

How to connect Google Sheets and MySQL

Step 1: Add the first step
Step 2: Add Google Sheets and MySQL nodes
Step 3: Connect Google Sheets and MySQL
Step 4: Run workflow

Import data from MySQL into Google Sheets

This workflow queries a table in MySQL and inserts the data into Google Sheets.

Nodes used in this workflow

Get started

Copy workflow

Popular Google Sheets and MySQL workflows

Over 3000 companies switch to n8n every single week

Google Sheets supported actions

Document
Sheet Within Document

Create

Create a spreadsheet

Delete

Delete a spreadsheet

Append or Update Row

Append a new row or update an existing one (upsert)

Append Row

Create a new row in a sheet

Clear

Delete all the contents or a part of a sheet

Create

Create a new sheet

Delete

Permanently delete a sheet

Delete Rows or Columns

Delete columns or rows from a sheet

Get Row(s)

Retrieve one or more rows from a sheet

Update Row

Update an existing row in a sheet

MySQL supported actions

Database

Delete

Delete an entire table or rows in a table

Execute SQL

Execute an SQL query

Insert

Insert rows in a table

Insert or Update

Insert or update rows in a table

Select

Select rows from a table

Update

Update rows in a table

Google Sheets and MySQL integration: Step-by-step video guide

Google Sheets and MySQL integration details

Google Sheets is a web-based spreadsheet program offered by Google for free. It similar to Microsoft Excel, and can be accessed anywhere on any device, you only need a Google account.

Google Sheets node docs + examples

Google Sheets credential docs

See Google Sheets integrations

Related categories

Data & Storage

Productivity

The relational database management system MySQL is free and open-source. Although MySQL includes standalone clients that let users communicate with a MySQL database directly using SQL, it is more frequently used in conjunction with other applications to develop applications that require relational database functionality.

MySQL node docs + examples

MySQL credential docs

See MySQL integrations

Related categories

Development

Data & Storage

Google Sheets and MySQL integration tutorials

Tips

6 e-commerce workflows to power up your Shopify store

Want to power up your online business and win back time? Discover how no-code workflow automation can help!

Tips

15 Google apps you can combine and automate to increase productivity

Learn how to combine and automate popular Google apps for more productivity in the workplace.

Tutorial

Automatically adding expense receipts to Google Sheets with Telegram, Mindee, Twilio, and n8n

Learn to automate adding expense receipts to Google Sheets using a Telegram Bot, Mindee API, Twilio, and n8n.

Tutorial

How to compare databases via the Compare Datasets node: a step-by-step tutorial

Learn to compare databases automatically, be it SQL tables or data from your favorite CRM. Grab this step-by-step tutorial with a free customizable workflow!

Tutorial

How to import XML to Google Sheets: 3 step-by-step techniques

Learn three different ways to import XML to Google sheets: with Google sheet’s IMPORTXML function, with Google AppScript and automation with n8n.

Tutorial

How to pull data from Google Spreadsheet to HTML: Code and no code approaches

Learn how to pull data from Google Spreadsheet to HTML using Google Apps Script and n8n automation tool.

Looking to integrate Google Sheets and MySQL in your company?

Why use n8n to integrate Google Sheets with MySQL

Build complex workflows, really fast

Handle branching, merging and iteration easily.
Pause your workflow to wait for external events.

Code when you need it, UI when you don't

Simple debugging

Your data is displayed alongside your settings, making edge cases easy to track down.

Use templates to get started fast

Use 1000+ workflow templates available from our core team and our community.

Reuse your work

Copy and paste, easily import and export workflows.

Implement complex processes faster with n8n

Get started

Google Sheets and MySQL integration

Build your own Google Sheets and MySQL integration

How to connect Google Sheets and MySQL

Step 1: Add the first step

Step 2: Add Google Sheets and MySQL nodes

Step 3: Connect Google Sheets and MySQL

Step 4: Run workflow

Import data from MySQL into Google Sheets

Popular Google Sheets and MySQL workflows

Import data from MySQL into Google Sheets

Import data from Google Sheets into MySQL

Sync Google Sheets data with MySQL

Over 3000 companies switch to n8n every single week

Google Sheets supported actions

MySQL supported actions

Google Sheets and MySQL integration: Step-by-step video guide

Google Sheets and MySQL integration details

Google Sheets and MySQL integration tutorials

6 e-commerce workflows to power up your Shopify store

15 Google apps you can combine and automate to increase productivity

Automatically adding expense receipts to Google Sheets with Telegram, Mindee, Twilio, and n8n

How to compare databases via the Compare Datasets node: a step-by-step tutorial

How to import XML to Google Sheets: 3 step-by-step techniques

How to pull data from Google Spreadsheet to HTML: Code and no code approaches

Why use n8n to integrate Google Sheets with MySQL

Build complex workflows, really fast

Code when you need it, UI when you don't

Simple debugging

Use templates to get started fast

Reuse your work