Skip to content

Import from Google Sheets

You can synchronise Ontime to a Google Sheet.
This is ideal for collaboration or extensive data manipulation.

Spreadsheet template Follow here to see the Google Sheet from the screenshot To enable this feature, you will to need provide Ontime with the necessary permissions.
From there, we can read and write to the Google Sheet spreadsheet.

  1. Create project

    Go to https://console.cloud.google.com/ and create a new project step-1.1 step-1.2 step-1.3

    On the front page select the newly created project step-1.1 step-1.4

  2. Enable the Sheet API

    Click enable APIs and Services step-2.1

    … and search for Sheets step-2.2 step-2.3 step-2.4

  3. Back on the APIs and Services to set up a OAuth consent screen step-3.1

    Add necessary scopes The first step depends very much on how your organization is set up but it should make sense by reading through the options If you are unsure select external and only fill out the required fields

    When thats done click “ADD OR REMOVE SCOPES”

    step-3.3

    Filter for sheets, add “/auth/spreadsheets” and click update step-3.4 step-3.5

    Click save and continue For “Test users” add the email(s) the will be using this.
    Save and go back to the dashboard

  4. Create credentials

    Go to Credentials step-4.1

    Click Create Credentials and select OAuth client ID step-4.2 step-4.3

    For Application type select TVs and Limited input device, give it a name and click create step-4.4

    Download the result, we are now done with the Google console step-4.5

  5. Connect Ontime

    Go to the sheet sync settings step-5.1 step-5.2 step-5.3

    Upload the file we have downloaded from Google console step-5.4

    Get the sheet ID, paste it in Ontime and click connect step-5.5 step-5.6

    Copy the code and click authenticate and follow the instructions from Google step-5.7