tr Skip to content
Black Friday FlowMattic for life, 12 payments of $33.25 Or $399 once. Nothing added for splitting Ends in --Days --Hrs --Min --Sec See the deal

Connect Shopify and Google Sheets

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 triggers 44 actions 6 example workflows 1 ready-made template Unlimited 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.

Shopify app icon Google Sheets app icon 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.

Order PaymentAdd New Row

View the template
Shopify app icon Google Sheets app icon

Write one row per line item for product reports

Iterator loops over the order's line items, so the sheet shows units sold per product and variant, which a pivot table turns into a bestseller list.

Order PaymentIteratorAdd New Row

Shopify app icon Google Sheets app icon

Record refunds on the original order row

When a refund is created, the order's row gets the refund amount and date, so net revenue in the sheet matches what you kept.

Refund CreateLookup Row DataUpdate Row

Shopify app icon Google Sheets app icon

Keep a stock sheet for purchasing

Inventory level changes update the matching item's cell, so the buyer sees what is running low without logging into the store admin.

Inventory Level UpdateLookup Row DataUpdate Cell Data

Shopify app icon Google Sheets app icon

Create Shopify products from a catalogue sheet

Suppliers' new lines are added as rows with title, price, SKU and description, and each row becomes a draft-ready product in your store.

New Spreadsheet RowCreate Product

Shopify app icon Google Sheets app icon

Change a variant's price by editing the sheet

When the price column changes, the workflow finds the product and updates the variant, so seasonal repricing happens in one sheet.

Update Specific Column ValueSearch ProductUpdate Product Variant

Set up: paid orders as rows

When you finish, every paid order in your Shopify store adds a row to your sales sheet.

  1. Connect Shopify

    Under Connects in FlowMattic, add a Shopify connection for your store with access to orders and products.

  2. Prepare the sheet

    Add a Google Sheets connection and create a sheet with columns such as Order, Date, Customer, Email, Total, Discount and Refund.

  3. Start with Order Payment

    Create a workflow with the Shopify Order Payment trigger and place a test order so FlowMattic captures the order fields.

  4. Write the row

    Add Google Sheets Add New Row, map the order fields to your columns, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up
Add each paid Shopify order to Google Sheets Template
  1. Shopify app icon 1. Trigger in Shopify Order Payment
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From ShopifyTo Google Sheets
    Order nameOrder
    Processed atDate
    Customer nameCustomer
    EmailEmail
    Total priceTotal
    Discount codesDiscount
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.

