Google Sheets and MySQL integration

Save yourself the work of writing custom integrations for Google Sheets and MySQL and use n8n instead. Build adaptable and scalable Data & Storage, Productivity, and Development workflows that work with your technology stack. All within a building experience you will love.

Get started

See n8n in action

How to connect Google Sheets and MySQL

Step 1: Create a new workflow
Step 2: Add and configure nodes
Step 3: Connect
Step 4: Customize and extend your integration
Step 5: Test and activate your workflow

Step 1: Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Google Sheets and MySQL integration: Create a new workflow and add the first step

Step 2: Add and configure Google Sheets and MySQL nodes

You can find Google Sheets and MySQL in the nodes panel. Drag them onto your workflow canvas, selecting their actions. Click each node, choose a credential, and authenticate to grant n8n access. Configure Google Sheets and MySQL nodes one by one: input data on the left, parameters in the middle, and output data on the right.

Google Sheets and MySQL integration: Add and configure Google Sheets and MySQL nodes

Step 3: Connect Google Sheets and MySQL

A connection establishes a link between Google Sheets and MySQL (or vice versa) to route data through the workflow. Data flows from the output of one node to the input of another. You can have single or multiple connections for each node.

Google Sheets and MySQL integration: Connect Google Sheets and MySQL

Step 4: Customize and extend your Google Sheets and MySQL integration

Use n8n's core nodes such as If, Split Out, Merge, and others to transform and manipulate data. Write custom JavaScript or Python in the Code node and run it as a step in your workflow. Connect Google Sheets and MySQL with any of n8n’s 1000+ integrations, and incorporate advanced AI logic into your workflows.

Google Sheets and MySQL integration: Customize and extend your Google Sheets and MySQL integration

Step 5: Test and activate your Google Sheets and MySQL workflow

Save and run the workflow to see if everything works as expected. Based on your configuration, data should flow from Google Sheets to MySQL or vice versa. Easily debug your workflow: you can check past executions to isolate and fix the mistake. Once you've tested everything, make sure to save your workflow and activate it.

Google Sheets and MySQL integration: Test and activate your Google Sheets and MySQL 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

Import data from MySQL into Google Sheets

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

Import data from Google Sheets into MySQL

This workflow imports data from Google Sheets into a MySQL database.

Sync Google Sheets data with MySQL

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: Manual Trigger: The workflow starts when the user clicks "Execute Workflow." Schedule Trigger: This node schedules the workflow to run at specific intervals on weekdays (Monday to Friday) between 6 AM and 10 PM. It ensures regular data synchronization. Google Sheet Data: This node connects to a specific Google Sheets document and retrieves data from the "Form Responses 1" sheet, filtering by the "DB Status" column. SQL Get inquiries from Google: This node retrieves data from a MySQL database table named "ConcertInquiries" where the "source_name" is "GoogleForm." Rename GSheet variables: This node renames the columns retrieved from Google Sheets and transforms the data into a format suitable for MySQL, assigning a value for "source_name" as "GoogleForm." Compare Datasets: This node compares the data retrieved from Google Sheets and the MySQL database based on timestamp and source_name fields. It identifies changes and updates. No reply too long?: This node checks if there has been no reply within the last four hours, using the "timestamp" field from the Google Sheets data. DB Status assigned?: This node checks if the "DB Status" field is not empty in the compared dataset. Update GSheet status: If conditions are met in the previous nodes, this node updates the "DB Status" field in Google Sheets with the corresponding value from the MySQL dataset. DB Status in sync?: This node checks if the "source_name" field in Google Sheets is not empty. Sync MySQL data: If conditions are met in the previous nodes, this node updates the "source_name" field in the MySQL database to "GoogleFormSync." Send Notifications: If conditions are met in the "No reply too long?" node, this node sends notifications or performs actions as needed. Sticky Notes: These nodes provide additional information and documentation links for users.

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.

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

Other integrations with Google Sheets

Other integrations with MySQL

Google Sheets and MySQL integration tutorials

Database
Tutorial

How to use Google Sheets as a database

Dive into the versatility of Google Sheets as a database with our in-depth comparison of Python scripting and n8n automation. Get 7 free workflows to set up your Google Sheets database in n8n!

Tutorial

How to import CSV into Google Sheets: 3 best methods

Explore 3 efficient methods for importing CSV files into Google Sheets, comparing n8n's automated workflow with the manual import via native Google Sheets interface and the programmatic import via Python.

Database
ITOps

How to work with XML and SQL using n8n

Break the boundaries of your workflow with SQL and XML in n8n. This extensive tutorial details how to export and import data, style XML with XSLT, and efficiently forward XML files for exponential productivity.

Database
Sales
ITOps
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!