Hi! I need help setting up Make.com for a Telegram bot with OpenAI Assistant. The bot asks things like “Which houses are free on Saturday?” and pulls data from a Google Sheets table with columns “House” (e.g., “Number 1”), “Mon”, “Tue”, “Wed”, “Thu”, “Fri”, “Sat”, “Sun” (days of the week), and values “free” or “booked”. I want Make.com to take the bot’s request, grab the table data, and send it back to the bot in JSON so it can reply, e.g., “Number 1 is free.” I tried a webhook, Google Sheets, and a couple other modules, but it’s not working—the bot stays silent. Can someone suggest a simple scenario: which modules to use and how to set them up to make it work? Thanks!
Welcome to the Make community!
Yes, that is possible. You’ll need a minimum of 5-6 modules:
This is just an example. Your final solution may or may not look like this depending on your requirements.
I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
Getting Started
- Help Centre | Tutorials – Make “Manual”
- Make Academy – Basics 101: Learn Make and get certified
Help Centre Basics
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Aggregate an array for mapping complex fields
- Date Format: tokens for
parseDate| tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
- How to use Regex in Make - How to use pattern matching to extract the text you want
- Webhooks – Make Academy – tutorial on how to use Webhooks
I have answered questions about Telegram bots and OpenAI elsewhere on the forum if you want to go down this route. I think it’s in one of the threads I replied to previously. You can use the forum search feature on my profile page to find related topics.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.