I work with a sales team who frequently enter OPPs into SalesForce.
Part of this process requires the sales rep to manually:
- Google customer City+State to find Zip Codes
- Use an in-house spreadsheet to map Zip Codes to sales regions
- Use another spreadsheet to map sales regions to sales reps
This process is done about 100 times/day by my team, and my current idea is to develop a Chrome extension to automate the google + excel spreadsheet lookups.
Any other ideas of how to best solve this problem?