logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Google Sheet Keeps getting 403 error
Options
Go to last post Go to first unread
Previous Topic Next Topic
gujingc  
#1 Posted : Monday, June 14, 2021 3:36:43 PM(UTC)
gujingc

Rank: Member

Groups: Registered
Joined: 2/4/2021(UTC)
Posts: 23
Man
United States
Location: Porter Ranch
I followed the steps to enter the Google sheet link and my API key. I keep getting the 403 forbidden error:

error screenshot

Please advise.

Jing
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
TDVideoEngineering  
#2 Posted : Tuesday, June 15, 2021 5:36:56 AM(UTC)
TDVideoEngineering

Rank: Newbie

Groups: Registered
Joined: 6/15/2021(UTC)
Posts: 3
Man
Germany

Thanks: 2 times
Hi,

I recently had such a problem. For me the reason was that I used the character '#' for the name of a tab. After removing it the spreadsheet worked again.

BR,
Tobi
Back to top
WWW
gujingc  
#3 Posted : Tuesday, June 15, 2021 6:43:24 AM(UTC)
gujingc

Rank: Member

Groups: Registered
Joined: 2/4/2021(UTC)
Posts: 23
Man
United States
Location: Porter Ranch
Tobi,

I tried the following:
1) I used "#"
2) I leave it blank
3) the google sheet name

I still got exactly the same error.

And I tried 5 APIs.
Back to top
gujingc  
#4 Posted : Sunday, June 27, 2021 4:21:21 AM(UTC)
gujingc

Rank: Member

Groups: Registered
Joined: 2/4/2021(UTC)
Posts: 23
Man
United States
Location: Porter Ranch
I found the solution.

When we create API keys in Google, we add HTTP reference restriction.

I do not know what right http to use for vmix, so I created one without HTTP restriction and used it for Google Sheet.

It all in a sudden works.
Back to top
gujingc  
#5 Posted : Sunday, June 27, 2021 4:27:47 AM(UTC)
gujingc

Rank: Member

Groups: Registered
Joined: 2/4/2021(UTC)
Posts: 23
Man
United States
Location: Porter Ranch
And when applying http reference restriction, use this vmix.*


It works for me.
Back to top
Users browsing this topic
Guest (2)
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.083 seconds.