nvbf/youtube-google-sheet-event-creator
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
Create youtube events based on a configurable google sheet
2 commits 1 branch 0 tags 41 KiB
  • JavaScript 100%
Find a file
Exact
Sindre Øye Svendby c0ea373c93 Sheets intgration is working, the api still needs to be created
2018-10-08 00:26:51 +02:00
.gitignore Initial commit 2018-10-06 15:13:56 +02:00
config.js Sheets intgration is working, the api still needs to be created 2018-10-08 00:26:51 +02:00
package-lock.json Sheets intgration is working, the api still needs to be created 2018-10-08 00:26:51 +02:00
package.json Sheets intgration is working, the api still needs to be created 2018-10-08 00:26:51 +02:00
README.md Sheets intgration is working, the api still needs to be created 2018-10-08 00:26:51 +02:00
server.js Initial commit 2018-10-06 15:13:56 +02:00
sheets.js Sheets intgration is working, the api still needs to be created 2018-10-08 00:26:51 +02:00
start.sh.sample Initial commit 2018-10-06 15:13:56 +02:00

README.md

Youtube Google sheet Event Creator

Basic idea behind this project

Lower the entrybar for pepole to create events on youtube. If you need to create a lot of events, there can be quite a daunting task to crate this for hand. And requirements changes all the time for most ppl, so by enabling smart mind, that are not programmers to controll the creation of events based on a google sheet can be very powerfull.

Description

Based on a google sheet lets you to create, start and stop a youtube event!

Requirements

Enable Goole API and get API Key

  1. Create a Project to host your credentials in GCP
  2. Enable YouTube Live Streaming API (more info)
  3. Enable Google Sheets Api (more info)
  4. On the Credential page choose create credentials and then choose api key, store the key.

Example

[https://docs.google.com/spreadsheets/d/1rQ6JbcSRFFD0pvGixlR-v3qMUG7_yqYZYqwloiJtZsI/edit?usp=sharing](Example Sheet)

# Env var - Google Sheet (GS)
GS_CLIENT_ID="" \
GS_PROJECT_ID="" \
GS_CLIENT_SECRET="" \
GS_ACCESS_TOKEN="" \
GS_REFRESH_TOKEN="" \
GS_EXPIRE_DATE="" \
GS_CHEK_INTERVAL_SEK="60" \
GS_START_EVENT_TEXT="IN_PROGRESS" \
GS_STOP_EVENT_TEXT="FINISHED" \
GS_ROW_START="2" \
GS_START_TIME_COLUMN="A" \
GS_END_TIME_COLUMN="B" \
GS_TITTEL_COLUMN="C" \
GS_DESCRIPTION_COLUMN="D" \
GS_CATEGORY_COLUMN="E" \
GS_TAGS_COLUMN="F" \
GS_STARTSTOP_EVENT_COLUMN="G" \
YOUTUBE_STREAM_KEY="" \
npm run start

Does this work?

This is based on a readme driven development, so this is created before I have done anything. So right now, nothing.