Function to upload local csv to new google sheet

[jennybc]

From #1, which was about a different thing, but accumulated some good links about this.

@leeper pointed out this: uploading using the Drive API (specifically the file insert endpoint, using the convert = true argument)

More links I found:

http://stackoverflow.com/questions/12765813/upload-csv-to-google-drive-spreadsheet-using-drive-v2-api

https://developers.google.com/drive/v2/reference/files/insert

[jennybc]

Done via b707de5

[yeedle]

Is it possible to extend this to upload a dataframe directly to google sheets? Perhaps by invisibly writing dataframe to disk, uploading file to googlesheets, and then invisibly remove file from disk. I often find myself writing dfs to disk and deleting them afterwards just so that I can upload them via gs_upload

[jennybc]

gs_new() can put an existing R object into a new Sheet.

https://cran.r-project.org/web/packages/googlesheets/vignettes/basic-usage.html#create-a-new-google-sheet

[yeedle]

Completely missed that 🙈