Automate work in Google Sheets

Budget: 4000 UAH Deadline: 5 days

Good day! I am making such connections in Apps Script, and the main divergence for you is not in calculations, but in access rights: separate tabs in one master file will not be divided, because Google grants access to the entire file at once. Therefore, each master has a separate table, and the script runs rows back and forth and consolidates everything into the main one.

I calculate the commission as a separate column from the net profit, so it can be verified visually, rather than trusting the formula. I will take 4000 UAH and 5 days. How many masters and managers are currently working?

Budget: 2000 UAH Deadline: 2 days

Hello!
My name is Oleg, I am the project manager of Business Atlas (BAA).
We have experience in setting up similar solutions.
How we will implement your specifications:
1. Restricted access and auto-routing:
Main database (Admin): The manager enters orders and links the client (with auto-search of history by phone number in the database).
Isolation for masters: Using n8n, orders are instantly duplicated into a personal tab/file of the assigned master. The master sees only their orders and does not have access to the general database or the company's finances.
2. Simple workspace for the master:
The master marks the status ("Completed") from their smartphone and enters actual figures (work, materials, parking, logistics).
Data is automatically returned to the Main Table in real-time. A strict logic can be set: the order will not close until actual expenses are entered.
3. Transparent financial logic:
Net profit: Auto-calculation for each transaction: Total amount - (Payment to the master + Materials + Additional expenses).
Manager's commission: The formula is strictly tied to net profit. If the margin falls due to expenses, the manager's commission is automatically recalculated.
4. Executive Dashboard (Summary report):
A separate tab or dashboard (Looker Studio) with summaries for any period: Total revenue, Payments to masters, Manager commissions, Net profit of the company, and margin analysis.
What you get as a result:
Data security: Masters do not see "extra" information, and you have full control.
Absence of human factor: All formulas and data transfers are automated through n8n.
Autonomy: We provide complete documentation (SOP) and video instructions for your team.
Estimated implementation time: 5–9 working days.
Message me privately to discuss details or show an example of your current table — I will provide guidance on exact timelines and costs! Expand

Budget: 22000 UAH Deadline: 7 days

We can do this as a managed system in Google Sheets with Apps Script - the benchmark is 22,000 UAH and 7 working days after access is granted.

Look, here’s the nuance - access rights are better managed not just with filters in a shared sheet, but with separate tables for masters or protected ranges. Otherwise, the privacy of orders can be easily compromised, and finances will then have to be heroically saved with coffee and prayers =)

> Question 1 - how many managers and masters will there be
> Question 2 - is the manager's commission always one percent or does it depend on the service, manager, or period

> Similar examples from Ingello
> https://business.ingello.com/forma-crm - roles, orders, accounting, and managed logic for working with clients
> https://business.ingello.com/forma-bpm - automation of statuses, processes, and financial stages
> https://systems-fl.ingello.com/ua - a brief overview of our approach to such systems

After access to the structure of the sheets, we will gather the data model, access rules, profit formulas, change log, and a summary financial report for the period. Expand

Budget: 20000 UAH Deadline: 19 days

Good day. To differentiate access, I suggest creating it as an Odoo application - it will need to be installed and configured once - then it can be used via the internet. Or if Odoo is not suitable, I can propose transferring it as a desktop CRM + remote database on a VPS server. I can show how both options will approximately look.

Budget: 5000 UAH Deadline: 7 days

Good day!

I see this task not only from the perspective of tables but from within the process — I am an accountant and a sales business trainer, so I understand the logic of the manager, the master, and the owner: where the risk of error in calculations lies, where the master can "lose" expenses, and where the commission should be calculated correctly — specifically from net profit, not from revenue.

What I will do:

Main table → auto-distribution of orders across personal sheets of masters (each sees only their own)
Client history by phone number
The master enters the status and fact (amount, expenses) — synchronizes automatically
Auto-calculation of net profit and manager's commission
Consolidated financial report for the period (revenue / payouts / commissions / company profit)

Cost: depending on the volume (number of masters, complexity of commission/bonus logic). I will provide the exact figure after a brief clarification of details.

I am ready to discuss and demonstrate the logic of calculations with an example. Expand

Budget: 3000 UAH Deadline: 4 days

Good day! The task is clear: we need to build a secure structure in Google Sheets with access rights segregation (so that masters only see their orders), automate data transfer in both directions, and set up an accurate calculator for net profit and commissions.

I have significant experience in building complex automation systems on Make.com and Google Sheets API architecture.
🛠 Here’s how I propose to implement your project:

