> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://fyno.io/docs/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://fyno.io/docs/_mcp/server.

# Spreadsheet Widget

> Learn how to configure the Spreadsheet widget in workflows to write workflow data to Microsoft Excel workbooks and Google Spreadsheets.

The **Spreadsheet** widget writes data from your workflow to an external spreadsheet, supporting both **Microsoft Excel workbooks** and **Google Sheets**.
![](/docs/_fern-img/f804b4e6af52e3376626f0c29ec81ab04ae668a7799e4a797141dbfabf754e4f.webp)
You can use this widget to:

* Record workflow execution details.
* Capture customer or transaction data.
* Maintain audit logs.
* Create reporting datasets.
* Share information with teams through spreadsheets.

After connecting the Spreadsheet widget to a Google Spreadsheet or Microsoft Excel workbook, you can configure one or more worksheets and map the required columns for use in your workflow.

## Supported Spreadsheet Types

When adding a **Spreadsheet Widget**, select one of the following connection types:

* **Microsoft Excel**
* **Google Spreadsheet**

The configuration fields displayed depend on the selected spreadsheet type.

## Microsoft Excel

Use this option to connect to an Excel workbook stored in Microsoft SharePoint.
![](/docs/_fern-img/9801063d231d0977b81bb89a50a899bc04002be974a4ded12e1c2f6b16ed4721.webp)

### Configuration

After selecting **Microsoft Excel**, provide the following details:

| Field              | Description                                                                 |
| ------------------ | --------------------------------------------------------------------------- |
| **Workbook ID**    | The unique identifier of the Excel workbook, which can be found in the URL. |
| **Sheet Name**     | The worksheet within the workbook to connect to.                            |
| **Tenant ID**      | Microsoft Azure Active Directory Tenant ID.                                 |
| **Client ID**      | Azure Application (Client) ID.                                              |
| **Client Secret**  | Azure Application Client Secret used for authentication.                    |
| **SharePoint URL** | The SharePoint site URL where the workbook is stored.                       |

### Values to Write to the Sheet

After selecting the worksheet, configure the values to write by mapping worksheet columns to workflow data.
![](/docs/_fern-img/c0d7fcfd8c1910075bbe6d3f49cd1499e87eb0bcdc3704f5f9f583a602b3e16e.webp)

1. For each mapping, specify:
   * **Column Header** – The column in the selected worksheet where the data will be written.
   * **Value** – The static value or workflow variable to write to the corresponding column.
2. Click **Add Another** to create a new column mapping and repeat the process to add additional column mappings as required.

## Google Spreadsheet

Use this option to connect to a Google Spreadsheet using a Google service account.
![](/docs/_fern-img/d38da6e3f85e2078a4695c826d7586d6e09d7b519949df1e6f49ce53093ddcc0.webp)

### Configuration

After selecting **Google Spreadsheet**, provide the following details:

| Field              | Description                                                  |
| ------------------ | ------------------------------------------------------------ |
| **Spreadsheet ID** | The unique identifier of the Google Spreadsheet.             |
| **Sheet Name**     | The worksheet within the spreadsheet to connect to.          |
| **Private Key**    | The private key from the Google service account credentials. |
| **Client Email**   | The service account client email used for authentication.    |

### Values to Write to the Sheet

After selecting the worksheet, configure the values to write by mapping worksheet columns to workflow data.
![](/docs/_fern-img/c0d7fcfd8c1910075bbe6d3f49cd1499e87eb0bcdc3704f5f9f583a602b3e16e.webp)

1. For each mapping, specify:
   * **Column Header** – The column in the selected worksheet where the data will be written.
   * **Value** – The static value or workflow variable to write to the corresponding column.
2. Click **Add Another** to create a new column mapping and repeat the process to add additional column mappings as required.

## Outcome

The **Spreadsheet** widget enables workflows to write data directly to external spreadsheets.

By supporting:

* Microsoft Excel.
* Google Spreadsheets.
* Static values.
* Dynamic workflow values.
* Multiple column mappings.

users can capture, organize, and share workflow-generated data efficiently.