Weekly JioMart Product Sheet Updates
Budget: ₹100 – ₹400 INR
I keep my JioMart catalogue in Google Sheets and every week the product section needs to be refreshed. The task is straightforward: take the latest feed I supply, cross-check it with the existing sheet, and bring three fields fully up to date—product name, long and short description, and category classification. No stock or price work is required, only these product-detail columns.
I’ll share the current master sheet, the incoming CSV/XLSX feed, and a simple colour-coded status key so you know which rows have already been handled. Your update has to be completed once every week, preferably by Friday evening, with all changes tracked in a separate “Changelog” tab so I can audit what was modified.
Accuracy in copy-pasting, solid command of Google Sheets functions (VLOOKUP, FILTER, ARRAYFORMULA), and a knack for keeping naming conventions consistent are the core skills I need. If you can automate part of the comparison with Apps Script that’s a bonus, but not mandatory as long as the end result is 100 % correct each week.
I’ll share the current master sheet, the incoming CSV/XLSX feed, and a simple colour-coded status key so you know which rows have already been handled. Your update has to be completed once every week, preferably by Friday evening, with all changes tracked in a separate “Changelog” tab so I can audit what was modified.
Accuracy in copy-pasting, solid command of Google Sheets functions (VLOOKUP, FILTER, ARRAYFORMULA), and a knack for keeping naming conventions consistent are the core skills I need. If you can automate part of the comparison with Apps Script that’s a bonus, but not mandatory as long as the end result is 100 % correct each week.
Related categories:
Visual Basic
Data Processing
Excel
Data Analysis
Google Sheets
Automation
Data Management