logo

Live Production Software Forums


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

Notification

Icon
Error

Options
Go to last post Go to first unread
ElBurrito  
#1 Posted : Thursday, September 16, 2021 12:11:03 AM(UTC)
ElBurrito

Rank: Member

Groups: Registered
Joined: 11/13/2017(UTC)
Posts: 27

Thanks: 3 times
I'm following these instructions to add Google Sheets as a source for a data source: https://www.vmix.com/kno...s-with-vmix-data-sources

I do that, and when I try to add it in vMix I get a 400 bad request error so it won't connect to Google Sheets. I've tried doing this over starting from scratch and got the same error. Can anyone help with what I'm doing wrong?
cchhita  
#2 Posted : Friday, September 17, 2021 9:49:16 AM(UTC)
cchhita

Rank: Member

Groups: Registered
Joined: 4/14/2020(UTC)
Posts: 16
United States
Location: Dallas, TX

Thanks: 5 times
I have been using Google Sheets for a very long time, and this has just started happening to me yesterday. I am not sure what the issue is, but changing to a different Google Sheet and API key renders the same result.
justpushplay  
#3 Posted : Friday, January 28, 2022 5:24:28 PM(UTC)
justpushplay

Rank: Newbie

Groups: Registered
Joined: 8/15/2018(UTC)
Posts: 7
Location: Finland

Was thanked: 1 time(s) in 1 post(s)
Is Google Sheets integration broken because I keep getting the same error message (400 bad request) no matter what I do? I have followed all the setup instructions and created a few new API keys but I can't seem to get it to work.
MattGrover  
#4 Posted : Friday, March 11, 2022 7:12:37 AM(UTC)
MattGrover

Rank: Member

Groups: Registered
Joined: 7/20/2020(UTC)
Posts: 14
Man
United Kingdom
Location: Henfield

Just having this issue as well...
MattGrover  
#5 Posted : Thursday, March 17, 2022 5:35:59 PM(UTC)
MattGrover

Rank: Member

Groups: Registered
Joined: 7/20/2020(UTC)
Posts: 14
Man
United Kingdom
Location: Henfield

I've just been trying to sort mine again as another one I made worked.

It could be to do with the Table name.

The default "Sheet1" "Sheet2" seems to work fine, when I rename them to "day1" "day2" I get the (400) error.
(now I've got a (429) Too Many Requests, but that's clearly something else)
Peter1000  
#6 Posted : Thursday, March 17, 2022 5:55:36 PM(UTC)
Peter1000

Rank: Advanced Member

Groups: Registered
Joined: 1/25/2019(UTC)
Posts: 284
Switzerland

Thanks: 16 times
Was thanked: 73 time(s) in 54 post(s)
unpaid Google API allows requests only every 8-9 seconds (try) you have to put that value (8000) in the lower right field of your datasorce settings
Users browsing this topic
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.