Wiresk

Wiresk

Excel – Triggers

Estimated reading time: 2 min
excel logo Background Removed Excel - Triggers

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 configuring your Trigger, you can load sample data into the Example Input panel in Flow Builder. This gives you a preview of what the Trigger returns and prepares the data for mapping.

How to get it:

  • Enter manually: Add your own sample data in the JSON editor, plain JSON string, or form view.
  • Use predefined Trigger samples: Triggers provide ready-made sample data that can be pulled directly into the Example Input panel.
  • Capture Example Input: Enable this option to record real data the next time the Flow runs. The captured sample will automatically appear in the panel.

With Sample Input in place, you can review the field structure and connect Trigger outputs to Method parameters with confidence.

For more details, refer to Example Input – How it Works.

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

Configuration Table:

Name*Get Workbook Range Values
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.

Site ID*

The SharePoint Site ID where the workbook is stored.

Select a Workbook*

Choose the Excel workbook (file) you want to retrieve data from. Wiresk lists available workbooks once a valid Site ID is provided.

Worksheet

Select the worksheet (tab) inside the workbook from which to read data.

Header Row

Define which row contains column headers. Wiresk uses this to label columns in the retrieved dataset.

Example: 1

Row From

The starting row number to include in the range.

Example: 2

Row To

The last row number to include in the range.

Example: 50

Column From

The first column letter to include.

Example: A

Column To

The last column letter to include.

Example: F

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 Excel - Triggers

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

(*) required field

Example Input

Configuration Table:

Name*List Rows in Table
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.

Site ID*

The SharePoint Site ID where the workbook is stored.

Workbook ID*

Choose the Excel workbook (file) you want to retrieve data from. Wiresk lists available workbooks once a valid Site ID is provided.

Table ID*

Choose the table from the Workbook to retrieve the rows.

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 Excel - Triggers

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

(*) required field

Example Input 
[
    "test1",
    "test2",
    "test3",
    "test4"
]
Expand

Once your Flow is configured, you can test or automate it using the Run panel or by managing Triggers from the Flow Management screen.

  • Run Flow: Manually runs the Flow once using sample data. Ideal for testing logic and field mapping. See How to Run a Flow.
  • Run Scheduler: Force-runs the Trigger immediately using live input. This bypasses the recurrence rule and is useful for verifying real data mapping. Learn more in Wiresk Scheduler – The Fundamentals.

From the Trigger management panel (clock icon), you can:

  • Activate or deactivate Triggers
  • Force-run the scheduler
  • Copy Routing Keys (for HTTP Triggers)

If your Flow uses a Webhook Trigger, it runs automatically on each incoming webhook—no scheduler required. It remains active until you manually deactivate it.

Important 01 Excel - Triggers

Going further Copy Link

See related Microsoft apps.

Explore the full Wiresk User Guide to learn more.

Looking for an integration that’s not yet available? Submit a request to our team, we’ll do our best to support your needs.