Architecture and Security (Access Rights Segregation):

We will create a Master Sheet with full access only for you/manager.

For each master, we will set up a separate personal Google Sheet. This is the only reliable way in the Google Ecosystem to ensure that a master does not see others' orders, client base, or the company's total profit.

Automation through Make.com:

Routing: When a master is assigned in the Master Sheet, Make.com instantly transfers the order details to the master’s personal sheet.

Client History: Auto-search by phone number in a separate "Clients" tab. If the number is new — Make creates a client card; if it’s a repeat — it pulls up the history.

Feedback (Master Report): When the master enters actual expenses (packaging, parking, materials) and changes the status, Make synchronizes this data with the Master Sheet.

Accurate Financial Block:

We will write formulas/scripts for automatic calculation:
Net Profit = Order Amount - (Payments to Master + Materials/Expenses)
The manager's commission will be strictly calculated from the net profit, as you specified.

We will set up a summary tab with consolidated analytics for any selected period (revenue, net profit, commissions, payments).

💡 Additionally, I can offer (if desired):

To connect a Telegram bot so that masters receive notifications about new orders and can change statuses directly in the messenger.

To connect Looker Studio for a visual dashboard with profit charts.

I am ready to discuss the details in chat and start implementation! If needed, I can show examples of similar working connections on Make.com. Expand

Budget: 4000 UAH Deadline: 5 days

Good day!
To the point — there is a section in your terms of reference that cannot be resolved within a single table. Protected ranges in Google Sheets block editing but not viewing: any master with editing access can open hidden tabs and see other people's orders and your margin.
Therefore, the working scheme is as follows: a main table for you and the managers + a separate report file for each master, linked by two-way synchronization on Google Apps Script. The master sees only their orders and does not see purchase prices. The data they enter (status, amount, materials, parking) automatically returns to your main table.
What is included:
Main table: orders, clients, masters, managers, directories, change log.
Automatic distribution of orders to the master's table upon assignment (and correct transfer if the master is changed).
Client history by phone number — with format normalization (067…, +380…, 380… are consolidated into one key), auto-fetching of data, and LTV.
Master's report with field validation and row blocking after confirmation.
Automatic calculation of net profit for each order.
The manager's commission is calculated solely from net profit — with fixed rates at the time of order closure, so that changes in percentage do not recalculate closed periods.
Consolidated financial report for the period: revenue, payments to masters, manager commissions, direct expenses, net profit of the company, margin, dynamics by months.
Separation of rights (owner / manager / master), daily auto-backup, "add master" button — the file is created from a template automatically. Expand

Budget: 7000 UAH Deadline: 7 days

Good day!

I am interested in your project. I have experience in automating business processes in Google Sheets, so I can set up the system so that most operations are performed automatically.

I will implement automatic order distribution across the masters' tables, delineate access rights, set up client history retention, automatic calculation of net profit, manager commissions, and create a consolidated financial report with key indicators. As a result, you will receive a convenient system that minimizes manual work and helps control all financial indicators in one place.

I would be happy to discuss the details and propose the optimal solution for your task.

Budget: 3000 UAH Deadline: 5 days

Ready to promptly and qualitatively complete your order. I have experience working with similar projects, always adhere to deadlines and technical specifications. I would be happy to collaborate!

Budget: 5700 UAH Deadline: 4 days

In this task, the most delicate point is not the manager's commission, but the moment when the master enters actual expenses into their file. If synchronization back to the Main table occurs twice, the net profit will be doubled, and the commission will be incorrect.

Therefore, I will link the rows by the unchanged order ID from the Main table, rather than by phone number or date. I will normalize the phone number separately for the client's history, as +380/067/38067 will not consolidate under one client without this. I will keep the financial layer in the Main table under protected formulas so that the master does not accidentally touch them.

First, I will establish a connection on copies of your tables with two test orders — you will see the full cycle from entry by the manager to the calculation of the commission. To start, I need the structure of the current tables and the exact formula for the distribution of funds.

Is the manager's commission a fixed percentage or does it depend on the service or the master?

Budget: 1111 UAH Deadline: 7 days

It is critical that the manager's commission is calculated only from the net profit — this means that all calculations must be linked into one system without errors. I will do this through Google Apps Script, which will automatically synchronize data between tables, calculate the net profit for each order, and generate summary reports for the period. I offer 2 weeks of free code support after delivery — if anything needs debugging or additional formulas. I am ready to start.

Budget: 6500 UAH Deadline: 3 days

Hello! I specialize in automating business processes, developing scripts (Google Apps Script / Python), and building financial systems in Google Sheets.

