Has anyone used the Zapier Webhook integration?

[Dilraj_Somel]

Basically, I am trying to use Webhooks for whenever my Airtable is updated with a new record.

Here is my understanding of how this works:

The webhook is like a user defined callback that can execute commands from one application to another.

So, first, I want the “trigger” to CATCH the HOOK. This generates a URL, but I am not exactly sure what to do with this. It says We’ve generated a custom webhook URL for you to send requests to.

URL: https://hooks.zapier.com/hooks/catch/3447493/r4nd0mn355/

I am guessing Airtable is going to have to send data to this URL, but nowhere does it explain how to do that. If I get Airtable to send data like that, I would just directly send it to my application.

So, can someone help me with sending a hook to my URL? I have a couple more questions latter, but they might be answered if this step works!

[Noel_Howell]

I’ve gotten around the missing ‘updates’ trigger for airtable records in by setting up a view with filters for the data updates I need and then any ‘new’ record in that specific ‘view’ will trigger zapier, which I can then use to update records elsewhere. I usually add a follow-up step in zapier to update the record in airtable so that it filters out of the view after being processed.

[W_Vann_Hall]

Will Zapier trigger on a record being displayed in the view a second time?

[Jeremy_Oglesby]

W_Vann_Hall:

Will Zapier trigger on a record being displayed in the view a second time?

I’m fairly certain the answer to this is no.

I’ve built a system for duplicating linked records for a client that operates on this same principle - a checkbox manually checked by the client initiates the zap by adding the record to be dupe’d to a filtered view. The last step of the zap checks another box that indicates zapier has done its job and all should be well - the record is removed from the filtered view. In tests, it was not possible to uncheck both boxes and have zapier act on the same record again by repeating the process. Thus, the system utilizes the checkboxes as an indicator that the record has already been “zapped” and it cannot be done again.

[openside]

hey everyone, we solved this shortcoming of triggering on updates more than once (as well as many other things) and finally able to announce its availability. Would love to get your feedback.

Custom Connector for Zapier Show and tell

Hey all, I’m really excited to share something that has been a long time in the making and one I think will help a lot of people. I’m curious: how many of you use Zapier for your Airtable integrations? I wanted to get a general poll for a sense of how people are using automation with Airtable: POLL: Do you use Zapier for your Airtable integrations? poll Excited to tell you about a project I’ve been working on and finally ready to launch! I’d welcome your feedback and insights on this. It trul…

[Henry_Bestritsk]

Connect the table to Slack which displays the update including the first column “key” value. Use zapier to lookup the document and do what you want like update the “updated date” field. The problem is that when you update 4 documents in zapier, it’s posted as one entry in Slack. It’s not an instant process. That’s the closest as I have come.

[alrotillman]

I’m banging my head against my desk because I’ve set up an entire system of email reminders to go out when something is overdue that depends on a record being able to trigger a zap if it is removed from the view and then reappears in the view at a later time point.

Can I get a definite answer from @Airtable_Support that the same record will not trigger a zap twice? I have a question into Zapier support as well.

Has anyone come up with any workarounds that do not cost $50/month? (Sorry, @openside, I work for a non-profit that does not have that kind of cash flow.)

Thanks for any help!

[mrmobius]

Can you give an example of when something that is overdue, becomes not overdue, then back into overdue again. Mapping this process may reveal a way to address the issue. :grinning:

[alrotillman]

My use cases:

1. A document could be due from one of our collaborators. However, our timelines often change (always being delayed, never moving up). If the timeline changes, I want to be sure that if the document was previously due (before the timeline change), that it will trigger the zap again when it comes to be due again.

2. We require quarterly check-ins with some on our collaborators. I keep track of when the quarterly check-in is due with a single view (I have a calculated field that tells me which quarter it is - 1, 2, 3, or 4). If a record in this view has already triggered my zap for the first quarter check-in, it won’t trigger it for any subsequent check-ins. I know I could solve this problem by creating a view for each quarter… but I have so many views already. This thing needs to be user-friendly in the end.

I ended up using the @openside plugin for these issues with the date trigger - so far so good! (Openside has a generous non-profit discount that helped a lot.)

[Dylan_Sather1]

Hi y’all,

I’ve setup webhooks for new records and record updates using a combination of Airtable’s Slack notifications and Pipedream (think Zapier, but optimized for webhooks).

For example, if you add a new record to a base, you’ll get a webhook out with a JSON payload sent to a custom HTTP endpoint for that update:

[
  {
    "tableId": "tbl98fitgvmmAR8aX",
    "recordId": "recltHKU7vKAv7bhW",
    "updates": [
      {
        "field": "Name",
        "newValue": "NEW RECORD"
      },
      {
        "field": "Status",
        "newValue": "CLOSED"
      }
    ]
  }
]

I documented the setup in a Medium post:

Medium – 20 Jun 19

Airtable Webhooks with Slack + Pipedream

We love Airtable here at Pipedream. But Airtable lacks one killer feature  —  webhooks.

Reading time: 7 min read

and this Pipedream pipeline:

Pipedream

Airtable Slack Messages -> Webhook - Pipedream

Accepts Slack messages from a channel dedicated to Airtable Slack notifications, modifies and sends a webhook out to a URL you specify

I’d love feedback on whether this helps solve anyone’s issues getting webhook notifications for record creation / updates.

Feel free to personally reach out if you need help getting it working — more than happy to help.

Dylan

[Jaosh_Sethna]

Didn’t use Zapier but used integromat since I couldn’t get it to work with the zaps.

Maybe you all want to have a look at my solution which I made to integrate airtable sheet with a wix website database. Same thing, but certain rules to follow for the integration to work. Have a check and let me know if it works for you’ll?

Wix to Zapier

Wix to Zapier Integration | Wix Database to Zapier

Integration of wix custom database through zapier which can then be used to pass on data to other applications such as google sheets, CRMs like pipedrive, HubSpot and other marketing solutions like mailchimp or sendgrid.