Export Option for Google Sheet

[IshaGupta18]

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 googleapis/google-api-nodejs-client#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]

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]

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]

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.