Development of automation for Google Sheets + weekly reporting in Telegram

Budget: 900 PLN Deadline: 7 days

Good day! This is exactly my topic; I have done Google Sheets automation using Apps Script and exporting reports to Telegram on a schedule. Slowdowns from 45 tabs are usually fixed by moving the history to a separate layer and recalculating with a script instead of live formulas, but first, I will take a look at your template to suggest a better option. Please let me know where to pull the data weekly, from the website via the link or from the personal account with a login? This will determine the parsing method.

Budget: 3400 PLN Deadline: 28 days

I can conduct an audit of the current Excel/Google Sheets system, identify the cause of the slowdown, and build a stable automation: weekly data import from the website, history preservation, metric aggregation, and automatic report sending to Telegram.

After the analysis, I will propose the optimal solution: optimization of Google Sheets, integration of Apps Script + Sheets API, or moving the processing to Python, so that the spreadsheet remains fast and does not break with further data accumulation. Budget and deadlines will be discussed in private correspondence.

Is authorization required to obtain data from the website, and does the structure of the pages or tables change from week to week?

Budget: 500 PLN Deadline: 3 days

Hello.

I am developing bots for Telegram using NodeJS. I have experience with Google Sheets. Write to me, and we will discuss.

Budget: 850 PLN Deadline: 10 days

Hello. My name is Vladimir, I am a Python and Node.js developer, as well as the founder of the engineering agency Vaysed. I have thoroughly studied your task of automating data collection, optimizing Google Sheets, and setting up weekly reporting in Telegram. I understand that the overloaded historical data table with 45 tabs requires a radical change in storage architecture and automation of parsing. To address the performance issue, I propose a hybrid approach by transferring the computational logic to a dedicated server. We will develop a microservice in Python that will schedule data parsing from the target website and store it in a fast relational database PostgreSQL. All complex aggregation, calculation of dynamics, and percentage ratios will occur on the server in milliseconds. The finished results will be exported via the Google Sheets API to a new, completely lightweight table solely for convenient viewing, as well as compiled into a summary report and sent to Telegram via a bot based on aiogram 3. I have relevant experience in creating fault-tolerant data collection systems and synchronization with spreadsheets. In the Lumos project, I designed a complex architecture for regular parsing and a system of automatic notifications in Telegram using Python. And while developing the PAYBACK CARTEL platform, I successfully set up uninterrupted synchronization of large data sets with third-party spreadsheet CRMs, which technically fully covers the logic of your task. You can view my portfolio at the link [ Freelancehunt]( Freelancehunt). I would be happy to discuss the website for data collection and the structure of your historical metrics in private messages.

Budget: 1000 PLN Deadline: 10 days

Good evening!

I professionally develop bots in Telegram and web applications in Python. I am ready to solve the performance issues of your Google Sheets, set up data parsing from a website, and send weekly summary reports via the Telegram Bot API + deploy the system on a server.

Message me privately, and we can clarify the details.

Budget: 300 PLN Deadline: 4 days

Good afternoon, we can finalize your technical assignment. Please message me for more information.

Budget: 3500 PLN Deadline: 7 days

Greetings, and I will say right away that I have experience working with similar automation. I can consult you and develop any type of automation. Message me privately, and I will be happy to collaborate 🙏

Budget: 100 PLN Deadline: 1 day

Hello. I have analyzed the performance issue of large tables in Google Sheets and plan to build a hybrid solution that combines the efficiency of Python for parsing and aggregating data with the flexibility of the Google Sheets API for updating and displaying information. This will allow for the automation of weekly data collection from external sources, ensure optimal processing and storage, and set up a reliable mechanism for automatic report generation and sending via the Telegram Bot API. I have successful experience in implementing similar systems for processing and visualizing large datasets, including creating custom parsers and integrating with messengers, which will allow us to use existing architectural developments to speed up the development process. I suggest discussing all implementation details, final budget, and timelines in private messages.

Budget: 450 PLN Deadline: 1 day

Good day!

I have reviewed your task. I understand the scope of the upcoming work and the possible implementation options.

To provide an accurate response regarding the deadlines and price, I would like to clarify a few questions that arose after analyzing your description.

Budget: 1111 PLN Deadline: 1 day

Hello! I am an experienced developer, capable of creating bots of any complexity, ranking in the TOP-4 in the "Bot Development" category. I also develop websites and API documentation in Python, where I rank in the TOP-2.

