Google Sheets allow users to create, edit, and collaborate on spreadsheets online. The following example demonstrates how to set up a custom webhook for a Google Sheets spreadsheet.

Prerequisites

  • Google account

  • Google Drive

Obtain the Webhook URL

  1. Log in to Google and create a Google Sheets spreadsheet.

  2. Name the file.

  3. In menu bar, select Extensions > App Script.

  4. Create the following function inside the Google App Script. This function allows you to send items and creates the headers automatically based on the key properties from the body posted.
    Note: Be sure to name the function doPost.

    function doPost(e) {
    var data = JSON.parse(e.postData.contents);
    var sheet = SpreadsheetApp.openById('<Google Sheet ID>').getActiveSheet();
    var newHeaders = Object.keys(data);
     
    var lastColumn = sheet.getLastColumn();
    var existingHeaders = [];
     
    if (lastColumn > 0) {
    existingHeaders = sheet.getRange(1, 1, 1, lastColumn).getValues()[0];
    }
     
    if (existingHeaders.length === 0 || !arraysEqual(existingHeaders, newHeaders)) {
    sheet.getRange(1, 1, 1, newHeaders.length).setValues([newHeaders]);
    }
     
     
    var rowData = [];
    for (var key in data) {
    if (data.hasOwnProperty(key)) {
    rowData.push(data[key]);
    }
    }
     
    sheet.appendRow(rowData);
     
    return ContentService.createTextOutput(JSON.stringify({ result: 'success' }))
    .setMimeType(ContentService.MimeType.JSON);
    }
     
    function arraysEqual(arr1, arr2) {
    if (arr1.length !== arr2.length) return false;
    for (var i = 0; i < arr1.length; i++) {
    if (arr1[i] !== arr2[i]) return false;
    }
    return true;
    }

  5. Change the value of openByid('<Google Sheet ID>'). The Google Sheet ID is located in your file URL.
    Example: SpreadsheetApp.openById('1mb5H7pUr1IKUSF91uR5TlBE34RrENbIgQgtfoG7rrI8').getActiveSheet();

  6. Select Deploy > New Deployment.

    1. For the type, select Web app.

    2. Enter a description.

    3. For Execute as, enter your gmail account

    4. For Who has access, select Anyone. Anyone with the URL will be able to use the webhook function.

    5. Select Deploy.

  7. Authorize access to the data.

  8. Select your Google account to continue. If needed, allow access to your Google account.

  9. Once this is done, the deployment will be updated and the web app URL will be available.

  10. Copy the URL that was automatically generated to test it in Elements.

Test the Webhook in Elements

  1. Sign in to Elements and create an automation.

    1. Action type: Execute Custom Webhook

    2. Webhook URL: Enter the URL obtained in the previous example.

    3. HTTP method: POST

    4. Content type: JSON (application/json)

    5. Request body:

      {
      "column1": "hello",
      "column2": "world"
      }

  2. Execute the action through the dashboard.

  3. View the spreadsheet and verify that information was written to the file.

Postman Test

Postman may be used to create a new POST request using the web app URL from the Google app scripts.

© 2025 Honeywell International Inc. All Rights Reserved.