Automating exports to Google Sheets or .pdf?

Adna Muliawan · July 2023

My school has a need to regularly reference student schedules during the first few weeks of the school year during add/drop/swap. Currently, I export a report from Blackbaud as a .csv, and copy it into a Google Sheet which does the processing that we need. However, the frequency that this needs to be updated is very high at the beginning of the year (at least twice daily), which would be difficult to do consistently without automation. Is there any way, preferably via the blackbaud API, to automate the export?

The desired output would be an arbitrary report regularly updating a set file destination on a local computer (eg. “export.csv”), or even better, a Google Sheet.

Todd Peyton · July 2023

Hello,

Yes! Please check out the two links below. They are the experts, but I would be glad to try and answer questions of how we are using this method if you like.

You might want to evaluate / copy / test this methodology for using SKY API developed by Nick Marchese from Emma Willard - https://watch.screencastify.com/v/uNrMxJmXSknS9jznbZ3H

Adna Muliawan · July 2023

@Todd Peyton
Thank you! This is the exact thing I needed, and with tutorials in multiple formats, too!

Bryna Gleich · July 2023

@Adna Muliawan

To learn more about SKY API for schools, also consider these two links:

Automating exports to Google Sheets or .pdf?

Comments

Categories