Telegram channel parser in Google Sheets (for OpenCart, with price updates)
56 USD 📋 Task description:
It is necessary to develop a parser for Telegram channels of clothing suppliers.
The parser should retrieve new posts from the channels, extract the main data (text, photo, price, sizes), and record them in Google Sheets.
❗ The table must be prepared for further import into OpenCart.
❗ At this stage, complex AI or full product parsing is NOT required.
🔗 Main functionality:
Connection to Telegram (via account)
Parsing posts from channels (list will be provided)
Processing only new posts (without duplication)
Partial data parsing (price, sizes — if possible)
Recording in Google Sheets
📥 Data to be retrieved:
Full text of the post
Channel name
Link to the post
Photo (URL, multiple images)
Price (if present in the text)
Sizes (if present in the text)
📊 Table structure (mandatory):
product_name
description
model
sku
price_supplier (supplier price)
markup_percent (markup percentage)
price (selling price)
quantity
stock_status
category
main_category
options (sizes, colors)
image
additional_images
source_text
channel_name
post_url
💰 Price logic (IMPORTANT):
The parser records the price only in the field:
👉 price_supplierThe field markup_percent is set manually
The field price (selling price) is calculated only in Google Sheets using the formula:
price = price_supplier * (1 + markup_percent / 100)
❗ IMPORTANT:
price_supplier is NOT used in OpenCart
only price is passed to OpenCart
the formula must be implemented in Google Sheets (not in code)
📏 Sizes:
The parser should try to extract sizes from the text
Record in the options field in the format:
Size:S,M,L
(if there are colors — also add them)
⚠️ Filling logic:
if data (price, sizes) is not found — leave empty
the entire text must be recorded in the source_text field
🔄 Operation logic:
check for new posts every 5–10 minutes
do not add duplicates (by post_url or ID)
🔄 Product update logic (VERY IMPORTANT):
If the supplier changes the price:
✅ update only:
price_supplier
✅ accordingly, price is automatically updated:
price (via formula)
❗ IT IS PROHIBITED to overwrite:
product_name
description
category
options
any fields that are edited manually
📌 That is:
if the product is already in the table → do not overwrite the entire row
only update the price
🧠 Product identification:
by post_url or post ID
📸 Photos:
store URL
support multiple images
⚙️ Technical requirements:
Python
Telethon or Pyrogram
simple and clear code
ability to add new channels
📌 Result:
working parser
automatic recording in Google Sheets
correct price update logic
launch instruction
💬 In your response, please indicate:
experience with Telegram API
examples of similar projects
timelines
cost
💡 Development plan (not included in this TOR):
full product parsing
moderation
integration with OpenCart
Client's review of cooperation with freelancer
Telegram channel parser in Google Sheets (for OpenCart, with price updates)Thank you for your work.
Freelancer's review of cooperation with Serhii Yalanzhy
Telegram channel parser in Google Sheets (for OpenCart, with price updates)Great client, I recommend for collaboration.
-
4 days147 USD
4 days147 USD
Good day.
I have reviewed the technical specifications. The task is clear: a Python parser for Telegram channels through an account is needed, which retrieves only new posts, extracts text / photos / price / sizes, records data in Google Sheets, and correctly updates only price_supplier without overwriting manually edited fields. This approach is logical to implement for your MVP. ()
I will implement this in Python using Telethon or Pyrogram, with careful deduplication logic based on post_url / post ID, basic extraction of price and sizes from text, support for multiple photos, and automatic recording in Google Sheets. The price formula will remain in Google Sheets, as you specified in the technical specifications. ()
What you will receive as a result:
— a working parser;
— recording in Google Sheets in the required structure;
— updating only price_supplier for already existing products;
— understandable code with the ability to add new channels;
… — an instruction manual for launching.
I have practical experience in Python automation, parsing, working with APIs, processing structured data, and building careful update logic without duplication. In similar tasks, the key for me is not just to "collect data," but to make the system stable for further operation and scaling.
Cost: 6500 UAH
Deadline: 4 days
If necessary, I can immediately lay out the structure after agreeing on the terms so that in the next stage it will be easy to transition from Google Sheets to a full import into OpenCart.
-
2 days56 USD
2 days56 USD
Sergiy, the task is clear: we need not just a parser, but a careful collection of new posts without duplicates, with recording in Google Sheets and correct updating of only price_supplier. I will implement this in Python + Telethon/Pyrogram: tracking channels, extracting text, photos, prices, and sizes, saving source_text and a constant logic of updating by post_url/ID without overwriting manual fields. Has experience with Telegram API and integrations for e-commerce. Ready to quickly discuss the structure and start.
Similar completed project: Парсинг та фільтрація сторінок, що продають оригінальну парфумерію по Україні
-
1 day56 USD
1 day56 USD
✋ Hello! We are the IT company dZENcode.
We can create a Telegram channel parser for you with data recorded in Google Sheets for this task.
Do you already have access to the list of channels?
Do you need filters for new posts and price updates right away?
We work in iterations, rates starting from 750 UAH/hour.
You can find detailed information about our services and rates on our website:
Freelancehunt
… Take a look – we will discuss the details of the work further, write when you are ready.
The final cost is determined only after clarifying the scope and requirements.
___________________
Best regards,
Manager of dZENcode
Our strengths:
💎 10+ years providing IT services: Outsourcing, Outstaffing
🔥 90+ in-house specialists
🚀 Projects "from scratch" and for support
⚙️ SLA and post-production support
✅ Contract with the company, guaranteed results!
🔥 250+ public reviews since 2015.
-
3 days68 USD
886 3 0 3 days68 USD
Hello! I am a Python developer specializing in automation and working with the Telegram API (Telethon/Pyrogram). The task is completely clear, especially the critical point regarding the logic of updating prices without overwriting manual edits.
My approach to implementation:
— Telegram: I will use Telethon to monitor channels in real-time. New posts will be processed instantly.
— Data parsing: I will write regular expressions (RegEx) to extract prices and sizes. All raw text will be stored in source_text, as you requested.
— OpenCart Ready: The table structure will clearly match your requirements for further import.
I am ready to discuss the details and demonstrate code examples in private messages!
-
3 days54 USD
409 3 days54 USD
Good day! I have carefully read the project brief — the task is clear, I am ready to take it on.
What I will implement:
— Connection to Telegram via account (Telethon)
— Parsing new posts from your channels every 5–10 minutes
— Extracting price and sizes from the text (regex)
— Recording in Google Sheets in your structure (product_name, price_supplier, options, etc.)
— Deduplication logic by post_url — there will be no duplicates
— When the price changes — only price_supplier is updated, the other fields remain unchanged
… — The price formula in the table remains on your side
Regarding my portfolio — I recently developed a full-fledged Telegram bot for a barbershop: FSM booking, master selection, admin panel with notifications, protection against double booking, SQLite. GitHub: https://github.com/NazarSikora/barbershop_bot
Deadline: 3 days after receiving the list of channels.
Cost: 2400 UAH (fixed price for all functionality as per the project brief).
If you have any questions — I am ready to discuss the details.
-
1 day56 USD
265 1 day56 USD
Good day.
I have extensive experience working with the Telegram API, parsers in Python, Telethon/Pyrogram, as well as automatic data entry into Google Sheets with logic for updating without duplication. I have worked on tasks where it is important to correctly process only new posts, save photos, text, links, partially extract prices and parameters from descriptions, and not overwrite manually edited fields. According to your specifications, I can implement a clear parser with the possibility of further expansion for OpenCart.
I suggest moving to private messages for a more detailed discussion of the specifications, deadlines, and costs.
-
3 days56 USD
332 3 days56 USD
Hello, Serhiy! I have experience in developing parsers in Python (using Telethon and gspread for Google Sheets API).
I have carefully reviewed your specifications. I will implement the project with a focus on the critical points for you:
Update logic: The script will check post_url, so there will be no duplicates — only automatic updates of price_supplier for existing items.
Data preservation: All your manual edits in the table (names, categories, descriptions) will remain untouched.
Formulas: The selling price will be calculated through a formula directly in Google Sheets, as you requested.
…
Parsing: I will extract prices and sizes using RegEx.
I am ready to start working today. The code will be clean, structured, and accompanied by a launch instruction.
-
1 day90 USD
172 1 1 1 day90 USD
Good day. I am ready to complete this project as I have extensive experience in application development.
-
1 day56 USD
84 1 day56 USD
Hello, I am ready to complete the order efficiently and quickly (in one evening). I have extensive experience working with Python scripts, Telegram bots, and API integrations.
-
1 day56 USD
690 5 0 1 day56 USD
Hello! I am ready to implement a parser for Telegram channels according to your requirements. I have practical experience in developing parsers in Python with deduplication logic and data updating without manually overwriting filled fields. Write to me, and we will discuss.
-
4 days56 USD
588 2 0 4 days56 USD
Hello.
I have experience in Telegram parsing and Google Sheets. For this project, it is optimal to access through Pyrogram with a separate Telegram account and a permanent session.
The approach is as follows:
connecting the account to Telegram and reading channels
selecting only new posts with deduplication by post_url or message ID
writing to Google Sheets via service account
… updating only the supplier's price, without overwriting manual fields
logging errors and recovering from failures
From a practical standpoint, it is important to clarify immediately:
whether the channels are public or private
whether access to the account/invites is needed
how many channels are planned
whether it is necessary to store multiple photos
whether OpenCart will be a separate next stage
I can answer all questions in private messages.
-
3 days90 USD
420 1 0 3 days90 USD
Good day! I develop custom Python solutions: data analysis, process automation, scripts, parsers, ETL pipelines. The cost starts from 4000 UAH. Details: www.engine-web.od.ua/
-
1 day56 USD
1495 13 0 1 day56 USD
Hello! I can implement it. Write to me privately to discuss all the details. I will be glad to cooperate!
-
3 days113 USD
3411 32 0 3 days113 USD
Hello!
The task is clear, do you have Telegram accounts?
I can set everything up for collecting the necessary information and distributing it in your table.
Write to me in private.
-
1 day56 USD
3482 50 0 1 day56 USD
Good evening
I am ready to take on your order
Write to me, I will be happy to help with your task
I have experience in developing similar tasks
-
5 days156 USD
367 1 0 5 days156 USD
Hello.
I have already created such parsers for Telegram (Telethon + recording in a table).
The main thing here is to properly process new posts, avoid creating duplicates, and carefully implement updates only for the price so as not to overwrite other fields.
I will extract the price and sizes from the text, but I will say right away - due to the different formats of posts, this will not always be 100% accurate, this is a normal situation for such tasks.
If that's okay, you can send examples of channels - I will look at the formats of the posts and immediately tell you how well it will be parsed there.
-
1 day56 USD
727 6 0 1 day56 USD
Hello, I have already done and have similar parsers, we just need to agree on the format and adapt it for you, feel free to contact me.
-
3 days451 USD
4467 102 0 3 days451 USD
Good evening. I will be happy to help. I will complete everything quickly and efficiently!
-
5 days113 USD
6847 164 1 5 days113 USD
Good evening, I am ready to discuss the project with you, I have experience working. The price and deadline are conditional. Thank you in advance.
-
3 days113 USD
2264 18 3 3 days113 USD
Hello! I am interested in your project. I specialize in automation and the development of Telegram tools in Python, so I have a good understanding of the specifics of working with User-bots and the Google Sheets API.
What I propose for implementation:
- Reliable data parsing: I will use Pyrogram to work through the account. This will ensure stable retrieval of posts and handling of media (photos).
- Smart price updating: I will implement logic to check by post_url. The script will find the existing row and update only the supplier's price, without affecting your manual edits, titles, or categories.
- Data extraction (Regex): I will set up flexible regular expressions to extract prices and sizes. Even if the text is unstructured, the parser will be able to identify key parameters.
- Security and limits: Since this is a User-bot, I will set up the correct delays (flood control) and a queue of requests to minimize the risk of account blocking by Telegram.
- Integration with Google Sheets: I will use the official API. The spreadsheet will be fully ready for import into OpenCart with all the necessary formulas.
…
I am ready to discuss everything in more detail and start working, feel free to write.
-
2 days56 USD
193 0 1 2 days56 USD
Hello! I am ready to implement your parser in Python (Telethon + Google Sheets API). I understood the logic of updating only price_supplier and saving manual edits — this is basic functionality, I will do everything clearly according to your specifications. I have experience in similar projects for OpenCart, so the structure of the table will be fully ready for import.
-
3 days113 USD
1267 35 1 3 days113 USD
Hello. Your project consists of two parts. First, parsing channels into a Google Sheet, then importing into OpenCart. I will do both parts in PHP because OpenCart is PHP. I can also, if desired, remove the Google Sheet and parse channels directly into OpenCart. Feel free to contact me. I will do it for a reasonable budget.
-
2 days56 USD
224 1 0 2 days56 USD
Hello! I have experience in developing similar solutions using Python + Telethon. I will do everything clearly according to your specifications, feel free to contact me.
-
2 days56 USD
1933 21 0 2 days56 USD
Sergiy, I will implement it without problems. I will implement it through telethon + aiogram for flexible and simple settings. Budget: 2200 UAH. Deadline: 1-2 days. Write to me.
-
3 days135 USD
2426 20 0 3 days135 USD
Good day, I am ready to complete your task quickly and efficiently. I have extensive experience in creating various parsers, Telegram bots, etc. Please write to me in private messages to discuss the details. I will be happy to help)
-
1 day56 USD
10123 117 0 1 day56 USD
Hello.
I develop bots for Telegram using NodeJS. I have experience with Google Sheets. I am ready to take on the project. Write to me, we will discuss.
-
3 days56 USD
4987 41 4 1 3 days56 USD
Good day!
I have experience working with the Telegram API (Telethon, Pyrogram) and integration with Google Sheets. I have developed similar parsers with dynamic data updates. I am ready to implement a parser for Telegram channels with automatic recording in Google Sheets and correct price update logic.
We will discuss the deadlines and cost after clarifying the details. Please write to me in private messages.
-
2 days56 USD
3999 7 1 2 days56 USD
Good evening. I have already done something like this. Almost one to one. I will do this quickly and with quality!
-
5 days90 USD
297 5 days90 USD
Hello! I have experience in developing parsers in Python and working with the Telegram API (Telethon). The task is clear, especially the logic of updating prices without overwriting manual edits — this is critical for OpenCart.
How I will implement this:
Stack: Python + Telethon (for working with channels) + gspread (for Google Sheets API).
Update logic: I will use a combination of channel ID and post ID as a unique key. The script will first check for the presence of the ID in the table: if it exists — it updates only price_supplier, if it does not exist — it creates a new row.
Data parsing: I will write flexible regular expressions (RegEx) to extract prices and sizes (S-XXL, 42-50, etc.) from the text.
…
Working with media: Obtaining direct URLs for photos through the Telegram bot or saving to the cloud (by agreement).
Reliability: I will add error handling (FloodWait) and logging, so the parser does not crash during prolonged operation.
Deadline: 3–4 days (1 day for the core parser, 1 for Google Sheets, 1 for tests and regular expressions).
Cost: I am ready to discuss, based on your budget.
-
Бюджет замалий для такої задачі
-
Current freelance projects in the category Data Parsing
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 21 hours 15 minutes back ∙ 16 proposals |
Creation of an Excel file for uploading products to the websites of other partners.I am interested in creating an Excel table with all parameters. Here is the website - https://heiztechnik.com.ua/ And the positions I am interested in to be transferred: Manual boilers: 1) TIS UNI 15-95 kW (10) pcs 2)TIS HARD 150-500 kW (7) pcs Pellet boilers: 1)TIS PELLET… Data Parsing ∙ 1 day 1 hour back ∙ 33 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 1 day 4 hours back ∙ 37 proposals |
Find a product feed (Google Merchant XML) for a website on OpenCart
16 USD
It is necessary to find a direct link to the active product feed (XML) of a competitor for Google Merchant Center Platform (CMS): OpenCart / ocStore Find the original feedRequirements for the result: Working link to the XML file Python, Data Parsing ∙ 1 day 9 hours back ∙ 21 proposals |
Parsing products from supermarketsNeed a specialist (parsing + Google Sheets + automation). Goal: Create a system for automatic retrieval and updating of food prices from Silpo and NOVUS supermarkets with data output to Google Sheets. What needs to be implemented: Create a main Google Sheets table with a product… Data Parsing, Information Gathering ∙ 1 day 17 hours back ∙ 46 proposals |
Odessa