Skip to content
  • Airtable logoAirtable logo
  • Google Sheets logoGoogle Sheets logo

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...
     logo logo
    TriggerPolling
  2. automatically do this...
     logo logo
    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
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

    • TransformRequired

    Action
    Write
    • TransformRequired

    Action
    Write
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Polling
    Try It
    • TransformRequired

    Action
    Write
    • TransformRequired

    Action
    Write
    • No Team Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Instant
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    • Trigger column

    Trigger
    Polling
    Try It
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.

Related categories

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

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.

Related categories

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.

Related categories

Triggers & Actions