Connect Shoprocket and Google Sheets

Shoprocket adds a cart and checkout to any website. FlowMattic writes its orders, customers and products to Google Sheets and keeps them in step as they change, so you have a sales log for bookkeeping, a customer list you own, and a product sheet that matches your store.

Try FlowMattic free See example workflows

15 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Shoprocket9 triggers

Do this in Google Sheets19 actions

1. TriggerOrder Created

2. ActionAdd New Row

When Shoprocket fires Order Created, 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

Shoprocket 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

Log every new Shoprocket order in a sheet

Each order becomes a row with customer, total and date, giving shop owners a sales log they can total each month.

Order CreatedAdd New Row

View the template

Write one row per item in each order

Iterator loops over the products in the order and adds a row for each, so you can count units sold per product.

Order CreatedIteratorAdd New Row

Update the order row when its status changes

Order Updated finds the order by ID and rewrites status and totals, so the sales log shows fulfilled and refunded orders correctly.

Order UpdatedLookup Row DataUpdate Row

Remove deleted orders from the sales log

When an order is deleted in Shoprocket, the workflow finds its row and deletes it, so test orders do not inflate your totals.

Order DeletedLookup Row DataDelete Row

Keep a product sheet in step with your catalog

Product Updated finds the product row and writes the new price and stock, so the team planning promotions works from current numbers.

Product UpdatedLookup Row DataUpdate Row

Build a customer list as people buy

Customer Created adds each new customer to a tab with name and email, giving you a list for follow-ups that lives outside the store.

Customer CreatedAdd New Row

Set up: a row for every order

At the end, every new Shoprocket order adds a row to your sales sheet.

Prepare the sales tab
Add headers such as Order ID, Customer, Email, Total, Status and Ordered at.
Connect Google Sheets
Under Connects, add a Google account that can edit the sheet.
Choose Order Created
Create a workflow with the Shoprocket Order Created trigger and complete the setup the trigger step shows.
Place a test order
Buy something from your store, or use a test order, so FlowMattic captures the order data.
Map and turn on
Add Google Sheets Add New Row, map the order fields, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Shoprocket	To Google Sheets
Order ID	Order ID
Customer name	Customer
Customer email	Email
Order total	Total
Order date	Ordered at

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

An order's items arrive as a list. Use Iterator if you want one row per item instead of one per order.
Keep the order ID and product ID in their own columns. The update and delete workflows find rows by them.
Deleting a row in the sheet does not delete the order in Shoprocket. The sheet follows the store, not the other way round.

Shoprocket

Integration page

Triggers (9)

Customer CreatedTriggers when a customer is created.
Product CreatedTriggers when a product is created.
Order CreatedTriggers when an order is created.
Customer UpdatedTriggers when a customer is updated.
Product UpdatedTriggers when a product is updated.
Order UpdatedTriggers when an order is updated.
Order DeletedTriggers when an order is deleted.
Product DeletedTriggers when a product is deleted.
Customer DeletedTriggers when a customer is deleted.

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

Shoprocket and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Sales data on your server

Order and customer details pass through your own WordPress site to the sheet, with no other automation service holding them.

Sale weekends cost the same

Runs are unlimited, so a busy promotion with many orders needs no bigger plan.

Books and stock in one file

Orders, customers and products sit side by side, ready for formulas and pivot tables.

Common questions

How do I send Shoprocket orders to Google Sheets?

Create a workflow with the Shoprocket Order Created trigger, place a test order, then add Google Sheets Add New Row and map order ID, customer, total and date to columns.

Can I see units sold per product?

Yes. After Order Created, add an Iterator over the order's items and write one row per item. A pivot table then totals units by product.

What happens when an order changes or is deleted?

Order Updated and Order Deleted each start their own workflow. Find the order's row by ID, then run Update Row or Delete Row.

Can I keep my product list in the sheet?

Yes. Use Product Created to add rows, Product Updated to change them and Product Deleted to remove them, all matched by product ID.

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

Start automating Shoprocket and Google Sheets

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

Try FlowMattic free See pricing

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. Shoprocket integration 1.0.0, Google Sheets integration 2.2.4.