Connect Google Sheets
Authorize the Google account that owns the spreadsheet.
Spreadsheets
Connect Google Sheets to WordPress
Add or update a Google Sheets row when something happens on your WordPress site. Match form, order, or other event details to the columns in your worksheet.
Noptin is installed on 15,000+ websitesSee what users say
How it works
Send WordPress activity to a spreadsheet
Choose a worksheet
Select the spreadsheet and worksheet that should receive the data.
Match the columns
Choose what goes into each column, such as a form answer or an order number.
Available in Noptin
Google Sheets actions
Rows
1 action
- Add or update a row in Google Sheets.
Explore connections
What can you send to Google Sheets?
Google Sheets + GeoDirectory
When a listing is published → add or update a row in Google Sheets.
See how to connect them →Google Sheets + Formidable Forms
When a specific Formidable Forms form is submitted → add or update a row in Google Sheets.
See how to connect them →Google Sheets + Hizzle Pay
When a customer has made a certain number of orders → add or update a row in Google Sheets.
See how to connect them →Google Sheets + Forminator
When a specific Forminator form is submitted → add or update a row in Google Sheets.
See how to connect them →Worksheet columns
Your worksheet determines the available columns
Available columns come from the header row of the worksheet selected in the connected Google account.
A form submission only provides fields collected by the form you select. Add the column headers you need in Google Sheets, then match them to the available values in Noptin.
Automation ideas
Example automations
These are examples. Available fields depend on the event and the choices on your site or connected account.
Save a Gravity Forms enquiry and add the sender to Noptin
When a specific Gravity Forms form is submitted.
Add or update a row in Google Sheets.
Create or update a subscriber.
Select a form with an email field. Map its answers to the worksheet columns, then map the same email address to the Noptin subscriber step.
Add or update a row in Google Sheets when someone subscribes
- When a subscriber's status changes to subscribed.
- Add or update a row in Google Sheets.
Add or update a row in Google Sheets when a Noptin subscriber is tagged
- When a tag is added to a subscriber.
- Add or update a row in Google Sheets.
Start here
Set up Google Sheets with Noptin
- Install the free Noptin plugin on your WordPress site.
- Activate your Noptin license, then install the Noptin add-on for Google Sheets from Noptin → Extensions. How to activate your license.
- Connect Google Sheets in Noptin using the account or server details requested in its settings.
- Create an automation rule with the Google Sheets row action, choose a worksheet, match its columns, then run a test.
How to install the Noptin newsletter plugin
About 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.
Ready to use Google Sheets with Noptin?
Follow the setup above, then build your first workflow in WordPress.
See plans and pricing