Telegram Bot chat manager analyzer
Bot settings are stored in a Google spreadsheet:
- list of manager nicknames
- prompts for chat analysis (day, week, month, quarter, year)
The bot should output results to separate Google spreadsheets (daily reports, weekly reports, quarterly reports, ready-made reports creating corresponding sheets (day with date, week with date range, etc).
Table structure for Daily Reports:
Sheet with the name 21.05.24 (or with the manager's name + date instead of the manager below + overall report + each chat separately with name and link)
Table header: manager, number of messages, questions to the manager, manager's responses, problems solved by the manager, messages without response, offers with offers (new products), tone, overall effectiveness rating from 1 to 10, recommendations. Ideally, also analyze each chat in which the manager is involved.
Need to optimize costs for tokens and make the bot trainable with memory and the ability to feed it with some documents with job instructions as well as make corrections in case of incorrect operation (on the Open Ai side).
-
419 13 0 Hello!
I work with Excel and Google spreadsheets.
Ready to help with formulas or macros (scripts).
Integration of Telegram bot and email with Google spreadsheets.
Looking forward to collaborating.
Hello.
I work with Excel and Google spreadsheets.
Ready to help with formulas macros (scripts).
… Communication with Telegram bot and email with Google spreadsheets.
I will be glad to cooperate.
-
2138 22 2 hello. I have experience in text analysis with OpenAI and also in building chatbots based on it.
did not fully understand what these chats are. is it just a manager and a client, or more people.
let's discuss the details so that I can come up with how to break down all the processes you need into small requests to the API, as well as reduce their number.
-
1165 11 1 Good day, I have experience in developing Telegram bots, as well as working with Google spreadsheets, write
Current freelance projects in the category Bot Development
Set up an AI bot in ManyChat for Instagram and Facebook MessengerSet up ManyChat Pro + OpenAI API (model gpt-4o-mini, but you can suggest something niche). Without Make/Zapier, if it can be implemented with ManyChat's internal tools, or with them if you justify the need.Bot operation logic:Triggered by any incoming message from a new client… AI & Machine Learning, Bot Development ∙ 16 hours 3 minutes back ∙ 23 proposals |
Telegram Bot + Send PulseI am looking for a freelancer who can help set up a Telegram bot for a simple mini course. Please send your portfolio along with the price. Thank you Bot Development ∙ 18 hours 6 minutes back ∙ 61 proposals |
Payment bot
223 USD
Connecting payment for a closed club in Telegram. It is necessary to set up a payment format where the user pays with a card from any country, and the channel author receives converted $ into their wallet. Additionally, reminders, automatic deductions, and automatic addition and… Bot Development ∙ 23 hours 6 minutes back ∙ 71 proposals |
It is necessary to develop a Telegram bot for monitoring cars from auctions in the USA (Copart, IAAI)A Telegram bot is needed for automatic searching and monitoring of "BUY IT NOW" cars at auctions in the USA (Copart, IAAI). The bot should operate automatically and send notifications about new cars that meet the specified filters.Main functionalityFilter settings: 1. Car… Data Parsing, Bot Development ∙ 2 days 20 hours back ∙ 93 proposals |
Telegram bot
53 USD
I need code for a Telegram bot that will take messages from one channel, modify them to fit my design, and post them in two other channels. In one channel, from 1 to 6 posts, and in the other channel, all posts. Bot Development ∙ 3 days 10 hours back ∙ 93 proposals |