google-sheetsexport-to-csvexport-to-excelgoogle-docsgoogle-docs-api

How can I automatically download backups of a Google Sheet?


I am currently using a Google Form to allow people to submit information that is stored in a Google Docs Spreadsheet (now "Google Sheets"). I was wondering if it is possible to automate a backup of the spreadsheet at regular intervals. For example, every Friday the spreadsheet will be exported as a CSV and either emailed to me or stored on in a password protected directory on the server.

Any ideas are appreciated!


Solution

  • Google Docs is the ideal tool to edit and collaborate on your documents online. Although Google Docs does not provide feature for automatically backup, people that use Dropbox storage at the same time as Google Docs have solution for that.

    The solution is cloudHQ (10$+/pm) service that provides real time synchronization between Google Docs and Dropbox. For example, while user is editing some Google Docs web document, the document is automatically modified in Dropbox. That means, cloudHQ automatically copies file from Google Docs to Dropbox.

    I would like to propose the following link to cloudHQ Quick Tour. CloudHQ also provides Google Chrome extension. With cloudHQ Chrome browser extension you can sync or replicate anything in your Dropbox or Basecamp account with Google Docs - directly from a Google Docs interface. Extension is available in Google Chrome web Store.

    I should be grateful if anyone could provide me some tip or opinion about data synchronization between cloud services.