MemberPress to Google Sheets: Live Membership Register
Every completed MemberPress transaction is added to your own Google Sheet as it happens, with the member, the membership, the amount and the subscription it belongs to. From that one tab: revenue by membership, new members by month and a list of who is due to renew.
In This Guide
A Payment Register in Google Sheets
SheetLink writes one MemberPress event to Google Sheets: a row each time a transaction is stored with the status Complete. It is part of SheetLink Pro ($79/year or $199 lifetime). This guide sets up the rule, shows the columns you get, and then puts them to work: revenue by membership, new members by month and a renewal watch list.
Everything below is built on completed transactions and nothing else. Plan changes, cancellations and expiries are not sent as events of their own, so none of the reports here depend on them.
Why a Sheet?
Because the questions a small membership business asks are spreadsheet questions: what came in this month, which membership earns the most, who has not paid again when they should have. A sheet answers those with a pivot table and two formulas, and the person who does the books can already read it.
A sheet is also yours. The rows go from your WordPress site to your own Google account, and they stay there whatever you later change on the site.
What Does SheetLink Capture From MemberPress?
One source in the rule editor, MemberPress - transaction completed. A row is written each time MemberPress stores a transaction whose status is Complete, with these columns:
transaction_id- the MemberPress transaction numberuser_id,user_email,user_login- the memberproduct_id- the ID of the membership that was bought. The membership's name is not sent.amount- the transaction totalgateway- the payment method, as MemberPress records it on the transactionsubscription_id- the subscription the payment belongs to, or 0 for a one-time paymentstatus- always complete
What is not captured: transactions with any other status, such as pending, failed or refunded; cancellations, pauses and expiries; a change from one membership to another as an event of its own; and the member's profile or custom fields.
MemberPress records each payment on a subscription as its own transaction, so a renewal that is paid arrives as a new row with the same subscription_id. That is what the renewal watch below is built on.
How Does a Transaction Reach the Sheet?
SheetLink Pro listens on your own site for MemberPress saving a transaction and hands each completed one to the same delivery pipeline your forms use. The row is written through the one-click Google connection or through a classic Apps Script web app in your own Google account. There is no relay service in between, and MemberPress itself carries on exactly as before.
Because it is the same pipeline, the same safety net applies. Every delivery is listed in the Sync Log, and a failed one is retried about 5 minutes, 30 minutes and 2 hours later, then kept in the Retry Queue for a one-click re-send.
The feed is live only. It starts when you switch the rule on; earlier transactions are not imported.
Setting Up the Rule
You need the free SheetLink Forms plugin, the SheetLink Pro plugin with an active licence, and MemberPress.
- Install SheetLink Forms from WordPress.org and connect Google under SheetLink → Connect Google, picking or creating the spreadsheet for your register.
- Install SheetLink Pro and activate your licence under SheetLink → License. The MemberPress source comes with the Extra Integrations feature, which is on by default; its switch is on the SheetLink → Features page.
- Under SheetLink → Sync Rules click + Add Rule and choose MemberPress - transaction completed as the form plugin. Leave Form ID blank to cover every membership, or enter one membership's ID to cover only that one. The ID is the number after
post=in the address bar when you edit the membership. - Complete a test purchase, or mark a test transaction Complete in MemberPress, and check that a row arrived.
With the one-click connection the first transaction writes the header row. With the default settings the columns are, left to right: Timestamp, transaction_id, user_id, product_id, amount, gateway, subscription_id, status, user_email, user_login. The formulas below assume that layout and call the tab Payments; use your own tab name.
Revenue by Membership and by Month
Because product_id is a number, add a small lookup tab called Memberships with the ID in column A and the name you want to see in column B. On the Payments tab add a column K headed "membership" with =IFERROR(VLOOKUP(D2, Memberships!A:B, 2, FALSE), D2), filled down.
A pivot table on the Payments tab then answers most money questions: put membership in Rows, the Timestamp grouped by month in Columns, and the sum of amount in Values. Revenue for one month without a pivot is =SUMIFS(Payments!E:E, Payments!A:A, ">="&DATE(2026,11,1), Payments!A:A, "<"&DATE(2026,12,1)).
These are completed payments as MemberPress recorded them. A refund issued later is not written to the sheet, so reconcile against your payment processor before you treat a total as final.
New Members by Month
A member's first row is their first completed payment since the rule was switched on. On the Payments tab add a column L headed "first" with =COUNTIF(I$2:I2, I2)=1, filled down. It is TRUE on the first row for each email.
New members in a month is then =COUNTIFS(Payments!L:L, TRUE, Payments!A:A, ">="&DATE(2026,11,1), Payments!A:A, "<"&DATE(2026,12,1)). Members who were already paying before the rule was switched on will be counted as new on their next payment, so the first few months read high.
Who Has Not Renewed?
The sheet does not see cancellations, but it does see payments stop. For recurring memberships, the last payment on each subscription tells you who is overdue.
On a new tab, list each subscription once with =UNIQUE(FILTER(Payments!G2:G, Payments!G2:G>0)) in column A. In column B put the date of its latest payment, =MAXIFS(Payments!A:A, Payments!G:G, A2), and in column C the member, =INDEX(FILTER(Payments!I:I, Payments!G:G=A2), 1).
For a monthly membership, a latest payment more than 35 days old means a renewal did not arrive: =TODAY()-B2>35. Use 370 for annual memberships. Conditional formatting on that column turns the tab into a short list to check in MemberPress, where you can see whether the member cancelled, the card failed, or the subscription simply ended.
How Do You Keep the Numbers in Front of You?
A small Apps Script time trigger can email you every Monday with the week's payments, revenue and new members, read from the formulas above. Our walkthrough on scheduling weekly digests from Google Sheets has the script pattern.
Start with the rule and the lookup tab, and add the renewal watch once a full billing cycle has passed, since it has nothing to compare against before then.
Frequently Asked Questions
What MemberPress data does SheetLink send to Google Sheets?
One row for each completed transaction: the transaction ID, the member's user ID, email and login, the membership's ID, the amount, the payment method as MemberPress records it, the subscription ID and the status.
Are cancellations, refunds or plan changes sent?
No. SheetLink writes a row only when MemberPress stores a transaction with the status Complete. Cancellations, expiries, refunds, failed payments and a change of membership are not sent as events of their own.
Do renewal payments appear in the sheet?
Yes, when they are paid. MemberPress records each payment on a subscription as its own transaction, and each completed one becomes a row with the same subscription ID.
What do I need, and what does it cost?
The free SheetLink Forms plugin, the SheetLink Pro plugin and MemberPress. The MemberPress source is part of SheetLink Pro, which is $79/year or $199 lifetime; it is not in the free plugin.
Can I send only one membership?
Yes. Enter that membership's ID in the rule's Form ID. The ID is the number after post= in the address bar when you edit the membership. Leave Form ID blank and the rule covers every membership.
Why does the sheet show a membership ID instead of its name?
The transaction carries the membership's ID, and that is what SheetLink sends. Keep a two-column lookup tab of ID and name in the same spreadsheet and use VLOOKUP to show the name beside each row.
How do I track churn if cancellations are not sent?
Watch for payments that stop. List each subscription with the date of its latest payment, and flag the ones where that date is older than one billing period plus a few days. Then check those members in MemberPress to see what happened.
Can the same transaction appear twice?
It can. A row is written each time MemberPress saves a transaction as Complete, so a completed transaction that is saved again, for example after an edit, can produce a second row. The transaction_id column identifies repeats, and duplicate prevention on the rule, keyed on transaction_id, stops repeats that arrive within its time window.
Can I import existing transactions?
No. The feed is live from the moment the rule is switched on. Earlier transactions are not imported.
More Automation guides
Send Every MemberPress Payment to Sheets
SheetLink Pro writes each completed MemberPress transaction to your own Google Sheet, straight from your WordPress site.
