Start any no-code software from Airtable with Webhooks!
Vložit
- čas přidán 7. 07. 2024
- Get a free webhook with Make (formerly Integromat): rebrand.ly/test_make
Tutorial how to trigger and activate any other software based on action or state in Airtable.
The core code use in this video:
const inputData = input.config()
const { recordId } = inputData;
const response = await fetch("yourwebhookURL"+"?recordId="+recordId)
console.log(response.status)
Make / Integromat Free plan allows you to create fully functioning automation scenarios and provides monthly renewable 1000 operations credit.
Subscribe to Business Automated for more video automation tutorials 🚀:
czcams.com/users/BusinessAut...
Business Automated is an independent automation consultancy. If you would like to request custom automation for your business, visit us at www.business-automated.com
If you like our tutorials - buy us a coffee☕: www.buymeacoffee.com/business
Follow us on Twitter🐦: / bautomated
Read more on Medium 💆♂️: / business-automated
#Webhook #Airtable #nocode - Jak na to + styl
One year Later 13/05/2024: Thank You !
i searched such kind of video for month. THANKS! I´m ready for Part II. :-)
Cool! What would be part 2?🤔
thank you!
You are welcome!
Very cleaver ideia to use the query strings params to setup Make's webhook expected data!
With that, one would also be able to use a regular button field, on Airtable, to trigger the webhook, passing dynamic data based on row field values.
I'll do that right now.
Thanks for the sharing
When you are using it on the Button field - it will basically open a new window with that webhook, which I find bit annoying. Solution: Add a webhook response on the webhook - which automatically closes the window :
Close Window
window.onload = function() {
window.close();
}
How do you set this up?@@BusinessAutomatedTutorials
@@hanaabello Just return the code above in the webhook response with status code 200
Why not use the "watch" feature in Make that allows you to watch when records change in Airtable and then take action based on that?
Webhook is instant. I press the button, the invoice gets created, don't want to sit around and wait for it even for 5 min.
"Watch" has a lot of applications, but can also had some pitfalls, e.g. if records get added to the view and their modified date is before the date you run the scenario last time.. To avoid that, for scheduled scenarios, I use "Search records instead". Once action is executed, the scenario moves record out of the search criteria/view.
Thanks for your response, makes sense
ehh i dont have script in basic plan.... there is another way to send data using webhook?
You can use Button and ad webhook URL in the button field with the Record ID. It works, just annoyingly opens window every time.
I'm receiving a Runtime Error [404] NOT_FOUND on Make when the Airtable module is trying to get a record. The Airtable automation is showing it works correctly while testing and the webhook is receiving the recordid. On the Airtable module's INPUT everything looks correct with it showing the Record ID, Base, and Table. But none of the OUTPUT details have appeared. Do you have any ideas for what might be causing this error? Thanks!
That error suggest that you are looking up record ID that does not belong to Base/Table you have selected.
Either you are using different base with the same name by accident or are looking up ID from a different table - so no much. It happened to me million times.
@@BusinessAutomatedTutorials Thanks!
I want to clean up long automations by creating http post request to a webhook and catching the data from one scenario into the next. Is there an easy way to just retrieve everything in the last scenario without adding script?
Maybe somehow getting the last scenario as JSON and then iterating it out? Can I parse data on the HTTP post request and then get all the variables I used in the first scenario back in the second? Otherwise I have to just change airtable, have airtable watch records and wait which is okay but I’m also trying to learn more stuff.😊
Hi there. If you are just talking about Make scenario - you can always send HTTP request with JSON to another scenario.
You could also do it in make - finish Automation with a scripting module and send data via fetch() (make sure using method POST) to Airtable webhook to start another automation.
On the other hand if you are doing this in Airtable - you could just - update status of a record to e.g. Stage 4 and have another automation trigger watching for all records in Stage 4 - once that completes you set it to Stage 5 etc..
This way you could avoid writing JSON in the script module. As much as that is possible - just requires more typing.
@@BusinessAutomatedTutorials great! This helps a lot, thanks
the script is not working for me i can receive the new record in webhooks
Which part doesn't work for you? Any error that you are getting?
My first automations failed idk why, it says « fix testing error »
That is unusual message. Which module is giving this message?
I think you did not pass the initial testing stage
It can't fetch the record ID when I do this with Zapier..
Part of problem might be that that Zapier is giant POS 🤣 and cannot properly handle data.
Check first if you are attaching the recordID and really making request with it (have you added record ID in the input on the script?) .
If the request is made than the data should arrive on Zapier webhook, what might be another problem is the data schema saved on zapier. - You would have to "retest" a few times. I really stopped using Zapier as it is not worth my life 😂
@@BusinessAutomatedTutorials it keeps saying 'undefined' so I also think it makes more sense to keep using integromat.
@@309BO you need to be also sure that you are providing the recordId as input to the script at the beginning.
Hi, where can we find the script?
Looks like I have forgotten to add it... 😅 See below
const inputData = input.config()
const { recordId } = inputData;
const response = await fetch("yourwebhookURL"+"?recordId="+recordId)
console.log(response.status)
@@BusinessAutomatedTutorials returning from the services office in the account for real estate in TM
@@seanpollard1808 Tell me more, I think I do not understand your question
Script is not available in free plan :(
No only the Scripting block. You coud use Scripting block, but then you have to manually press the button.
@@BusinessAutomatedTutorials Yeah but that doesn't work if you want to automate things. Scripts showed in this video isn't available in Airtable with free plan
@@AadilKeshwani Yes, if you need to automate thigs that $29 bucks for paid Airtable plan is the best investment ever.