Good Day Everyone,
I have recently added DATA SOURCES to make things easier. The issues that I am experiencing are:

1.Instead of a photograph appearing, I am getting the LINK to the photograph
2.I can make changes in GOOGLE SHEETS but have to use DATA SOURCES box to see graphics change.

Thanks in advance...

Thanks for your response..
I am confused! LOL... I placed photographs in GOOGLE DRIVE to obtain an URL.
https://drive.google.com...c_FwIvj/view?usp=sharing shows rather than the photograph. However, when I mouse over the link in GOOGLE SHEETS I see the photograph. Question 2 wasn't thought thru....

Doggy,
I have to chuckle at you. You are funny.. It is not that I am not wanting to provide answers.
Perhaps I am not understanding your question(s). I am thinking that the "IMAGE PLACEHOLDER" missing is my problem. Are they in GT Designer?
I got the URL from the GOOGLE DRIVE. That's where I have photographs stored.
The Names and Titles populate. Just not an image. The Lower Thirds displays the LINK.
Not sure how to add/remove restrictions.


Thanks...

Well, there is no official way to get image URL-s from images that are added to the spreadsheet, only external web addresses work.

But.. there is an unofficial way I have used. One could publish the spreadsheet to the web. File -> Share -> Publish to web. Select Link then from dropdowns Entire Document and Web page. Click Publish. Copy the URL. At the bottom of the dialog make sure the "Automatically republish when changes are made" is checked. Start publishing.

Now you should have a URL that if you open in the incognito window would show your table and also the images. And the last step - you need intermediate software that parses that webpage and exports contents as CSV for example. I have written it to run on my local machine and it fetches entire table and image URLs from the HTML file. You need to change image URL a little to get maximum resolution, it is for example https://lh3.googleuserco...JNaDMjcBtm7ssvH1dDaJqiQw=w228-h229 and you need to remove the part that is in bold.

Done.

Edit: Damn, I missed the point, but I'll leave that here, maybe it helps someone.

To get Google Drive image links to work, firstly you need to share them publicly. Right-click, Share, change link sharing to "Anyone with the link". Now you get URL-like https://drive.google.com/file/d/16c3pHrTu6ehgrugi8HFP_n9vPezCSMuE/view?usp=sharing which will not work in Data Source since it is not a direct link to the image, vMix basically tries to fetch the webpage itself. Now you what you do, is you must get the image id (in bold) and replace it in following link: https://drive.google.com/uc?export=view&id=16c3pHrTu6ehgrugi8HFP_n9vPezCSMuE image now shows up in GT Title.

To get Dropbox images working, you share the image, you get URL like https://www.dropbox.com/...311xepnhn1taxn/5.png?dl=0 which again won't work in vMix, now if you change dl value to 1 like https://www.dropbox.com/...11xepnhn1taxn/5.png?dl=1 the image shows up in GT Title.