How I will implement your project:

- Secure architecture: the main database is for the manager and admin. A separate Google Sheets file is created for each master. The master can see and edit only their orders without access to the main database.
- Auto-synchronization (Google Apps Script): when a master is assigned in the Main table, the order is automatically transferred to their file. When the master updates the status or actual expenses (materials, parking, etc.) — the data returns to the Main database.
- Customer database: automatic pulling and saving of order history by phone number.
- Financial block: setting up formulas for calculating net profit (Revenue - Payments - Expenses) with protection against accidental editing. The manager's commission is strictly deducted from the net profit.
- Summary report: a dashboard with summaries (revenue, net profit, commissions, payments) and filtering by the selected period.

Execution conditions:

- Deadline: 3–4 days.
- Cost: 6500 UAH.

Result: a ready bundle of sheets + a short video instruction on how to work with the system for managers and masters.

I am ready to discuss the details and structure of your current sheet in the chat. Expand

Budget: 5000 UAH Deadline: 5 days

I have reviewed your task; it is clear and has a standard architecture for building accounting in Google Sheets with access rights differentiation. I would be happy to discuss the details in the chat and start working.

Budget: 7000 UAH Deadline: 7 days

You need to link Google Sheets, restrict access, and automate the calculation of net profit and commissions. I am ready to do this according to your process. I will set up the transfer of orders from the Main Sheet to the personal tabs of the masters, so that each one sees only their rows. I will add the preservation of customer history by phone number and the recording of statuses and actual figures by the master. I will create an auto-calculation of net profit for each order, and the manager's commission will be calculated specifically from it. A separate tab will contain a summary report for the period: revenue, payments to masters, manager commissions, and the company's net profit. I work with business process automation and CRM. Write to me to agree on the structure of the sheets, and I will get started right away.

Budget: 8500 UAH Deadline: 7 days

Arthur, separate tabs in one file will not provide privacy: the editor will be able to see others' data. Therefore, I suggest a closed main table and a separate file for each master, linked by an unchangeable order ID.

I have experience in JS/Python automation and API integrations. I will not include a separate production case specifically for Google Apps Script. In the first version, I will implement the distribution of new orders, return statuses and expenses without duplicates, normalization of the number for the client's history, a formula for net profit → manager's commission, and summarization over a period. We will check access and formulas on test orders. I do not include CRM, mobile applications, or custom reports outside the description in this estimate.

How many managers and masters will there be, and is the commission percentage the same for all services?

Budget: 6000 UAH Deadline: 7 days

Good day, Arthur. An important nuance: separate tabs in one Google file do not provide true access segregation — a master with editing rights can potentially see other sheets. Therefore, I will propose a scheme of "closed main database + separate file for each master," and I will synchronize it through Apps Script using the unchanged order ID. Statuses and actual expenses will return to the main database without duplication, and the client's history will be linked by a normalized phone number. I will arrange finances as a separate accounting layer: revenue, materials, other expenses, payment to the master, net profit, and only then the manager's commission. I will add protection for formulas and summaries by period. To start, I need examples of current tables and the exact formula for fund distribution.

Budget: 6000 UAH Deadline: 3 days

I will set up Google Sheets so that the manager enters orders once in the main table, and the master only sees their rows and enters the status, amount, and expenses.

The manager's commission will be calculated solely from the net profit. I will add the client's history by phone number and a separate tab with a summary: revenue, payments to masters, commissions, and net profit.

I work daily with AI systems as an AI engineer in a German company; for my own e-commerce service, I support Python automation, SQLite, and cron tasks.

You will receive a ready table for checking the scenario from order creation to financial report before payment.

Do you need separate Google Sheets for the masters, or personal tabs in one file?

Budget: 8000 UAH Deadline: 5 days

Manually transferring orders and calculating net profit is a risk of errors and a waste of time. I propose to automate: 1) we agree on the logic — which fields, who sees them, how the commission is calculated; 2) I will implement a script (Google Apps Script or Python + Sheety API) with auto-distribution among masters and client history by number; 3) I will add auto-calculation of net profit and commission; 4) testing and handover. I have experience in similar automation — Allegro API -> CMS (photos, specifications, prices). What is the current structure of the tables and how many users are there? Example of work: https://freelancehunt.com/showcase/work/razrabotka-parsera-sistemyi-avtomatizatsii-allegro/2039438.html

Price: 8000 UAH
Deadline: 5 days

Budget: 3000 UAH Deadline: 5 days

