# Using ChatGPT with Glide: telegram -\> Glide -\> telegram integration via make **URL:** \ **Category:** Ask for Help\ **Tags:** chatgpt, make\ **Created:** [April 29, 2024, 2:04pm UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935 "2024-04-29T14:04:52Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![fraser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fraser/32/68111_2.png) [@fraser](https://community.glideapps.com/u/fraser)\ **Post date:** [April 29, 2024, 2:04pm UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935/1 "2024-04-29T14:04:52Z")
Hi I’m building an app / website for a sports (paragliding) club, part of which is building a knowledge base of interesting articles and links, which I’ve done - so far so good. I’ve connected this knowledge list to ChatGPT which gives me a rather splendid way to search the database; screenshots below if anyone is looking to do this too. I’ve utilised the ‘answer questions about a table’ feature which gives me the sort of response I’m looking for i.e. one fairly tightly confined to answering questions about the table. The club uses Telegram extensively for communication and discussion and I’d like to be able to connect this to my knowledge base; probably through make although I’m open to suggestions. Currently I’ve been able to connect make to Telegram, I can send messages from inside Glide to Telegram: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/6/865f12a47ec24faf99d262bbdc21f59a9f02ec9a.png) and I can capture Telegram messages in a Glide table ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/eda2bd2aa9af0ac45dfcefd21128fead0443c658.png) What I’d like to be able to do is replicate the ‘answer questions about a table’ functionality to do the following: 1. Collect a telegram message 2. Feed this question to ChatGPT along with my glide table 3. Send the ChatGPT response back to Telegram It’s the table information I’m not able to collect. Any ideas? ChatGPT setup below for anyone looking to do this part. Cheers ---
**Author:** ![fraser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fraser/32/68111_2.png) [@fraser](https://community.glideapps.com/u/fraser)\ **Post date:** [April 29, 2024, 2:18pm UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935/2 "2024-04-29T14:18:00Z")
# Chatbot table: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1d8625dd6f74a3791ea5ed8c799fb42f5a909e04.png) # Response table: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/c/0cd72508aaa7c39e64a2273c785c751522421af3.png) # Layout ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a505d440e690f2727961b3b117a1d21fdb80a069.jpeg) The reply button triggers the action above, clearing the previous answer from the chatbox and saving the response. # Action: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/4/e49118f565bce64d9b743fdada0cc0b4f6141991.png) # Set column values ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/4151042e6982253eaa279d1c30e286654427916c.png) # OpenAI setup Before doing this you need to set up the integration with your OpenAI API. You don’t need a premium account but do need tokens - for testing a few £ did it for me The context from the chatbot table is very important; this contains a set of fixed information about how I want the response to be generated; things like present it in markdown, always give a link to the relevent table item ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/c/1cd0d02921362e837d2d9e668a96fa1b940d4840.png) # Add row / set values ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/1599f653c50760e88b7e14026682a46572d46528.png) # Set column values ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/88b3246cacdd43926e4a47d75c839801a6423b3a.png) # And opens the detail (answer) page ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4ab3fdf499f12c9d4e6f8180de5b95ec76633fce.png) Hope that helps someone. As I said above I’m trying to replicated this functionality with the question submitted from telegram and returned to telegram, probably using [make.com](http://make.com) if anyone can help with that ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 29, 2024, 2:54pm UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935/3 "2024-04-29T14:54:30Z")
With “answer questions about a table”, what Glide does under the hood, as far as I can recall, is first converting your table into vectors, then your question to a vector, and pulls out the most related vector from the table to try to answer your question. Now I don’t have actual experience with building something like this, I did try using OpenAI’s [embeddings](https://platform.openai.com/docs/api-reference/embeddings) last year but it was more of a personal project, and using Python, not via their API. This Vector Store thing, going alongside their Assistants API, looks like what you need to build an application for that. [https://platform.openai.com/docs/api-reference/vector-stores](https://platform.openai.com/docs/api-reference/vector-stores) However, Glide is handling the “ever-growing database” part for you in the app, in the Assistants API you’re uploading files for them to convert to vectors, so how you handle adding new records to the vector store, I imagine that would be a headache. ---
**Author:** ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)\ **Post date:** [January 9, 2025, 8:52am UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935/4 "2025-01-09T08:52:04Z")
@ThinhDinh didn’t David just say in the annual update that this year they would look at integrating RAG into Glide Tables? Or did I misunderstand that? I have a few use cases for RAG and have built a pinecone integration via [make.com](http://make.com) myself and another one directly from glide with stack-ai, however the pinecone one is (imo) a bit more complex to setup and maintain and stack-ai doesn’t give me the granularity for settings and metadata filtering to get great results out of it. If you or someone would have more info about Glide integrating RAG I would love to be involved! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 9, 2025, 3:38pm UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935/5 "2025-01-09T15:38:43Z")
> [@Tim\_Gestels](#): > > didn’t David just say in the annual update that this year they would look at integrating RAG into Glide Tables? Or did I misunderstand that? Sorry, I’m out of the loop on this, can you share where he said that? If it’s a meeting, 100% I missed it because they’re usually midnight to 3AM my time. Also, my comment was a bit old. Since then, internally at my agency, we have tried various third party solutions that can accept links from our knowledge base and answer our new hires’ questions. I think that’s the closest use case I have for this. > [@Tim\_Gestels](#): > > If you or someone would have more info about Glide integrating RAG I would love to be involved! I’m just a fellow user like you, I almost have no inside info 😅 ---
**Author:** ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)\ **Post date:** [January 10, 2025, 8:21pm UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935/6 "2025-01-10T20:21:28Z")
It was in the gliding into the new year 2024 at 21:50 [https://www.youtube.com/watch?v=yBZZxyBB9lA&t=1310s](https://www.youtube.com/watch?v=yBZZxyBB9lA&t=1310s) No problem, I assumed you would know more. You seem to be involved in everything ;-), probably due to all the great advice on the forum here. But anyways I’m looking for better tooling to get RAG quality at a decent level. Just random chunking (without adding context, metadata filtering & reranking) and storing in a vector database doesn’t seem to be enough. But I didn’t find a nocode tool yet that allows you to do that via an API. If you would hear of a good solution let me know! Best regards, Tim ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 11, 2025, 12:36am UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935/7 "2025-01-11T00:36:26Z")
> [@Tim\_Gestels](#): > > It was in the gliding into the new year 2024 at 21:50 [https://www.youtube.com/watch?v=yBZZxyBB9lA&t=1310s](https://www.youtube.com/watch?v=yBZZxyBB9lA&t=1310s) Thanks for the link. That does sound like what you’re suggesting as well. However, I believe that isn’t necessarily a new thing, the “Answer question about a table” action already does that. I believe they just want to enhance it. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 11, 2025, 12:36am UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935/8 "2025-01-11T00:36:57Z")
> [@Tim\_Gestels](#): > > If you would hear of a good solution let me know! > **[Quickstart](https://www.embedding.io/docs/quickstart)** > > ImportantThe API and its documentation are still in progress and not stable yet.Get your API tokenPlease follow the steps on the Authentication page to make authenticated requests.Create your first collectionA collection is a group that will hold... We’re using this internally. ---
**Author:** ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)\ **Post date:** [January 11, 2025, 9:22am UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935/9 "2025-01-11T09:22:17Z")
Maybe but if you rewind to 10 seconds before he says it’s an integral part of their underlying database infrastructure. Also for big tables. So I’m hoping/assuming it’s a big thing. 🤞 ![1000078245](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a5734fa9357de3e29f3ced06f974f0dab67d65bf.jpeg) ---
**Author:** ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)\ **Post date:** [January 11, 2025, 9:22am UTC](https://community.glideapps.com/t/using-chatgpt-with-glide-telegram-glide-telegram-integration-via-make/72935/10 "2025-01-11T09:22:59Z")
Thanks will test it out 👌