MySQL to Google Sheets
Send MySQL data to Google Sheets automatically
MySQL
- Mammoth
Google Sheets
Order ID Customer Status Total 50213 Pine & Co Shipped $412.00 50214 Delta Supply Pending $1,080.00 50215 Marlow Cafe Shipped $96.50 50216 Pine & Co Refunded $58.00
Shown on sample data.
Set up MySQL to Google Sheets in three steps
- Step 1
Connect MySQL
Enter your server's host, port, database and a user with read access.
- TablesJoinsYour SQLStep 2
Pick your fields
Pick a table, or write your own SQL. Mammoth can also write the SQL from a description.
Updated
Step 3Send it to Google Sheets
Pick a new or existing spreadsheet and a tab. Mammoth writes the rows after every refresh.
Choose how Google Sheets updates
Your MySQL data refreshes every day, or only when you ask. You can set a different schedule.
| Order ID | Customer | Status | Total |
|---|---|---|---|
| 50213 | Pine & Co | Shipped | $412.00 |
| 50214 | Delta Supply | Pending | $1,080.00 |
| 50215 | Marlow Cafe | Shipped | $96.50 |
Clears the tab, then writes every row again.
Best for a current view, like this month's numbers.
| Order ID | Customer | Status | Total |
|---|---|---|---|
| 50213 | Pine & Co | Shipped | $412.00 |
| 50214 | Delta Supply | Pending | $1,080.00 |
| 50216 | Pine & Co | Refunded | $58.00 |
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.
Add your other data
Join MySQL with HubSpot, Xero, Google Ads or 100+ other sources.
Fix the data first
Remove duplicates, fill blanks and fix formats. The same fixes run every time.
Lifetime value = Sum of Total by CustomerAdd 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?
Does Google Sheets update automatically?
Can I add new rows instead of overwriting the sheet?
Is there a size limit?
What access does Mammoth need in MySQL?
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