Setting up Google Sheets
It is necessary to set up "communication" between different Google Sheets, as well as to implement sorting within them and connect Telegram notifications when certain changes occur in the sheet. Additionally, continuously fix any bugs that arise.
-
300 2 0 Hello! I am interested in your task. I have experience working with Google Sheets and Google Apps Script. I will implement all the tasks you described by writing individual scripts, which guarantees reliability and flexibility:
1. Linking tables: I will set up automatic data exchange between different files (import/export).
2. Sorting: I will implement auto-sorting when data changes or on a schedule.
3. Telegram notifications: I will connect a bot that will instantly send messages about specific changes in cells or new requests directly to your chat or group.
I am also ready for long-term cooperation to support the system and fix any errors that may arise in the future. Please let me know how many tables need to be linked at this stage? I am ready to discuss the details and start working.
-
1318 63 1 Dmitry, good day.
I have implemented more serious tasks. Do you need a trigger, for example, for changes in the deal status that will react in real time, or statistics that will be sent to TG, for example, once an hour?
Interactions between tables are not a problem; we can connect other data sources as well.
Feel free to reach out, we will discuss, I will show similar works, we will agree, I will do it.
P.S. The price and deadlines are preliminary as the scope of work is not yet clear.
-
981 17 0 Hello!
I professionally engage in Google Sheets automation. Please reach out - I am ready for collaboration.
-
388 2 0 Good day, Dmytro!
I am ready to set up your Google Sheets system. I have extensive experience in similar tasks.
What I can do for you:
Connection between sheets: I will set up seamless data exchange between different files (through IMPORTRANGE, QUERY, or Apps Script for more complex scenarios) so that the information is always up to date.
Sorting: I will implement automatic sorting within the sheets based on the required criteria.
Telegram notifications: I will write a script that will track changes (for example, status changes) and instantly send messages to your Telegram.
Support: I am ready to take the sheets for ongoing support and quickly fix bugs.
… Briefly about my latest project (CRM in Google Sheets):
API automation: Full integration with Nova Poshta (bulk creation of shipping documents, auto-updating statuses) and pRRO Checkbox (receipt generation).
Complex logic without "lags": The scripts automatically calculate net profit, ROI, and write off losses for canceled orders. The sheet does not freeze from thousands of formulas.
Auto-reports: Daily analytics (turnover, margin, lead price) is automatically sent to the Telegram bot.
User-friendly UX: Management through a custom menu, color-coded status indicators, and minimal manual work.
-
3012 73 4 2 Good day! I have a very large experience in working with spreadsheets and creating Telegram bots!!!!!!!
Contact me!!!!!!
-
1024 8 0 Hello, Dmytro!
I am very knowledgeable in Google Apps Script and can implement any logic for data exchange between tables or with external systems, as well as connect notifications in Telegram.
After completing the work, I provide a guarantee and offer support for automation.
I would be happy to collaborate.
The cost is calculated based on the specific task.
Current freelance projects in the category Accounting Services
MPSR management and financial report in Excel
67 USD
Help to understand the logic of the report, understand how the controls and formulas work, possibly assist with filling out from the accounting program. Accounting Services, Consulting ∙ 18 hours 16 minutes back ∙ 10 proposals |
Бухгалтер для ТОВ (імпорт, ЗЕД, медичні вироби)
16 USD
Шукаємо бухгалтера на часткову зайнятість (аутсорс) для ТОВ на початковому етапі діяльності. Завдання:— податкова та фінансова звітність ТОВ — супровід ЗЕД операцій (імпорт з Китаю) — облік поворотної фінансової допомоги від засновника — консультації з ПДВ на медичні вироби… Accounting Services ∙ 1 day 15 hours back ∙ 3 proposals |
We are looking for a strong accountant/financial controller to build an accounting system for a clothing brand.
337 USD
We are looking for a strong accountant/financial controller to build an accounting system for a clothing brand. Main tasks: • Build the company's management accounting from scratch. • Set up the accounting for the movement of goods: warehouse → cutting → sewing → quality control… Accounting Services ∙ 2 days 21 hours back ∙ 8 proposals |
Accountant with experience in international taxation, Delaware LLC
112 USD
Looking for a accountant with experience in international taxation who can handle fully or partially: Bookkeeping for LLC (Stripe transactions, expenses, invoices) Delaware LLC (form 5472, franchise tax) CFC declaration in Ukraine Contract FOP → LLC OSS VAT declaration quarterly… Accounting Services, Legal Services ∙ 7 days 9 hours back ∙ 3 proposals |
Consultation on working with EDIN for the supplier Epicenter
17 USD
Consultation needed on working with the electronic document flow EDIN in collaboration with Epicenter We are a supplier of goods for the Epicenter network and work through the electronic document flow system EDIN. A consultation is needed from a specialist who has practical… Accounting Services, Project Management ∙ 7 days 15 hours back |