Read and write Excel workbooks in OneDrive or a selected SharePoint document library through a named Microsoft account.
Explore 36 workflow actions for Microsoft Excel, including account permissions and operation limits.
20 read actions16 write actions
WORKFLOW ACTIONS
What you can configure.
Choose an action in the workflow builder, connect an account, and map its inputs. These actions are available in the catalog; your account access and a successful test determine whether they work for your setup.
Add SharePoint workbook worksheet
Write
Create a named worksheet in a SharePoint workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Add worksheet
Write
Create a uniquely named worksheet in an accessible workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Workbook actions use files in the connected account's OneDrive. SharePoint and shared-drive workbook selection are not included.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Append or update SharePoint worksheet row
Write
Find one worksheet row by an exact key cell, update it, or append a new row when absent.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Compares the key cell exactly, with type and case preserved. The submitted row must contain the key column, and duplicate matches refuse the write.
Scans at most 10,000 rows and 50 columns. The first data row defaults to 2, leaving a heading row untouched. Another editor can move, insert, or change rows between the scan and write.
An append uses two Graph writes and may leave a blank row if the cell update fails. Unconfirmed writes leave the V2 run uncertain and require inspection before retrying.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Append SharePoint workbook table rows
Write
Append one to one hundred rows to a table in a SharePoint workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
The number of cells in each row must match the table column count.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Append SharePoint worksheet row
Write
Insert one row after the populated cells in a SharePoint workbook worksheet and write its values.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Writes one row of at most 50 cells, below Excel row 1,048,576. The worksheet used range must fit within 50 columns. Another editor can change the sheet between the read and insert.
The insert and cell update are separate Graph requests. If either write is dispatched without a confirmed final receipt, the run is uncertain and must be checked before retrying.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Append table rows
Write
Add one to one hundred rows at the end of an Excel table.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
The number of cells in each row must match the table's column count. Graph rejects a mismatch.
Workbook actions use files in the connected account's OneDrive. SharePoint and shared-drive workbook selection are not included.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Browse OneDrive folder
Read
List one page of files and folders within a selected OneDrive folder.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Returns one page. Pass the $skipToken from the returned Graph next link to continue on this same folder.
Browse SharePoint library folder
Read
List one page of files and folders inside a SharePoint document-library folder.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Returns one page. Pass the $skipToken from the returned Graph next link to continue on this same drive and folder.
Clear SharePoint worksheet cells
Write
Clear contents of a selected rectangular worksheet range in a SharePoint workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Clears cell contents while retaining formatting. Select the intended range before running this action.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Convert SharePoint workbook table to range
Write
Remove table behavior while preserving cell data in a SharePoint workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
The table stops being a table, while Microsoft Graph preserves the cell data.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Create SharePoint workbook table
Write
Create a table from a bounded worksheet range in a SharePoint workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
The address must include a worksheet name and a rectangular A1 cell range. Graph rejects ranges that overlap an existing table.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Delete SharePoint workbook table
Write
Delete one table from a SharePoint workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Microsoft Graph deletes the table. Confirm the intended table before running this action.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Delete SharePoint workbook worksheet
Write
Delete one worksheet from a SharePoint workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Deleting a worksheet removes its cells and tables. The workbook must retain a worksheet.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Discover OneDrive workbooks
Read
Scan bounded pages of the connected OneDrive and its folders for Excel workbooks.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Scans at most 20 Graph pages and returns at most 100 .xlsx files from the connected account's own drive. A result with complete false means more folders or pages remain.
Shared remote items are excluded because their IDs cannot be passed to workbook actions on this drive.
Discover SharePoint workbooks
Read
Scan bounded pages and folders of a selected SharePoint document library for Excel workbooks.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Scans at most 20 Graph pages and returns at most 100 .xlsx files in the selected document library. A result with complete false means more folders or pages remain.
Remote items are excluded because their IDs may belong to another drive.
Find SharePoint table row by column value
Read
Scan bounded pages of a SharePoint workbook table for the first matching cell.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Compares the displayed string form of the cell exactly and case-sensitively.
Scans at most 100 rows per page and 20 pages. A result with complete false means later rows were not searched.
Find table row by column value
Read
Scan bounded pages of one Excel table for the first cell matching a value.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Compares the displayed string form of the cell with the entered value, exactly and case-sensitively.
Scans at most 100 rows per page and 20 pages. A result with complete false means later rows were not searched.
List OneDrive files
Read
List one page of root OneDrive files to find workbook IDs.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Lists the root folder only. Pass the $skipToken from the returned Graph next link to continue.
OneDrive may include non-workbook files; choose an .xlsx workbook ID.
List SharePoint library files
Read
Find Excel workbooks in one SharePoint document library root.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Lists one page at the root of a document library. Pass the $skipToken from the returned Graph next link to continue on this same drive.
Use folder browsing or library search for nested workbooks.
Select an .xlsx file in a library the connected user may access.
List SharePoint table columns
Read
Read column identifiers and names from one SharePoint workbook table.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Very wide tables may exceed NodeHub's bounded provider response.
List SharePoint table rows
Read
Read one bounded page of rows from a SharePoint workbook table.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Reads one page of at most 100 rows.
List SharePoint workbook tables
Read
List one bounded page of tables in a SharePoint workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Lists one bounded page of tables in the selected workbook.
List SharePoint workbook worksheets
Read
List worksheets in a SharePoint document library workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Requires an .xlsx workbook in a SharePoint document library accessible to the connected work or school account.
List table columns
Read
Read column identifiers and names from one Excel table.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Graph returns columns in a single response. Very wide tables may exceed NodeHub's response limit.
List table rows
Read
Read the rows and cell values in one Excel table.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Reads one bounded page. A very large row may exceed NodeHub's response limit.
List tables
Read
List Excel tables in a workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Lists one bounded page of tables in the selected workbook.
List worksheets
Read
List worksheets in an accessible Excel workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
The workbook must be an Office Open XML file accessible to the connected user.
Move SharePoint workbook to recycle bin
Write
Delete a workbook file in a SharePoint document library, moving it to the recycle bin.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Microsoft Graph moves the selected drive item to the recycle bin. The item ID must identify the intended workbook.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Read SharePoint worksheet range
Read
Read the used range in one SharePoint workbook worksheet.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
A large used range may exceed NodeHub's bounded provider response.
Read used range
Read
Read the populated cells of one worksheet.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Microsoft documents usedRange for work or school accounts, not personal Microsoft accounts. A very large used range may exceed NodeHub's response limit.
Rename SharePoint workbook worksheet
Write
Rename one worksheet in a SharePoint workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Search OneDrive files
Read
Search the connected OneDrive for workbook files or folders by name or content.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Search can return shared items with a remoteItem facet. A remote workbook ID may not work with actions that address this account's own drive.
Returns one page of results. Pass the $skipToken from its Graph next link to continue the same search.
Search SharePoint library files
Read
Search a selected SharePoint document library for workbook files or folders.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
May return non-workbook files. Returns one page of search results. Pass the $skipToken from its Graph next link to continue the same search.
Update SharePoint workbook table row
Write
Replace the cell values of a selected row in a SharePoint workbook table.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Use a row index returned by a recent table-row read. Other editors can change row positions before this write.
The number of cells must match the table column count.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Update SharePoint worksheet cells
Write
Set values in a selected rectangular worksheet range in a SharePoint workbook.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
The values matrix must match the height and width of the selected range; Graph rejects mismatches. Null cells are left unchanged.
The workbook must be an .xlsx file in a SharePoint document library accessible to the connected user.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Update table row
Write
Replace the cell values of a selected row in a OneDrive workbook table.
Permissions and limits
Account permissions
Files.ReadWrite
Operation limits
Use a row index returned by a recent table-row read. Other editors can change row positions before this write.
The number of cells must match the table column count.
Workbook actions use files in the connected account's OneDrive. SharePoint and shared-drive workbook selection are not included.
A write is sent once. A lost provider response leaves the run uncertain, and NodeHub does not retry it automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
SETUP
Start with a controlled test.
01Connect the intended account
Use the account and permissions required for your process. Review the connection check before configuring a workflow action.
02Review inputs and access
Select a listed operation and map its required inputs. Use test records and add a human approval before writes that need review.
03Confirm the result
Inspect step outputs and confirm the result in Microsoft Excel. A saved workflow is not a completed provider action.
Data & Docs ยท CONNECTION
