What is your goal?
i am creating a sceanio in which i will add, update, delete and search the google sheet inventory data through a telegram bot. the sheet contains 300 items. i am using two groq modules, one for gazing the intent of the user and the other while generating response for search query.
What is the problem & what have you tried?
the problem i am facing is the the groq module is only giving responses based on first 200 rows of data while there are 300 rows of data present in my inventory google sheet. I also want to master this skill of accessing sheets data through telegram bot, can you suggest better ways to access huge data may be 500-1000 rows of data and generating responses for that.
Hello @Abiral_Barahpuria and Welcome to the Make Community!
Are you able to share any details about how your scenario works?
Please mask any personal information.
here the groq module shown in the right in the second route is the one which has to give the correct answer. but as you can see in telegram chat screenshot i received the output but there were more items in it but i didn’t got that as an output. You may give the solution or at least some good resources on how to fetch correct data using an ai module and how to structure this type of prompt
Why are you using groq for the output though? Can’t you just pass the result of the text aggregator back to telegram directly?
Also does the text aggregator have all the data inside to begin with?
yes text aggregator has all the required data. The simple logic of using groq ai because i want answers to different questions like Q1) How many items are there which are less than 20 in stocks, Q2) List all the items which belong to category electonics , Q3) Name item which as id 121 and many questions like these . My google sheet has columns: id, item, cateogy, no. of stock and price per piece. It has 200 items across 12 categories. I want to use groq to ask anyting related to this sheet which can’t be possible even if i create separate routes. By the way, for now i want answers to some basic questions which would be of great help to me if you could respond:
Q1) Do Ai models change their answers for the same question if asked at different times if we don’t do any change to the prompt?
Q2) I have used llama 3.3 70 b versatile for this scenario. would i have got the same answer even if I had used any other model?
Q3) with so many models across so many companies, how should i know that this model will be good with sheets and for answers that i have asked above?
Thank You
