Skip to main content

How to set up your workflow to run automatically

Learn what are the triggers and how to use it to keep your spreadsheets updated even when you are offline

Written by Jonatan Gomes

Add a trigger to choose when your workflow runs and which automations it runs. You can run it on a schedule or in response to an event, such as a form submission or a file change.

Before you start

You need Manager or Owner access to change triggers. Only the workflow owner can turn off an active trigger or change an "On workflow run" trigger. Collaborators can view the settings but can't change them.

All options except "Based on a schedule" are smart triggers and require a plan that includes them. Some plans also limit how many triggers you can have active at once.

Set up a trigger

  1. Open your workflow in the Sheetgo web app. Select the Triggers icon in the workflow sidebar, or select "Triggers" at the top of the Automations panel, next to "Run all".

  2. Open the trigger you want to change, or select the "+" button ("New trigger") to add one. If the workflow has only one trigger, its settings open directly.

  3. Turn on the switch at the top ("Auto-Run" or "Run automatically") so you can edit the fields.

  4. Under NAME, keep the default name or enter a name that helps you identify the trigger. You can rename it later.

  5. Under AUTOMATIONS, choose the automations to run.

  6. Under TRIGGER OPTIONS, choose how to start the run. New triggers default to "Based on a schedule". Use the articles below for each option's setup details.

  7. Complete the fields for your chosen option and review the "Consumption" estimate for automation credits.

  8. Select "Save changes". This button stays disabled until the trigger is complete.

You can also open the same settings from your workspace: select the trigger summary on the workflow's card, such as "Weekdays at 10AM" or "Manual trigger". The switch reads "Auto-Run" or "Run automatically", depending on where you open it.

The Triggers panel with Auto-Run on and a schedule that runs every hour between 6:00 AM and 6:00 PM from Monday to Friday

Choose a trigger option

TRIGGER OPTIONS

When it runs

Detailed setup article

Based on a schedule

At the frequency you set, or once on a chosen date.

On form submission

When a chosen form, or any form in the workflow, receives a response.

On workflow run

When another workflow you own finishes running.

On webhook event

When a webhook source in the workflow receives a request from an external system.

On file or folder change (PREVIEW)

When a Google Drive file or folder you choose changes.

Use several triggers

A workflow can have up to 10 triggers, in any mix of types. For setup and management details, see Use more than one trigger in a workflow.

Pause automatic runs

The workflow owner can turn off an active trigger. When the switch is off, you can't edit the fields, and a trigger saved with the switch off remains dormant.

For a workflow with several triggers, each row in the Triggers panel has its own switch. A trigger that is off shows "Paused".

Did this answer your question?