Looking for a specialist to set up a working management system for the new assortment based on Asana + Google Workspace for an e-commerce business (sales on marketplaces, import from China).
What we have now:
– A company that sells products on marketplaces (Allegro and others);
– Understanding of the process of selecting and launching new SKUs;
– Vision of the structure: Asana as the main task system, Google Sheets/Docs/Drive as the database and document storage.
What needs to be done by the contractor:
1. Design the structure:
- Google Sheets table "Niche Showcase" (tracking ideas and statuses for products).
- PRD template ("Product Map") in Google Docs.
- Folder structure on Google Drive: a separate folder for each SKU, linked to the table and Asana.
2. Set up Asana:
- Project/board for the process of launching new products (stages: idea → analytics → PRD → RFQ → order → content → launch → stable sales).
- Fields, statuses, checklists tailored to our process.
3. Create integrations and automation:
- Link Google Sheets/Docs/Drive with Asana (via n8n, Zapier, Make, or similar).
- Automatic creation/updating of tasks in Asana when the status of a niche changes or a new SKU appears in the table.
- Linking tasks to specific folders and documents on Google Drive.
4. Documentation and handover:
- Brief instructions for the team: how to add a new niche, how to work with tasks, where to find documents.
- 3 iterations of edits after testing.