Ecom Store Pro

How to Connect Shopify to Google Sheets: Flow, Apps, CSV

Connect Shopify to Google Sheets with Flow's free Add row action, a sync app, Zapier or Make, or a CSV export: what each writes and where it stops.

Listen to a short brief of this article
Hands-free while you multitask

The short version

Shopify Flow, a free app on the Basic, Grow, Advanced and Plus plans, can add a row to a Google Sheets spreadsheet every time a workflow runs, from any trigger such as a new order.

It only appends: no Flow page we read in November 2026 describes updating a row or reacting to edits made in the sheet.

For rows that stay in sync, or edits that go back to Shopify, use an App Store app: of five listings read on November 16, 2026, SheetWave describes two-way sync from $4.99 a month and Exportsy is free up to 60 orders a month.

Zapier needs a paid plan because Shopify is a premium app there, and a one-off report needs only a CSV export imported into Sheets.

The Quick Verdict
Key Takeaway: For a live log of store events, use Shopify Flow: its free Google Sheets action adds a row on any trigger. Pick a two-way sync app when rows must update or edits must flow back, Make or paid Zapier when a new sheet row must trigger work, and a CSV export for one-off reports.

Find the row that matches what your sheet has to do; the sections below show each route in detail.

Which route, by what the sheet has to do

Your situationPickWhy
Log every new order, or another store event, as it happensShopify FlowFree on Basic, Grow, Advanced and Plus; its one Sheets action adds a row on any trigger
Rows must stay current, or edits in the sheet must reach the storeA two-way sync appFlow only appends; SheetWave (from $4.99/month) and Exportsy (free up to 60 orders a month) describe two-way sync on their listings
A new row in the sheet has to start something elseMake or ZapierMake's Watch New Rows and Zapier's New Spreadsheet Row triggers start work when a row is added (Zapier needs a paid plan for Shopify); no Flow page we read describes a trigger from Sheets
One report now, or now and thenCSV export, imported into SheetsNo app or workflow; Shopify recommends Google Sheets for working with CSV files
The data starts in the sheet and has to go into ShopifyCSV import or MatrixifyDownload the sheet as CSV; Matrixify's listing says it imports from Google Sheets

On the Basic, Grow, Advanced and Plus plans, Shopify can write to Google Sheets without a paid tool: Shopify Flow, a free app, has a Google Sheets action that adds a row each time it runs in a workflow. Whether that is enough depends on one question: what the sheet has to do once the row lands.

This guide sorts the routes by that question (Flow, an App Store app, Zapier or Make, and a plain CSV export), then walks through the Flow setup field by field, the errors Shopify documents for it, and what to check before customer data lands in a shared sheet.

The Routes and What Each One Writes

Key takeaway

The routes differ less in how they connect than in what they leave in the sheet. Flow and the connectors write new rows, sync apps keep rows in step with the store, and a CSV export is a snapshot that starts ageing the moment you download it.

The routes from Shopify to Google Sheets, side by side
RouteWhat lands in the sheetDirectionWhat you pay forWhere you set it up
Shopify FlowOne new row each time the action runs (once per workflow run, or once per item inside a For each loop), added at the bottom of the tabShopify to SheetsNothing extra: Flow is a free app on Basic, Grow, Advanced and PlusThe Flow app in your admin, plus a Google account with edit access
Google Sheets appDepends on the app: orders, products, customers or inventory, in some apps kept in syncOne way or both ways, per listingThe app's plans; cheapest paid plans of the five below run from $4.90 to $19.99 a month; three of the five list a free planThe Shopify App Store and the app's own settings
ZapierA row per Zap run, for example one per new orderShopify to Sheets; a new or updated sheet row can also start a ZapA paid Zapier plan, since Shopify is a premium app; one task per row writtenZapier, with your Shopify and Google accounts connected
MakeA row at the bottom of the table per scenario runShopify to Sheets; a new sheet row can also start a scenarioMake's own plans (not priced in this article)A Make scenario with Shopify and Google Sheets modules
CSV exportA snapshot of orders, products or customers at the moment you exportShopify to a file to Sheets, once per exportNothingThe Shopify admin's export, then Google Sheets' import

