Excel allows users to create, edit, and collaborate on spreadsheets online. The following example demonstrates how to set up a custom webhook for an Excel spreadsheet.

Prerequisites

  • Microsoft account with access to OneDrive and Excel online

  • Power Automate

Obtain the Webhook URL

  1. Create an Excel spreadsheet in OneDrive.

  2. Name the file.

  3. In the spreadsheet, insert a table and save the file.

  4. Log in to Power Automate.

  5. In the portal, select Create. Then select Automated Cloud Flow.

  6. Select Add Trigger.

  7. Select “When a HTTP request is received” to add the trigger.

  8. For the requested body, refer to the example below. Change the properties as needed based on the columns in the spreadsheet.

    {
    "type": "object",
    "properties": {
    "column1": {
    "type": "string"
    },
    "column2": {
    "type": "string"
    }
    }
    }

  9. Select << to close the screen, saving the changes for the trigger.

  10. Select Add to add an action, then select Add a row into a table.

  11. Under Parameters, enter the location of the spreadsheet file and add the table you created to synchronize with the Add a row into a table action.

  12. Add each column from your table and synchronize them with the properties from the request body.

  13. Select << to close the screen, saving the parameters.

  14. Add a title for the Power Automate webhook trigger and save it to get the URL.

  15. After saving, select the trigger to 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.

© 2025 Honeywell International Inc. All Rights Reserved.