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 USD2 days110 USD
Detail 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
-
2 days50 USD2 days50 USD
Hello! The task is quite simple, I can complete it as soon as possible and with high quality.
-
3 days110 USD
1606 16 1 3 days110 USDGood afternoon! I am ready to take on the development of a post scheduler based on a Telegram bot. Please message me privately to discuss the technical specifications and terms of cooperation.
-
6 days350 USD
609 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
162 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
4536 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
-
3 days60 USD
2456 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
54570 1010 1 10 5 days250 USDHello. I have extensive experience in developing Telegram bots. I am ready for collaboration.
-
2 days50 USD
921 6 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
2553 37 0 1 day50 USDGood afternoon
I am ready to complete this work
Write to me
I will be happy to help
-
1 day50 USD
6359 86 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
9612 178 1 3 days50 USDGood afternoon!
I am ready to do it.
I would be happy to discuss cooperation.
-
2 days60 USD
1401 7 0 2 days60 USDHello, the task is simple, I can do it without problems by Thursday.
-
1 day50 USD
2470 15 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
Deploy the bot+admin panel on hosting
19 USD
There is an easy bot with an admin panel, it needs to be deployed on hosting and configured for routing interactions For more detailed information, I will be waiting for your response Bot Development ∙ 27 minutes ago ∙ 3 proposals |
Transfer call data from Binotel to Looker StudioHello, it is necessary to transfer call data from biontel to looker studio Incoming calls Outgoing calls Missed calls Please specify the cost and deadlines in the applications, thank you. Data Parsing, Bot Development ∙ 12 hours 32 minutes ago ∙ 6 proposals |
Test of the written Telegram bot and connecting it to the server. Quick payment
17 USD
Hello everyone! I already have a ready-made Telegram bot written in Python, which should automatically buy NFTs (gifts) according to certain filters (price, quantity, limit, recipients, etc.). ⚠️ What is needed: Test the code (all logic is already written). Finish/debug… DevOps, Bot Development ∙ 1 day 9 hours ago ∙ 8 proposals |
Arbitration dex cex bot signaling
250 USD
Need to create a bot that sends spread signals between DEX and CEX exchanges, it is important that they understand crypto Cryptocurrency & Blockchain, Bot Development ∙ 2 days 15 hours ago ∙ 5 proposals |
Technical task for the development of a hotel chat-bot program
362 USD
It is necessary to create a universal chat-bot for hotels that operates through Telegram and can be integrated into the hotel website as a pop-up widget. The bot should answer any customer questions regarding hotel operations, services, additional options, and accommodation… AI & Machine Learning, Bot Development ∙ 2 days 17 hours ago ∙ 18 proposals |