How to Add Subscribers to a Google Spreadsheet with Zapier

Do you want to easily maintain a spreadsheet of your subscribers? With OptinMonster’s Zapier integration, it’s simple! In this guide we’ll show you how to use Zapier to automatically send your OptinMonster lead information to a Google Spreadsheet.

NOTE: Zapier is a paid service, however they do offer a trial you can use to determine if it’s the right fit for your needs.
  1. Create Google Spreadsheet
  2. Configure Webhook Integration
  3. Create Zapier Action
  4. Configure Google Sheets Action
  5. Test Action
  6. Turn on Your Zap

Step 1 – Create Google Spreadsheet

If you don’t already have a specific Spreadsheet created in your Google Sheets account you want to use to add subscribers to, you’ll want to create one now.

To begin, create a new Spreadsheet in your Google Sheets account.

Once created, name your new Spreadsheet.

Give your new Spreadsheet a unique name.

Finally, in the first row of your spreadsheet you’ll want to add the title of each data object you wish to collect. These can be any name that is convenient to you. Later, when you are configuring your Zapier Action, you’ll be prompted to link each title with the specific data object passed by OptinMonster. In this example we’ve setup our Spreadsheet to collect all data that can be passed by OptinMonster:

  • Lead First Name
  • Lead Last Name
  • Lead Email Address
  • Lead Phone Number
  • Lead IP Address
  • Lead Referrer URL
  • Campaign ID
  • Campaign Title
  • Campaign Slug

Add the Titles for each data object you wish to collect to the first row of your Spreadsheet.

Step 2 – Configure Webhook Integration

Now that you have your Spreadsheet ready, be sure to connect OptinMonster to Zapier using our Webhook integration option.

Follow our Zapier integration guide to connect OptinMonster with Zapier.

Step 3 – Create Zapier Action

Once you’ve configured a Webhook Trigger in Zapier following our Zapier integration guide, you’ll be ready to create an Action for your Zap. Select the Continue button to begin configuring your Action.

Once you've created your Webhook Zapier Trigger, you can begin configuring your Zapier Action.

Step 4 – Configure Google Sheets Action

From the Choose an Action App screen, select Google Sheets.

Note: you may need to search for this app if you haven’t previously used it in a Zap.

Choose from the Apps available in Zapier to use as your Action.

Next you’ll be prompted to specify what Action should happen within Google Sheets. Choose Create Spreadsheet Row from the options, followed by the Save + Continue button.

Choose Create a Spreadsheet Row as the Google Sheets Action.

Zapier will now ask you to choose or connect your specific Google Sheets account. If you haven’t already connected your Google Sheets account to Zapier, select Connect a New Account.

Connect your Google Sheets account to Zapier.

If connecting a new Google Sheets account, a new window will open prompting you to login to your Google account and confirm Zapier can access your account. Select the Allow button to proceed:

Confirm that Zapier can access your Google Sheets account when prompted.

Once connected, that window will close and you’ll be returned to your Action setup. You’ll see your new Google Sheets account available to select now. Once you select the account you want to connect for this Action, select the Save + Continue button.

Once you've connected your Google Sheets account, select it then continue to the next step.

On the next screen you’ll be asked to choose the Spreadsheet and Worksheet that this Action should write new lead data to. In the beginning we created a new spreadsheet named ‘My Zapier Spreadsheet’, so that is what we selected for the Spreadsheet field. For the Worksheet field you can choose ‘Sheet1’ unless you specifically need to add data to a different sheet of your spreadsheet.

Choose the Spreadsheet and Worksheet to add data to.

Once you set the Spreadsheet and Worksheet fields, additional fields will appear on the screen so you can link Titles you set in your new spreadsheet in the beginning of this guide to the data objects passed by OptinMonster. Selecting the dropdown for each field will show you each data object option.

You'll now be able to link the specific data objects to the Columns of your Spreadsheet.

Link each Title to the data object so the data is written to the correct column in your spreadsheet. This might look like the following:

Your configuration may look like this example, showing linked Spreadsheet columns with specific data objects passed by OptinMonster.

Then select the Continue button.

Once you've configured your Spreadsheet setup, select the Continue button to proceed.

Step 5 – Test Action

Zapier is now ready to test the Action you’ve configured and will show you the following screen. When you’re ready, select the Create & Continue button to test your Action.

Once you've setup your Spreadsheet, you can test your Action setup.

If everything was correctly configured you’ll see a success message! Select the Finish button to proceed.

If your Action setup is correct, you'll see a Success Message.

IMPORTANT: You can also confirm the data has been correctly added to your spreadsheet, you’ll see a notice added by Zapier indicating test data has been entered:

Once you've tested your Action, you can open your Spreadsheet in Google Sheets to confirm data was added by Zapier.

Step 6 – Turn on Your Zap

The final step is to turn your new Zap on!

The last step is to enable your Zap.

That’s it, you’ve successfully configured OptinMonster to work with Zapier to add subscribers to a Google Spreadsheet!

Looking for more ways to connect OptinMonster with Zapier? Check out our guide on how to receive text messages of new subscribers using SMS by Zapier.