Using Open AI with Automation in Airtable

[@GarethPronovost]

Grab my *FREE TRAINING* that teaches the building blocks of automation: www.garethpronovost.com/webinar-registration 👈👈 Get a 30-day free trial with Make.com here: www.make.com/en/register?pc=gapconsulting 👈👈

[@yannickgodin955]

So nice to see your excitment with GPT-3, Gareth! It's actually taking the No Code community by storm right now! Looking forward to discovering what other use cases you can come up with. Keep up the great work (this post was written by a human)!

[@GarethPronovost]

Lol @ "this post was written by a human" - the future is definitely now!

[@ManfredWania]

Gareth, this one is amazing! I‘m blown away. Thanks for sharing!

[@GarethPronovost]

So glad you enjoyed it. I'm still reeling by the opportunities here.

[@franckyahi3384]

Gareth, it seems that you have French ascedent du to your last name. Anyway, I shall say that you kind o contributed to change my job life. Watching your intro videos on Airtable was smething outstanding. I want ot thank you for the great job you've been doing. Indeed sometimes you 're fast but you bring valuable information. keep doing a greater job....

[@GarethPronovost]

Thank you so much, I'm truly honored to be of help. 🤝

[@insight-guy]

🎯 Key Takeaways for quick navigation: 00:00 🎥 The video discusses how to leverage AI and automation, particularly focusing on OpenAI's GPT model. 00:40 💻 The video presenter, Gareth from GAP Consulting, encourages beginners to start with his free training on no code automation. 01:36 🤖 Gareth presents the interface of ChatGPT, a paid part of OpenAI, which allows communication with an AI model. 02:33 🌨️ Gareth uses the AI model to generate a description of snow, demonstrating its text generation capabilities. 03:32 📝 Gareth presents his Airtable database, explaining how he uses it to store content and posts, and how these two are linked. 04:30 💡 Gareth proposes a scenario where AI could generate social media posts based on his blog content, saving him time. 05:26 📝 Gareth uses OpenAI to generate a social media post based on his blog, demonstrating the potential uses of AI in content creation. 06:51 🔄 Gareth refines his request to the AI model to make the generated social media post shorter, demonstrating how users can tweak their interactions with the AI for better results. 07:48 🔄 Gareth demonstrates how to incorporate the AI model into an automation, using a webhook for triggering the automation. 08:44 🔘 Gareth adds a button to his Airtable record to initiate the automation, demonstrating how to easily implement AI and automation into a workflow. 09:39 🧩 A concatenate formula is used in Airtable to append a unique record ID to the webhook URL. 10:06 🎯 This record ID helps in identifying the exact location in Make to apply any changes. 10:36 🔗 Once the URL is opened, the webhook gets triggered and the data is successfully sent and received in Make. 11:03 🔍 In Make, the data can be located using the record ID passed from Airtable. 11:57 🎫 Using the record ID, the corresponding data can be retrieved and viewed in detail. 12:56 🤖 OpenAI's GPT-3 is used to automate the creation of social media posts, providing unique content for each post. 13:55 📜 The automation uses the unique URL for each blog, ensuring the correct reference for each post. 14:24 📊 User can adjust the number of tokens and temperature values based on their requirement for risk-taking and length of text generated. 15:50 🔄 After the text is generated by OpenAI, it is updated back into Airtable. 16:47 💡 The entire process involves using automation and artificial intelligence to generate a social media comment, and update it back into Airtable. 17:17 🎉 The successful execution of this automation is validated in Airtable. 17:47 🚀 The automation can generate and share social media posts based on the content created, thereby eliminating the need for manual intervention. 18:15 🔄 Demonstrated a sample run using a blog post from November 2022. The automation correctly generates a relevant post based on the selected record. 18:43 💡 The system shows an intelligent understanding of blog content and generates relevant posts accordingly. 19:13 📚 Encourages new users to join in for a deeper understanding of no-code automation through training and subscribing to the channel. 19:41 🎓 Reminds viewers of the free training on no-code tools and automation basics available on their website, and invites them to explore other paid services, including advanced courses and consulting. Made with HARPA AI