Shopify Help Center (Flow, export and CSV pages), Zapier Help Center and pricing, Make's app documentation and five Shopify App Store listings, read November 16, 2026; app prices in US dollars as the listings bill them.

What none of the routes is: a switch in the Shopify admin. No Shopify page we have found describes a built-in two-way sync with Google Sheets; as of November 16, 2026, the order, product and customer export pages, the CSV help, the Flow help and the Flow app listing mention Sheets only as a program for CSV files or as the target of Flow's row action.

Shopify Flow: the Free Route That Only Adds Rows

Key takeaway

Flow is Shopify's own automation app, free on its App Store listing, which names Google Sheets among the services it integrates with. You install Flow once, connect a Google account, and from then on every workflow run can add a row.

What the Google Sheets Connector Can and Cannot Do

Key takeaway

Shopify lists exactly one action for the Google Sheets connector, and its reference page describes it in one sentence:

The Add row to spreadsheet action adds a single row of data to a Google Sheets spreadsheet.
Shopify Help Center — Add row to spreadsheet ·

The same page says the action can be used with any trigger, so the row can come from a new order, a new customer or a product change. Flow can also start on a clock instead of a store event: for repeating workflows, the Scheduled time trigger runs at intervals from 10 minutes to one year.

Flow itself costs nothing extra. Shopify describes it as a free app available on the Basic, Grow, Advanced, and Plus plans, installed from the Shopify App Store. Usage limits depend on the plan, but the Flow help page doesn't name the Sheets action among the plan-limited features; the action it does limit, Send HTTP Request, is for Grow, Advanced and Plus.

What the connector does not do matters as much. None of the Flow pages we read on November 16, 2026 (the Google Sheets action and connector pages, the connector list and the full trigger and action reference lists) describes an action that reads, updates or deletes a row already in the sheet, or a trigger that starts a workflow when the sheet changes.

So plan the sheet as a log that only grows; how edits made there get back to the store is covered in sending sheet edits back.

One more boundary, from Shopify's page on managing connections: conditions can't be set using connectors. If only some orders should become rows, add a Flow condition step before the Sheets action.

Set Up the Workflow, Step by Step

Key takeaway

Steps one and four happen once per store and Google account, though step four's edit-access check applies to each new spreadsheet; steps two, three and five to seven repeat for every workflow that writes to a sheet, and step eight for every new spreadsheet. Step four decides whether the first run succeeds: a 403 when Flow adds a row commonly means the connected Google user can't edit the worksheet, and right after a new connection Shopify says you likely didn't give Flow permission to edit your spreadsheets. How Flow's test runs work before you switch a workflow on is covered in testing a Shopify Flow workflow.

Connect Shopify to Google Sheets with FlowTick each step off as you go. Your progress stays in this browser.

Connect Shopify to Google Sheets with Flow

Tick each step off as you go. Your progress stays in this browser.

0 of 8 done
  1. Install the free Shopify Flow app from the Shopify App Store; it is available on the Basic, Grow, Advanced and Plus plans.

  2. Start a workflow with the event that should add a row, such as Order created, which fires when a customer places an order or a draft order is marked as paid.

  3. Add Add row to spreadsheet, the one action of the Google Sheets for Shopify Flow connector, after the trigger; if the action panel says that app is not installed, install it from the panel's Install button.

  4. Connect Flow to a Google account that can edit the spreadsheet, and on Google's permission screen check See, edit, create, and delete all your Google Sheets spreadsheets.

  5. Paste the Spreadsheet URL and enter the name of an existing tab in Tab name, both required, and optionally list the Row contents as comma-separated fields, one column per comma.

  6. Give the tab a header row in the same order as your fields, and keep the first columns of its last row filled so new rows start in the first column.

  7. Test the workflow before you turn it on, then check that the first real row lands in the right tab and columns.

  8. Share the spreadsheet only with the people who need it, as Editor, Commenter or Viewer, especially when rows carry customer names or emails.

In Shopify adminOpen in your store
  1. Apps
  2. Flow
Step 3: search Google Sheets in Select action; the App-badge row is the connector, its Add row action sits below.

Fill In the Three Fields

Key takeaway

The action asks for three things, and only two of them are required:

