Export Option for Google Sheet

publiclab / simple-data-grapher

Turns CSVs into graphs in a few simple steps; embeds onto other websites!

https://publiclab.github.io/simple-data-grapher/

GNU General Public License v3.0

38 stars 52 forks source link

Export Option for Google Sheet #64

Open IshaGupta18 opened 5 years ago

IshaGupta18 commented 5 years ago

I am working on a demo of the simple-data-grapher library to be hosted on heroku and also implement the Google Sheets feature there, as after struggling for few days I realized that we need a server to make that work, as credentials can't be set in the browser itself. Here's a link which explains it better https://github.com/googleapis/google-api-nodejs-client/issues/1620. So once the demo is up and running, we can probably create a similar kind on an actual server. @jywarren @namangupta01 @gauravano what do you think?

IshaGupta18 commented 5 years ago

Here's a heroku demo of the current simple-data-grapher functionality. I am still struggling with the same error for Google sheets tho :(

https://simple-data-grapher.herokuapp.com/

jywarren commented 5 years ago

Some options to explore?

https://stackoverflow.com/questions/42362702/how-to-import-a-csv-file-using-google-sheets-api-v4
This seems to indicate that there could be a more complex integration like an "add-on" -- but maybe that's too much? https://blog.sheetgo.com/how-to-solve-with-sheetgo/import-csv-to-google-sheets-automatically/

jywarren commented 5 years ago

https://developers.google.com/drive/api/v3/manage-uploads#import_to_google_docs_types_ - this looks promising and may not require a token...? it uses fs but maybe it could be replaced with something browser compatible? I think this approach probably assumes you are already logged into Google Drive, so we'd have to warn the user.