Welcome,
Visitor
This demos a Google sheet integrations showing download, analysis, upload, and production of a Google slide deck of basic plots from the data set, facilitated by the Pygsheets library. If you would like to chuck some data at it, try your own, or if you don't have something at the ready, you can use data I uploaded here. Please copy it over to something under your control (suggest File...Make a Copy) and try out the instructions below!
Instructions for use.
- Prepare some numerical data you would like to analyze in a Google sheet. You can view the linked example above, but basically the first row are the column names for the data
- Give this app permission to edit the sheet, the email to use is p2-87-169@portfolio-298906.iam.gserviceaccount.com
- In the form below, enter in the URL for your sheet, and the name of the tab where your data resides, and your email (which must be a G-suite email)
- Click analyze!
- If the data is large, the app will have to complete the work in the background minutes after clicking Analyze. In that case, you may have to check your spam folder at the email you provided for notification of the slide deck being completed and ownership transferred to you.