Ontime v2
Link to new docs
  • ontime
  • Feature list
  • Roadmap
  • Contributing
  • Main Concepts
    • Interface
      • Settings Bar
      • Rundown
      • Timer Control
      • Display Messages
      • Info
      • Quick start
      • Upload
      • Integration Settings
      • Application Settings
        • App Settings
        • Event Data
        • Editor Settings
        • Cuesheet settings
        • Views
        • URL Aliases
      • About modal
  • Views
    • Network views (Intro)
    • Stage Timer
    • Clock
    • Minimal Timer
    • Backstage Info
    • Public Info
    • Lower Thirds
    • Studio Clock
    • Countdown
    • Cuesheet
  • Control and feedback
    • Ontime APIs
      • HTTP API
    • Integrations
    • Runtime Data
  • Features
    • Google Sheet
    • Smart Time Entry
    • The delay workflow
    • Roll
    • Import events from Excel
    • URL Aliases
    • Edit Anywhere
    • Headless Mode (Docker)
    • Note: Lower thirds in OBS
    • User fields
    • Custom Styling
    • Make your own viewer
    • Count to anything
    • External data
  • ❤️Additional Notes
    • Control Ontime from vMix
    • Sync: Poll ontime status
    • Use in Raspberry Pi
    • Companion module
Powered by GitBook
On this page
  • Step 1 - Upload client secret
  • Step 2 - Authenticate
  • Step 3 - Add Document ID
  • Step 4 - Select the worksheet
  • Step 5 - Upload / Download at will
  1. Features

Google Sheet

Sync your rundown to a Google Sheet

PreviousRuntime DataNextSmart Time Entry

Last updated 1 year ago

Ontime supports the syncing of the rundown to a Google Sheet

You need to provide Ontime with the necessary permissions. From there, we can read and write to the Google Sheet spreadsheet.

This is ideal for collaboration or extensive data manipulation.

Spreadsheet template

By duplicating our template, you can get started quicker by using spreadsheets in Ontime.

Step 1 - Upload client secret

Create a token in Google Cloud Console

  • On the Google Cloud Console, Create a Project, and in the APIs and services > Enabled APIs and servers, make sure you enable the Google Sheets API.

  • Select Desktop App as the Application Type, and give the app a name.

  • Download the file with the Client ID and upload it to the Ontime interface.

Step 2 - Authenticate

Once we have the Client ID token Ontime can request Google permission to access the data in the spreadsheet.

For your security, the authentication is kept in memory and wiped when Ontime quits. This means that you would need to re-authenticate every time you start Ontime.

Step 3 - Add Document ID

You will need to provide Ontime with the ID of the document to import.

The Document ID is available in the URL after the d, such as https://docs.google.com/spreadsheets/d/<Document ID>/edit#gid=0

Click the Connect button to establish connection and get the worksheet options

Step 4 - Select the worksheet

Once connected, the dropdown will populate with a list of worksheets available in the document.

Select the one with your rundown.

Step 5 - Upload / Download at will

Now Ontime is connected to your Google Sheet document.

You can get the data from your Google Sheet into Ontime by pressing the Download button at any time.

You can also push your local data from Ontime to the Google Sheet by clicking the Upload button.

See the

You will need to create a token in your Google Account and upload it to Ontime

This guide is copied from the Google documentation at

Go to , click Create Credentials, and select OAuth client ID.

template here
https://console.cloud.google.com
https://console.cloud.google.com
https://console.cloud.google.com/apis/credentials
Google sheet modal is available in the left app menu