[@LocalAlienCreative]

Dude, this was absolutly life saver! Thank you kindly!!!

[@GarethPronovost]

This is why we do what we do! Happy to help 💪

[@bfkouba]

This is exactly what I was looking for. Thank you! Can these automations be trigged in AirTable when a value changes instead of through a button?

[@GarethPronovost]

Definitely! You can trigger an automation based on a change in a specific field ✅

[@ValentinBrel]

Great Thank you! I have a small question : why don't you directly use the Airtable module with the integrated webhook as the first module? Thank you again

[@GarethPronovost]

It has to do with the way that make.com counts operations. If you search Airtable every 15 minutes for a trigger in Make, you will spend operations needlessly throughout the day. 4 per hour x 24 hours. This can run up the cost of your plan, so we use a webhook to counter that.

[@GarethPronovost]

The integrated webhook is a newer feature in Make, I'm not sure if it was available when we filmed this originally but it does the same job as our script+webhook

[@francisrealestateltd.]

I need to learn so Much from You ❤

[@GarethPronovost]

You can do it!

[@francisrealestateltd.]

Yes Sir 🙏🏿

[@tahirjetter5665]

Hey Gareth, if you wanted to continue going through all of your blogs with the same workflow, would you have just had to add a iterator module in Make and map it correctly?

[@GarethPronovost]

You can do this with an iterator, which would take many things and break it down for each item. Alternatively, you could create a different trigger and trigger many all at once. I wouldn't want to push a button 100 times, but I could copy paste a checkbox, for example

[@sergeyrizen9113]

Hi, Gareth 👋 It's just unbelievable! Thanks for sharing this recipe with the community. Two questions raise. 1. Am I right in thinking the same can be done using Zapier instead of Make? 2. Can something similar be done to correct grammar in an existing article/post? Many thanks and all the best

[@GarethPronovost]

Thanks for watching! 1. Sure you can use Zapier instead of Make.com, if you don't mind paying double for automations 🤪 2. You can add descriptions in your prompt to cultivate your optimal output. For example, you can ask for the output to be in a playful tone, or for it to be written for a fifth grader to understand. That said, I do recommend an editing step where you take the output and review it before publishing. I don't fully trust the AI to post on my behalf. 🤷‍♂️ 2.

[@sergeyrizen9113]

Hi Gareth! Thank you for the detailed reply. Yeah, we as humans should not release control entirely when dealing with AI. Will have a closer look at Make, thanks for the advice

[@williamho161]

Thank you for sharing the video! It's awesome!!

[@GarethPronovost]

Glad you liked it!

[@TowPiglet]

very cool

[@PaulGaleComedy]

Wondering if it's "reading" the blog, Gareth, or just writing the posts based on the descriptive text at the end of your URL. Would be a little more expensive, but you could use Make to send the body of the link through to Open API to ensure it's reading the text -- I assume that would lead to less generic results

[@GarethPronovost]

Excellent point!

[@TheMaxiviper117]

It does not have access to the internet

[@isaacwick9522]

dude you are a genius

[@GarethPronovost]

😂 thanks, hope this helps!

[@TheRemyRomano]

Nice job. So easy to do with Make.

[@GarethPronovost]

So easy and incredibly powerful!

[@cmmarinaroch]

Great stuff. Works like charm.

[@GarethPronovost]

Love it!

[@OntheHookGames]

I just implemented this. F*cking incredible. Thank YOU Gareth!!!!

[@GarethPronovost]

Woot!

[@nuzzre]

I can forsee lots of uses for this flow! However, I'm asking it to create a 200-300 word property description, and it's only giving me the first dozen words or so. I must be telling it to snip somewhere? Where would that be?

[@Pxl83webdesign]

This is great, any way to to do this using a button in an interface. I would love to press the button and have it post the Openai response to a text field in an interface I built.

[@GarethPronovost]

Absolutely. We do this constantly.

[@Pxl83webdesign]

@@GarethPronovost Great, I got it to work, added the button to the table and a text field and then added it to the interface. Is there a way to turn off the new window from opening when I click the button?

