Simple chat bot
16 USD 
Automation of adding job vacancies from our Telegram channel to Google Sheets. The bot reads new posts and adds them to Google Sheets.
📌 Goal:
• Automatically extract job vacancies from Telegram posts.
• Fill Google Sheets without manual input.
• Create a convenient system for storing and updating data.
2️⃣ Technical implementation (Python + Google Sheets API) or your option
• Telegram Bot API (so the bot can read messages). 7630111878:AAHfAldPAsF7kq2wGVbjzsiOgB2jBLe0gjM
• Google Sheets API (to write job vacancies to the table by fields) https://docs.google.com/spreadsheets/d/1cxY153GPVJsum_Dz5T4yuAQL10yyXOqfTxif6xK1Jpo/edit?usp=sharing
• Python (script for processing job vacancies).
• Heroku / VPS (so the bot works 24/7).
3️⃣ Bot operation algorithm
1️⃣ Reads new job vacancies from the channel. Add a link to the post in TG in the table.
2️⃣ Extracts data (location, salary, schedule, requirements, etc.).
3️⃣ Writes them to Google Sheets.
4️⃣ Sends a notification to the manager about the new vacancy.
4️⃣ Code for Telegram bot (Python)
import telebot
import gspread
from oauth2client.service_account import ServiceAccountCredentials
# Connecting to Google Sheets API
scope = ["https://spreadsheets.google.com/feeds", "https://www.googleapis.com/auth/drive"]
creds = ServiceAccountCredentials.from_json_keyfile_name("credentials.json", scope)
client = gspread.authorize(creds)
sheet = client.open("Table_Name").sheet1 # Select the sheet
# Connecting to Telegram API
TOKEN = "YOUR_BOT_TOKEN"
bot = telebot.TeleBot(TOKEN)
# Handler for new job vacancies
@bot.channel_post_handler(func=lambda message: True)
def handle_message(message):
text = message.text
lines = text.split("\n")
# Extracting data from the post
vacancy = {
"vacancy": lines[0],
"location": lines[1].split(": ")[1] if "Location" in lines[1] else "",
"salary": lines[2].split(": ")[1] if "Salary" in lines[2] else "",
"schedule": lines[3].split(": ")[1] if "Schedule" in lines[3] else "",
"requirements": lines[4].split(": ")[1] if "Requirements" in lines[4] else "",
"link": f"https://t.me/c/{message.chat.id}/{message.message_id}"
}
# Adding to the table
sheet.append_row([vacancy["vacancy"], vacancy["location"], vacancy["salary"], vacancy["schedule"], vacancy["requirements"], vacancy["link"]])
bot.send_message(message.chat.id, "✅ Vacancy added to the table!")
# Starting the bot
bot.polling()
1️⃣ Create a bot in → copy the API token.
2️⃣ Create a Google Sheet with columns: Vacancy, Location, Salary, Schedule, Requirements, Link.
3️⃣ Create a service account in Google Cloud → get credentials.json.
4️⃣ Deploy the bot on a server (Heroku / VPS).
6️⃣ What will this give?
-
2 days56 USD
94014 1265 1 10 2 days56 USD
Hello. I have extensive experience in developing Telegram bots. I am ready for collaboration.
-
7 days226 USD
1315 7 0 7 days226 USD
Good day.
I am ready to take on your project.
I can develop such a bot for you using no-code/low-code tools and node.js (if needed)
Message me privately, we will discuss all the details and find the best solution for you.
-
1 day23 USD
670 8 1 1 day23 USD
Good day, I have extensive experience in developing Telegram bots, I am ready to start working right now and complete it quickly, and most importantly, with quality.
-
1 day23 USD
1850 46 3 1 day23 USD
Hello!
I am interested in your project, I have extensive experience in automating/emulating user actions (JavaScript, Selenium, Playwright), asynchronous/multithreaded parsing (Requests, WebSockets, HTTPX, BS4), data processing (Openpyxl, JSON, MySQL, MongoDB), and developing Telegram bots of varying complexity (Telethon, Pyrogram, Aiogram).
Contact me to discuss the details and deadlines for this project!
-
3 days45 USD
1810 31 0 3 days45 USD
Hello. Ready to develop
Write to me in private messages to discuss the details
-
7 days113 USD
3714 17 0 7 days113 USD
Hello! 😊
I am ready to develop a bot for you that will automatically read job postings from your channel, extract the necessary data (title, location, salary, schedule, requirements) from the posts, and save it in a Google Sheet via the Google Sheets API. Additionally, the bot will send notifications to the manager about new job postings, which will significantly simplify the work.
Technologies used:
Python – the main programming language.
Telebot/aiogram – for creating the Telegram bot.
gspread and oauth2client – for integration with the Google Sheets API.
… Heroku/VPS – to ensure the bot operates continuously 24/7.
I would be happy to discuss your project and deadlines in detail. I look forward to your response!
Best regards,
Andriy!)
-
3 days23 USD
369 1 0 3 days23 USD
Hello, I professionally work with bots in Telegram!
I have extensive experience with telebot, aiogram, telegram API
I am waiting for your feedback :)
-
3 days23 USD
1084 22 1 3 days23 USD
Good afternoon
For the functionality you described, there is a simpler solution without Heroku / VPS and Google Sheets API.
-
3 days45 USD
1341 23 0 3 days45 USD
Good afternoon. I am ready to write such a bot. Let's get in touch and discuss the details.
-
4 days45 USD
613 6 1 4 days45 USD
Hello! I can offer to implement this project using java + spring boot.
-
2 days23 USD
230 1 1 2 days23 USD
Good day! Ready to complete today! Python + Google Sheets Api
-
1 day45 USD
834 8 0 1 day45 USD
I can start working today and complete everything quickly within 3 hours. I write in Python and have extensive experience in creating bots. Telebot is a poor library; it's better to use Aiogram. It is much more reliable and works better with large volumes. If you need me to write in Telebot, I can do that too, no problem.
-
1 day16 USD
1711 8 0 1 day16 USD
Good day. I am ready to complete it. I have many successful cases that I can tell you more about in private.
Current freelance projects in the category Bot Development
Link UA Telegram botA Telegram bot needs to be developed that connects clients and performers of physical labor (movers, cleaning, repairs, laborers) across cities in Ukraine. Functionality: Two roles — client and performer. The client creates a request, selects a category, specifies the address… Bot Development ∙ 1 hour 20 minutes back ∙ 30 proposals |
Automation of creating advertising creatives.There is a solution in the form of Higgsfield AI + nodes that generate quite close to the idea based on the prompt, paired with almost frame-by-frame editing, everything works well, except for one thing, which is the censorship on the use of celebrity faces and such. An… AI & Machine Learning, Bot Development ∙ 11 hours 44 minutes back ∙ 8 proposals |
Futures botA futures trading bot needs to be created. Under defined conditions, it should automatically set take profit, hedge, lock in profits, and automatically restart trading. Bot Development ∙ 22 hours 59 minutes back ∙ 36 proposals |
Telegram automation of message distribution in chatsNeed to send messages to Telegram chats. To avoid bans. There are several hundred chats. To configure the frequency and variability of texts. Python, Bot Development ∙ 1 day back ∙ 30 proposals |
Telegram botIt is necessary to develop a bot for a Telegram group. The functionality of the bot is quite simple: 1. Text recognition in voice messages 2. Checking for prohibited words in text 3. If prohibited words are detected, the bot should automatically delete this voice message. Bot Development ∙ 1 day 2 hours back ∙ 60 proposals |
Ukraine