Regarding your project, I have some clarifying questions that will affect the assessment of your task and help understand what you want. Please write to me to clarify all the details!

You can review my skills in my resume 👉 Freelancehunt
My work is also published in my portfolio 👉 Freelancehunt

I look forward to your response, thank you.

Budget: 80 PLN Deadline: 1 day

Hello! I am ready to take on the project and solve the issue with the table lag once and for all.

How I propose to solve the task

Performance of Google Sheets:

The main reason for the lags in 45 tabs is excessive cross-references and the total volume of cells.

I propose a hybrid solution: move historical data to an archive table, and current working data to the main working file. We will perform updates and aggregation using a script, rather than heavy formulas (IMPORTRANGE/ARRAYFORMULA), which will completely relieve the load from the interface.

Automatic parsing and import:

I will write an autonomous script in Python (using Google Sheets API / gspread).

The script will collect data from your website weekly, form a ready array, and upload it to the necessary tabs in a batch request (to avoid hitting Google API limits).

We will set up the launch to be fully automatic (via a free server trigger / Cron / GitHub Actions — you won’t have to press anything manually).

Aggregation and Telegram report (Stage 2):

The script will automatically retrieve the dynamics for the past and current week, calculate the % changes, and generate a clean, readable report with key metrics.

Sending to your Telegram chat/bot on a precise schedule.

Technology stack: Python (requests, BeautifulSoup/Playwright, gspread), Google Sheets API, Telegram Bot API.

Next step:
Please send me the link to the website (to assess the parsing structure) and an example table (or access for viewing). After that, I will immediately provide you with exact deadlines and costs.

I look forward to collaborating! Expand

Budget: 600 PLN Deadline: 4 days

Good evening, Dmitry.

The brakes on 45 tabs usually involve laying out formulas and restructuring live. Automation will indeed help here.

I have experience with parsing complex websites, integrating with Telegram, and storing in tables - you can check my reviews where I solved similar tasks. I have a couple of questions:
1. Does the source website have any authorization or protection?
2. In your opinion, what exactly in the table creates lags?
3. Should the data for the report be taken from different tabs or is there one final summary?
4. Should the report in Telegram be simply formatted as text, or does it need something more advanced?

Without understanding such details, and the table as a whole, it's difficult to predict the price or terms. Moving to Google Sheets might help, but we need to understand the nature of the Excel workbook itself.

I am ready to connect to discuss the details! Expand

Budget: 6000 PLN Deadline: 5 days

😀 Hello, Dmytro!

I have done similar work multiple times: optimizing heavy Google Sheets + automatic parsing from websites + reporting in Telegram.

What I will do (Stage 1):
1) Analyze the spreadsheet (45 tabs) — I will find what exactly is causing the slowdown (array formulas, IMPORTRANGE chains, unnecessary volatile functions) and propose solutions: splitting into several files + Apps Script with triggers instead of "live" formulas, or moving heavy calculations to a Python script with recording of ready values through Sheets API (the most reliable for large spreadsheets).
2) Auto-parsing from the specified website — Python script (requests/BeautifulSoup or Selenium, depending on the site) on a schedule (Google Cloud Scheduler/cron) → recording in the necessary tabs.
3) Weekly aggregation + auto-report in Telegram bot (aiogram) with summarized figures.

I need to look at the template of the spreadsheet and the source website to provide an exact plan and timeline.

Approximately Stage 1: 6000 UAH / 5 days.

🎥 Profile: Freelancehunt

I am ready to start immediately after gaining access to the spreadsheet. Expand

Budget: 650 PLN Deadline: 7 days

Good day, I am a Python developer with extensive experience in Python development, working with Telegram, and also with Google Sheets. I understand your task - I can implement it quickly and efficiently. Write to me - we will discuss the details. I am ready to start today.

Budget: 800 PLN Deadline: 14 days

Currently, the data is spread across dozens of tabs, which causes the table to lag, and the weekly updates and report preparation require manual oversight, creating a risk of missing important dynamics.

First, I will analyze the structure of the 45 tabs, formulas, and the volume of historical data to determine what is reasonable to keep in Google Sheets and what should be moved to a separate storage or archive. For regular data uploads, I will set up a scenario on Make with parsing through the API or Apify, if the site allows it, and recording only new data on a schedule. I will implement the aggregation of metrics and report sending through Google Sheets, Make, and Telegram Bot API: key figures, weekly changes, and a link to the summary table will be sent to the chat.

