A specialist is required to automate Google Sheets for the VB marketplace. The sheets are filled on a daily basis. It is necessary for them to be automatically consolidated based on reports from the personal account (using an API key or your own script).
The process of filling in the tables needs to be automated. Currently, our tables are filled in manually - we want everything to be pulled automatically
There are a total of 2 tables:
https://docs.google.com/spreadsheets/d/1ZyI_DTvzjIVDWwgw95DsQcGeWAKeKRrZfxU0qwUWPIw/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1a2oDy5QSQab-BzjanB8TiPamJxiyCoLRwrozPGFUMqk/edit?usp=sharing
Explanation:
Table No. 1.
Consists of 5 types of reports from the personal account for two IP:
“Sales Funnel”
“Sales”
“Promotion - Finance”
Statistics of each individual company in automatic advertising and search advertising (we download and upload statistics manually)
The table is formed for each SKU on separate sheets. The table in the link above shows one SKU as an example
Table No. 2.
Consists of reports from the personal account for two IP:
“Summary by Seller”
“Weekly Sales Dynamics and Analysis”
Currently, the reports are downloaded and uploaded manually. After loading the reports, we get “Category Dynamics”, overall results for the week, and overall results for the month.
I can provide details on filling in the tables in private correspondence - we have recorded screencasts on filling in the tables. I can also send them so that the logic is clear