I’m interested in setting up a video ingestion procedure using google sheets.
My ideal workflow looks like this: a google sheet is prepared with 1 row per video, and a column for each metadata field. Videos are hosted on gdrive (or box?) and a link to them is on the sheet.
Using google app script, I highlight one or more rows, and then run an “ingest” command (or an “update video source file” command) from the Custom Menu. The script would send each file to brightcove with its accompanying metadata, and then update the google sheet with the new brightcove ID.
But I have a feeling I can’t be the first one to think of this - has anybody else created a resource like this? What kind of upload automations have you developed?