[@GarethPronovost]

Definitely. We did a video a while back that showed how to trigger Make.com from a button push without the window opening. It involves a script (copy/paste) and a webhook trigger. Do a search for the video, called "button push no more buttons Airtable" or something similar to that. (I'm on my phone and can't link the exact video)

[@hammadyounas2688]

@GarethPronovost. I have the content in the interface, How can I get that and pass to OpenAI?

[@GarethPronovost]

If the content is in your Airtable record, you need to send it to OpenAI using the automation (either Zapier or Make). To do this, build an automation that takes it from Airtable and shares it with AI, similar to how we did in the video.

[@naturallydope247]

What app are you creating the webhook in? Softr?

[@GarethPronovost]

The webhook here was created in make.com

[@juamsalvez]

Thank you Gareth! Is there any way to do the same in SmartSuite with the limitations that we have with Make at the moment?

[@GarethPronovost]

Hi! Yes this exact process can be replicated in SmartSuite using Make.com - their Make integration isn't public yet, but you can request access if you message their support channel.

[@vazapcool]

Is it possible to predict data from Airtable with BIGML?

[@GarethPronovost]

I haven't seen this done, but I checked BIGML and saw that they have an open API, so it is most likely possible, although I don't know if they have an integration with make.com or not. If not, you'd need custom code to create an integration.

[@556andressantorio]

This is amazing! Thank you Gareth! I am running into an issue, however. Somehow I have to go back to MAKE and hit 'Run once' in order for it to start listening to the buttons in the table. WIthout it if I click the button it opens the window but does not trigger the automation. Am I missing something?

[@GarethPronovost]

Hi! Have you upgraded to a paid account with OpenAI? It's inexpensive, but you do need a card on file with them to make API calls. Sorry I didn't explain that thoroughly in the video.

[@556andressantorio]

@@GarethPronovost no, but the calls go through. Isn’t it a MAKE setting to make the scenario always on?

[@nikolaytrakiyski6220]

@@556andressantorio I am having the same problem now. Did you bypass this by any chance?

[@556andressantorio]

@@nikolaytrakiyski6220 I managed to make it work for some time but I don’t use this automation anymore. Garett is is up to date I suppose.

[@trixymariemacaraeg2362]

