Skip to main content

Form | Google Sheets Real-Time Integration Setup Guide

Part 1: Prepare your webhook URL (on Google's side)

Step 1. Make a copy of the Google Sheets template

  1. Sign in: Sign in to the Google account you want to use to receive the data.

  2. Open the template: Click the provided [Google Sheets template] (this template already includes a pre-written data-receiving Apps Script).

  3. Make a copy: Make a copy of the template into your own Google Drive.

Step 2. Deploy the Apps Script to generate a webhook URL

  1. Open Apps Script: In your copy of the Google Sheet, click the "Extensions" menu at the top, then select "Apps Script."


  2. Create a new deployment: On the Apps Script page that opens, click "New deployment" in the top right.

  3. Deploy as a web app: Choose to deploy it as a "web app."

  4. Complete authorization: A permissions dialog will pop up — follow the steps to complete authorization (this lets the app write to your Google Sheet).


  5. Get the URL: Once authorization is complete, you'll see a full URL appear — this is the webhook URL you need to paste into the Form dashboard. Copy this URL.

Part 2: Set up the Form webhook (on Feversocial's side)

Step 3. Set up the Form's webhook

For how to set up a webhook, see: Webhook setup guide

Step 4. Test the transfer and you're all set

  1. Send a test: Click the "Send Test Data" button.

  2. Check the results:

    • Check whether the Form dashboard shows "Connection Successful."

    • Most important: immediately open your copy of the Google Sheet and confirm that a new test entry has been received.

  3. Save and activate: Once the test succeeds, click "Save." From then on, every new form submission will automatically and instantly flow into your Google Sheet.

Did this answer your question?