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
advisiontv  
#1 Posted : Wednesday, April 29, 2020 10:55:08 PM(UTC)
advisiontv

Rank: Advanced Member

Groups: Registered
Joined: 4/3/2020(UTC)
Posts: 38
United Kingdom
Location: Canterbury

Thanks: 4 times
Was thanked: 4 time(s) in 4 post(s)
Im having trouble experimenting with an excel spreadsheet for the first time set up by a remote colleague.

He's shared a spreadsheet with me.
I've copied the link into data sources but realised it needs an API and credentials enabling etc.

Now - do I generate this or him? We've tried both ways but says "remote server returned an error 403 Forbidden)

Should this all be done before the spreadsheet is shared - or doesn't it matter.

Once the API key is in, will it be the same API key for all spreadsheets in the future?
Vince Beck  
#2 Posted : Thursday, April 30, 2020 8:27:23 AM(UTC)
Vince Beck

Rank: Advanced Member

Groups: Registered
Joined: 7/28/2019(UTC)
Posts: 351
United States
Location: Santa Rosa

Thanks: 1 times
Was thanked: 53 time(s) in 51 post(s)
When sharing, make sure you choose more and "Anyone with Link", otherwise you'll get the forbiden error.

If you haven't created the API: https://developers.googl...sheets/api/quickstart/js

And yes, you use the same API for all future sheets from that account.
Users browsing this topic
Guest
Similar Topics
Google Sheets "Too Many Requests" - Ever fixed?? (General Discussion)
by BoxMan_Actual 8/28/2024 5:58:05 AM(UTC)
Vmix to Google sheets (General Discussion)
by Ben777 6/18/2024 8:16:22 AM(UTC)
Google Sheets/Excel - list all in column (General Discussion)
by fcvideo 5/7/2024 1:25:51 AM(UTC)
Vmix + Companion + Stream Deck + Google Sheets (General Discussion)
by ab800 2/22/2024 7:07:28 AM(UTC)
Google Sheets Triggers (General Discussion)
by Ruben Blammo 9/3/2023 7:00:43 PM(UTC)
How to Change Font Size in Data Source for Google Sheets (General Discussion)
by mgrayeb 2/4/2023 3:55:20 AM(UTC)
How to dynamically select the next X rows of data from Google Sheets based on selected (General Discussion)
by sautez 1/24/2023 6:09:40 PM(UTC)
Google Sheets API Errors (General Discussion)
by UR_Sage 9/25/2022 2:51:14 AM(UTC)
Change source file location (video) depending on datasource (google sheet) (General Discussion)
by 33Fraise33 8/14/2022 8:18:39 PM(UTC)
Ticker with Google Sheet data source only displaying one column (General Discussion)
by Tone13 4/15/2022 10:46:18 AM(UTC)
COULD THE COMMAND Http Web API BE SENT WITHIN GOOGLE SHEET? (3rd Party Software and Development)
by Papo 10/7/2021 11:27:51 PM(UTC)
Google Sheets data source 400 bad request error (General Discussion)
by ElBurrito 9/16/2021 12:11:03 AM(UTC)
Adding Google Sheets to vMix as Data Source (General Discussion)
by Trilback 9/11/2021 9:32:47 PM(UTC)
Google Sheet Keeps getting 403 error (General Discussion)
by gujingc 6/14/2021 3:36:43 PM(UTC)
Data Source Short Cut Google Sheets (General Discussion)
by davidsxs 3/15/2021 8:59:42 PM(UTC)
google sheets data in UTC (General Discussion)
by kily2010 2/4/2021 3:01:38 AM(UTC)
Calling API from Google Sheets (3rd Party Software and Development)
by Monday Production 1/31/2021 9:56:14 AM(UTC)
Google Sheets (General Discussion)
by gefiltafish 1/29/2021 9:46:35 PM(UTC)
Populate Streaming Settings using Google Sheets Data Source (Feature Requests)
by RSR22 1/13/2021 7:31:31 AM(UTC)
The perfect Google Sheet for your data source - Enjoy! (General Discussion)
by Vince Beck 9/4/2020 3:13:16 PM(UTC)
Help me connect the google sheet (General Discussion)
by Rogeramosh 8/16/2020 8:34:48 PM(UTC)
Data Source Google Sheet ID problem (General Discussion)
by gzifcak 7/11/2020 7:44:09 AM(UTC)
Updating Titles from Google Sheets (General Discussion)
by advisiontv 5/1/2020 7:40:46 PM(UTC)
Using multiple google sheets for two different overlays with shortcuts (General Discussion)
by Bamboo 4/17/2020 4:02:43 PM(UTC)
Google Sheets in Data Sources - Running Costs? (General Discussion)
by Popis Dad 11/12/2019 8:40:14 AM(UTC)
Basic Data Sources/Google Sheets question ... (General Discussion)
by Popis Dad 10/13/2019 11:37:32 PM(UTC)
Google Sheets Error Message (General Discussion)
by topherharris 8/21/2019 9:04:04 AM(UTC)
Shortcuts for Data Sources Google Sheets (General Discussion)
by vmixer 4/1/2019 10:34:16 AM(UTC)
Data Source Google Sheets ERROR (General Discussion)
by curtismacd31 1/26/2019 8:07:03 AM(UTC)
Shortcuts Datanextrow Google Sheets (General Discussion)
by kjones9999 10/28/2017 4:23:30 PM(UTC)
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.