This demos a Google sheet integration with this application, facilitated by the Pygsheets library. The practical use case is in reporting out data to a spreadsheet for the type of data consumer who would like data in such a form. For example, a scientist who wants lab measurement data aggregated in a spreadsheet, or a product manager who wants to have new enrollment numbers for the last month broken down by site.

Instructions for use.

• Create a new Google spreadsheet where you want results. The application will write some some data to your sheet at the tab name you desire. (Simply 2 columns, 3 rows)
• Give this app permission to edit the sheet, the email is p2-87-169@portfolio-298906.iam.gserviceaccount.com
• In the form below, enter in the URL for your sheet, and the desired name of the tab this app will write to (e.g. Sheet1 is the default).
• Click submit!