13 ms·
I use Python to suck structured data out of our sales CRM's REST API and transform it into a nicely formatted narrative biweekly report in Excel for exec manage
by scrumper 9y ago
I use Python to suck structured data out of our sales CRM's REST API and transform it into a nicely formatted narrative biweekly report in Excel for exec management. Pleasingly, it's reduced the aggregate time the sales team spends "writing about work" from about 80 hours a month to under 20. Subsequently I've extended that script to also automate the process around reminding relevant people about expiring legal agreements and the like.
Using Python 2.7, BeautifulSoup, XLSXWriter, Fuzzy Fuzzy. As a Python newbie, the hardest thing was working out how to even pick a version and an environment to start building on.