Using Excel in Agents

After you connect Microsoft SharePoint, the following nodes become available in Profound Agents under Microsoft Suite > Microsoft Excel. Use them to read values and rows from a workbook, write cells and rows back, and create new workbooks or worksheets. Every node runs with the permissions of the account you select under Microsoft Account. A node reaches only the files that the connected account can open.

New to Agents? See Getting started with Agents in the Profound Help Center.

Shared settings

Every node that works on an existing workbook takes a Workbook and an optional Worksheet name. Leave the worksheet empty to use the first visible worksheet. Create Workbook creates a new file instead, so it has no Workbook field.

Choosing a workbook

In the node settings, select your Microsoft Account, then select a workbook in one of the following ways:

Search by name in the Workbook field. Search reaches only the files Microsoft has indexed, so a file created a moment ago may not appear yet.
Paste the SharePoint or OneDrive link of the workbook into the same field.
Browse by selecting Browse workbooks in OneDrive or SharePoint at the bottom of the list. This opens the Microsoft file picker, which also finds files search can’t show yet.
Use a variable from an earlier node’s output, for example the workbook_ref that Create Workbook returns.

The nodes work with .xlsx and .xlsm files.

Value property

Several nodes take a Value property under Advanced settings. It controls how cell values are handled:

Values — Interpret the value as typed, or as returned by the read nodes, so 10 becomes the number 10 and =A1+1 becomes a formula.
Formulas — Treat every value in that field as a formula.
Text — Return the cell as it’s displayed. Available only in the read nodes, such as Get Values.

A single write can carry up to 100,000 cells, and a cell can hold up to 32,767 characters. Numbers longer than 15 digits are written as text, so Excel doesn’t round them.

Available nodes

Get Values
Get Row
Update Cell
Write Rows
Create Workbook

Get Values

Reads the values in a range of cells.

Required inputs

Microsoft Account — Select a connected account from the dropdown
Workbook — Search for a workbook by name, paste its SharePoint or OneDrive link, or browse for it

Optional inputs

Input	Default	Description
Worksheet name	First visible worksheet	The worksheet to read values from.
Range	Used range (the range of cells that have values)	A range of cells in A1 notation, such as `A1:D10`. Leave it empty to read all values in the worksheet.
Value property (under Advanced settings)	Values	Which cell property to return. Learn more in Value property
Output format (under Advanced settings)	Rows (2D array)	The shape of the output: Rows (2D array), Records (list of dicts), Columns (dict of lists), CSV (string), TSV (tab-separated), HTML table, Markdown table, or Raw (full API response). Records and Columns use the first row of the range as column names.

Output

A JSON object with the values in the selected format, the output format, the workbook reference ID, the name of the worksheet, and the range of cells that was read.

To write the values back with Create Workbook, select the same output format in this node as the input format in that node.

Get Row

Reads one row in a worksheet.

Required inputs

Microsoft Account — Select a connected account from the dropdown
Workbook — Search for a workbook by name, paste its SharePoint or OneDrive link, or browse for it
Row selection — Specific row (default), First row, or Last row
Row number — Required when Row selection is set to Specific row. Rows are numbered from 1 up to 1,048,576

Optional inputs

Worksheet name — The worksheet to read the row from. Defaults to the first visible worksheet
Range — Limits which columns the row is read from. For example, A1:D10 returns only columns A to D. Leave it empty to read every column that has data

Output

A JSON object with the row as an array of values, the row number, and a record field that pairs each row value with the column name from the first row.When the row read is the first row, the record field is empty.

Update Cell

Writes a value into a single cell.

Required inputs

Microsoft Account — Select a connected account from the dropdown
Workbook — Search for a workbook by name, paste its SharePoint or OneDrive link, or browse for it
Cell — The cell to write to, such as B2
Value — The value to write: text, a number, a boolean, or a formula such as =SUM(A1:B1). To write a formula, select Formulas under Value property

Optional inputs

Worksheet name — The worksheet to write to. Defaults to the first visible worksheet
Value property (under Advanced settings) — Values (default) or Formulas. Learn more in Value property

Output

A JSON object with the workbook reference ID and URL, the name of the worksheet, the range of cells that was updated, and the number of updated cells.

Write Rows

Adds or updates rows in a worksheet.

Required inputs