Triggers (79)

  • Cart CreationTriggers when a new cart is created.
  • Cart UpdateTriggers when a cart is updated.
  • Checkout CreationTriggers when a new checkout is created.
  • Checkout DeletionTriggers when a checkout is deleted.
  • Checkout UpdateTriggers when a checkout is updated.
  • Collection CreationTriggers when a new collection is created.
  • Collection DeletionTriggers when a collection is deleted.
  • Collection UpdateTriggers when a collection is updated.
  • Customer SMS Marketing Consent UpdateTriggers when a customer SMS marketing consent is updated.
  • Customer Account Settings UpdateTriggers when customer account settings are updated.
  • Customer CreationTriggers when a new customer is created.
  • Customer DeletionTriggers when a customer is deleted.
  • Customer DisableTriggers when a customer is disabled.
  • Customer Email Marketing Consent UpdateTriggers when a customer email marketing consent is updated.
  • Customer EnableTriggers when a customer is enabled.
  • Customer Group CreationTriggers when a new customer group is created.
  • Customer Group DeletionTriggers when a customer group is deleted.
  • Customer Group UpdateTriggers when a customer group is updated.
  • Customer Purchasing SummaryTriggers when a customer purchasing summary is generated.
  • Customer Tags AddedTriggers when tags are added to a customer.
  • Customer Tags RemovedTriggers when tags are removed from a customer.
  • Customer UpdateTriggers when a customer is updated.
  • Discount CreationTriggers when a new discount is created.
  • Discount DeletionTriggers when a discount is deleted.
  • Discount UpdateTriggers when a discount is updated.
  • Draft Order CreationTriggers when a new draft order is created.
  • Draft Order DeletionTriggers when a draft order is deleted.
  • Draft Order UpdateTriggers when a draft order is updated.
  • Fulfillment CreationTriggers when a new fulfillment is created.
  • Fulfillment Hold AddedTriggers when a fulfillment hold is added to a fulfillment order.
  • Fulfillment Hold ReleasedTriggers when a fulfillment hold is released from a fulfillment order.
  • Fulfillment Service Failed to CompleteTriggers when a fulfillment order cannot be completed by fulfillment service.
  • Line Items Prepared for PickupTriggers when fulfillment order line items are prepared for pickup.
  • Fulfillment Order MovedTriggers when a fulfillment order is moved.
  • Fulfillment Order RescheduledTriggers when a fulfillment order is rescheduled.
  • Scheduled Fulfillment Order ReadyTriggers when a fulfillment order that was scheduled becomes due.
  • Fulfillment Order Placed on HoldTriggers when a fulfillment order transitions to the "On hold" status.
  • Fulfillment Order Hold ReleasedTriggers when a fulfillment order is released and is no longer on hold.
  • Order Routing CompleteTriggers when fulfillment order's order routing is complete.
  • Fulfillment Orders CancelledTriggers when fulfillment orders are cancelled.
  • Cancellation Request AcceptedTriggers when fulfillment orders cancellation request is accepted.
  • Cancellation Request RejectedTriggers when fulfillment orders cancellation request is rejected.
  • Cancellation Request SubmittedTriggers when fulfillment orders cancellation request is submitted.
  • Fulfillment Request AcceptedTriggers when fulfillment orders fulfillment request is accepted.
  • Fulfillment Request RejectedTriggers when fulfillment orders fulfillment request is rejected.
  • Fulfillment Request SubmittedTriggers when fulfillment orders fulfillment request is submitted.
  • Line Items Prepared for Local DeliveryTriggers when fulfillment orders line items are prepared for local delivery.
  • Fulfillment Orders MergedTriggers when fulfillment orders are merged.
  • Fulfillment Orders SplitTriggers when fulfillment orders are split.
  • Fulfillment UpdateTriggers when a fulfillment is updated.
  • Inventory Item CreationTriggers when a new inventory item is created.
  • Inventory Item DeletionTriggers when an inventory item is deleted.
  • Inventory Item UpdateTriggers when an inventory item is updated.
  • Inventory Level ConnectTriggers when an inventory level is connected.
  • Inventory Level DisconnectTriggers when an inventory level is disconnected.
  • Inventory Level UpdateTriggers when an inventory level is updated.
  • Location ActivationTriggers when a location is activated.
  • Location CreationTriggers when a new location is created.
  • Location DeactivationTriggers when a location is deactivated.
  • Location DeletionTriggers when a location is deleted.
  • Location UpdateTriggers when a location is updated.
  • Market CreationTriggers when a new market is created.
  • Market DeletionTriggers when a market is deleted.
  • Market UpdateTriggers when a market is updated.
  • Order CancellationTriggers when an order is cancelled.
  • Order CreationTriggers when a new order is created.
  • Order DeletionTriggers when an order is deleted.
  • Order EditTriggers when an order is edited.
  • Order FulfillmentTriggers when an order is fulfilled.
  • Order PaymentTriggers when an order is paid.
  • Order Risk Assessment ChangedTriggers when an order risk assessment is changed.
  • Order UpdateTriggers when an order is updated.
  • Product CreationTriggers when a new product is created.
  • Product DeletionTriggers when a product is deleted.
  • Product UpdateTriggers when a product is updated.
  • Refund CreateTriggers when a new refund is created.
  • Shop UpdateTriggers when the shop is updated.
  • Tender Transaction CreationTriggers when a new tender transaction is created.
  • Transaction CreationTriggers when a new transaction is created.

Actions (25)

  • Create CustomerCreates a new customer in Shopify.
  • Update CustomerUpdates an existing customer in Shopify.
  • Delete CustomerDeletes a customer from Shopify.
  • Search CustomerSearch for a customer by email or other criteria.
  • Create ProductCreates a new product in Shopify.
  • Update ProductUpdates an existing product in Shopify.
  • Delete ProductDeletes a product from Shopify.
  • Search ProductSearch for products by title or other criteria.
  • Create Product VariantCreates a new variant for an existing product.
  • Update Product VariantUpdates an existing product variant.
  • Delete Product VariantDeletes a product variant.
  • Upload Product MediaUploads media (images/videos) to a product.
  • Delete Product MediaDeletes media from a product.
  • Create OrderCreates a new order in Shopify.
  • Update OrderUpdates an existing order in Shopify.
  • Cancel OrderCancels an order in Shopify.
  • Search OrderSearch for orders by various criteria.
  • Create CollectionCreates a new collection in Shopify.
  • Update CollectionUpdates an existing collection in Shopify.
  • Delete CollectionDeletes a collection from Shopify.
  • Create DiscountCreates a new discount code in Shopify.
  • Update DiscountUpdates an existing discount in Shopify.
  • Delete DiscountDeletes a discount from Shopify.
  • Update InventoryUpdates inventory levels for a product variant.
  • Get Inventory LevelsGets current inventory levels for products.
Google Sheets app icon

Google Sheets

Integration page

Triggers (6)

  • 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.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Shopify and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

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.