Skip to content

MySQL to Google Sheets

Send MySQL data to Google Sheets automatically

Connect MySQL to Mammoth, pick the fields you want and send them to Google Sheets. Mammoth keeps Google Sheets up to date on a schedule, so nobody exports a report by hand.
  1. MySQL
  2. Mammoth
  3. Google Sheets
    Order IDCustomerStatusTotal
    50213Pine & CoShipped$412.00
    50214Delta SupplyPending$1,080.00
    50215Marlow CafeShipped$96.50
    50216Pine & CoRefunded$58.00

Shown on sample data.

Set up MySQL to Google Sheets in three steps

  1. Step 1

    Connect MySQL

    Enter your server's host, port, database and a user with read access.

  2. TablesJoinsYour SQL
    Step 2

    Pick your fields

    Pick a table, or write your own SQL. Mammoth can also write the SQL from a description.

  3. Updated
    Step 3

    Send it to Google Sheets

    Pick a new or existing spreadsheet and a tab. Mammoth writes the rows after every refresh.

Start free and connect MySQL14-day Pro trial · No credit card

Choose how Google Sheets updates

Your MySQL data refreshes every day, or only when you ask. You can set a different schedule.

Google Sheets
Order IDCustomerStatusTotal
50213Pine & CoShipped$412.00
50214Delta SupplyPending$1,080.00
50215Marlow CafeShipped$96.50
Replace

Clears the tab, then writes every row again.

Best for a current view, like this month's numbers.

Google Sheets
Order IDCustomerStatusTotal
50213Pine & CoShipped$412.00
50214Delta SupplyPending$1,080.00
50216Pine & CoRefunded$58.00
Append

Adds new rows under the ones already there.

Best for a running log, like results by week.

A spreadsheet holds up to 10 million cells. For bigger data, use a Live link or a CSV file.

Clean and combine your MySQL data first

Mammoth gets the data ready before it goes to Google Sheets.

Join

Add your other data

Join MySQL with HubSpot, Xero, Google Ads or 100+ other sources.

Status codes turned into wordsDuplicate customers merged
Clean

Fix the data first

Remove duplicates, fill blanks and fix formats. The same fixes run every time.

Lifetime value = Sum of Total by Customer
Calculate

Add the columns you need

Work out lifetime value, order count or month so they arrive ready to use.

What teams use MySQL in Google Sheets for

  • Operations tracker

    Orders by status, current for the team every morning.

  • Customer lists

    Active customers and their totals, for sales and support.

  • Daily KPIs

    Sign-ups, orders and revenue in one tab for leadership.

Ways to get MySQL data into Google Sheets

Mammoth

For MySQL data in a sheet, without writing a script.

  • ✓Updates on a schedule
  • ✓Works without writing code
  • ✓Clean the data before it reaches the sheet
  • ✓Join CRM or accounting data

Apps Script with JDBC

For teams who write and maintain their own script.

  • ~Updates on a scheduleWith a script trigger
  • ✕Works without writing code
  • ~Clean the data before it reaches the sheetIn your script
  • ~Join CRM or accounting dataIn your script

Export a CSV by hand

For a one-off copy of a table.

  • ✕Updates on a schedule
  • ✓Works without writing code
  • ~Clean the data before it reaches the sheetBy hand
  • ~Join CRM or accounting dataPasted in by hand

Common questions about MySQL to Google Sheets

How do I connect MySQL to Google Sheets?
Connect MySQL to Mammoth and pick the fields you want. Then export them to Google Sheets, and Mammoth keeps it up to date.
Does Google Sheets update automatically?
Yes. Your MySQL data refreshes every day, or only when you ask. You can set a different schedule. After each refresh, Mammoth sends the new data to Google Sheets.
Can I add new rows instead of overwriting the sheet?
Yes. Choose Append and Mammoth adds rows under the data already in the tab. Replace clears the tab first.
Is there a size limit?
Google Sheets holds up to 10 million cells in a spreadsheet. For more than that, use a Live link or a CSV file.
What access does Mammoth need in MySQL?
A database user with SELECT permission on the tables you want. Mammoth only reads.

Step-by-step setup is in our docs for MySQL and Google Sheets.

Keep Google Sheets up to date with MySQL data.

Start free, connect MySQL, and send it to Google Sheets.

  • ✓ 14-day Pro trial
  • ✓ No credit card
  • ✓ Viewers always free