Do I need a paid Open AI to be able to do this? My automation runs an error in ChatGPT and says I have reached my quota. :(

[@claudiolins4025]

Me too.. and i have chat gpt 4.0 :( can we help us from the basic?

[@tgauss]

Thanks for the tutorial! I'm having a similar issue I see happening in your video where the Open AI Text output is preceded by a few blank lines. Any idea how to prevent that from happening?

[@GarethPronovost]

I haven't cracked that just yet. For us it's a low priority since I'm having the output reviewed before getting published. Removing the spaces manually is just part of the review process, since I'm hesitant to trust the AI without a verification step.

[@PaulGaleComedy]

Could use the "trim" feature within Make to remove any blank characters before or after the text.

[@joingather]

Small thing, but instead of using Concatenate, I’ve found that "&" character easier to use & cleans up the code a bit. Just FYI

[@GarethPronovost]

Thanks for the tip! Personally I find & to be confusing and prefer Concatenate, but appreciate the different perspective!

[@joingather]

@@GarethPronovost To each their own! I normally use it and lean heavily on line breaks to keep the code easily readable, but 🤷‍♂ Great video btw, super interesting. Wondering when Airtable will begin building in AI content generation features more directly. Have you had to work much with Internationalization of apps you build atop Airtable? Wondering if you have good tips for serving content across a variety of languages.

[@rebeccavesperas8274]

@@joingather @GarethPronovost I'm wondering if I already have text in the description field if either methods mentioned here will completely overwrite the field. If so maybe I make a field just for the chatgpt generated product description and then have one for additional information, then add a third where I combine the two...

[@cgc2300]

hello can you explain to me what is the advantage of using airtable given that my articles are already stored on a database, WordPress

[@GarethPronovost]

I don't know that I'd consider WordPress to be a database as much as it's a way to build your website. I'm not a WordPress pro though, so I'm not the best person to discuss WP

[@cgc2300]

​@GarethPronovost hello I was talking to you about WordPress since I would like to do a business selling jewelry, so I am finding out about the plugins to use but I am also finding out about the subject of artificial intelligence and also using chatgpt with make to ask him to write me articles or product descriptions and send them directly to social networks, I had some ideas and could I see your opinion and also I still have questions regarding SEO, can chatgpt do keyword and hashtag research for me automatically? I also understood that content written by artificial intelligence is penalized by Google? anyway thank you for answering me

[@XxStupendousManxX]

Does SmartSuite also have the ability to disable a button until conditions are met?

[@GarethPronovost]

Yes and no. I tried using an IF( [Link], [Link], "") formula and it didnt' work for the button. However, I can just reference [Link] field and it is only able to be pushed if there's a link in the right field. So more advanced conditions seem not to be available just yet, but hoping soon!

[@dankelly]

Where are you in Airtable that you see that huge + button? It looks like a separate tool.

[@GarethPronovost]

I think you might be talking about Make.com

[@dankelly]

@@GarethPronovost ooooh. My bad. I've been watching a bunch of your Airtable videos and got this one mixed up with those. 👍

[@Group881]

I tried doing the prompts directly on Chat GPT and using the the airtable/make integration displayed. I found out that the direct Chat GPT prompt gave much better results. For some reason the result I keep on getting from airtable/make scenario using Chat GPT is cut, it does not paste all the text, is there reason this happens?

[@GarethPronovost]

Check the number of tokens you are allowing to be consumed by the automation. If you don't give it enough "gas" it can't give you lengthy results.

[@EvgeniyKharam]

Great video, thank you, how to create an API for ChatGPT ?

[@GarethPronovost]

Not sure I understand the question.

[@KellyBNunn]

Gareth. How can I contact you for consulting?

[@GarethPronovost]

We have some consulting options on our website here: garethpronovost.com

[@VoyceAtlas]

make sure he doesnt tell you that gpt has internet access lol because that explination was so off and wrong. all these people making videos about it and they dont know anying about how it really workds. the link is just being read and made up because it has words in it.

[@GarethPronovost]

@@VoyceAtlas correct, it doesn't connect with the internet. Apologies for the misinformation. 👊

[@ximenacastillo5270]

Hi! I am running into this error when running the Airtable module: RuntimeError [500] Origin Airtable Automatic error handler If you want to handle this error automatically, choose one of the following options. This will create a new error-handler route in your scenario. You can then expand the route in any way you like. ---- I have no idea how to fix that problem or where is coming from. Hope you can help me!

[@GarethPronovost]

Hi Ximena, I'm sorry I don't know what's causing this. Have you checked to make sure that Airtable wasn't "down"

[@Belfast1966.]

i keep getting an error "There is no scenario listening for this webhook."

[@GarethPronovost]

Have you turned your automation on?

[@Belfast1966.]

@@GarethPronovost your the man!😁thanks!

[@francisrealestateltd.]

❤❤❤

[@mattiasherrera1]

Wow!!!!!! That's all I can say

[@GarethPronovost]

Right?

[@pvellenzer]

God help us !

[@GarethPronovost]

Surreal, right?!?

[@User_PC_Loadletter]

Dude. .... Dude.

[@GarethPronovost]

Right?

[@Matrixeve-sojinsamuel]

In these types of videos, you don't have to start explaining what chatgpt is? etc; as per your video title "Using Open AI with Automation in Airtable" your target audience is already familiar with at least Open AI, Chatgpt, and Airtable. Next time please focus on the intent.

[@GarethPronovost]

Appreciate the feedback

[@robertt8279]

Between AI writing detectors and crypto watermarks within the text, folks need to watch out if they're using this blindly for Seo. You should never be putting content out on the web automatically without reading it and editing it first.

[@GarethPronovost]

Good advice!

[@VoyceAtlas]

bro this is bad info... you cant read the url... its reading the link words. do not use the way this guy said he doesnt understand that gpt does not have internet access.