Skip to main content

Every day, a pizza shop offers a different specialty slice pie of the day, which I have listed on Airtables. The chat bot platform I'm using now is bad at telling time, so when someone starts using the chatbot, I would like to make an API call to my base to see

(1) what time it is and if the pizza shop is open; 

(2) if the pizza shop is serving slices [which serves between 11:30 a.m. and 2:00 p.m.]; and

(3) What specialty slice pie of the day they're serving?

I'm a newbie, but I don't mind doing research. If you can just give me a general direction, I would greatly appreciate it. thank you

Hi!

What chat bot tool are you using?

you can integrate with Make.com and create a workflow (sequence of steps) to search every "question" you mentioned. Then send the answer to chatbot

i'm an Airtable and Make consultant, you can contact me for further help.


As @Marcelo12 mentioned above, your best bet is to use Make’s advanced integrations and automations for Airtable.

I give an entire demonstration on how to use Make to connect ChatBots with Airtable on this Airtable podcast episode:

https://youtube.com/watch?v=LyNdh9E7bOQ&list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1&index=14&pp=gAQBiAQB


Hi!

What chat bot tool are you using?

you can integrate with Make.com and create a workflow (sequence of steps) to search every "question" you mentioned. Then send the answer to chatbot

i'm an Airtable and Make consultant, you can contact me for further help.


Yes, I am using Make.com and ChatBotBuilder, or CBB. Can you give me the basic structure of how you would run this?

Right now, I do use these platforms for an appointment-setting chat bot where CBB sends an API that creates a record, and then that triggers a script that grabs all of the user's information. And that's about the only experience I have, if that helps. I've included the photos. 

I'm going to assume I would have the system timestamp element included in the base spreadsheet along with the pizza of the day and its corresponding date.

1) Would I use a filter in Make to find the open/closed time, day of week, and date parameters for pie-of-the-day, or would that be done in a formula field inside of Airtables?

2) Would I use a similar trigger setup where CBB creates a record first to get a record ID? Or is there a better way? Thanks again for your help. mark

   


Hi!

What chat bot tool are you using?

you can integrate with Make.com and create a workflow (sequence of steps) to search every "question" you mentioned. Then send the answer to chatbot

i'm an Airtable and Make consultant, you can contact me for further help.


Here's an easy question for you, I'm trying to get this formula to work tell me what's not correct. I wanna match the slice pie of the day date with the current date


Reply