Google Sheets Api to Youtube Api/Oauth - Update Livebroadcast Title & Description - Based on Date/Time

Job ID: 31510622

Budget: £10 – £20 GBP

I am looking for a YouTube Livestream/Livebroadcast Title/Description to be updated from a googlesheet. The time and date of the event will be stored in one of the columns on the sheet ie 09/15/2021 10PM.

So at anytime before the Livestream/Livebroadcast commences . I need the title and descriptions to be updated already.

This script will not start and stop the live streaming! I just need the details of the live broadcast to be updated from a google spreadsheet.

I would like to have this as a cron and have it run no more than about twice a day. The next event on the spreadsheet then updates the broadcast. I would like the spreadsheet to have many different titles descriptions for many future dates so I need the relevant information to be used. So lets says its the 30/09/2021 (September 30th) and its 9pm. I need the next event which is at 10pm (according to the spreadsheet) updated on the Youtube channel. I think this is handled by the Google OAuth 2.0 (details of the channel itself) instead of the Youtube Api (I think this is for generic searching etc). The automatic streaming is handled by another service and is not part of this project.

Google has already provided plenty of code examples but I am not sure if its this one

https://developers.google.com/youtube/v3/live/docs/liveBroadcasts/update

or this one

https://developers.google.com/youtube/v3/live/docs/liveStreams/update

Can you give me quote and ETA. Please only offer a quote if you have experience with the Googlesheets Api/Youtube Api and Google OAuth 2.0
Related categories: PHP JavaScript Python Google App Engine YouTube