Google Sheets + Webhooks by Zapier
Add info to a Google Sheet from new Webhook POST requests
Keeping an updated record of key information means you never have to wonder if there are missing or forgotten items. Set up this integration, and Zapier can catch a webhook POST from any source you want, automatically adding the information to a new row on Google Sheets once you've chosen which items go into different columns during setup. From then on, you can be sure we'll catch everything while you're free to work on other tasks.
Keeping an updated record of key information means you never have to wonder if there are missing or forgotten items. Set up this integration, and Zapier can catch a webhook POST from any source you want, automatically adding the information to a new row on Google Sheets once you've chosen which items go into different columns during setup. From then on, you can be sure we'll catch everything while you're free to work on other tasks.
- Free forever for core features
- 14 day trial for premium features & apps
URLRequired
This should return a list of dictionaries of content type JSON in reverse chronological order. For example:
[{"id":1234},{"id":1235}]Key
If the returned JSON is not a list and is instead an object (maybe paginated), enter the key that contains the results. Example: "results", "items", "objects", etc... (children via dot syntax supported)
Deduplication Key
Zapier deduplicates the array we see each poll against the
idkey. If theidkey does not exist, you should specify an alternative unique key to deduplicate off of. If neither are supplied, we fallback to looking for the shortest key withidin it otherwise we will raise an error.Xpath
If the content fetched is XML or HTML, optionally define an xpath to extract data from the content. Will trigger whenever the content at the xpath changes!
Basic Auth
A pipe (
|) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
Try ItPick off a Child Key
By default, Zapier gives you the entire payload of the webhook. If this is specified, Zapier will only grab the child key from the object(s) sent to Zapier. For example, given
{"contact": {"name": "Mike"}}, add "contact" here to only return{"name": "Mike"}. Traverse more deeply nested children by using dot-separated syntax. Line item payloads will run your Zap for each instance of the child key.
Try ItURLRequired
We recommend not putting any query string arguments in the URL (use "Query String Params" below).
Query String Params
These params will be URL-encoded and appended to the URL when making the request. Note: If you specify nothing for this field, we will automatically encode and include every field from the previous step in the query string. If you don't want this, use the "Custom Request" action.
Send As JSON
If "yes", this dumps the results directly to a key (set below) as JSON. If "no", we simulate a form.
JSON key
Only used if As JSON.
Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
URLRequired
Any URL with a querystring will be re-encoded properly.
Payload Type
Pay special attention to the proper mapping of the data below.
Data
These are key-value pairs that will form the data portion of the request. If you leave these empty, all fields from the previous step will be used. If you want to send your own raw JSON or form-encoded values here, please use the Custom Request action instead.
Wrap Request In Array
Wraps the request in an array if that is something the service requires.
File
A file object to be attached to the request. The request will automatically be converted to
multipart/form-data, with the above payload type defining the sub content-type for the data being passed.Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
Catch Raw Hook
Wait for a new POST, PUT, or GET to a Zapier URL. Gives the request body unparsed (max 2 MB) and also includes headers.
Try ItMethodRequired
The HTTP method we'll use to perform the request.
URLRequired
Any URL with a querystring will be re-encoded properly.
Data Pass-Through?
If yes, request
databelow will be overridden with the raw data from the previous step (you are still responsible for headers though, likeContent-Type). Defaults to no.Data
Place raw data for the request here. Could be JSON, XML, etc. Nothing is parsed for you here (including extra line breaks or spaces -- everything is sent verbatim). You probably need to define a header below corresponding to your data
Content-Type. Reminder: data provided in this field is completely ignored if you chose "yes" to pass-through.Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
URLRequired
Any URL with a querystring will be re-encoded properly.
Payload Type
Pay special attention to the proper mapping of the data below.
Data
These are key-value pairs that will form the data portion of the request. If you leave these empty, all fields from the previous step will be used. If you want to send your own raw JSON or form-encoded values here, please use the Custom Request action instead.
Wrap Request In Array
Wraps the request in an array if that is something the service requires.
File
A file object to be attached to the request. The request will automatically be converted to
multipart/form-data, with the above payload type defining the sub content-type for the data being passed.Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try It
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
About Webhooks by Zapier
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.