Wiresk

Wiresk

Google Sheets – Triggers

Estimated reading time: 5 min

What will start your automation…

Run Once Tab: This tab allows you to schedule a Flow to execute a single time at a specific date and time. This is ideal for one-time operations such as data syncs, cleanups, or initial configuration steps. After execution, the schedule will be automatically cleared unless rescheduled manually.

Run Tab: This tab is used to set up repeating schedules:

  • Repeat feature: This dropdown determines how long the automation will continue repeating based on the selected frequency (Minutely or Hourly). You can choose from:
    • Repeat Forever
      • The automation will continue to run indefinitely at the defined interval (e.g. every 15 minutes).
      • No end condition is specified.
    • Repeat for (x) Times
      • You set a specific number of repetitions.
      • Requires the field Number (x) of Repeat Times to be filled (e.g. 10 times).
    • Repeat Between Start & End Dates
      • The automation will run only within a defined date range.
      • Additional fields will appear to select start and end dates.
      • Useful for limited-time schedules like campaigns or batch jobs.
  • Daily at Multiple Times: Sets the Flow to run several times per day based on a minutely or hourly interval.
  • Daily: This allows a Flow to run x times per day at a specific time.
  • Weekly: This allows you to run a Flow weekly by selecting the days and time.
  • Monthly: This will monitor your Trigger every month on a defined date and hour.
  • Yearly: This will monitor your Trigger on a specific date and hour every year.
  • Specific dates: This will start your Trigger on specific dates and time.

For more details, see Wiresk Scheduler – The Fundamentals.

After you’ve configured your Trigger parameters, select the “Use” button to fetch a live sample of data from the Trigger.

What it does:

  • Extracts real data based on your Trigger setup
  • Validates your parameters by showing if they match existing records
  • Prepares data for field mapping – the sample helps you map your Trigger output to your Method parameters in the Flow. Refer to FIELD MAPPING documentation.

Think of it as a preview step: it makes sure your Trigger is working and gives you real data to work with when setting up the rest of your flow.

SHEETS Google Sheets - Triggers

These Triggers will start your Flow automatically at a specific time or intervals instead of being triggered by events like Webhooks.

Configuration Table:

(*) required field

Name*New Spreadsheet Row
Connection*Select your connection or create one.
TimeoutYou can additionally set the Trigger duration to limit the information processed per execution to optimize performance and resource usage.
Recurrence Rule/scheduler*Set up your recurrence rule.

PARAMETERS

This tab enables you to configure the Trigger.

Drive*:

Select your Drive.

Select a Spreadsheet*:

Choose the Spreadsheet to watch.

Include Previous Data:

Selecting Yes retrieve all existing data. Choosing No shows only data created since the last time the flow was executed.

This tab allows you to preview the data that will be retrieved and included in the output.

In specific Trigger instances, data can only be previewed when it is available for retrieval. If no event occurs from the Trigger, a message “No data available” will be displayed.

preview data button 2025 04 09 Google Sheets - Triggers

Use this button to preview the data based on the “Configure Parameter” tab.

⚠️ Reminder: Click “Use” to validate your Trigger with sample data before saving.

Data Sample input

Configuration Table:

(*) required field

Name*Worksheet Row Added or Modified
Connection*Select your connection or create one.
TimeoutYou can additionally set the Trigger duration to limit the information processed per execution to optimize performance and resource usage.
Recurrence Rule/scheduler*Set up your recurrence rule.

PARAMETERS

This tab enables you to configure the Trigger.

Drive*:

Select your Drive.

Select a Spreadsheet*:

Choose the Spreadsheet to watch.

Worksheet*:

Choose the Worksheet to watch.

Specify Header*:

If the Worksheet has a header, select it row :

  • Second Row
  • Third Row
  • Fourth Row
  • Fifth Row

If not select No Header.

Include Previous Data:

Selecting Yes retrieve all existing data. Choosing No shows only data created since the last time the flow was executed.

This tab allows you to preview the data that will be retrieved and included in the output.

In specific Trigger instances, data can only be previewed when it is available for retrieval. If no event occurs from the Trigger, a message “No data available” will be displayed.

preview data button 2025 04 09 Google Sheets - Triggers

Use this button to preview the data based on the “Configure Parameter” tab.

⚠️ Reminder: Click “Use” to validate your Trigger with sample data before saving.

Data Sample input 
{
    "Header1": "cell value",
    "Header2": "cell value"
}
Expand

Configuration Table:

(*) required field

Name*New Spreadsheet Created
Connection*Select your connection or create one.
TimeoutYou can additionally set the Trigger duration to limit the information processed per execution to optimize performance and resource usage.
Recurrence Rule/scheduler*Set up your recurrence rule.

PARAMETERS

This tab enables you to configure the Trigger.

Drive*:

Select your Drive to monitor.

Include Previous Data:

Selecting Yes retrieve all existing data. Choosing No shows only data created since the last time the flow was executed.

This tab allows you to preview the data that will be retrieved and included in the output.

In specific Trigger instances, data can only be previewed when it is available for retrieval. If no event occurs from the Trigger, a message “No data available” will be displayed.

preview data button 2025 04 09 Google Sheets - Triggers

Use this button to preview the data based on the “Configure Parameter” tab.

⚠️ Reminder: Click “Use” to validate your Trigger with sample data before saving.

Data Sample input 
{
    "id": "1l5rLYNWZi-B0S4PiFxEFn04KCW3kEnEAFkl9Z21Sy6g",
    "name": "spreadsheet name"
}
Expand

Configuration Table:

(*) required field

Name*New Worksheet in Spreadsheet
Connection*Select your connection or create one.
TimeoutYou can additionally set the Trigger duration to limit the information processed per execution to optimize performance and resource usage.
Recurrence Rule/scheduler*Set up your recurrence rule.

PARAMETERS

This tab enables you to configure the Trigger.

Drive*:

Select the Drive to monitor.

Select a Spreadsheet*:

Select the Spreadsheet to monitor.

Include Previous Data:

Selecting Yes retrieve all existing data. Choosing No shows only data created since the last time the flow was executed.

This tab allows you to preview the data that will be retrieved and included in the output.

In specific Trigger instances, data can only be previewed when it is available for retrieval. If no event occurs from the Trigger, a message “No data available” will be displayed.

preview data button 2025 04 09 Google Sheets - Triggers

Use this button to preview the data based on the “Configure Parameter” tab.

⚠️ Reminder: Click “Use” to validate your Trigger with sample data before saving.

Data Sample input 
{
    "title": "Sheet1",
    "sheetId": 0,
    "index": 0
}
Expand


After setting up your Flow, you can choose to:

  • “Run once”, your Flow will run only a single time. You can use this function to test your Flow.
  • “Run Scheduler” will automate your Flows with the recurrence rule you previously defined.

For more details, refer to How to run a Flow tutorial in our Help Center.
 
If you are using a Webhook Trigger, the Flow will initiate automatically when a webhook is received from your connected apps. This means that the Flow is automated without a scheduler and will run until you deactivate the Flow manually. Refer to Webhook documentation in our Help Center.