Google Sheets Integration

Use the Google Sheets add-on to automatically add or update a row in Google Sheets when specific events occur in WordPress.

Setting up the integration takes just a few minutes. This guide will walk you through connecting your spreadsheet and adding data step by step.

Installation

1. Log in to your WordPress admin dashboard.
2. Navigate to Noptin → Extensions and open the Connections tab.
3. Find the Google Sheets add-on by scrolling through the list of extensions.
4. Click Install Now. After the install finishes, activate the addon.

After installing the add-on, follow these steps to complete the setup.

Step 1: Create OAuth 2.0 Credentials

1. Go to the Google Cloud Console
2. Create a new project or select an existing one

3. To prevent connection warnings, go to audience settings and add your email as a test user.
4. Next, enable the following APIs:
   • Google Sheets API
   • Google Drive API (for read-only access to list spreadsheets)

5. Go to APIs & Services → Credentials
6. Click Create Credentials → OAuth client ID

7. Create the OAuth client ID as follows:
   • Application Type: Web Application
   • App name: Noptin
   • Authorized redirect URI: You can find this in your WordPress admin dashboard at Noptin > Settings > Integrations > Google Sheets.

8. Click Create and copy the Client ID and Client Secret

Step 2: Configure the Integration

1. In your WordPress admin, go to Noptin → Settings → Integrations.
2. Find the Google Sheets integration settings.
3. Enter the Client ID and Client Secret that you copied in the previous step.
4. Click the “Save Settings” button to save your settings.
5. Finally, click Connect to Google Sheets to connect Noptin to Google Sheets.

Noptin will redirect you to the Google OAuth screen. Enable all scopes, then authorize the connection.

Google will redirect you to the Noptin settings page. Ensure the integration is connected as shown below.

Step 3: Start Using the Integration

Once connected, you can create automation rules that automatically add rows to Google Sheets.