Connect MemberPress and Google Sheets

Membership sites live on recurring numbers: who joined, who paid, who cancelled and who finished a course. FlowMattic writes those MemberPress events into Google Sheets from your WordPress site, and it can also act on the sheet, adding members your team lists or pausing a subscription when someone asks for a break.

Try FlowMattic free See example workflows

53 triggers 60 actions 7 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in MemberPress47 triggers

Do this in Google Sheets19 actions

1. TriggerSubscription Created

2. ActionAdd New Row

When MemberPress 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

MemberPress 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 new MemberPress subscription to a sheet

Member name, email, membership and price go into one row per subscription, giving the owner a member log to sort and share without logging into wp-admin.

Subscription CreatedAdd New Row

View the template

Mark refunded payments in the payment log

When a transaction is refunded, the workflow finds its row by transaction number and changes the status cell, so monthly revenue in the sheet matches what you actually kept.

Transaction RefundedLookup Row DataUpdate Row

Build a cancellations sheet for retention reviews

Each cancelled subscription is added to its own tab with the membership and how long the person stayed, so you can spot which plans lose people early.

Subscription StoppedAdd New Row

Keep a follow-up list of failed renewals

Failed recurring payments are written with a readable date, so whoever handles billing can contact members about their card before access lapses.

Recurring Transaction FailedDate/Time FormatterAdd New Row

Record course completions for certificates

Course creators get a row for every student who finishes, with the course name and date, ready for issuing certificates or picking testimonials.

Course CompletedAdd New Row

Create members from a corporate client's sheet

A company buying seats lists its staff in a sheet. Each new row creates the MemberPress member and writes the new member ID back into that row.

New Spreadsheet RowCreate MemberUpdate Row

Pause a subscription when support marks the row

Support staff type pause in an action column when a member asks for a break. A Filter checks the value and MemberPress pauses that subscription.

Update Specific Column ValueFilterPause Subscription

Set up: new subscriptions as rows

Once finished, every new MemberPress subscription is added to your Google Sheet as one row.

Make the sheet
Create a spreadsheet with headers such as Date, Member, Email, Membership, Price and Subscription ID.
Connect Google Sheets
Add a Google Sheets connection under Connects in FlowMattic. MemberPress is on the same WordPress site, so it needs no account.
Choose the trigger
Start a workflow with MemberPress Subscription Created and make a test signup so FlowMattic captures a real subscription.
Map the row
Add Google Sheets Add New Row, pick the spreadsheet and tab, map each subscription field to its column, test it and switch the workflow on.

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

From MemberPress	To Google Sheets
Created date	Date
Member display name	Member
Member email	Email
Membership title	Membership
Price	Price
Subscription ID	Subscription ID

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

Member Added fires before payment is accepted. For paid members only, use Member Signup Completed or Transaction Completed instead.
Member Active on Membership may fire more than once for the same member, so look the member up with Lookup Row Data before adding a row.
The course triggers and the Complete Lesson, Complete Course and course progress actions need MemberPress Courses.

MemberPress

Integration page

Triggers (47)

Member AddedTriggers when a new member registers but before their payment details are accepted.
Member Signup CompletedTriggers when a new member completes the signup and their payment is accepted.
Member Account UpdatedTriggers when a member updates their account information.
Member DeletedTriggers when a member is deleted from the system.
Member Logged InTriggers when any member logs in.
Subscription CreatedTriggers when a subscription is created.
Subscription PausedTriggers when a subscription is paused.
Subscription ResumedTriggers when a subscription is resumed.
Subscription StoppedTriggers when a subscription is cancelled.
Subscription Upgraded to Non-RecurringTriggers when a user upgrades their subscription and the new subscription is non-recurring (one-time payment).
Subscription Upgraded to RecurringTriggers when a user upgrades their subscription and the new subscription is auto-recurring.
Subscription Downgraded to Non-RecurringTriggers when a user downgrades their subscription and the new subscription is non-recurring (one-time payment).
Subscription Downgraded to RecurringTriggers when a user downgrades their subscription and the new subscription is auto-recurring.
Subscription ExpiredTriggers when a subscription expires.
Transaction CompletedTriggers when a transaction has completed on MemberPress.
Transaction RefundedTriggers when any transaction is refunded.
Transaction FailedTriggers when any transaction fails.
Transaction ExpiredTriggers when any transaction expires.
Offline Payment PendingTriggers when a user completes signup with an offline payment method and admin approval is required.
Offline Payment CompleteTriggers when an admin manually marks an offline transaction as completed.
Offline Payment RefundedTriggers when an admin manually marks an offline transaction as refunded.
Recurring Transaction CompletedTriggers when a transaction associated with a recurring subscription completes.
Renewal Transaction CompletedTriggers when the 2nd or later transaction associated with a recurring subscription completes. Does not fire for the first transaction.
Recurring Transaction FailedTriggers when a recurring transaction fails on the gateway.
Recurring Transaction ExpiredTriggers when any transaction associated with a subscription expires. This does not indicate a subscription is expiring, only the transaction.
Non-Recurring Transaction CompletedTriggers when a non-recurring transaction has completed on MemberPress.
Non-Recurring Transaction ExpiredTriggers when any transaction not associated with a subscription expires.
Member Active on MembershipTriggers when a member becomes active on a membership plan. May fire multiple times for the same member/membership.
Member Inactive on MembershipTriggers when a member becomes inactive on a membership plan. May fire multiple times for the same member/membership.
After Member RegistersTriggers when any After Member Signup reminder fires.
After Signup AbandonedTriggers when any After Member Signup Abandoned reminder fires.
Before Subscription ExpiresTriggers when any Before Subscription Expires reminder fires.
After Subscription ExpiresTriggers when any After Subscription Expires reminder fires.
Before Subscription RenewsTriggers when any Before Subscription Renews reminder fires.
After Credit Card ExpiresTriggers when any After Credit Card Expires reminder fires.
Before Credit Card ExpiresTriggers when any Before Credit Card Expires reminder fires.
Before Subscription Trial EndsTriggers when any Before Subscription Trial Ends reminder fires.
Sub Account AddedTriggers when a sub account is added by the corporate account.
Sub Account RemovedTriggers when a sub account is removed by the corporate account.
Course StartedTriggers when a user views the course for the first time.
Course CompletedTriggers when a user completes the course.
Lesson StartedTriggers when a user views the lesson for the first time.
Lesson CompletedTriggers when a user completes the lesson.
Quiz AttemptedTriggers when a user attempts the quiz.
Assignment CompletedTriggers when a user completes an assignment.
Gift PurchasedTriggers when a gift is purchased.
Gift ClaimedTriggers when a gift is claimed by a recipient.

