search

Synthoid / ExportSheetData

Add-on for Google Sheets that allows sheets to be exported as JSON or XML.
MIT License
234 stars 46 forks source link

upload generated JSON file to Amazon S3 #114

Open epoger opened 4 years ago

epoger commented 4 years ago

Suggested enhancement: allow user to configure the plugin to upload the JSON file generated to an Amazon S3 bucket rather than Google Drive.

I am willing to try my hand at adding that, if it's considered a good idea... or perhaps I would be better off using a 2-step solution? (Upload JSON file to Google Drive, and use a connector of some sort to upload a copy into S3 from there?)

Synthoid commented 4 years ago

Interesting idea. I'm not 100% sure that it can be done easily, since most of the app-script API is locked down when it comes to external URLs. This is especially challenging since the file doesn't exist until the Google Drive API creates it. That said, you could probably get the generated JSON as a string then pass that to a custom function that interacts with your S3 bucket.