Import from Google Sheets
You can synchronise Ontime to a Google Sheet.
This is ideal for collaboration or extensive data manipulation.
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.
Create project
Section titled “Create project”On the front page select the newly created project
Enable the Sheet API
Section titled “Enable the Sheet API”Open the sidebar and click “APIs and Services”
Click “Enable APIs and Services”
… and search for “Sheets”
Setup Data Access
Section titled “Setup Data Access”Add the necessary scopes
Go to “Data Access” and click “Add or remove scopes” This could depend on your organization is set up but it should make sense by reading through the options
Find the correct scopes by filtering for “sheets”
Enable “…/auth/spreadsheets” and click “Update”
Click save and continue
For “Test users” add the email(s) the will be using this.
Save and go back to the dashboardAdd test user
Go to “Audience” and click “Add users” Here add the email(s) the will be using this.
Remember to save
Create credentials
Section titled “Create credentials”Go to “Clients”
Click “Create client”
For Application type select “TVs and Limited input device”, give it a name and click “create”
Download the result, we are now done with the Google console
Connect Ontime
Section titled “Connect Ontime”Go to the sheet sync settings
Upload the file we have downloaded from Google console
Get the sheet ID, paste it in Ontime and click connect
Copy the code and click authenticate and follow the instructions from Google
