Freelance projects

Freelance projects

Business Safe

Simple chat bot

Bot Development — incorrectly specified categories?

16 USD

Project translated automatically. Log in or register, to view the original

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?

Proposals 17 Rejected 1

Andrey K.

1 296 1

Budget: 2500 UAH Deadline: 2 days

Hello. I have extensive experience in developing Telegram bots. I am ready for collaboration.

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.

Svitlana Kakaliuk

8 1

Budget: 1000 UAH Deadline: 1 day

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.

Anna N.

46 3

Budget: 1000 UAH Deadline: 1 day

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!

Tymur Mamyedov

31 0

Projects 31
Rating -
Rating 1 778

Budget: 2000 UAH Deadline: 3 days

Hello. Ready to develop
Write to me in private messages to discuss the details

Andrii Domashchenko

17 0

Budget: 5000 UAH Deadline: 7 days

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!)

Alona P.

1 0

Projects -
Rating -
Rating 321

Budget: 1000 UAH Deadline: 3 days

Hello, I professionally work with bots in Telegram!
I have extensive experience with telebot, aiogram, telegram API
I am waiting for your feedback :)

Dmitro Pulariia

22 1

Projects 22
Rating -
Rating 1 046

Budget: 1000 UAH Deadline: 3 days

Good afternoon
For the functionality you described, there is a simpler solution without Heroku / VPS and Google Sheets API.

Mikola S.

23 0

Projects 23
Rating -
Rating 1 285

Budget: 2000 UAH Deadline: 3 days

Good afternoon. I am ready to write such a bot. Let's get in touch and discuss the details.

Mihaylo Galagan

6 1

Projects 6
Rating -
Rating 589

Budget: 2000 UAH Deadline: 4 days

Hello! I can offer to implement this project using java + spring boot.

Vitalii Dovhaniuk

1 1

Projects -
Rating -
Rating 230

Budget: 1000 UAH Deadline: 2 days

Good day! Ready to complete today! Python + Google Sheets Api

Yurii Shtibel

8 0

Budget: 2000 UAH Deadline: 1 day

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.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Roman Fedonyuk

8 0

Budget: 700 UAH Deadline: 1 day

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

Signal bot for trading

Python 55 proposals 31 July

67 USD
Creation of an OLX bot

49 proposals 30 July

Not specified
Create an SEO system based on n8n

AI & Machine Learning 51 proposals 30 July

Not specified
Парсинг маркетплейсу

Data Parsing 31 proposals 30 July

38 USD
Post reposting bot for Telegram

85 proposals 28 July

68 USD

Kostya Petrov
Ukraine
Madhunt

Projects 39
Rating 3.8
Rating 2 661

Simple chat bot

Andrey K.

Yaroslav Stopin

Svitlana Kakaliuk

Anna N.

Tymur Mamyedov

Andrii Domashchenko

Alona P.

Dmitro Pulariia

Mikola S.

Mihaylo Galagan

Vitalii Dovhaniuk

Yurii Shtibel

Proposals are currently absent

Roman Fedonyuk

Current freelance projects in the category Bot Development

Signal bot for trading

Creation of an OLX bot

Create an SEO system based on n8n

Парсинг маркетплейсу

Post reposting bot for Telegram