xlwings Newsletter #40

A New Way to Automate Google Sheets with Python

July 12, 2022

Blog: A New Way to Automate Google Sheets with Python

It’s been possible to automate Google Sheets via the Google Sheets API for many years and there are multiple Python packages available that wrap this API: there’s gspread, pygsheets, ezsheets, and Google’s own google-api-python-client. All these packages talk from Python to Google Sheets and require you to create a Google Cloud Platform project, download a credentials file, and potentially share your spreadsheet with the user from the credentials file.

I, however, was missing the Google Apps Script experience in Python, i.e., I wanted to develop interactive spreadsheet apps directly in Google Sheets. So I went ahead and added Google Sheets support to xlwings: instead of using the Sheets API to talk from Python to Google Sheets, xlwings goes the other way around and talks from Google Sheets to Python.

Learn more about the high-level concepts by clicking the button and reading my latest blog post.

Book: And the winner is...

It's been a while since the last newsletter, but you may still remember that I was giving away a free copy of my book "Python for Excel". The winner was drawn at the end of April and the book went to Chris in the U.S., congratulations!

In related news, "Python for Excel"

  • is now available in Korean (picture)

  • can be pre-ordered in German (planned release: September 30, 2022)

  • will also be translated into Portuguese (no publication date yet)

You will find all relevant links on the book's homepage: 

Save the date: In-person meetup in London

It's been a very long time, but we're finally back for an in-person meetup later this year in London.

When: 19 September 2022, 6:30pm (London time)

Where: The Microsoft Reactor London

I'll be sharing more details a bit closer to the date, but you can always contact me if you want to present something (simply reply to this email). You can reserve your spot here (please note again that this is NOT a webinar but a live event):

Thanks for reading along!

~ Felix