Skip to content

Shopify to Google Sheets

Send Shopify data to Google Sheets automatically

Connect Shopify 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. Shopify
  2. Mammoth
  3. Google Sheets
    OrderDateProductTotal
    #1042Nov 12Trail jacket$189.00
    #1043Nov 12Wool socks (3)$36.00
    #1044Nov 13Day pack$74.50
    #1045Nov 13Trail jacket$189.00

Shown on sample data.

Set up Shopify to Google Sheets in three steps

  1. Step 1

    Connect Shopify

    Enter your store's .myshopify.com address, then approve Mammoth in Shopify.

  2. OrdersProductsCustomersRefunds
    Step 2

    Pick your fields

    Tick the store tables and columns you want, or ask for the data in plain words.

  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 Shopify14-day Pro trial · No credit card

Choose how Google Sheets updates

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

Google Sheets
OrderDateProductTotal
#1042Nov 12Trail jacket$189.00
#1043Nov 12Wool socks (3)$36.00
#1044Nov 13Day pack$74.50
Replace

Clears the tab, then writes every row again.

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

Google Sheets
OrderDateProductTotal
#1042Nov 12Trail jacket$189.00
#1043Nov 12Wool socks (3)$36.00
#1045Nov 13Trail jacket$189.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 Shopify data first

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

Join

Add your other data

Join Shopify with Google Ads, Facebook Ads, Xero or 100+ other sources.

Test orders removedRefunds matched to their orders
Clean

Fix the data first

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

Net sales = Total − Discounts − Refunds
Calculate

Add 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

Shopify dashboard built in Mammoth, showing Net sales, Orders, Average order value, Units sold, Discounts, Returns
The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

See the free Shopify dashboard template

Common questions about Shopify to Google Sheets

How do I connect Shopify to Google Sheets?
Connect Shopify 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 Shopify 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 about a large store?
Choose Add new rows only with an order ID or date as the key column. Each refresh then brings in only the new records.

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