Unconference live session grid

by ConvivioTeam

GitHub Readme.md

Unconference live session grid

Produces an easy-to-browse session listing site based off a Google Spreadsheet. Updates live when the spreadsheet is updated. Made by Convivio

Demo site: https://unconf-session-test.herokuapp.com/

Demo spreadsheet: https://docs.google.com/spreadsheets/d/1uyeVc73aeKG8xgHvUzqR_WYbr3WPhsrk9gj746Mayac/edit?usp=drive_web&ouid=101644837907742352061


Environment settings

// Required: Google Developer Authentication settings 
// Required: The URL of the spreadsheet to pull from
// Option: The number of seconds to pull new session information from the google sheet
// This is set to 5 seconds by default, increase this if you see the app struggling to serve requests in a timely fashion
// The url of the logo image to use in the heading
// The name of the unconference for headings and meta tags
// Optionally set the year to filter the sessions by, defaults to current year.

Setting up your spreadsheet

This tool was originally designed for UKGovcamp and currently follows the structure of their session spreadsheet. We'd recommend cloning that spreadsheet to ensure this works as expected.

If you'd like to deviate from the columns in the spreadsheet and would like support, feel free to open an issue.

Google authentication set up

  1. Go to the Google Developers Console
  2. Select your project or create a new one (and then select it)
  3. Enable the Drive API for your project
  • In the sidebar on the left, expand APIs & auth > APIs
  • Search for "drive"
  • Click on "Drive API"
  • click the blue "Enable API" button
  1. Create a service account for your project
  • In the sidebar on the left, expand APIs & auth > Credentials
  • Click blue "Add credentials" button
  • Select the "Service account" option
  • Select "Furnish a new private key" checkbox
  • Select the "JSON" key type option
  • Click blue "Create" button
  • your JSON key file is generated and downloaded to your machine (it is the only copy!)
  • note your service account's email address (also available in the JSON key file)
  1. Share the doc (or docs) with your service account using the email noted above