I can set up this system in Google Sheets so that the manager works in the main table, and each master only sees their orders.

I will separately configure the storage of client history by phone number, order statuses, and financial calculations: net profit, payments to masters, and the manager's commission specifically from the net profit.

I will also create a summary report for the period so that revenue, expenses, commissions, and profit are calculated automatically.

I just want to clarify one point: should the masters work in separate Google Sheets files, or are separate tabs with access restrictions sufficient?

Budget: 12000 UAH Deadline: 8 days

Currently, data on orders, financial results, and the responsibility of masters easily diverges across different tables, leading to errors in payments and making it difficult to see the actual net profit of the company.

I will build a unified logic based on Google Sheets: the manager will work with the main table, while orders will automatically be distributed into personal tables for the masters with access only to their data. Through Make, I will set up synchronization of statuses and actual expenses back into the general database, and the client's history will be formed by phone number.

In the main table of the establishment, there will be transparent formulas: revenue, expenses, payment to the master, net profit, and the manager's commission specifically from the net profit. Separately, I will create a summary report for the selected period so that the manager can see the finances without manual consolidation.

The exact amount will be determined after agreeing on the number of masters and the rules for calculation.

How many masters will be working in the system at the same time, and do they have different payment conditions or percentages?

Budget: 1200 UAH Deadline: 1 day

Good day! I have a lot of experience working with Google Sheets - formulas and scripts are not a problem at all!! Feel free to contact me, I will do it well! If, by any chance, you need any revisions, I will make them completely free of charge!!

Budget: 1500 UAH Deadline: 1 day

Hello.

I am implementing an order accounting system based on Google Sheets and Google Apps Script:

— a main table for managers and the supervisor;
— automatic distribution of orders among the personal tables of the masters;
— each master will have access only to their own orders;
— two-way synchronization of statuses, actual amounts, and expenses;
— client history with search by phone number;
— automatic calculation of revenue, expenses, payments to the master, and net profit;
— the manager's commission will be calculated solely from the net profit of the order;
— a consolidated financial report for the selected period;
— a change log and protection of critical financial fields;
— system checks for duplicates, synchronization errors, and incorrect data.

I will build the system using unique order IDs to ensure it works correctly after sorting, moving, and editing rows.

Before handover, I will test the main scenarios: creating an order, assigning a master, entering actual expenses, changing the status, calculating commissions, and generating a financial report. Expand

Budget: 11000 UAH Deadline: 7 days

Arthur, I understand the task as a managed accounting system where the manager works with the main database, each master sees only their orders, and profits and commissions are calculated without manual transfer.

I will implement a structure using Google Sheets + Apps Script: I will normalize client data by number, set up the distribution of orders into separate files for masters (tabs in one file do not provide true privacy), two-way return of statuses and expenses, and a financial model. The manager's commission will be calculated based on net profit. I will add a summary for the period and a log of synchronization errors.

Readiness: the master does not have access to others' orders; a new order appears in the required file; statuses and actual expenses are returned to the main table; the client is reachable by phone; control examples correctly calculate revenue, payouts, commission, and net profit. I will provide the configured tables, scripts, and a brief instruction.

Cost — 11,000 UAH, deadline — 7 calendar days after receiving copies of the tables and calculation rules.

Please let me know how many managers and masters will be at the start and whether the commission formula is the same for all managers?

Budget: 1111 UAH Deadline: 1 day

Good day!

I can implement a fully automated system on Google Sheets using Google Apps Script.

What will be implemented:

* automatic distribution of orders from the main table to the personal tables/tabs of the masters;
* access restriction so that each person sees only their orders;
* automatic tracking of customer history by phone number;
* saving statuses and actual data entered by the master;
* automatic calculation of net profit for each order;
* calculation of the manager's commission solely from the net profit;
* consolidated financial report with revenue, payments to masters, manager commissions, and company profit.

I have extensive experience in automating business processes in Google Sheets, developing on Google Apps Script, and integrating complex business logic.

After reviewing the current structure of the tables, I will be able to propose an optimal solution, estimate timelines, and the cost of work. Expand

Budget: 3000 UAH Deadline: 7 days

Hello! I am ready to establish connections between the tables, set access rights, and configure the auto-calculation of net profit considering the manager's commissions. I have experience in automating financial calculations and data routing in Google Sheets through scripts.

Do you already have written formulas or scripts in these tables, or do we need to create everything from scratch?

Budget: 7000 UAH Deadline: 6 days

