Get Hackbot to take video submissions from teams and add to the Google sheet used for judging

[jonathanrelf]

When collating a list of team video submissions this was manually done by reviewing Twitter, looking for #Hack24 and then copy/pasting YouTube / Vimeo URLs into a Google Sheet. Due to some teams incorrectly formatting their tweets additional delay and confusion was caused when attempting to gather the submissions especially against a 'deadline'.

I understand that getting teams to tweet is a good way to engage the wider community and spread the word so the exact solution to this needs to involve the hack stakeholders views ( @andrewseward ;) )

Potential solutions:

• Give Hackbot a new command that teams can issue that takes the challenges entered (if not already captured by Hackbot earlier) & a video URL. This data would be inserted into a Google Sheet for the Judging activity to use. Confirmation from Hackbot of a valid submission would help reassure teams that they had done the correct thing.
  • A tweet could be still required to be manually sent by teams as part of the submission rules.
  • A tweet could be sent from @hacktwentyfour containing the details. Submissions would have to be less than 140 characters including URL (URLs with media links don't count towards character count since 2016)
• Get Hackbot to listen to Twitter for the #Hack24 hashtag and parse submissions into a Google Sheet for the Judging activity to use. It could then confirm the receipt of the video submission by posting a message into the appropriate Slack channel mentioning the team name / participants so they know the submission has been received.