Add or update a row in Google Sheets when a member's membership level changes
When a member's membership level changes
Add or update a row in Google Sheets.
Simple Membership → Google SheetsEvents and actions
Use Simple Membership events to automate Google Sheets
Choose a Simple Membership event to start an automation, then add or update a row in Google Sheets. The action settings show what information you need to provide.
Already using Noptin? Learn how to create an automation rule.
Noptin is installed on 15,000+ websitesSee what users say
Automation ideas
Ways to connect these tools
These are examples. Available fields depend on the event and the choices on your site or connected account.
Available in Noptin
Google Sheets actions
Rows
1 action
- Add or update a row in Google Sheets.
Available in Noptin
Simple Membership events and actions
Memberships
3 events · 2 actions
View events and actions
Events
- When a member registers
- When a member's membership level changes
- When a member's membership status changes
Actions
- Change a member's membership level
- Change a member's membership status
About this connection
How the two tools fit together
Simple Membership: A flexible, well-supported, and easy-to-use WordPress membership plugin for offering free and premium content from your WordPress site.
Google Sheets: Google Sheets is a web-based spreadsheet application that enables you to create, edit and share spreadsheets online. With this integration, you can automatically add and update data in your Google Sheets when certain events occur in WordPress.
What information can you send?
Choose a spreadsheet and worksheet. Noptin shows its column headings so you can decide what goes in each column.
Available details depend on the Simple Membership event or action you choose and any fields configured on your site. Available columns come from the header row of the worksheet selected in the connected Google account.
Before you begin
Have these details ready
For Add or Update Row, you will need:
- Connected Google account
- Spreadsheet and worksheet
- Values for the worksheet columns
Start here
Set up Simple Membership and Google Sheets with Noptin
- Install the free Noptin plugin on your WordPress site.
- Activate your Noptin license, then install the Noptin add-on for Simple Membership and Google Sheets from Noptin → Extensions. How to activate your license.
- Install and set up Simple Membership on your WordPress site. Connect Google Sheets in Noptin using the account or server details requested in its settings.
How to install the Noptin newsletter plugin
Put it together
Set up the automation in WordPress
- Choose a Simple Membership event to start the automation.
- Select the Google account, spreadsheet, and worksheet that should receive the row.
- Match the details from the first step to the fields in the second. Run a test, then turn on the rule.
Follow the automation rules guide if you need help creating the rule.
Ready to connect Simple Membership and Google Sheets?
Build the automation in your WordPress dashboard with Noptin.
See plans and pricing