The fields of Add row to spreadsheet
FieldRequired?What to enter
Spreadsheet URLRequiredThe address of the Google Sheets spreadsheet the rows go to
Tab nameRequiredThe name of an existing tab in that spreadsheet, which receives the rows
Row contentsOptionalA comma-separated list of fields; each comma starts a new column

Shopify Help Center, Add row to spreadsheet, read November 16, 2026.

If the panel says the app isn't installed

The connector is an app of its own. As of November 16, 2026, in a store where it wasn't installed, the action panel opened with a banner above these fields: “The app "Google Sheets for Shopify Flow" is not installed. Triggers and steps provided by this app are unavailable.” The same banner carries an Install button. Shopify's connections page describes the same step: if you haven't connected the app before, you get a message that it's uninstalled and click Install.

In Shopify adminOpen in your store
  1. Apps
  2. Flow
Steps 3 and 5: without the connector installed, the panel shows an Install banner above the three fields.

Commas are the trap. Because each comma denotes a new column, a value that contains one, such as an order note, splits across extra columns. Shopify's fix is a Liquid filter that removes the commas, for example {{ order.note | replace:",", " " }}.

One order, one row is the default. If you need a row for every line item, Shopify points to Flow's For each action: loop through the order's line items and call Add row to spreadsheet once for each item.

When a Google Sheets App Fits Better

Key takeaway

An app earns its fee where Flow stops. Flow adds rows; the apps below sync, edit in bulk or keep a read-only copy, depending on the listing. That two-way sync is the main thing they add, since no Shopify page we have found describes a built-in one (see the routes above).

These are five apps found on the Shopify App Store on November 16, 2026, not a complete list:

Five Google Sheets apps on the Shopify App Store

SheetWaveby senstores
Listed as “SheetWave ‑ Google Sheets Sync”
Two-way sync

Syncs orders, customers, products and inventory to Sheets and sends edits to products, customers and inventory back to Shopify; every plan lists reverse sync.

From
$4.99/month
Entry plan: 1 Google connection and 3,000 sheet writes a month; 14-day free trial.
Direction
Shopify to Sheets; edits to products, customers and inventory back
Data
Orders, customers, products, inventory
Google Sheets Orders Syncby Opossum
Orders only

Exports your orders to Google Sheets whenever an order is created or updated.

Basic plan
$4.90/month
One paid plan; 7-day free trial.
Direction
Shopify to Sheets
Reviews
0 as of November 16, 2026
NeatSheetby NeatFlow
Editing products in Sheets

Edit prices, inventory levels, SKUs, barcodes, tags and product status directly in Google Sheets.

Free plan
$0
5 exports and 20 changes a month; Pro, $9.99/month, has unlimited exports and changes.
Scheduled exports
Pro plan only
Trial
7 days on Pro
Sleek Sheetsby Fiery Tools
Read-only reporting

Puts orders, products, customers and inventory into one spreadsheet it creates; read-only on your store.

Free plan
$0
Pro $9/month, 7-day free trial.
Google access
Only the spreadsheet it creates, per the listing
Reviews
0 as of November 16, 2026
Exportsyby WEB UNIVERS
Listed as “Exportsy Sync To Google Sheets”
Two-way order sync

Describes two-way sync; its Free plan lists real-time two-way order sync, and of its four plans only Unlimited lists abandoned checkouts synced to Sheets.

Free plan
$0
60 orders a month; Basic $19.99/month for 500 orders; 14-day free trial.
Direction
Shopify to Sheets and back
Data
Orders; abandoned checkouts on the Unlimited plan

Shopify App Store listings read November 16, 2026; prices in US dollars as the listings bill them. A snapshot of five apps, not a complete list or a ranking.

Before you install one, check what it can touch. Sleek Sheets states the narrow case on its listing: “It's read-only on your store, and on Google it can only touch the one spreadsheet it creates for you - nothing else in your Drive.” Apps that read customer details answer to Shopify's rules: a public app that uses customer name, address, phone or email fields must meet Shopify's level 1 and level 2 protected customer data requirements.

Zapier or Make: When the Sheet Is One Step of Many

Key takeaway

A connector makes sense when the sheet is one stop in a longer chain, or when you already run one. On Zapier, Shopify comes with a condition: Shopify is a premium app on Zapier, so you need a paid Zapier plan; on the store side, Zapier asks for an active Shopify store on Basic, Shopify, Advanced or Plus, where Shopify is the plan now called Grow. Zapier's free plan includes 100 tasks a month, but premium apps are only available on paid plans.

