SureMembers → Google SheetsEvents and actions

Use SureMembers events to automate Google Sheets

Choose a SureMembers event to start an automation, then add or update a row in Google Sheets. The action settings show what information you need to provide.

See plans and pricing See what you can do ↓

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.

Add or update a row in Google Sheets when a user is added to an access group

When a user is added to an access group
Add or update a row in Google Sheets.

Available in Noptin

Google Sheets actions

Rows

1 action

Add or update a row in Google Sheets.

Available in Noptin

SureMembers events and actions

Memberships

3 events · 2 actions

View events and actions

Events

When a user is added to an access group
When a user is removed from an access group
When an access group is published

Actions

Add a user to an access group
Remove a user from an access group

About this connection

How the two tools fit together

SureMembers: A simple yet powerful way to add content restriction to your website.

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 SureMembers 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 SureMembers 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 SureMembers and Google Sheets from Noptin → Extensions. How to activate your license.
Install and set up SureMembers on your WordPress site. Connect Google Sheets in Noptin using the account or server details requested in its settings.

See how to install a premium extension.

How to install the Noptin newsletter plugin

Put it together

Set up the automation in WordPress

Choose a SureMembers 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 SureMembers and Google Sheets?

Build the automation in your WordPress dashboard with Noptin.

See plans and pricing