Loading

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.

  1. When this happens...
    Webhooks by ZapierWebhooks by Zapier
    Catch Hook

    Wait for a new POST, PUT, or GET to a Zapier URL.

    TriggerInstant
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

    ActionWrite
Try this template
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • 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 id key. If the id key 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 with id in 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.

    Trigger
    Scheduled
    Try It
    • Pick 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.

    Trigger
    Instant
    Try It
    • URLRequired

      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.

    Action
    Write
    • 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.

    Action
    Write
  • Webhooks by Zapier triggers, actions, and search

    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.

    Trigger
    Instant
    Try It
    • MethodRequired

      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 data below will be overridden with the raw data from the previous step (you are still responsible for headers though, like Content-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.

    Action
    Write
    • 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.

    Action
    Write
    • 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

    Trigger
    Scheduled
    Try It
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

  • Google
  • Spreadsheets

Similar apps

Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
Quip integrationsQuip integrations

Quip

Documents
webhook logo
webhook logo

About Webhooks by Zapier

Webhooks simply POST data (or JSON) to a specific URL every time we see something new. Webhooks can also accept data (or JSON) to kick off a workflow in Zapier.

Related categories

Get started for free

You can't add more hours to the day. Zapier is the next best thing.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.