Their wide adoption of Google tools makes them a great choice in collaborative contexts like cross border projects. Online documents and spreadsheets can also be used as input for any kind of automated processes, allowing non technical people to participate with tools they are already familiar with. In this hands-on session we will see how to automate Google Docs to make more with it. Think for example how to create, edit, upload or export files, but also perform some search and replace across multiple documents, automating the publishing of a csv as a spreadsheet with headers and filters, etc.
I will briefly present the different options available (Google App Scripts, Python with Gspread or the Google Drive API). Then you will have an opportunity to complete a Hands-On task.
For the hands on task, please set up one of the authenticating methods
described here, either OAuth or a service account.
If you have a particular use case in mind, please bring it and we will discuss it together / try to make it happen!
