How do I create a MisoData from a Google Drive spreadsheet?

In order for our system to download the CSV file, you need to follow this guide to generate a download link for the CSV file of Google Drive Spreadsheet.



1. Open a Google Drive Spreadsheet


Click “Share” to change share settings



2. Change Access Settings


- Click  “Change”  to change access settings

- Click “Anyone with the link”

- Click “Save”





3. Publish to the web...


a. Select  “File”  at the top navigation

b. Click “Publish to the web…”




c.. Make sure the option  “Automatically republish when changes are made” is checked

- Click “Start publishing”

- Copy “Document link”



Replace  “pubhtml” with  “export?gid=0&format=csv“


Change from

https://docs.google.com/spreadsheets/d/<KEY>/pubhtml


Change to

https://docs.google.com/spreadsheets/d/<KEY>/export?format=csv&id=<KEY> (csv file)


To export only a specific sheet, change to

https://docs.google.com/spreadsheets/d/<KEY>/export?format=csv&id=<KEY>&gid=<SHEET ID>&single=true


Google spreadsheets provide also:

https://docs.google.com/spreadsheets/d/<KEY>/export?format=xlsx&id=<KEY> (xlsx file)

https://docs.google.com/spreadsheets/d/<KEY>/export?format=ods&id=<KEY> (ods file)

https://docs.google.com/spreadsheets/d/<KEY>/export?format=tsv&id=<KEY> (tsv file)


Google Spreadsheets have not been optimized for large volume spreadsheets which makes accessing them via the API a challenge. 

Feedback and Knowledge Base