r/madeinpython • • Aug 16 '22

Python Google Sheets and Excel Automation with XLWings and automated email sending.

How many times did you hear an accountant say,

"Man, I have the same repetitive job done over and over on Excel" or

"I spend 30 mins a day doing the same excel tasks over and over"

That's the beauty of XLWings. Now, I will show you how an 11-minute task that is done daily is transformed into a 30-second script that fires automatically with #CRON Jobs on #linux, mac, or windows!

This 500-line script will download automatically the workbook from Google Spreadsheet using the GSpread library, automate 3-page steps tasks in Excel and finally send an automated email to a person using the SMTP library! Everything is automated! See! With the power of automation, you no longer need to repeat tasks!

Check it out here! https://youtu.be/ed4OsePomFw

22 Upvotes

2 comments sorted by

0

u/[deleted] Aug 17 '22

[deleted]

1

u/[deleted] Aug 17 '22

This is a python library, so it is using python. AFAIK it’s the best python excel lib, but it’s SaaS, so bleh.

0

u/[deleted] Aug 17 '22

[deleted]

2

u/[deleted] Aug 17 '22

Trust me dude, I get it, I’m happy to run my scripts from my IDE all of the time, but if you want to share that power with some non-programmer coworkers you’re gonna have to spin up a front end.
Everyone knows how to open an xlsl though, so if you’re working as part of a non-tech team, excel is like a nice API between your python skills, and them.
I’m in this exact scenario right now. One of a team of a dozen, and my scripts work 30x faster than the fastest non-python guy, but I want to share the scripts so I have to spin up tkinter.