Github repo: Using sky-python-api-client To Auto Update Google Sheets

Warren Hyson

I made a Github Repo to serve as an example of how the sky-python-api-package can be used to auto update data in an external data warehouse.

In addition to pandas and the sky-python-api-client, I also used gspread to make interaction with Google Sheets really simple.

For efficiency I created several Advanced List in my Core environment to get the data I wanted in the best format.

On that note, would it be possible to make Advanced List shareable to the community? I think that would make development much easier for each party involved. For example, when integrating with School Messenger I had to create several Advanced List that worked with their application. It was sort of a pain in the butt because I had to make sure the Advanced List in my environment matched their codebase.

If they were instead able to create their own Advanced List templates, and schools could connect them just like they can connect apps in the Blackbaud marketplace, I think that would be really helpful.

As a developer it would be great for testing and debugging. For the end user its great because it doesn't require any advanced knowledge of the product.

Have a great Thanksgiving