Create a bot in TG for working with Google Sheets.
Need to create a bot in Telegram for working with Google Sheets in two
In one table, we have content with posts, each post has its own number, category, subcategory
Then there is a second table. There, a script works that publishes content to the Telegram channel according to the time-post
I need to create a bot in Telegram, to which I will add 2 tables, and I will send it a content plan in the format: date - time - category, and it will randomly select posts from the category and send them to the table where the publication
example:
Saturday, 14.12
1. 09:15 — Familiarization with the product *(1)*
2. 11:50 — Audience survey *(6.5)*
3. 13:30 — Channel statistics *(4.3.1)*
4. 16:00 — Answer to the question *(2)*
5. 18:40 — Handling objections *(3)*
I will send this to the bot, and it will take posts from these categories from the table where the content is, and send them to the table where the publication of this content in the Telegram channel is.
-
2 days110 USD
2940 23 3 2 days110 USDDetail in the project brief
- how many posts to select
- date format in the publication table
P.S.
- I can create navigation and date, time, and category selection in the bot
-
6 days350 USD
449 3 1 1 6 days350 USDReady to develop a Telegram bot that automates the process of selecting content from Google Sheets and preparing publications in a second table based on your content plan.
Main functionality of the bot:
Connecting to the tables:
Access to two tables:
The first table with content (posts, categories, subcategories).
The second table for transferring content with publication information.
Processing the content plan:
…
The bot receives a textual content plan specifying the date, time, and categories.
Analyzes requests and finds relevant posts in the first table.
Selecting posts:
Random selection of posts from the specified category in the content table.
Considering already used posts (avoiding repetitions).
Filling the second table:
Automatic filling of the second table (date, time, post text) for transfer to the publication script.
Additional functionality (optional):
The ability to view the list of selected posts before saving to the second table.
Integration of notifications about successful table updates.
Technical implementation:
Programming language:
Python for the main logic of the bot.
gspread library for integration with Google Sheets.
Telegram API:
Using the python-telegram-bot library to work with the bot.
Integration with Google Sheets:
Reading the first table to obtain content.
Writing to the second table to transfer data to the publication script.
Logic of operation:
Parsing the content plan received via Telegram.
Searching for posts by categories.
Random selection and uniqueness of posts.
Hosting:
Deploying the bot on VPS or cloud platforms (AWS, Heroku).
Work stages:
Requirement gathering:
Detailed analysis of your content plan, table structure, and logic of the publication script.
Development:
Writing the main code of the bot for processing content and integrating with Google Sheets.
Testing:
Checking the bot's operation with real data.
Fixing bugs and optimization.
Launch:
Deployment and configuration of the bot for stable operation.
Benefits of collaboration:
Automation: Maximum simplification of work with content and publications.
Flexibility: Adaptation to your needs (possibility of adding new features).
Reliability: Ensuring uninterrupted operation of the bot.
Ready to discuss project details and propose an optimal solution. Write to agree on the next steps! 😊
-
1 day50 USD
235 1 day50 USDHello, this task is manageable for me. I will gladly complete it for the specified amount with the highest quality and the fastest speed.
-
1 day400 USD
3853 24 0 1 day400 USDGood day,
I am ready to take on your project.
I can create a bot in Telegram that will automatically select content from your post table based on the specified categories and send it to the table for publication in the channel.
My rate is $16 per hour. To start working, I will need more detailed information about the tables and data formats.
Sincerely,
… Maxim
-
2 days50 USD
1509 33 0 2 days50 USDHello! The task is quite simple, I can complete it as soon as possible and with high quality.
-
3 days60 USD
2054 47 7 2 3 days60 USDHello!
I can develop a Telegram bot for automating work with two Google Sheets:
• The first sheet is the content source (posts with numbers, categories, subcategories).
• The second sheet is for publishing content on a schedule.
The bot will:
1. Receive a content plan from you in the format “date-time-category”.
2. Randomly select posts from the first sheet based on the category.
… 3. Automatically add the selected posts to the publication sheet.
I will implement everything using Google API, provide a user-friendly interface, and ensure stable operation. Write to discuss the details!
-
5 days250 USD
95799 1272 1 10 5 days250 USDHello. I have extensive experience in developing Telegram bots. I am ready for collaboration.
-
2 days50 USD
1872 9 0 2 days50 USDHello!
I am ready to develop a Telegram bot to work with two Google Sheets, as you described.
I will use Python with the Aiogram and Google Sheets API libraries.
I am ready to discuss the project requirements to make the bot as convenient and useful as possible.
Best regards,
Dmitry
-
1 day50 USD
3096 50 1 1 day50 USDGood afternoon
I am ready to complete this work
Write to me
I will be happy to help
-
1 day50 USD
9944 117 0 1 day50 USDHello.
I am developing bots for Telegram using NodeJS. I have experience with Google Sheets. I am ready to take it on. Write to me, and we will discuss.
-
3 days50 USD
15541 214 1 3 days50 USDGood afternoon!
I am ready to do it.
I would be happy to discuss cooperation.
-
2 days60 USD
7134 13 0 2 days60 USDHello, the task is simple, I can do it without problems by Thursday.
-
1 day50 USD
2830 19 0 1 day50 USDHello! I am ready to develop the bot, I can start today. I suggest we discuss the details in private messages.
Current freelance projects in the category Bot Development
Telegram bot
269 USD
It is necessary to completely replicate the interface and functionality, but without the payment platform. It needs to be done in a short time. Bot Development ∙ 20 hours 17 minutes back ∙ 88 proposals |
Automatic video posting on social media according to a scheduleTechnical Assignment (TA) Automatic video publication on social media according to a scheduleProject Description A script/bot (Python preferred, or any other solution of your choice — the main thing is stability and ease of maintenance) is needed, which automatically publishes… Python, Bot Development ∙ 21 hours 52 minutes back ∙ 47 proposals |
Bot for receiving/searching applications
28 USD
In short: Create a bot where users can create and find profiles, the bot should have referral links, etc. Everything is detailed below. Client-side bot: Before the /start button, text in the center of the chat: What can this bot do? Welcome to Sugar Secret Agency! -Premium… Python, Bot Development ∙ 23 hours 54 minutes back ∙ 54 proposals |
Signal bot with automation in Google SheetsA bot is needed that will accept an application and automatically place it in Google Sheets, for example: store1, 26.06, 500kg or 200kg, and it will automatically mark 500 or 200 in the cell of the date on the store's line in the table. Bot Development ∙ 1 day back ∙ 57 proposals |
We are looking for a developer to create a trading bot/chatbot.We are looking for a developer to create a trading bot / chat bot. An IT specialist is needed who can develop a bot for market analysis 24/7 and send trading signals for gold, indices, Bitcoin, and Forex pairs. The main requirement is that the specialist must understand… Python, Bot Development ∙ 1 day 19 hours back ∙ 40 proposals |