SetclockSetclockHelp

Follow a Google Sheet

Keep a stage's running order in step with a Google Sheet. Setclock checks the sheet about once a minute, even when nobody has Setclock open, and never changes a set that's on stage or already played.

Web appOwners, admins and stage managersUpdated Nov 22, 20263 min read
On this page

Before you start

  • In Google Sheets, share the sheet: Share › General access › Anyone with the link (Viewer), or File › Share › Publish to web.
  • Open the tab with the running order and copy the link from the address bar, so Setclock follows that tab.
  • The sheet has an artist column and a start, end or length column. Stage and Day columns let one sheet feed the whole show.

Start following

  1. Open the show's Lineup, pick the stage, and press Import.

  2. Choose Spreadsheet, paste the Google Sheets link and press Get.

  3. Check the column matches and the rows, as in Import a running order.

  4. Turn on Keep following this sheet.

  5. Press Import and follow the sheet. If the stage already has a running order, press Replace upcoming items and follow, then press again. A sheet with Stage and Day columns follows every stage and day it lists.

The stage tab now says Follows a Google Sheet, and a bar above the running order shows when the sheet was checked and last changed.

While it follows

  • Edit the sheet, not Setclock. Upcoming sets you change in Lineup go back to match the sheet at the next check.
  • Decks, contacts, tech and notes you add in Setclock are kept.
  • Sets on stage or already played never change.
  • Each update is listed in the show's Activity, with what was added, changed or removed.
  • Press Check now to check straight away, Open sheet to open it in Google Sheets, or Stop following, then press again. The running order stays as it is when you stop.

When updates pause

A row someone is halfway through typing, or a sheet cleared by mistake, never wipes the running order. Updates pause and the bar shows the reason, starting Waiting for the sheet. Fix the sheet and the next check picks it up. Deleting the stage stops following its sheet. Archived shows aren't updated.

It says "Setclock can't open this sheet."

The sheet isn't shared. In Google Sheets, choose Share › General access › Anyone with the link (Viewer), or File › Share › Publish to web, then try again.

It says "Paste the link of a Google Sheet (docs.google.com/spreadsheets/…)."

The link isn't a Google Sheets link. Copy it from the sheet's address bar.

It says "That sheet is too big to import."

The tab is over the size limit. Copy the running order into its own tab and link that tab.

The bar says "Waiting for the sheet: The sheet has no rows for this stage. Nothing was changed."

The Stage or Day values in the sheet no longer match this stage, or the rows were deleted. Put them back, or stop following and import again.

The bar says "The stage this sheet fed was removed."

Stop following it, or import the sheet again on another stage.

It says "Imported, but couldn't start following the sheet"

The running order was imported once. Check the connection and import again with Keep following this sheet on.

Check now says "Couldn't check the sheet. Check this device's internet connection."

This device is offline. Setclock keeps checking the sheet on its own every minute anyway.

Did this answer your question?