Connect Ordergroove and Google Sheets

Ordergroove sends an event for almost every change in a subscription program: new subscribers, swaps, skipped orders, cancellations and placement failures. FlowMattic writes the ones you care about to Google Sheets, so retention, merchandising and operations teams each get a tab they can sort and chart without logging in to Ordergroove.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Ordergroove32 triggers

Do this in Google Sheets19 actions

1. TriggerSubscription Created

2. ActionAdd New Row

When Ordergroove fires Subscription 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

Ordergroove 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 each new Ordergroove subscription in a sheet

Every subscription created becomes a row with product, frequency and customer, giving you a growth log that finance and marketing can both read.

Subscription CreatedAdd New Row

View the template

Record cancellations for the retention team

Each canceled subscription is added to a churn tab with the product and date, so the team can call back recent cancellers and spot products people leave.

Subscription CanceledAdd New Row

Update the subscription row when the delivery frequency changes

Find the subscription by its ID and overwrite the frequency column, so your sheet shows how often each customer now receives their order.

Subscription Change FrequencyLookup Row DataUpdate Row

See which products subscribers swap to

Every SKU swap adds a row with the old and new product. Merchandisers can count swaps per product to see what customers prefer over time.

Subscription SKU SwapAdd New Row

List rejected order placements for operations

Orders that Ordergroove will not retry go to a tab with the order and reason, so someone can contact the customer before the next shipment is missed.

Order RejectAdd New Row

Keep one row per out-of-stock item

Look the SKU up first and add it only once, with the date it was first seen. Buyers get a short restock list instead of one row per order.

Item Out Of StockLookup Row DataRouterAdd New Row

Set up: a log of new subscriptions

When you are done, each subscription created in Ordergroove adds a row to your sheet.

Prepare the tab
Add a header row such as Subscription ID, Customer, Product, Frequency and Created.
Connect Google Sheets
Under Connects, add a Google account with edit rights to the spreadsheet.
Choose Subscription Created
Create a workflow with the Ordergroove Subscription Created trigger and complete the setup shown in the trigger step.
Create a test subscription
Subscribe to a product in your store, or use a test customer, so FlowMattic captures the event data.
Write the row
Add Google Sheets Add New Row, map the subscription fields, test the step and switch the workflow on.

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

From Ordergroove	To Google Sheets
Subscription ID	Subscription ID
Customer email	Customer
Product	Product
Frequency	Frequency
Created date	Created

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

Subscriber Canceled fires when a customer cancels their last active subscription, while Subscription Canceled fires for each one. Pick the one that matches the question you are asking.
Ordergroove sends many order events. Start with one workflow per event you need rather than one large workflow, so each tab stays easy to read.
Store the subscription ID in its own column. The frequency, swap and cancel workflows all find rows by it.

Ordergroove

Integration page

Triggers (32)

Subscriber CreatedTriggers when a customer has created their first subscription.
Subscriber CanceledTriggers when a customer cancels their last active subscription, ending recurring revenue generation.
Subscriber Suscriptions CreatedTriggers when a subscriber creates one or more subscriptions.
Subscription CreatedTriggers when the customer creates a subscription.
Subscription CanceledTriggers when a subscription is cancelled.
Subscription SKU SwapTriggers when the product associated with a subscription is changed.
Subscription Change LiveTriggers when a canceled subscription is reactivated.
Subscription Change FrequencyTriggers when the subscription's delivery frequency is modified.
Subscription Change ComponentsTriggers when a product is updated, added, or removed from the list of bundle components of the subscription.
Subscription Change QuantityTriggers when the subscription's quantity is modified.
Subscription Change Shipping AddressTriggers when a subscription's shipping address is set.
Subscription Change PaymentTriggers when a subscription's payment is set.
Subscription Refresh One Click TokenTriggers when the previous 1-Click token is used.
Order Change Shipping AddressTriggers when an order's shipping address is set.
Order Change PaymentTriggers when an order's payment is set.
Order Change Next Order DateTriggers when an order's desired placement date is modified.
Order Skip OrderTriggers when an order is canceled, meaning the order will not be placed.
Order Send NowTriggers when an order's placement date was moved up to today.
Order CancelTriggers when the placement response (response code "030") for an order indicates it should be canceled and no longer attempted.
Order SuccessTriggers when the placement response for an order indicates it was processed successfully and GMV was realized.
Order Generic ErrorTriggers when the placement response for an order indicates an unknown error occurred (response code "999") and should be retried.
Order RejectTriggers when the placement response for an order indicates the order was rejected, no GMV was realized, and the order should not be retried.
Order ReminderTriggers when a reminder notification is sent to a customer for an upcoming order that will be placed.
Order Retryable Placement FailureTriggers when the placement response for an order indicates it should be processed through our configurable retry flow.
Order Refresh One Click TokenTriggers when the previous 1-Click token is used.
Item CreatedTriggers when an item is created.
Item Change QuantityTriggers when the quantity of an item is modified.
Item RemovedTriggers when the item is removed from an order.
Item.Item SubscribeTriggers when a subscription is created from an item that originally was a "one-time" item - an item in an order that customer had not subscribed to.
Item Update PriceTriggers when the price of an item is updated.
Item Successfully PlacedTriggers when the associated order's placement response indicates it was processed successfully and GMV was realized.
Item Out Of StockTriggers when an item is detected as not having enough inventory to be fulfilled.

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

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

Subscription data on your server

Customer and order details travel from Ordergroove through your WordPress site to your sheet, not through another company's automation account.

Busy renewal days cost the same

Runs are unlimited, so a day with thousands of placements and item events needs no bigger plan.

A tab for every team

Retention, operations and merchandising each get the events they need in a sheet they already use.

Common questions

How do I send Ordergroove subscriptions to Google Sheets?

Use the Ordergroove Subscription Created trigger and a Google Sheets Add New Row step. Map the subscription ID, customer, product and frequency to columns, test with a real subscription and switch the workflow on.

Can I track skipped orders?

Yes. Order Skip Order fires when an order will not be placed. Add a row for each, or look up the subscription and count skips in a column.

Can I see failed payments or placements?

Order Retryable Placement Failure, Order Generic Error and Order Reject each fire for a different kind of failure. Log them to one tab with a Type column, or to separate tabs.

Can the sheet change a subscription in Ordergroove?

No, these workflows only read Ordergroove events and write rows. Use the sheet to decide who to contact, then make the change in Ordergroove.

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

Start automating Ordergroove 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. Ordergroove integration 1.0.0, Google Sheets integration 2.2.4.