Tracking the time taken for order processing in Google Sheets (automatic data collection from KeyCRM)
290 USD It is urgent (by Friday) to create a Google Sheet that automatically pulls data from KeyCRM and shows the time taken for each order by status.
It is necessary
To set up the integration of Google Sheets with KeyCRM
To collect in the table the history of statuses for each order (with date and time).
- To make automatic time calculations:
- from "New" to "Transferred to delivery"
- from "New" to "Print"
- from "Transferred to delivery" to "Received" and so on for all available statuses
Add filters and basic analytics (average time, SLA, highlighting long processes).
The output should be a ready Google Sheet with auto-updating data, formulas for calculating time between statuses, and a short instruction on how to use and modify or add new metrics
Work results
Client's review of cooperation with Illia Vasilenko
Tracking the time taken for order processing in Google Sheets (automatic data collection from KeyCRM)Developed a convenient and well-thought-out dashboard for tracking orders, which automatically collects and analyzes data regarding the time orders spend at various stages. Particularly appreciated: clear visualization of SLAs, cycles, and order statuses detailed reports (custom, performance, by stages) the ability to filter by dates, statuses, urgency understandable interface and logical data structure. Well understood the business logic, proposed adequate solutions, and was in touch throughout the entire process. Task completed on time, the result fully meets expectations. Recommend for collaboration, especially for projects related to analytics, dashboards, and process automation.
Freelancer's review of cooperation with Danilo Galitsky
Tracking the time taken for order processing in Google Sheets (automatic data collection from KeyCRM)Good client. Clear task and communication.
-
1 day134 USD
4089 8 0 1 1 day134 USD
Good day.
Our team has many years of experience in developing ERP, CRM, CMS, and specialized software for businesses. We create effective digital solutions that help automate processes, increase productivity, and scale companies.
We work with modern technologies — from bots and scripts to AI agents and analytical systems. We develop websites of varying complexity. In our portfolio, we have implemented ERP solutions for the hotel business, as well as for companies engaged in the import and sale of goods, and our own product XFitness — an ERP system created specifically for fitness clubs.
We are ready to implement your project and offer the best solution tailored to your needs.
Our portfolio:
Freelancehunt
We specialize in the following areas:
… - Development of ERP Systems
- Development of CRM Systems
- Development of Websites of any complexity
- Development of CMS Systems
- Support for Websites
- Development of OpenCart
- Support for OpenCart
- Modification of OpenCart
- Refinement of OpenCart
- Development of WordPress
- Support for WordPress
- Modification of WordPress
- Refinement of WordPress
- Development of ECommerce
- Support for ECommerce
- Modification of ECommerce
- Refinement of ECommerce
- Development of Web Applications
- Support for 1C Servers
- Support for Web Servers
- Development of mobile applications
- Data parsing
- Development of bots
- Development of AI agents
and on the following technologies:
- Python
- PHP
- Laravel
- Symfony
- Yii2
- JS
- NodeJS
- jQuery
- TypeScript
- MySQL
- HTML
- CSS
- Vue
- Nuxt.js
- React
- React Native
- C++
-
1 day134 USD
945 31 1 1 day134 USD
Hello. Ready to discuss in more detail in private messages. 4500 - 1 day
-
2 days134 USD
2947 73 4 2 2 days134 USD
Hello!!! I have experience, so I can do it quickly and efficiently!!! Contact me!!
-
2 days134 USD
1768 17 1 2 days134 USD
Good morning! I have already completed a similar task, but it was more complicated due to the dashboard. Everything will be ready by Friday.
-
1 day134 USD
110 1 day134 USD
Good day, please write to me in private messages, I will help you do it.
Current freelance projects in the category Data Processing
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 2 days 12 hours back ∙ 17 proposals |
Assistant to the manager for project work in the field of science and scientific publicationsLooking for a responsible assistant to work with personal social networks, a contact database, and current projects in the field of science and scientific publications. At the first stage, the collaboration is planned for one month. The main task is to assist with basic… Information Gathering, Data Processing ∙ 3 days 4 hours back ∙ 10 proposals |
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 5 days 4 hours back ∙ 21 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 5 days 4 hours back ∙ 19 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 7 days 13 hours back ∙ 14 proposals |
Lvov