In some cases, it may be useful to store your subscribers from Hubbub’s Save This form into a Google Sheet that can then be uploaded to your existing mailing list provider.

Automatically Adding Save This Subscriber List to Google Sheets #

With a free add-on called Webhooks for Sheets, you can connect your spreadsheet directly to Hubbub using a webhook URL.

Getting Started #

You’ll need a Google account with access to Google Sheets. Once that’s ready, go to the Google Workspace Marketplace and install the Webhooks for Sheets add-on. Click Install and follow the prompts to give it access to your account.

Then:

1. Create a new Google Sheet.
2. Give the sheet a custom name, like “Subscribers” (you’ll need this later).

Opening the Webhooks App #

If the side panel isn’t open already, click the small arrow in the bottom right corner of the Sheets interface to open it.

From the side panel, click on the Webhooks for Sheets icon.

The app will walk you through the connection steps. Here’s a breakdown of what to expect:

Setting Up the Webhook (First-Time Setup) #

The first three steps prepare your spreadsheet to work with webhooks:

• Step 1: Rename your Google Sheet (you’ve already done this).
• Step 2: Click Enable to turn on the Apps Script API. This will take you to the Google Cloud settings page. Click into Google Apps Script API and enable it.
• Step 3: Return to your spreadsheet and reload the page to continue.

Once you reload, the app will be ready for webhook setup.

Creating the Webhook #

Now it’s time to configure where the data should go.

• Select the sheet tab inside your Google Sheet that you want to send the data to.
• (Optional) Enable the timestamp setting if you want to record when each entry is saved.
• Click Create.

The app will generate a unique webhook URL for your sheet.

Final Steps #

After the webhook is created:

1. Reload the spreadsheet again.
2. Click Next in the Webhooks side panel.
3. Your webhook URL will now appear in the panel.

Copy this URL and paste it into Hubbub > Save This > Zap Webhook URL (the field is titled Zap Webhook URL, but it accepts any webhook), then click Save Changes.

Note: You will need to toggle on “Enable Zapier” in order to see the webhook field.

You can now test the connection by saving a post via Save This. The subscriber’s email will be sent to your Google Sheet automatically via the webhook and will appear in your selected sheet tab.