Connect WooCommerce Subscriptions and Google Sheets

Subscription stores live on recurring numbers: how many signed up, who renewed, whose card failed and who left. FlowMattic writes those WooCommerce Subscriptions events into Google Sheets from your WordPress site, so owners and finance staff can watch churn and revenue in a sheet, and support can extend or pause a subscription by editing a row.

Try FlowMattic free See example workflows

24 triggers 48 actions 7 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in WooCommerce Subscriptions18 triggers

Do this in Google Sheets19 actions

1. TriggerSubscription Created

2. ActionAdd New Row

When WooCommerce Subscriptions 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

WooCommerce Subscriptions 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 subscription as a row for analytics

Each signup adds a row with the customer, product, billing period, price and start date, giving you a running ledger of recurring signups to chart by month.

Subscription CreatedAdd New Row

View the template

Ready-made template

Record each renewal payment and thank the customer

Successful payments go to a Renewals tab for revenue tracking, and an Email (SMTP) step sends a short thank-you so long-term subscribers feel noticed.

Subscription Payment CompleteAdd New RowEmail (SMTP)

View the template

Build a dunning list of failed renewal payments

Every failed renewal adds the subscriber, amount and date to a Failed payments tab, so someone can call or email them before the subscription lapses.

Subscription Renewal Payment FailedAdd New Row

Mark cancelled subscriptions on their original row

When a subscription is cancelled, FlowMattic finds its row by subscription ID and fills in the end date and status, so the signup ledger also shows churn.

Subscription CancelledLookup Row DataUpdate Row

Track upgrades and downgrades in a switch log

Subscription Switched writes the old and new product with the date, which shows which plans people move to and whether a price change pushed them down a tier.

Subscription SwitchedAdd New Row

Extend a subscription when support adds free days in the sheet

Support types a subscription ID and a number of days on a Goodwill tab. Each new row extends that subscription and adds a note saying why.

New Spreadsheet RowExtend Subscription DurationAdd Subscription Note

Change a subscription's status from a status column

Editing the status column to on-hold or active updates the subscription in WooCommerce, so account managers handle pauses from a shared sheet without wp-admin access.

Update Specific Column ValueFilterUpdate Subscription Status

Set up: new subscriptions in a sheet

When you finish, every new WooCommerce subscription adds one row to your subscriptions sheet.

Prepare the sheet
Create a spreadsheet with columns such as Subscription ID, Date, Customer, Email, Product, Billing period and Total.
Connect Google Sheets
Add a Google Sheets connection under Connects. WooCommerce Subscriptions runs on your site and needs no connection.
Start with Subscription Created
Create a workflow with the Subscription Created trigger and place a test subscription order to capture the data.
Map Add New Row
Add Add New Row, pick the spreadsheet and tab, map the subscription fields to the columns, test it and switch the workflow on.

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

From WooCommerce Subscriptions	To Google Sheets
Subscription ID	Subscription ID
Start date	Date
Billing first and last name	Customer
Billing email	Email
Product name	Product
Billing period and interval	Billing period
Recurring total	Total

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

Keep the subscription ID in its own column. Lookups for cancellations, notes and sheet-driven changes all depend on it.
Subscription Payment Complete covers any subscription payment, including the first. Use Subscription Renewal Payment Complete if you only want renewals.
Sheet-to-store workflows act on whatever is typed. A Filter that checks the value is on-hold or active stops a typo from cancelling someone.
Writing to the tab that a Google Sheets trigger watches can start that workflow again. Use separate tabs for logs and for edits.

WooCommerce Subscriptions

Integration page

Triggers (18)

