Link or import Google Sheet file type

Feature request
1

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”.

2

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:

https://support.google.com/docs/thread/56613805?hl=en

3

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?

1 Like
4

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:
http://fileformats.archiveteam.org/wiki/Google_Sheet

5

Thanks for looking into this. Google has some work to do to improve gsheets use.

6

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.

7

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.

8

It is definitely on the wishlist!

9

I’ve had a lot of success using automations for data stored in Google Sheets. Has Google made it any easier, since this last post, to link or import Google Sheets to EDT?

10

Currently you have to turn the Google Sheet into a file (e.g. in CSV or Excel format) before Easy Data Transform can do anything with it. There seem to be various ways to do this. See the links above, also:
https://support.google.com/drive/answer/7638428

Further down the line we hope to allow you to easily integrate with online data sources. Hopefully you will then be able to extract data from a Google Sheet in a few clicks.