Zapier's Shopify and Google Sheets templates add a row for each new paid order or each inventory update, and you choose which order fields to send. Zapier's New Order trigger, which fires when an order is created, is instant and supports line items. The cost arithmetic is short: per Zapier's pricing page, a task is used only when a Zap successfully completes an action, and triggers don't count, so a Zap whose one action writes the row spends one task per order.

Make's Google Sheets Add a Row module adds a new row at the bottom of the table, fed by Shopify modules such as Watch orders. Make and Zapier can both start work from the sheet: Make's Watch New Rows trigger starts a scenario when a row is added, and Zapier's New Spreadsheet Row trigger fires when a row is added to the bottom of a spreadsheet (New or Updated Spreadsheet Row also fires on edits); a Zap that includes Shopify still needs a paid Zapier plan. No Flow page we read describes a trigger from Google Sheets. Make's documentation adds a caveat for Watch New Rows: if a sheet contains a blank row, “Make doesn't process all subsequent rows.”

What either connector adds up to at your volume, in Zapier tasks or Make operations, is worked out in Shopify Flow vs Zapier vs n8n.

If you were planning to point a Shopify webhook straight at a spreadsheet instead, that needs a go-between too: using Google Sheets as a Shopify webhook URL covers the connectors and the Apps Script option.

A One-Off Report: Export a CSV, Import It Into Sheets

Key takeaway

When the job is a monthly report rather than a live feed, the admin's own export is enough, and Shopify points to Sheets as the tool for it:

Shopify recommends that you use Google Sheets to work with your CSV files.
Shopify Help Center — CSV files ·
1
Export from Shopify
Export orders, products or customers as a CSV file from the matching page of your admin.
2
Import the file into Google Sheets
CSV is one of the file types Google's import options accept.
3
Append, don't replace
Choose Append rows to current sheet, where the import dialog offers it, to add the rows after the last row with data, instead of replacing what the sheet already holds.
In Shopify adminOpen in your store
  1. Orders
  2. Export
Step 1: choose which orders to export and which CSV type, then click Export orders.

Three limits come with the export:

  • Large exports arrive by email. Past a set number of orders, or when you export by date, Shopify emails the orders file to you and the store owner.
  • Customer files are capped at 15 MB. Shopify names Google Sheets among the programs that open them; the steps are in exporting your customer list.
  • Transaction history is captured payments only. An order export with transaction history contains captured payments data only.

Sending Sheet Edits Back to Shopify

Key takeaway

Editing in a sheet is often why merchants want the connection, and the way back is a separate trip. The CSV round trip uses Shopify's own import: in Google Sheets, go to File > Download > Comma-separated values (.csv, current sheet), then import that file on the matching admin page. Google Sheets saves files with UTF-8 encoding by default, so you skip the encoding step other spreadsheet programs can need.

Don't sort a product CSV

Shopify warns that sorting your CSV file in a spreadsheet program can cause product variants or image URLs to become disassociated. Edit the rows, but keep their order. If an import still fails, the product CSV import errors guide matches each message to its fix.

Two limits apply on the way back: you can't import order information using a customer CSV file, and the customer import file, like the export, is capped at 15 MB.

Apps are another way back. SheetWave lists reverse sync from Sheets to Shopify on every plan, and Matrixify's listing says it imports products, orders, customers and more from Excel, CSV or Google Sheets; what Matrixify does for a Shopify store sets out where it goes beyond the native CSV. A connector can do it too: on a paid Zapier plan, for example, Zapier's template can update inventory quantities in Shopify when new or updated spreadsheet rows occur in Google Sheets.

Keep the Sheet Working: Errors, Size and Customer Data

Key takeaway

Once the feed runs, the problems Shopify and Google document fall into three groups: errors when Flow adds a row, size, and who can read the data.

Errors the Flow Connector Documents

