Shopify to Google Sheets
Send Shopify data to Google Sheets automatically
Shopify
- Mammoth
Google Sheets
Order Date Product Total #1042 Nov 12 Trail jacket $189.00 #1043 Nov 12 Wool socks (3) $36.00 #1044 Nov 13 Day pack $74.50 #1045 Nov 13 Trail jacket $189.00
Shown on sample data.
Set up Shopify to Google Sheets in three steps
- Step 1
Connect Shopify
Enter your store's .myshopify.com address, then approve Mammoth in Shopify.
- OrdersProductsCustomersRefundsStep 2
Pick your fields
Tick the store tables and columns you want, or ask for the data in plain words.
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 Shopify data refreshes every day, or only when you ask. You can set a different schedule.
| Order | Date | Product | Total |
|---|---|---|---|
| #1042 | Nov 12 | Trail jacket | $189.00 |
| #1043 | Nov 12 | Wool socks (3) | $36.00 |
| #1044 | Nov 13 | Day pack | $74.50 |
Clears the tab, then writes every row again.
Best for a current view, like this month's numbers.
| Order | Date | Product | Total |
|---|---|---|---|
| #1042 | Nov 12 | Trail jacket | $189.00 |
| #1043 | Nov 12 | Wool socks (3) | $36.00 |
| #1045 | Nov 13 | Trail jacket | $189.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 Shopify data first
Mammoth gets the data ready before it goes to Google Sheets.
Add your other data
Join Shopify with Google Ads, Facebook Ads, Xero or 100+ other sources.
Fix the data first
Remove duplicates, fill blanks and fix formats. The same fixes run every time.
Net sales = Total − Discounts − RefundsAdd the columns you need
Work out net sales, margin or week so they arrive ready to use.
What teams use Shopify in Google Sheets for
Daily sales log
Every order added to the sheet as the day goes on.
Stock planning
Units sold by product, ready for the next order.
Bookkeeping
Sales, discounts and refunds by day for the accounts.
Ways to get Shopify data into Google Sheets
Mammoth
For Shopify data in a sheet, joined with your ad spend and accounts.
- ✓Updates on a schedule
- ✓Clean the data before it reaches the sheet
- ✓Join ad spend or accounting data
- ✓Send the same data to Excel, Power BI or a warehouse
Shopify's order export
For a one-off CSV of your orders.
- ✕Updates on a schedule
- ~Clean the data before it reaches the sheetBy hand
- ~Join ad spend or accounting dataPasted in by hand
- ✕Send the same data to Excel, Power BI or a warehouse
Or turn the same data into a Shopify dashboard
Describe the dashboard in one sentence and Mammoth builds it from your data.
The template: paste this into Mammoth
Shopify sales: net sales, orders, average order value, units sold, discounts and returns as KPIs, a daily net sales trend, net sales by product type, and net sales by sales channel

Common questions about Shopify to Google Sheets
How do I connect Shopify to Google Sheets?
Does Google Sheets update automatically?
Can I add new rows instead of overwriting the sheet?
Is there a size limit?
What about a large store?
Step-by-step setup is in our docs for Shopify and Google Sheets.
Keep Google Sheets up to date with Shopify data.
Start free, connect Shopify, and send it to Google Sheets.
- ✓ 14-day Pro trial
- ✓ No credit card
- ✓ Viewers always free