ActionMicrosoft ExcelUpdated September 2026

What worksheets are in this Excel workbook?

Short answer: You can list excel worksheets in Microsoft Excel by hand from its own interface, but it won’t repeat itself. On TinyCommand, add the Microsoft Excel List Excel Worksheets action to a workflow, map its 1 input from any upstream app, and it runs automatically every time the trigger fires. No code, and a free tier to start.

List Excel Worksheets in Microsoft Excel — start free All 5 Microsoft Excel actions

List Excel Worksheets in Microsoft Excel — start free

Inputs

The fields this action accepts.

Every field can be mapped from an upstream trigger, AI step, table row, or hard-coded literal.

Field	Type	Required	Description
Workbook DriveItem ID drive_item_id	string	Required	ID of the .xlsx file in OneDrive/SharePoint

Sample request

{
  "drive_item_id": "{{trigger.drive_item_id}}"
}

Returns

{
  "value": [
    {
      "id": "{00...}",
      "name": "Sheet1",
      "position": 0
    }
  ]
}

Use these fields in downstream nodes for routing, logging, or error handling.

Triggered by

Apps that pair well as the trigger for List Excel Worksheets.

Any of these apps can fire this action as part of a workflow.

Gmail → Microsoft Excel

1 Gmail triggers

Slack → Microsoft Excel

13 Slack triggers

Google Sheets → Microsoft Excel

2 Google Sheets triggers

HubSpot → Microsoft Excel

18 HubSpot triggers

FAQ

Questions about List Excel Worksheets.

What does the List Excel Worksheets action do in Microsoft Excel?

Returns all worksheets in a workbook with name and ID. Useful for resolving worksheet identifiers at workflow setup.

What inputs does List Excel Worksheets require?

Required: Workbook DriveItem ID. Every input accepts a static value or a variable from any upstream node in your workflow.

Can I use dynamic inputs from earlier workflow nodes?

Yes. Any field on this action can pull values from upstream nodes, whether that's a form response, a trigger payload, an AI output, or a lookup result.

What happens if Microsoft Excel returns an error?

The run history shows the failed step with its input and the error message Microsoft Excel returned, so you can fix the input and run the workflow again. Automatic retries are built into HTTP steps only, where you can also set your own retry count and delay.

Does List Excel Worksheets support batch operations?

Run List Excel Worksheets inside a loop to process each item in an array. TinyCommand does not throttle calls for you, so for large arrays add a Delay step if you need to stay within Microsoft Excel's rate limits.

More actions