In a similar task with the Telegram bot, requests were automatically structured and sent to the CRM, which completely eliminated manual data transfer and ensured timely notifications for managers.

What volume of new records is typically added in a week, and who is currently preparing the report manually?

Budget: 430 PLN Deadline: 5 days

I have carefully reviewed the task. I have previously worked with optimizing large Google Sheets, automation through Google Apps Script, Python, and the Google Sheets API, as well as data parsing and integrating Telegram bots.

I would not immediately limit myself to optimizing the sheet itself. First, I will analyze the current structure and propose the most effective solution, whether it be optimizing Google Sheets, a hybrid architecture, or transferring part of the logic to Python using the Google Sheets API. The main goal is for the system to operate quickly, reliably, and not require constant manual intervention.

I have a few questions regarding the current sheet and the data source that I would like to clarify before starting work, but overall the task is completely clear and feasible.

Budget: 550 PLN Deadline: 8 days

Dmitry, 45 tabs by themselves are not necessarily the cause of slowdowns. First, I will check the volume of historical data, formulas across entire columns, cross dependencies, IMPORTRANGE, and recalculations. Based on the results, I will choose a solution: optimizing the current file or splitting it into an archive layer with history and a lightweight working table. I will not move the system to Airtable or Notion without confirmed necessity.

I will implement both stages of the project:
I will optimize the table and set up weekly data retrieval from one website — via API, if available, or through a parser. New records will be added in batches, existing ones updated by a unique key, and duplicates excluded. I will add a schedule, a run log, retries, and error notifications.

I will create a separate summary with history, key indicators, weekly dynamics, and percentage changes. According to the schedule, the bot will send a brief report and a link or file with the full table to Telegram.

I already have a Python system that retrieves external data on schedule, checks for duplicates, saves history, and sends results and technical statuses to Telegram. Therefore, I will use the already proven logic of automatic launch and error control here.

As a result, I will deliver an optimized working table, set up automation, a Telegram bot, source code, and a brief instruction. After launch, I will provide 7 days of support.

The cost is 550 PLN, and the timeframe is 8 calendar days. The price includes both stages, one source website, and one main format for the weekly report. Can you send a copy of the table and the website address so I can confirm the chosen architecture before starting work? Expand

Budget: 100 PLN Deadline: 2 days

Good evening. I am ready to take it on, I would like to discuss the details in private. Please reach out.

Budget: 100 PLN Deadline: 1 day

Good day
I have extensive experience in automation and can solve your task.
Write to me (deadlines and price in private, as requested).

Budget: 450 PLN Deadline: 5 days

Good afternoon. First, we need to look at the table itself and understand what exactly is creating the load: the number of tabs, formulas, the volume of history, or scripts.

It will most likely be optimal to separate working data, archives, and reporting, and set up the loading of new data through Google Apps Script on a schedule. I will also create a pivot table with dynamics and automate the weekly report sending to Telegram.

After reviewing the template of the table and the website, I will be able to confirm the scope of work and suggest the best implementation option.

Budget: 300 PLN Deadline: 3 days

Hello!

I specialize in exactly this: Google Sheets automation and weekly reports. Recently, I completed a similar project, automatic generation of weekly PDF reports from a Google Sheet: collecting data from different tabs, summarizing with dynamics and percentages, charts, all on a schedule without manual triggering. Stack: Google Apps Script and Sheets API.

Briefly, here's how I see your task.

Stage 1. The slowdowns in a sheet with ~45 tabs are usually addressed like this: we extract the history and heavy formulas from the working file, and replace the formula recalculation with a script that calculates on a schedule. I will find the exact solution when I look at the template. Sometimes it's enough to clean up, sometimes it's better to keep the history separate and synchronize. Weekly parsing of the website into the necessary tabs will be triggered by a time-based trigger, without manual launching.

Stage 2. A summary table with history and percentages, then auto-sending to Telegram. The report is sent via the Telegram Bot API (sendMessage and sendDocument), which connects from the same Apps Script.

I am ready to look at your table template and clarify where we pull the data from and in what format the report is needed in Telegram. After that, I will provide the timeline and cost.

Vitaly Expand

Budget: 2000 PLN Deadline: 7 days

