Connecting to Google Sheets

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.