Shopify store owners often run reporting, purchasing and catalogue updates from Google Sheets. FlowMattic fills the sheet from your store as paid orders, refunds and stock changes happen, and works the other way too: product rows can create listings and a price column can update variants in Shopify.
85 triggers44 actions6 example workflows1 ready-made templateUnlimited runs
Try a pairing
When this happens in Shopify79 triggers
Do this in Google Sheets19 actions
1. TriggerOrder Payment
2. ActionAdd New Row
When Shopify fires Order Payment, FlowMattic runs Add New Row in Google Sheets with the data from that event.
You build this in the FlowMattic workflow builder on your own site. See the setup steps
Shopify and Google Sheets workflows you can build
Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.
Ready-made template
Add each paid Shopify order to Google Sheets
Order Payment fires once the order is paid, so the sales sheet holds real revenue with order number, customer, total and discount code.
Add each paid Shopify order to Google SheetsTemplate
1. Trigger in Shopify
Order Payment
2. Action in Google Sheets
Add New Row
Fields mapped from the earlier steps (a typical setup)
From Shopify
To Google Sheets
Order name
Order
Processed at
Date
Customer name
Customer
Email
Email
Total price
Total
Discount codes
Discount
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.
Triggers and actions in this pair
A trigger starts a workflow. An action is something FlowMattic does in the app as a step.
Good to know
Order Creation fires for every order, paid or not. Use Order Payment for a revenue sheet so pending and failed payments are left out.
A sheet that updates Shopify and is also updated by Shopify can loop. Keep store-to-sheet columns and sheet-to-store columns separate, and trigger only on the latter.
Store the order name or SKU in the sheet. Refund and stock workflows use it with Lookup Row Data to find the row to change.
New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet
Actions (19)
Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library
Why run this pair with FlowMattic
Shopify and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.
Order data stays with you
Customer and order details move from Shopify to your sheet through your own WordPress server, not through a separate automation company.
Sale days cost the same
Runs are unlimited, so a Black Friday with thousands of orders and stock changes writes every one without a task allowance.
The sheet can run the catalogue
Because Shopify has product and inventory actions here, the same spreadsheet can add products and change prices, not only report.
Common questions
How do I send Shopify orders to Google Sheets automatically?
Create a workflow with the Shopify Order Payment trigger and add Google Sheets Add New Row. Map the order number, customer, total and date to columns, test with an order and switch it on.
Can each product in an order get its own row?
Yes. Add an Iterator on the order's line items before Add New Row. Each item then becomes a row with product, variant, quantity and price, plus the order number.
Can I export orders placed before the workflow existed?
Search Order can find past orders by criteria. Loop over the results with Iterator and add each as a row, once, before the new-order workflow takes over.
Can the sheet update stock levels in Shopify?
Yes. An Update Specific Column Value trigger on a stock column can run Update Inventory for that variant, which suits counts done in a warehouse sheet.
Will customer details come through?
Yes. The order data includes the customer's name and email, and Customer Creation can keep a separate customer list in another tab.
30-day money-back guarantee Unlimited workflows and runs Self-hosted
Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Shopify integration 1.0, Google Sheets integration 2.2.4.