Actions (41)

List SubscriptionsRetrieves subscriptions with optional filters.
Get SubscriptionRetrieves a subscription by ID.
Create SubscriptionCreates a new subscription record.
Update SubscriptionUpdates an existing subscription.
Delete SubscriptionDeletes a subscription by ID.
Cancel SubscriptionCancels a subscription and stops future payments.
Expire SubscriptionExpires active transactions attached to the subscription.
List MembersRetrieves members with optional filters.
Get MemberRetrieves a member by ID or email address.
Create MemberCreates a new member.
Update MemberUpdates an existing member by ID or email address.
Delete MemberDeletes a member by ID or email address.
List RulesRetrieves access rules with optional filters.
Get RuleRetrieves an access rule by ID.
Create RuleCreates a new access rule.
Update RuleUpdates an existing access rule.
Delete RuleDeletes an access rule by ID.
List MembershipsRetrieves memberships with optional filters.
Get MembershipRetrieves a membership by ID.
Create MembershipCreates a new membership product.
Update MembershipUpdates an existing membership product.
Delete MembershipDeletes a membership by ID.
List CouponsRetrieves coupons with optional filters.
Get CouponRetrieves a coupon by ID.
Create CouponCreates a new coupon.
Update CouponUpdates an existing coupon.
Delete CouponDeletes a coupon by ID.
List TransactionsRetrieves transactions with optional filters.
Get TransactionRetrieves a transaction by ID.
Create TransactionCreates a new transaction.
Update TransactionUpdates an existing transaction.
Delete TransactionDeletes a transaction by ID.
Refund TransactionIssues a refund for a transaction.
Refund and Cancel TransactionRefunds a transaction and cancels the related subscription.
Pause SubscriptionSuspends a subscription temporarily.
Resume SubscriptionResumes a paused subscription.
Complete LessonMarks a lesson as completed for a user (requires MemberPress Courses).
Complete CourseMarks all lessons in a course as completed for a user (requires MemberPress Courses).
Reset Course ProgressResets a user's progress for a specific course (requires MemberPress Courses).
Get Course ProgressRetrieves a user's progress for a specific course (requires MemberPress Courses).
Send Gift EmailSends the gift claim email to the recipient (requires MemberPress Gifting).

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

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

Forty-seven MemberPress triggers

Signups, renewals, refunds, reminders, gifts and course progress can each fill their own tab, so the sheet reflects the whole membership business.

Member data stays on your site

Rows are written from your own WordPress server, and runs are unlimited, so renewal day with hundreds of payments costs nothing extra.

The sheet can manage members

With 41 MemberPress actions, staff can create members, pause subscriptions or issue refunds by editing a spreadsheet they already use.

Common questions

What does the MemberPress Google Sheets integration do?

It writes MemberPress events such as new subscriptions, payments, refunds, cancellations and course completions into Google Sheets rows, and it can turn sheet rows into MemberPress changes like new members or paused subscriptions.

Can I export members who joined before the workflow existed?

Yes. Use a Schedule with List Members, loop over the result with Iterator and add each member with Add New Row. Run it once to fill the sheet.

Can I log every renewal payment?

Yes. Renewal Transaction Completed fires for the second and later payments of a recurring subscription, so a separate tab can track renewals apart from first payments.

Can I issue refunds from the sheet?

Yes. Watch a column with Update Specific Column Value, check the value with a Filter, and run Refund Transaction with the transaction ID from that row. Test it carefully, because refunds go through your gateway.

Does it work with MemberPress reminders?

Yes. Triggers such as Before Subscription Renews or Before Credit Card Expires fire when your MemberPress reminders run, so each one can add a row to a follow-up tab.

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

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