Airtable + Webhooks by Zapier + Formatter by Zapier + Google Sheets

How to Connect Apps to Webhooks Demo #1

The first demo for the How to Connect Apps to Webhooks presentation at ZapConnect 2023. In this Zap, we'll use a webhook to watch an app's URL for new instances, go back to the app for additional information in another webhook, use a Formatter step to create a lookup table to match information coming from the inital app to the information needed for a subsequent app, then use another Formatter step to convert the output of the lookup table into the desired format, and finally adding it to Airtable.

The first demo for the How to Connect Apps to Webhooks presentation at ZapConnect 2023. In this Zap, we'll use a webhook to watch an app's URL for new instances, go back to the app for additional information in another webhook, use a Formatter step to create a lookup table to match information coming from the inital app to the information needed for a subsequent app, then use another Formatter step to convert the output of the lookup table into the desired format, and finally adding it to Airtable.

  1. When this happens...
    Webhooks by ZapierWebhooks by Zapier
    Retrieve Poll

    Poll a URL and look for new entries.

    TriggerScheduled
  2. automatically do this...
    Webhooks by ZapierWebhooks by Zapier
    GET

    Fire off a single GET request with optional querystrings.

    ActionWrite
  3. then do this...
    Formatter by ZapierFormatter by Zapier
    Utilities

    Various utilities like "choose value from list" or "look up in table" (with line-item support).

    ActionWrite
  4. then do this...
    Formatter by ZapierFormatter by Zapier
    Utilities

    Various utilities like "choose value from list" or "look up in table" (with line-item support).

    ActionWrite
  5. then do this...
    Google SheetsGoogle Sheets
    Lookup Spreadsheet Row

    Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

    ActionSearch
  6. then do this!
    AirtableAirtable
    Create Record

    Creates a new record with auto-populating fields.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • URLRequired

    • Key

    • Deduplication Key

    • Xpath

    • Basic Auth

    • Headers

    Trigger
    Scheduled
    Try It
    • Pick off a Child Key

    Trigger
    Instant
    Try It
    • URLRequired

    • Query String Params

    • Send As JSON

    • JSON key

    • Unflatten

    • Basic Auth

    • Headers

    Action
    Write
    • URLRequired

    • Payload Type

    • Data

    • Wrap Request In Array

    • File

    • Unflatten

    • Basic Auth

    • Headers

    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

    • URLRequired

    • Data Pass-Through?

    • Data

    • Unflatten

    • Basic Auth

    • Headers

    Action
    Write
    • URLRequired

    • Payload Type

    • Data

    • Wrap Request In Array

    • File

    • Unflatten

    • Basic Auth

    • Headers

    Action
    Write
    • TransformRequired

    Action
    Write
airtable logo
airtable logo

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.
Learn moreHelp

Related categories

  • Databases

Similar apps

Quickbase integrationsQuickbase integrations

Quickbase

Databases
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
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.
Learn moreHelp

Related categories

  • Developer Tools
  • Zapier
formatter logo
formatter logo

About Formatter by Zapier

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.
Learn moreHelp

Related categories

  • Documents
  • Zapier
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 moreHelp

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets