Google Sheets + MySQL

Create Google Sheets rows from new MySQL custom query results

Effortlessly transfer data from your MySQL database to Google Sheets using this seamless workflow. When a new row is created in MySQL based on a custom query, it adds multiple rows to your selected Google Sheets spreadsheet. Maintain organized data and focus on analysis and insights while the automation handles the data transfer for you.

Effortlessly transfer data from your MySQL database to Google Sheets using this seamless workflow. When a new row is created in MySQL based on a custom query, it adds multiple rows to your selected Google Sheets spreadsheet. Maintain organized data and focus on analysis and insights while the automation handles the data transfer for you.

  1. When this happens...
    MySQLMySQL
    New Row (Custom Query)

    Triggers when new rows are returned from a custom query that you provide. Advanced Users Only.

    TriggerScheduled
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Multiple Spreadsheet Rows

    Create one or more new rows in a specific spreadsheet (with line item support).

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Table/ViewRequired

    Trigger
    Scheduled
    Try It
    • QueryRequired

    Trigger
    Scheduled
    Try It
    • Table/ViewRequired

    • Primary KeyRequired

    • Order ByRequired

    • Trigger Column

    Trigger
    Scheduled
    Try It
    • TableRequired

    • ID ColumnRequired

    Action
    Write
    • Table/ViewRequired

    • Order By

    • Dedupe Key

    Trigger
    Scheduled
    Try It
  • MySQL triggers, actions, and search

    New Table

    Triggers when you add a new table.

    Trigger
    Scheduled
    Try It
    • TableRequired

    Action
    Write
    • TableRequired

    • Lookup ColumnRequired

    • Lookup ValueRequired

    Action
    Search
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
mysql logo
mysql logo

About MySQL

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.
Learn more

Related categories

  • Databases

Similar apps

SQL Server integrationsSQL Server integrations

SQL Server

Databases
Quickbase integrationsQuickbase integrations

Quickbase

Databases
Firebase / Firestore integrationsFirebase / Firestore integrations

Firebase / Firestore

Databases