Good day! Let's get straight to the point: if the master is to see only their orders, this cannot be done with tabs in one file — range protection prevents editing but not viewing, and a hidden tab can be accessed with two clicks. Therefore, the architecture is as follows: Main table + a separate file for each master, with Apps Script synchronization in both directions. Only this way are the data truly separated.
The rest: auto-distribution of orders into the masters' files; returning their actual figures to the Main; calculating net profit and commission specifically from it — formulas in the Main, which the master cannot see or touch; a summary tab for the period; client history by phone with number normalization (without it, +380/067/38067 will not consolidate into one client).
7,000 UAH, 6 days. First, I will do it on a copy of your tables and show it with test orders.

Budget: 12000 UAH Deadline: 10 days

Good day! Straight to the point — there is a technical trap in your specifications that is better to close before starting.

In Google Sheets, tab protection limits EDITING but not VIEWING. If all masters work in one file, everyone can open another's tab and see the amounts, expenses, and earnings of colleagues (even a hidden tab can be easily revealed). Thus, a "personal tab with restricted access" does not solve the problem in its pure form.

The working scheme: A main table for the manager + a separate file for each master. Apps Script, when creating an order, writes a row in the required master's file, while statuses and actual figures are automatically returned back to the Main. The master physically does not have access to others' data.

What is included:
1. Main table — order database, auto-distribution to the master, client history by phone number (previous orders, masters, and amounts are pulled up when entering the number).
2. Master's file — only their orders; status, scope of work, total amount, material expenses, parking, etc. Data is synchronized in the Main.
3. Calculations — net profit for each order (amount − expenses − payment to the master); the manager's commission is calculated ONLY from the net profit. I will move the commission rates to a separate "Settings" tab so that different rates can be set for different managers/types of orders without rewriting the code.
4. Summary report — filter by period: revenue, payments to masters, manager commissions, net profit of the company.
5. A short instruction for the manager and master + 30 days of free bug fixes.

Deadline: 7 working days until the first working version, followed by refinements based on your comments.
Cost: 12,000 UAH through Safe, payment after acceptance of work.

Free and without obligations: before starting, I will create a demo on test tables — the manager enters an order, the row automatically appears in the master's file, the master sets the status and expenses, and the net profit and commission are recalculated in the Main. You will see the live mechanics, and then decide whether we will work together.

To make the demo according to your process, please let me know:
— how many masters and managers are there currently;
— how the payment to the master is calculated (percentage or fixed);
— whether the manager's commission is the same for everyone or different. Expand

Budget: 1500 UAH Deadline: 1 day

Hello! I have done many similar projects! There will be no problem! I will do it quickly within a few hours! Feel free to contact me!

Budget: 5000 UAH Deadline: 2 days

Hello.

I am ready to do it.
I have worked on automated P&L tables.

The only thing that is unclear is the preservation of the client's history; what does that mean?

Budget: 18000 UAH Deadline: 10 days

We already have a practically ready similar scheme for automating work in Google Sheets, which can be quickly adapted to your process and launched.
We are in touch and can discuss the details here and find the shortest way to launch.

Budget guideline - from 18,000 UAH
Timeline guideline - 7-10 working days for the first working version

I see the implementation as follows:
- main table for the manager
- personal tables or tabs for masters with restricted access
- automatic order transfer to the master
- client history by phone number
- entry of actual expenses and statuses by the master
- calculation of net profit
- manager's commission only from net profit
- financial report by periods

From your side, we will need an example of the current table, calculation rules, a list of roles, and who should see which data.

I would like to clarify 2 points:
- should the masters work in separate Google Sheets files or are separate tabs with restricted access sufficient?
- is the manager's commission the same for everyone or does it depend on the manager, type of order, or amount?

Similar logic cases from Ingello:
- https://business.ingello.com/forma-bpm - automation of business processes and statuses
- https://business.ingello.com/forma-crm - client accounting, roles, operational logic
- https://business.ingello.com/iks - management system with accounting and reporting

Main profile for Freelancehunt:
- https://systems-fl.ingello.com/ua Expand

Budget: 1500 UAH Deadline: 3 days

Hello! Am I correct in understanding that the key requirement is that the manager's commission is calculated solely from the net profit, not from the revenue? I will discuss the terms and budget more precisely in personal correspondence.

1. I will set up automatic transfer of orders from the main table to the personal tabs of the masters through filters or scripts.
2. I will implement access rights segregation so that each master sees only their own rows.
3. I will write formulas for the automatic calculation of net profit and the manager's commission, as well as create a summary report for the period.

Thank you for considering my proposal. I look forward to the opportunity to collaborate with you!