Graphics

I am trying to datalink to a google sheet that our conference is going to use to update scoring during an event. Does anyone have an idea as to how I would data link to a sheet.

I read the old post about publishing the google sheet and then bringing that in as an RSS feed. It appears as though Google has changed their publish URLs since that post was written, and so the steps to accomplish this would be different now.

I have google drive downloaded to my local machine and I can see the file, the problem is the file comes as a google sheet and not as an XLSX that I could easily link to.

Know this is a little late, but we were able to achieve this:

In Google Sheets, choose File > Publish to the Web. Under Link and next to Entire Sheet, choose XLSX in the drop down menu. Under Published Content & Settings, be sure to check mark "Automatically republish when changes are made." Copy that share link.

We used wget in the command prompt to download that link and place the xlsx file locally. In Datalinq, pointed to the correct file and boom, we were able to update the Google Sheet and it updated after a few seconds in XPression. Unfortunately I don't have the wget command anymore, as this was a one time deal, but I do know there's a lot of tutorials on Google!

Hope this helps!
#XPression

https://discussions.rossvideo.com/forum/default-forum-gc1/xpression-cg-and-graphics-system-gc12/11473-support-of-google-docs-drive
#XPression

@Stewart, it was my understanding that this wouldn't effectively be live through a wget method. When I tried it, it wouldn't republish changes when there were multiple people using the sheet. What was being published wasn't in sync to the current gsheet state. 

#XPression

I am sorry that I never circled back.  We did end up using google sheets just fine.  We have 5 different people inputting data.  Our hang up was on refreshing data since it does not appear that there is support for macro driven sheets in datalinq.  So I matched all of the data up, and just updated excel every 3-5 seconds manually (600 times or so).  Newer versions of excel have the ability to take in external data.

So I downloaded the google sheet through Chrome.  I went to the downloads page in chrome, right clicked and copied the download link.  I took that into excel and told excel to take from an external data source.  That then populated my excel sheet.  Then I did a manual update in excel and the data passed no problem at all.

I do not remember, but my memory serves me best that we had 6 different download sheets we had to do, because excel was not reading the different tabs from google sheets.  So each tab had to be downloaded one at a time.

#XPression