Google Sheets macro
45 USD A macro is needed (preferably in Google Sheets) that sums up the quantities (stocks) of products based on data from 3 sources, where the product identifier is the article number:
“Google sheets” file, in a specific folder on Google Drive
API file - needs to pull from Salesdrive (instructions from them below)
“.ods” file, which the user uploads every day to a specific folder on Google Drive
How the macro should work:
The user copy-pastes the “.ods” file into the corresponding Google Drive folder
The user enters our stock macro and adds the required articles to this file, then RUNS THE MACRO, and for these articles, the macro should go to the 3 files and extract the stocks based on the product status logic.
Example of a completed stock macro file (with some explanations of the logic inside): https://docs.google.com/spreadsheets/d/1Hkc4f1rPZPyYcKmzKbdsXBd0GfFjncQhSrL66VkbCwI/edit?usp=sharing
Example of an ".ods" file (only part of the info): https://drive.google.com/file/d/1N2HKXnnb2zbwMuRn0fV8y7r0WmaWzU8m/view?usp=sharing
The same product (Article) can be in several warehouses. Also, the order and number of columns in this file may change, but the exact names will always be the same
Example of a Google Sheets file (only part of the info and part of the sheets): https://docs.google.com/spreadsheets/d/1p6BShf_2DvAZ--6HnHzbvSwoc4JYt8b25OW6MP5Hegs/edit?usp=sharing
Here 1 sheet = 1 supplier, all sheets have the same structure, there can be 30-40 suppliers, the macro needs to check all of them by articles.
Example of the info returned by the API (only part of the info, I exported it to Excel manually): https://docs.google.com/spreadsheets/d/1oiPOlVsMt3OtblZU9pko11qhMfQo0fIx/edit?usp=sharing&ouid=100149837749797672307&rtpof=true&sd=true
Instructions for connecting to the API https://salesdrive.ua/knowledge/api/order-list. The API key will be provided to the executor. The frequency of data extraction is every 1 minute.
Client's review of cooperation with Dmitry L.
Google Sheets macroEverything is 10/10! I recommend! The developer did significantly more than I described in the technical specifications. Promptly, clearly, cool. I recommend!
Freelancer's review of cooperation with Nikolay Oli
Google Sheets macroMykola is a reliable client, happy to collaborate. An interesting atypical task, seemingly easy to implement at first glance, but it turned out to be more complicated. Mykola, loyal and competent in his field, is always in touch and we quickly resolved all issues. I would gladly work on new tasks when the opportunity arises. I recommend him for collaboration.
-
2 days67 USD
981 17 0 2 days67 USD
Good day!
Please feel free to reach out. I have experience integrating Google Sheets with various services via API and automation in spreadsheets.
-
2 days45 USD
3020 73 4 2 2 days45 USD
Good day! I can implement!!!!!
!!!!!!!!!!!! Feel free to contact me!!!!!!!!!!!!!!!!!!!
-
5 days67 USD
631 5 0 5 days67 USD
Good day
I can create a program to avoid the limitations of Google Sheets
I will do it quickly and efficiently
-
Winning proposal2 days45 USD
1315 63 1 Winning proposal2 days45 USD
Good time.
With the .ods file, some maneuvers need to be done because Google Drive cannot read it directly; it can be converted to Google Sheets using a macro, and then read (inconvenience when replacing each time by deleting the converted one). There is also a library that can read it; tests need to be done. Also, if the order of columns changes, a search by name needs to be done. There may be 30-40 suppliers, and how many products are there?
Because if comparisons and row iterations + column searches by name are done, it can take a lot of time, and Google allows a maximum of 6 minutes for macro execution; if there are many operations and it doesn't fit within six minutes, there will be an error without a result.
Feel free to reach out, we will discuss, we will agree, I will do it.
Current freelance projects in the category Databases & SQL
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 2 days 2 hours back ∙ 53 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 2 days 3 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 2 days 15 hours back ∙ 10 proposals |
Database synchronization
Synchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 2 days 21 hours back ∙ 12 proposals |
Setting up a backup system and optimizing server infrastructure
Objective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 3 days 20 hours back ∙ 26 proposals |
Kyiv