Connecting to Google Forms

Connecting to Google Sheets

Estimated reading: 2 minutes 168 views

Step 1: Generate Webhook API Key from REM

  1. Generate the Webhook API Key from REM for the campaign.
    👉 Guide on how to generate an API key from REM

Step 2: Create Google Form

  1. Go to Google Forms.
  2. Click Blank Form.
  3. Add a question:
    • Question Title: Name
    • Question Type: Short Answer
    • Make it Required.
  4. (Optional later) Add more fields (Email, Phone, City, etc.) — the script can be updated easily.

Step 3: Link Form to Google Sheet

  1. In the Google Form → go to the Responses tab.
  2. Click the green Sheets icon → it will create a Google Sheet.

Step 4: Set Up Google Sheets Script

  1. Open your Google Sheet.
  2. Go to Extensions → Apps Script.
  3. Delete any existing code.
  4. Copy & paste the following script:

function sendLeadToREM(e) {

  // e.values contains all form responses in order

  var rowData = e.values;

  // Map data (Timestamp is [0], Name is [1])

  var postData = {

    source: “google_form”,

    contact_name: rowData[1] // Name

    // Later you can add more fields like email, phone, etc.

  };

  var options = {

    method: “post”,

    payload: postData

  };

  var apiUrl = “Webhook URL of your REM”;

  var response = UrlFetchApp.fetch(apiUrl, options);

  Logger.log(response.getContentText()); // Debugging

}

Step 5: Set Up Trigger

Before running and deploying the script, you need to set up a trigger:

  1. In the Apps Script editor, open the left menu → click Triggers icon.
  2. Click + Add Trigger (bottom right).
  3. Select the following:
    • Function: sendLeadToREM
    • Event source: From spreadsheet
    • Event type: On form submit
  4. Click Save.
  5. On first run, Google will ask for authorization → click Allow.

Step 6: Run & Deploy

  • After setting the trigger, run the script once manually.
  • Your leads from Google Form → Google Sheet will now automatically sync into REM.

Leave a Comment

Share this Doc

Connecting to Google Sheets

Or copy link

CONTENTS