Key takeaway
Flow and Google Sheets errors, per Shopify
What you seeWhy, per ShopifyWhat to do
A 403 error when Flow adds a rowCommonly, the Google user who connected Sheets can't edit the worksheet; right after a new connection, you likely didn't give Flow permission to edit your spreadsheetsGive that user edit access to the spreadsheet; after a new connection, reconnect and check See, edit, create, and delete all your Google Sheets spreadsheets
One value spread across several columnsEach comma in Row contents starts a new column, including commas inside the dataRemove commas from the field with a Liquid filter such as replace
New rows start in the wrong columnThe last row has empty values in its first few columns, so Sheets inserts from the first column with contentFix that row in the spreadsheet itself
A 429 or 500 errorCommonly, the worksheet is having trouble adding rows: the Google API received too many requests, or the worksheet has too many fields or rowsShopify names no number; check how many runs reach the sheet at once and how large the worksheet has grown

Shopify Help Center, Add row to spreadsheet (FAQ), read November 16, 2026; the column behaviour follows Google's append rule, which the same page links.

To change the Google account behind the connector, the store needs a copy of the Flow app installed, and the connection is managed from Flow; Shopify's connections page says to choose the app row Google Sheets for Shopify Flow, marked with an App badge, not the Add row to spreadsheet action.

How Big Can the Sheet Get, and What a Retry Does

Key takeaway

Google's limit is per spreadsheet: up to 20 million cells or 100MB for spreadsheets that are created in or converted to Google Sheets. A row-per-order log uses as many cells per order as Row contents has columns. Shopify's 429 and 500 entry above names a worksheet with too many fields or rows as one cause, without a number.

Retries need the same care. Flow's manual retry uses the same trigger data as the original run, and Zapier says it will attempt to replay a Zap run but cannot guarantee success.

Zapier's replay page says replaying an errored run repeats only the steps that stopped with an error, while replaying the entire run from the Zap editor repeats every step; Flow's retry page says a manual retry also uses up-to-date data in conditions and actions, but doesn't say whether a row the first run added is skipped. So check the sheet for the order before you retry a Flow run or replay a whole Zap. Where each tool keeps its run history, and for how long, is in the guide to failed Flow runs and Zap replays.

Customer Data in a Shared Sheet

Key takeaway

A Flow row carries whatever Row contents names, including a customer's name, email and address, and from then on the sheet's sharing settings decide who reads it. Shopify is plain about whose responsibility the data is:

As a Shopify merchant, you're responsible for complying with the privacy and data protection laws and regulations that apply to your business.
Shopify Help Center — Processing customer data requests ·
  • Share narrowly. Google gives three levels of access when you share a file: Editor, Commenter or Viewer. The account connected to Flow needs edit access; people who only read the report don't.
  • Count the sheet in erasure requests. When a customer asks you to erase their data, Shopify's page says it's your responsibility to contact any other companies you've shared it with, so check whether that customer also sits in your sheet.
  • Keep one account. Shopify says you must use the same account every time you use the action, so connect a Google account the business controls.

The Bottom Line

Key takeaway

The choice is about what the sheet does after a row lands, not about how the data gets there. A running log of orders needs nothing beyond Flow and a Google account with edit access; the spending usually starts when the sheet has to talk back, and even then Exportsy and NeatSheet list free plans with monthly caps.

Build the Flow workflow first, and pay only for what it can't do. If you need two-way sync, set the listings' order or write limits against your monthly volume before you choose a plan, and keep customer columns out of any sheet you share widely.
Your Next Step by Stage
Logging new ordersFor a live log of new orders, build and test the Flow workflow before you turn it on.Build and test a Flow workflow
Paying for a connectorBefore you pay Zapier or Make per task or operation, compare what each layer costs at your volume.Compare Flow, Zapier and n8n
Editing in the sheetIf edits in the sheet must reach Shopify, see what Matrixify imports that a plain CSV cannot.What Matrixify does

Not Sure Which Route Your Sheet Needs?

We look at what has to land in the sheet, from which store event, how often and whether edits go back, and tell you which route to take: Flow, an app, Zapier or Make, or a CSV round trip. The task is estimated first, then billed at $28 an hour; the workflow, the app and the Google account stay with you.

See developer services

Frequently Asked Questions

