Use a webhook source to push data into an automation from another application. The application sends a POST request to an address Sheetgo gives you, and the data it sends becomes the rows your automation processes. The webhook source is marked BETA.
Add a webhook as a source
Open an automation in the automation builder.
Under APPS & SERVICES, choose Webhook from the source list.
Select Copy URL to copy the address shown under DISPATCH URL.
Select Next step and choose where the data should be written.
Each webhook source has its own dispatch URL. Send data to that address and it arrives in that automation.
Authorize the request
Every request needs an Authorization header carrying your Sheetgo API key as a bearer token:
Authorization: Bearer <your API key>
The source step shows the key currently in use under AUTHORIZATION, with the middle characters hidden. Select Manage API key to create a key or replace the existing one.
Treat the dispatch URL and the API key as secrets. Anyone who has both can write data into your automation.
Format the request body
Send a JSON object with a values array. Each entry in the array is one row, and each row is an array of cell values. The first row becomes the header row:
{
"values": [
[
"Header 1",
"Header 2"
],
[
"row1.a",
"row1.b"
]
]
}
The source step shows this example under EXAMPLE REQUEST BODY. Select Copy body to copy it.
Choose a destination
A webhook source writes to a Google Sheets, Excel, or CSV destination.
To pass the data on to an API endpoint or to another webhook, build a second automation that reads from the file the first one writes. The builder suggests the same approach when a destination is not available for the source you picked.
Related articles