Subscription CreatedTriggers when a new subscription is created
Subscription Status UpdatedTriggers when subscription status changes
Subscription ActivatedTriggers when subscription status is set to active
Subscription On HoldTriggers when subscription is put on hold
Subscription CancelledTriggers when subscription is cancelled
Subscription ExpiredTriggers when subscription expires
Subscription Pending CancellationTriggers when subscription is pending cancellation
Subscription Renewal Payment CompleteTriggers when a renewal payment is completed
Subscription Renewal Payment FailedTriggers when a renewal payment fails
Subscription Payment CompleteTriggers when any subscription payment is completed
Subscription Payment FailedTriggers when any subscription payment fails
Subscription Trial EndedTriggers when subscription trial period ends
Subscription SwitchedTriggers when subscription is upgraded/downgraded
Subscription Payment Method UpdatedTriggers when subscription payment method is changed
Subscription Date UpdatedTriggers when subscription date is updated
Subscription DeletedTriggers when subscription is permanently deleted
Subscription TrashedTriggers when subscription is moved to trash
User Purchases Variable SubscriptionTriggers when user purchases a variable subscription product

Actions (29)

Get SubscriptionGet subscription details by ID
Update Subscription StatusUpdate subscription status
Update Subscription DatesUpdate subscription dates (next payment, trial end, etc.)
Cancel SubscriptionCancel a subscription
Reactivate SubscriptionReactivate a cancelled or on-hold subscription
Add Subscription NoteAdd a note to subscription
Create SubscriptionCreate a new subscription for a customer
Update SubscriptionUpdate subscription details
Find Subscriptions by User IDFind all subscriptions for a specific user
Extend Subscription DurationExtend subscription by a specific number of days
Remove Subscription ProductRemove a product from subscription
Create Subscription ProductCreate a new subscription product
Update Subscription Product PriceUpdate pricing for a subscription product
Update Subscription Product StockUpdate stock quantity and status for a subscription product
Create Variable Subscription ProductCreate a variable subscription product with attributes
Create Subscription VariationCreate a subscription variation for a variable subscription product
End Subscription TrialEnd the trial period of a subscription immediately
Schedule Payment RetrySchedule or reschedule a failed payment retry at a specific date/time
Bulk Update Subscription StatusUpdate status of multiple subscriptions at once
Process Early RenewalCreate an early renewal order for an active subscription
Apply Coupon to SubscriptionApply a recurring or one-time coupon to an existing subscription
Update Billing ScheduleChange billing period and interval for a subscription
Set Manual RenewalToggle subscription between automatic and manual renewal
Synchronize Payment DateAlign subscription renewal dates to a specific day/date
Create Resubscribe OrderCreate a resubscribe order for an expired or cancelled subscription
Suspend Subscription TemporarilyPut subscription on hold with automatic reactivation date
Process Switch OrderSwitch subscription product with prorated calculations
Copy Subscription to UserDuplicate a subscription for a different user
Update Related Orders StatusUpdate status of all related orders for a subscription

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

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

Recurring numbers in one place

Signups, renewals, failures, switches and cancellations each have a tab, which makes churn and revenue easy to see.

Customer data stays with you

FlowMattic runs on your own WordPress site, so subscriber details go from your store to Google directly.

Renewal day costs the same

Runs are unlimited, so hundreds of renewals on the first of the month need no bigger plan.

Common questions

Can I see monthly recurring revenue in Google Sheets?

Yes. Log new subscriptions and renewal payments in their own tabs with the recurring total and date. A pivot table or SUMIFS formula by month then gives you recurring revenue without any export.

Can I log trials separately?

Yes. Subscription Trial Ended writes a row when a trial finishes, and a Router can split converted and cancelled trials into different tabs.

Can the sheet create new subscriptions?

Yes. A New Spreadsheet Row trigger can run Create Subscription for a customer. Check the user ID and product in the row first so mistakes do not create real subscriptions.

What happens to the row when a subscription is deleted?

Nothing unless you build it. Subscription Deleted can find the row with Lookup Row Data and mark it, or remove it with Delete Row.

Can each subscription product get its own tab?

Yes. Put a Router after the trigger with a condition on the product name, and point each path's Add New Row at a different tab, so a coffee club and a software plan are reported apart.

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

Start automating WooCommerce Subscriptions 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 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. WooCommerce Subscriptions integration 1.0.0, Google Sheets integration 2.2.4.