Automated Industry Categorizer for Spreadsheets
Budget: $150 – $700 USD
As a freelancer, you'll revamp my repetitive tasks by creating an automatic tool that categorizes my industry-specific spreadsheets. These spreadsheets are currently in Google Sheets format and span across various industries such as Fashion, Beauty, Sports, Tech, and are not categorized.
Key Responsibilities:
• Develop an automated system in Google Sheets that can detect the Industry Category for each brand / client and tag it appropriately.
• Create a system that can detect when data is in the wrong place. For example if a contact from the Beauty industry has been put in a spreadsheet for the Tech industry the system should detect this and correct accordingly.
• Our spreadsheets headings are labeled as the following - Brand | City | Title | First Name | Last Name | Email. This system should take the name of the 'Brand', assess which industry it belongs to and sort accordingly.
Ideal Skills and Experience:
• Proficient in Google Sheets and Google Apps Script to automate tasks
• Knowledge of data categorization
• Experience with Ai
• Experience in automating spreadsheet tasks
• Understanding of the Fashion, Beauty, Sports, Tech industries to ensure data is in the correct position.
Key Responsibilities:
• Develop an automated system in Google Sheets that can detect the Industry Category for each brand / client and tag it appropriately.
• Create a system that can detect when data is in the wrong place. For example if a contact from the Beauty industry has been put in a spreadsheet for the Tech industry the system should detect this and correct accordingly.
• Our spreadsheets headings are labeled as the following - Brand | City | Title | First Name | Last Name | Email. This system should take the name of the 'Brand', assess which industry it belongs to and sort accordingly.
Ideal Skills and Experience:
• Proficient in Google Sheets and Google Apps Script to automate tasks
• Knowledge of data categorization
• Experience with Ai
• Experience in automating spreadsheet tasks
• Understanding of the Fashion, Beauty, Sports, Tech industries to ensure data is in the correct position.