Webhooks by Zapier + Google Sheets + Salesmate Integrations
How to connect Webhooks by Zapier + Google Sheets + Salesmate
Zapier lets you send info between Webhooks by Zapier and Google Sheets and Salesmate automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Webhooks by Zapier + Google Sheets + Salesmate
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Webhooks by Zapier, Google Sheets, and Salesmate. And don’t forget that you can add more apps and actions to create complex workflows.
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
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
How Webhooks by Zapier + Google Sheets + Salesmate Integrations Work
- Step 1: Authenticate Webhooks by Zapier, Google Sheets, and Salesmate.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
About Webhooks by Zapier
Related categories
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.