I have clients that enter data into a Google Sheet (I know… how lame), that is synced to my computer. It would be great if I could use a Google Sheet as a document source and have it as a “watch file”.
We would like to add the ability to access data from web applications such as Google Sheets and Airtable. But that is probably going to be a fair amount of work.
Until then, the I only way I could find to do this is to write a ‘Google App Script’ to periodically download the Sheet to a local .csv file. I haven’t tried this. But here are some links I found:
If you have your Google Drive synced to your computer, the file is available locally on the hard drive as a *.gsheet file. Possibly an easier to implement stop gap?
Unfortunately it seems that the .gsheet file is effectively just a pointer to the online document. It doesn’t contain any actual data that we can access without using the web API:
Thanks for looking into this. Google has some work to do to improve gsheets use.
I have hardly used it. I understand it is a long way behind Excel in terms of features. It is also limited to 5 million cells.
I’d like to add my vote to this feature request. While Google Sheets is definitely less powerful than Excel, the biggest thing that it has going for is how it enhances collaboration. It eliminates so many emails because everyone has access to the same data all the time from one place.
I’d also like to be able to export transformed data to a Google Sheet.
It is definitely on the wishlist!