Yes. Shopify Flow is a free app on the Basic, Grow, Advanced and Plus plans, and its Google Sheets connector adds a row to a spreadsheet each time its action runs in a workflow, from any trigger. You need a Google account with edit access to the sheet. A CSV export imported into Sheets is free too, but it is a one-time snapshot.
Not as far as Shopify documents it. The Google Sheets connector has one action, Add row to spreadsheet, which appends a row at the bottom. None of the Flow pages we read in November 2026 describes an action that reads, updates or deletes an existing row. If rows must stay current, look at a sync app instead.
Not on its own. No Shopify page we read in November 2026 describes a built-in sync from Google Sheets back to a store, and no Flow page we read documents a trigger from the sheet. Download the sheet as a CSV and import it, or use an app: SheetWave lists reverse sync on every plan, and Matrixify imports from Google Sheets.
Shopify describes Flow as a free app available on the Basic, Grow, Advanced and Plus plans, installed from the Shopify App Store. Usage limits depend on the plan, but the Flow help page doesn't list the Google Sheets action among its plan-limited features. Send HTTP Request, a different action, is limited to Grow, Advanced and Plus.
No. Zapier lists Shopify as a premium app, and premium apps are only available on paid Zapier plans, so connecting Shopify to Google Sheets through Zapier needs a paid plan. The free plan's 100 tasks a month don't change that. On the Shopify side, Zapier lists Basic, Shopify (the plan now called Grow), Advanced and Plus.
For a Zap with one action that writes the row, one task per order. Zapier uses a task only when a Zap successfully completes an action, triggers don't count toward the limit, and checking for new data costs nothing. Every extra action step in another app adds a task per order; Filter by Zapier and the other steps on Zapier's no-task list don't count.
Commonly, the Google user who connected Sheets can't edit the worksheet, so give that account edit access to the spreadsheet you name in the action. Right after a new connection, Shopify says you likely didn't give Flow permission to edit your spreadsheets: reconnect and check the box See, edit, create, and delete all your Google Sheets spreadsheets on Google's permission screen.
Because each comma in Row contents starts a new column, and that includes commas inside the data itself, such as an order note. Shopify's fix is a Liquid filter that removes them, for example replace with each comma swapped for a space, applied to the field before it reaches the sheet.
Use Flow's For each action. Shopify's Add row page says you can loop through each line item of the order and call the Add row to spreadsheet action once for each, so every item gets its own row. Put the line item fields in Row contents inside the loop.
Google allows up to 20 million cells or 100MB for spreadsheets created in or converted to Google Sheets. A sheet that gains one row per order uses as many cells per order as Row contents has columns. Shopify also lists too many fields or rows in a worksheet as a cause of 429 and 500 errors.
Yes, as a one-off. Export your orders as a CSV file from the Shopify admin, then import the file into Google Sheets and, where the import dialog offers it, choose Append rows to current sheet to add them after your existing data. Large exports, or exports by date, are emailed to you and the store owner. The sheet won't update until you export again.
Of five listings read November 16, 2026: SheetWave, from $4.99/month, syncs orders, customers, products and inventory to Sheets and sends edits to products, customers and inventory back to Shopify; every plan lists reverse sync. Exportsy describes two-way sync; its Free plan (60 orders a month) lists real-time two-way order sync, and of its four plans only Unlimited lists abandoned checkouts synced to Sheets.
Not directly, according to our FAQ on using Google Sheets as a Shopify webhook URL: route it through a connector that writes the row, such as Zapier on a paid plan, Make or n8n, or a Google Apps Script web app you test first. Flow's Add row to spreadsheet action needs no webhook at all.
About This Article
Shopify Developer & Editorial Director
9+ years with Shopify since 2017

Front-end developer specializing in Shopify since 2017. Experienced in building custom Liquid themes, optimizing storefront performance, and integrating third-party apps. Directs the editorial process behind Ecom Store Pro: sets its topics and the rules every AI-written page must pass before publication.

This page was written by AI. Separate AI agents that did not write it check its figures and claims against official sources and test its links and interactive tools. A human editor sets the site's editorial direction, topics and rules and checks that pages are complete and display correctly, but does not check their facts or edit their text. Details may change — always confirm critical data at shopify.com.

Editorial Policy

Some links in this article are affiliate links. If you sign up for a Shopify store through these links, we may earn a commission at no extra cost to you. Read our full advertising policy.

Continue Learning

What to Read Next

Stay updated

Get notified about new articles

Subscribe to receive updates when we publish new Shopify guides and insights.