Simple chat bot
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?
-
94026 1265 1 10 Hello. I have extensive experience in developing Telegram bots. I am ready for collaboration.
-
1315 7 0 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.
-
670 8 1 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.
-
1850 46 3 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!
-
1810 31 0 Hello. Ready to develop
Write to me in private messages to discuss the details
-
3714 17 0 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!)
-
369 1 0 Hello, I professionally work with bots in Telegram!
I have extensive experience with telebot, aiogram, telegram API
I am waiting for your feedback :)
-
1084 22 1 Good afternoon
For the functionality you described, there is a simpler solution without Heroku / VPS and Google Sheets API.
-
1341 23 0 Good afternoon. I am ready to write such a bot. Let's get in touch and discuss the details.
-
613 6 1 Hello! I can offer to implement this project using java + spring boot.
-
230 1 1 Good day! Ready to complete today! Python + Google Sheets Api
-
834 8 0 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.
-
1711 8 0 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
AI agent in Telegram for online store
451 USD
Task: creating an AI agent in Telegram for live communication with customers and processing orders in the online store on OpenCart. It is also necessary to implement customer notifications regarding order statuses, store operating hours, working conditions, delivery times, and… AI & Machine Learning, Bot Development ∙ 2 hours 40 minutes back ∙ 29 proposals |
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 ∙ 5 hours 18 minutes back ∙ 46 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 ∙ 15 hours 43 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 ∙ 1 day 2 hours back ∙ 37 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 4 hours back ∙ 30 proposals |