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
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 situation | Pick | Why |
|---|---|---|
| Log every new order, or another store event, as it happens | Shopify Flow | Free 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 store | A two-way sync app | Flow 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 else | Make or Zapier | Make'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 then | CSV export, imported into Sheets | No app or workflow; Shopify recommends Google Sheets for working with CSV files |
| The data starts in the sheet and has to go into Shopify | CSV import or Matrixify | Download 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
| Route | What lands in the sheet | Direction | What you pay for | Where you set it up |
|---|---|---|---|---|
| Shopify Flow | One 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 tab | Shopify to Sheets | Nothing extra: Flow is a free app on Basic, Grow, Advanced and Plus | The Flow app in your admin, plus a Google account with edit access |
| Google Sheets app | Depends on the app: orders, products, customers or inventory, in some apps kept in sync | One way or both ways, per listing | The 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 plan | The Shopify App Store and the app's own settings |
| Zapier | A row per Zap run, for example one per new order | Shopify to Sheets; a new or updated sheet row can also start a Zap | A paid Zapier plan, since Shopify is a premium app; one task per row written | Zapier, with your Shopify and Google accounts connected |
| Make | A row at the bottom of the table per scenario run | Shopify to Sheets; a new sheet row can also start a scenario | Make's own plans (not priced in this article) | A Make scenario with Shopify and Google Sheets modules |
| CSV export | A snapshot of orders, products or customers at the moment you export | Shopify to a file to Sheets, once per export | Nothing | The 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.
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.
Install the free Shopify Flow app from the Shopify App Store; it is available on the Basic, Grow, Advanced and Plus plans.
Before you tick this off
- Flow is installed in this store
- The store is on Basic, Grow, Advanced or Plus
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.
Before you tick this off
- The trigger is the event that should add a row
- If only some events count, a condition step sits between the trigger and the action
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.
Before you tick this off
- The action comes after the trigger and any condition step
- The connector shown is Google Sheets for Shopify Flow
- The connector app Google Sheets for Shopify Flow is installed
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.
Before you tick this off
- The account has edit access to the target spreadsheet
- The spreadsheet permission checkbox was checked
- This is the account you will use every time you use the action
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.
Before you tick this off
- Tab name matches an existing tab the rows should land in
- Fields that can contain commas go through a Liquid replace filter
- If each line item needs its own row, the action sits inside a For each loop
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.
Before you tick this off
- The header row follows the order of Row contents
- The last row has no empty cells in its first columns
Test the workflow before you turn it on, then check that the first real row lands in the right tab and columns.
Before you tick this off
- A test or the first real event produced a row in the right columns
- The workflow is turned on
Share the spreadsheet only with the people who need it, as Editor, Commenter or Viewer, especially when rows carry customer names or emails.
Before you tick this off
- Only the connected account and the people who edit the sheet are Editors
- Readers of the report are Viewers
- Apps
- Flow
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
| Field | Required? | What to enter |
|---|---|---|
| Spreadsheet URL | Required | The address of the Google Sheets spreadsheet the rows go to |
| Tab name | Required | The name of an existing tab in that spreadsheet, which receives the rows |
| Row contents | Optional | A comma-separated list of fields; each comma starts a new column |
Shopify Help Center, Add row to spreadsheet, read November 16, 2026.
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.
- Apps
- Flow
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
Syncs orders, customers, products and inventory to Sheets and sends edits to products, customers and inventory back to Shopify; every plan lists reverse sync.
- Direction
- Shopify to Sheets; edits to products, customers and inventory back
- Data
- Orders, customers, products, inventory
Exports your orders to Google Sheets whenever an order is created or updated.
- Direction
- Shopify to Sheets
- Reviews
- 0 as of November 16, 2026
Edit prices, inventory levels, SKUs, barcodes, tags and product status directly in Google Sheets.
- Scheduled exports
- Pro plan only
- Trial
- 7 days on Pro
Puts orders, products, customers and inventory into one spreadsheet it creates; read-only on your store.
- Google access
- Only the spreadsheet it creates, per the listing
- Reviews
- 0 as of November 16, 2026
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.
- 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.
- Orders
- Export
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.
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 see | Why, per Shopify | What to do |
|---|---|---|
| A 403 error when Flow adds a row | Commonly, 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 spreadsheets | Give 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 columns | Each comma in Row contents starts a new column, including commas inside the data | Remove commas from the field with a Liquid filter such as replace |
| New rows start in the wrong column | The last row has empty values in its first few columns, so Sheets inserts from the first column with content | Fix that row in the spreadsheet itself |
| A 429 or 500 error | Commonly, the worksheet is having trouble adding rows: the Google API received too many requests, or the worksheet has too many fields or rows | Shopify 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.
- 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.
Frequently Asked Questions
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 PolicySome 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.
