Budget: 2000 UAH Deadline: 1 day
Hello, I can implement it on App Scripts, I am currently available for your project, feel free to contact me.
Budget: 2000 UAH Deadline: 1 day
Hello.
I have experience with Google Sheets. I am ready to take it on. Write to me, we will discuss.
Budget: 1600 UAH Deadline: 3 days
Good day. I have worked multiple times with Google Sheets through the Google API, mainly as a data recording source after parsing. The technical specifications are not entirely clear, and I would like to see it myself. I am indicating an approximate cost.
Looking forward to working with you!
Budget: 3200 UAH Deadline: 3 days
Hello!
I see the task as automatic synchronization of the Master (products + prices) into 14 separate tables by the SKU key with correct transfer of IMAGE(), hyperlinks, and different sets of columns for each catalog.
I propose implementation through Google Apps Script (without IMPORTRANGE + QUERY) to ensure stability and minimal load on the API:
a separate Config sheet (table IDs, tabs, columns, values/formulas mode)
batch update
an "Update" button + scheduled trigger
correct transfer of formulas or values — we will agree before starting
Questions for clarification:
Should IMAGE be transferred as formulas or as values?
Are all tables already created and open for editing?
I am ready to start immediately after access to the Master.
If you have questions, I will respond in personal messages.
Budget: 2000 UAH Deadline: 4 days
Hello!
I understood the task for automating the Master table.
I will implement it using Google Apps Script (IMPORTRANGE + QUERY will be slow and unstable for 14 files).
I will do:
- A script for distributing data across 14 tables (by SKU).
- Transferring photos (IMAGE) and hyperlinks.
- A convenient configuration sheet for managing columns/tables without code.
- An update button or trigger (on schedule/when changed).
I have experience with GAS and API. Write to me, and we will discuss the details!
Budget: 990 UAH Deadline: 3 days
Hello, Oleksandr!
Straight to the point: the combination of IMPORTRANGE + QUERY for 14 tables will "break" your Master file. Here, only Google Apps Script with batch update is needed for speed.
How I will solve your key tasks:
Images and links: A regular script breaks them. I will use getRichTextValues() and getFormulas() to ensure that photos (IMAGE) and hyperlinks are transferred perfectly.
Complete independence: I will create a convenient configuration sheet. You will be able to independently add new tables and specify which columns to export there, without interfering with the code.
User-friendly interface: I will add a custom menu for manually triggering updates + we will set up a background trigger.
I specialize in building complex architectures and web applications based on Google Sheets. Message me privately — I will show examples of my work and we will discuss the details!
Budget: 5000 UAH Deadline: 7 days
Good day. I can do it. Do we need to store any data in an external database?
Budget: 1000 UAH Deadline: 3 days
Good day!
I have extensive experience in data automation in Google Sheets using Google Apps Script and API. I am ready to implement a data distribution system from your Master table into 14 separate directories. I will ensure high stability, scalability, flexible column configuration, correct display of IMAGE formulas and hyperlinks, optimized data handling, and minimal manual intervention.
Message me privately, and we will clarify the details.