Good day.
I am ready to take on the automation of Google Sheets and weekly reports in Telegram.
Portfolio: https://gooru-lab.github.io/portfolio/
Relevant experience: Google Sheets API / scripts, data parsing and import, optimization of heavy spreadsheets, Telegram Bot API (weekly/status newsletters).
Stage 1 — speed + weekly import
• Analysis of the template (~45 tabs) and justification of the solution: optimization of Sheets / Apps Script, hybrid (offline + sync) or Python + Sheets API — what will realistically remove the bottlenecks.
• Auto-import of data from the website into the required tabs on schedule (without manual triggering).
Stage 2 — aggregation + Telegram
• Summary table (history, dynamics, % changes) from the required cells/tabs.
• Weekly report (key indicators + table) in the bot / chat / channel.
We will clarify in private: the template of the table, the source URL, where to send in Telegram, the day/time of the newsletter. Then — deadlines and costs by stages. Expand

Budget: 450 PLN Deadline: 5 days

Hello, Dmitry! 45 tabs with historical data — Sheets recalculates and keeps everything in memory at once, so this is not solved by "speeding up formulas," but by separation: archive files with history separately + a lightweight working table where the script only uploads what is needed. Before selecting a contractor, I am ready to do this for free: send the template — I will return an analysis within a day of what exactly is causing the slowdown and justification for the best option (optimization within Sheets vs hybrid with Python synchronization) for your structure.

Plan according to your stages:
1) Audit of the template → archive of history + working layer (IMPORTRANGE selectively, without cascades); weekly parsing of the site in Python (Google Sheets API, batch writing) on schedule without manual launch; log of launches and errors.
2) Aggregation from specified cells/tabs → summary with dynamics and % changes → auto-sending of the report to Telegram (Bot API): compact table + key indicators, format to be agreed upon with a live example.
Delivery: code + clear instructions + one week of free support after launch.

Questions: 1) What is the source site (open or does it require a login)? 2) Should the report be sent to a group/channel or personally?

For transparency: I write code with an AI assistant, and I check and test each result manually.

Budget: 555 PLN Deadline: 14 days

The problem with the performance of a large spreadsheet during online work is solved by splitting the data and minimizing formulas — this is a standard approach for Google Sheets with 45+ tabs. I will do it through Google Apps Script: I will set up automatic data parsing from the specified website via a cron schedule, optimize the structure of the spreadsheet (splitting it into working and archive tabs, replacing heavy formulas with script calculations), set up data collection into a pivot table with dynamics and percentages, and then organize automatic weekly sending of the finished report to Telegram via the Telegram Bot API. I offer 2 weeks of free code support after delivery — scripts may require debugging due to changes on the website or the structure of the spreadsheet. I am ready to start.

Budget: 600 PLN Deadline: 5 days

Hello, Dmitry. Often, performance issues in Google Sheets with 45+ tabs arise from overload due to open formulas, incorrect use of IMPORTRANGE, and lack of architectural data separation. The task is clear, and I am ready to offer a comprehensive architectural solution and implement it.

Budget: 500 PLN Deadline: 3 days

Brakes on 45 tabs — a standard theme for Google Sheets when there are a bunch of cascading formulas and history. The browser simply can't handle constant recalculation during online work.

From experience, I know that if you continue to keep all 45 tabs in one file, the sheet will still die. It's better to move the raw historical data to a separate archival document or SQLite, and in the working sheet, only upload the final figures through a script.

I usually do the parsing and updates in Python via the Google Sheets API. Here's roughly how I push fresh data to the sheet:

import gspread
gc = gspread.service_account('creds.json')
sh = gc.open_by_key(SHEET_ID)
ws = sh.worksheet('data')
ws.clear()
ws.update('A1', rows, value_input_option='USER_ENTERED')

I see the steps like this: unloading the structure and formulas, auto-parser with scheduled uploads, a summary sheet with metrics, and a Telegram bot for reports.

I can start from tomorrow. Expand

Budget: 1111 PLN Deadline: 7 days

Ready to take on your project. To optimize the paths, I need to review the table and understand how the current parsing is set up. One option is to move the historical data to a separate table and pull it into the main one. The price is conditional. Please message me the details.

Budget: 100 PLN Deadline: 1 day

Good day, I am ready to complete your task quickly and efficiently. I have extensive experience in creating various bots. Please write to me in private messages to discuss the details. I would be happy to help :)