Input	Description	Notes
Microsoft Account	Select a connected account from the dropdown	-
Workbook	Search for a workbook by name, paste its SharePoint or OneDrive link, or browse for it	-
Mode	Add rows (default) appends the rows after the last non-empty row. Update rows overwrites existing rows	-
Row data format	Arrays (default) or JSON Objects	Learn more in How to shape Row data
Row data	The rows to write	See How to shape Row data

How to shape Row data

Row data format	Mode	Shape	Example
Arrays	Add rows	Each inner array is one worksheet row. Its values are written to columns in order	`[["Alice", "alice@example.com", 90], ["Bob", "bob@example.com", 85]]`
	Update rows	The first value of each inner array is the number of the row to update	`[[1, "Alice", "alice@example.com", 95], [3, "Charlie", "charlie@example.com", 88]]`
JSON Objects	Add rows	Each object’s keys are column letters	`[{"A": "Alice", "B": "alice@example.com", "C": 90}]`
	Update rows	Each object also carries a `row_number` key with the number of the row to update	`[{"row_number": 1, "A": "Alice", "B": "alice@example.com"}]`

Optional inputs

Worksheet name — The worksheet to write to. Defaults to the first visible worksheet
Value property (under Advanced settings) — Values (default) or Formulas. Learn more in Value property
Start column (under Advanced settings) — The column to start writing at, for example A or E. Leave empty to start from the first column (A)

Output

A JSON object with the workbook reference ID and URL, the name of the worksheet, the range of cells that was updated, and the number of rows that were created and updated.

In Update rows mode, the rows are written one at a time. If Excel reports a conflict partway through, the rows written before it stay written. Run the node again to rewrite the same cells.

Create Workbook

Creates a workbook, or adds a worksheet to a workbook that already exists.

Required inputs

Input	Description	Notes
Microsoft Account	Select a connected account from the dropdown	-
Title	The name of the new workbook, or of the new worksheet when Add to Existing Workbook is set	Enter the name without the file extension. The node appends `.xlsx` automatically
Rows	The data to write into the new workbook or a worksheet	Select the data format under Input format
Input format	The format of the data to write: JSON (default), Markdown table, CSV, TSV (tab-separated), or HTML table	JSON accepts an array of objects, an array of arrays, or an object that maps each column name to a list of values

Optional inputs

Input	Default	Description
Add to Existing Workbook	Empty	Leave it empty to create a new workbook. Select a workbook to add a worksheet to it instead. Destination folder and Worksheet name don’t apply to an existing workbook, so they disappear when you select one.
Destination folder	OneDrive root	The folder that receives the new workbook. Search for a folder by name, paste its link, or browse for it.
Worksheet name (under Advanced settings)	`Sheet1`	The name of the first worksheet in the new workbook.
Value property (under Advanced settings)	Values	Values or Formulas. Learn more in Value property

Output

A JSON object with the workbook reference ID, URL, and title, and the name of the worksheet the data was written to.

To store the output of Get Values in a new workbook, select the same format under Output format in that node and under Input format in this node.

Troubleshooting

See Troubleshooting Microsoft 365 setup and Agent errors for errors the Excel nodes report.

Adobe Experience Manager

Contentful

Drupal

Framer

G2

Gamma

Gong

Looker

Microsoft 365

Salsify

Sanity

Slack

Wordpress

Using Excel in Agents

Shared settings

Choosing a workbook

Value property

Available nodes

Get Values

Required inputs

Optional inputs

Output

Get Row

Required inputs

Optional inputs

Output

Update Cell

Required inputs

Optional inputs

Output

Write Rows

Required inputs

How to shape Row data

Optional inputs

Output

Create Workbook

Required inputs

Optional inputs

Output

Troubleshooting

​Shared settings

​Choosing a workbook

​Value property

​Available nodes

​Get Values

​Required inputs

​Optional inputs

​Output

​Get Row

​Required inputs

​Optional inputs

​Output

​Update Cell

​Required inputs

​Optional inputs

​Output

​Write Rows

​Required inputs

​How to shape Row data

​Optional inputs

​Output

​Create Workbook

​Required inputs

​Optional inputs

​Output

​Troubleshooting

Shared settings

Choosing a workbook

Value property

Available nodes

Get Values

Required inputs

Optional inputs

Output

Get Row

Required inputs

Optional inputs

Output

Update Cell

Required inputs

Optional inputs

Output

Write Rows

Required inputs

How to shape Row data

Optional inputs

Output

Create Workbook

Required inputs

Optional inputs

Output

Troubleshooting