logo

Live Production Software Forums

www.vmix.com

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Google Sheets Error Message - Having trouble getting Google Sheets document into vMix as Data Source
Options
Go to last post Go to first unread
Previous Topic Next Topic
topherharris  
#1 Posted : Wednesday, August 21, 2019 9:04:04 AM(UTC)
topherharris

Rank: Member

Groups: Registered
Joined: 8/21/2019(UTC)
Posts: 13
United States
Location: Pasadena, CA

Thanks: 3 times
Was thanked: 2 time(s) in 2 post(s)
The error message I'm getting: "ERROR: The remote server returned an error. (403) Forbidden"

I've followed the instructions here first on how to create a Google API Key for Google Sheets" - https://www.vmix.com/hel...ex.htm?GoogleAPIKey.html

I then tried to add the API key I created as well as the "Shareable link" to a test Google Sheets doc.

Am I missing a step?

Thanks,

Christopher

System Profile:
vMix Pro 22.0.0.67
Windows 10 Enterprise v1803
Intel Xeon CPU E5-2687W v4 3.00GHZ
64 GB RAM
NVIDIA GeForce GTX 1080
Back to top
WWW

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
IanM  
#2 Posted : Thursday, August 22, 2019 1:12:55 AM(UTC)
IanM

Rank: Member

Groups: Registered
Joined: 8/3/2019(UTC)
Posts: 21
United Kingdom
Location: London

Thanks: 1 times
When you did 'Share' on the sheet, did you click the 'Get shareable link' on the pop up. That seemed to do it for me.
Back to top
topherharris  
#3 Posted : Saturday, August 24, 2019 7:28:47 AM(UTC)
topherharris

Rank: Member

Groups: Registered
Joined: 8/21/2019(UTC)
Posts: 13
United States
Location: Pasadena, CA

Thanks: 3 times
Was thanked: 2 time(s) in 2 post(s)
Originally Posted by: IanM Go to Quoted Post
When you did 'Share' on the sheet, did you click the 'Get shareable link' on the pop up. That seemed to do it for me.


Yup, I did that. Unfortunately, the ability to share at our site is limited globally in our G Suite. Meaning, we can't make a Google Sheets document "Public."

So, unless there's a way to log in via the vMix Data Source manager, it's not going to happen.

-topher
Back to top
WWW
PopisDad  
#4 Posted : Monday, August 2, 2021 7:52:29 PM(UTC)
PopisDad

Rank: Advanced Member

Groups: Registered
Joined: 7/24/2014(UTC)
Posts: 30
Location: Milton Keynes, UK

Thanks: 5 times
Desperate to know if you ahev been killed by your boss, but more importantly did you solve the problem with the 'forbidden' error?
Back to top
WWW
PopisDad  
#5 Posted : Monday, August 2, 2021 8:13:35 PM(UTC)
PopisDad

Rank: Advanced Member

Groups: Registered
Joined: 7/24/2014(UTC)
Posts: 30
Location: Milton Keynes, UK

Thanks: 5 times
I had everything working fine yesterday, and yet running again this morning I am getting the 'forbidden' error...

Any clues as to what may have changed? I have double checked the two main entries for the API and the Google Sheets location.
Back to top
WWW
PopisDad  
#6 Posted : Tuesday, August 3, 2021 3:47:41 AM(UTC)
PopisDad

Rank: Advanced Member

Groups: Registered
Joined: 7/24/2014(UTC)
Posts: 30
Location: Milton Keynes, UK

Thanks: 5 times
UPDATE: All working as expected now. It seems the issue is to keep Google Credential Restrictions to 'None'!
Back to top
WWW
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.128 seconds.