Excel Integration — Automate Excel with AI on Beauto
Microsoft Excel is a powerful spreadsheet application for data analysis, calculations, and visualization, enabling users to organize and process data with formulas, charts, and pivot tables
Category: spreadsheets · 54 actions available
What you can automate with Excel
Beauto connects Excel with 900+ other apps so you can build AI-powered workflows in minutes. Trigger automations from Excel events, enrich Excel data with AI, or sync Excel with the rest of your stack — without writing code.
- Sync Excel data with Gmail, Slack, Notion, HubSpot, Google Sheets, and more
- Trigger AI agents on new Excel events and route the output anywhere
- Schedule recurring Excel tasks — daily reports, cleanups, or bulk updates
- Use natural language to describe the workflow; Beauto builds it for you
Excel actions Beauto supports
- Add Chart — Add a chart to a worksheet using Microsoft Graph API.
- Add SharePoint Worksheet — Add a new worksheet to a SharePoint Excel workbook using Microsoft Graph Sites API.
- Add Table — Create a new table in a worksheet using the Microsoft Graph API.
- Add Table Column — Add a column to a table using Microsoft Graph API.
- Add Table Row — Add a row to a table using Microsoft Graph API.
- Add Workbook Permission — Tool to grant access to a workbook via invite. Use when you need to share a specific workbook file with designated recipients and roles.
- Add Worksheet — Add a new worksheet to an Excel workbook using Microsoft Graph API.
- Apply Table Filter — Apply a filter to a table column using Microsoft Graph API.
- Apply Table Sort — Apply a sort to a table using Microsoft Graph API.
- Clear Range — Tool to clear values, formats, or contents in a specified worksheet range. Use when you need to reset cells before adding new data.
- Clear Table Filter — Clear a filter from a table column using Microsoft Graph API.
- Close Excel Session — Tool to close an existing Excel workbook session. Use when you need to explicitly end a persistent session to release workbook locks. Note: The Microsoft Graph closeSession API is idempotent - it returns 204 for both act
- Convert Table To Range — Convert a table to a range using Microsoft Graph API.
- Create Workbook — Tool to create a new Excel workbook file at a specified drive path. Generates a new .xlsx file with specified worksheets and data, then uploads it to OneDrive.
- Delete Table Column — Delete a column from a table using Microsoft Graph API.
- Delete Table Row — Delete a row from a table using Microsoft Graph API.
- Delete Worksheet — Tool to delete a worksheet from the workbook. Use when cleaning up unused or temporary sheets after verifying no dependencies exist. Example: \
- Export Workbook to PDF — Tool to export an Excel workbook to PDF via Microsoft Graph's format conversion. Use when you need a PDF version of an Excel file for sending, storing, or attaching.
- Get Chart Axis — Tool to retrieve a specific axis from a chart. Use when you need properties like min, max, interval, and formatting of the chart axis.
- Get Chart Data Labels — Tool to retrieve the data labels object of a chart. Use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.
- Get Chart Legend — Tool to retrieve the legend object of a chart. Use after creating or updating a chart when you need to inspect legend visibility and formatting.
- Get Range — Get a range from a worksheet using Microsoft Graph API.
- Create Excel Session — Create a session for an Excel workbook using Microsoft Graph API.
- Get SharePoint Range — Get a range from a worksheet in SharePoint using Microsoft Graph Sites API.
- Get SharePoint Worksheet — Get a worksheet by name or ID from a SharePoint Excel workbook using Microsoft Graph Sites API.
- Get table column — Tool to retrieve a specific column from a workbook table. Use when you need to fetch column properties and data by its ID or name.
- Get workbook — Tool to retrieve the properties and relationships of a workbook. Use when you need to inspect comments, names, tables, or worksheets.
- Get Worksheet — Get a worksheet by name or ID from an Excel workbook using Microsoft Graph API.
- Get Worksheet Used Range — Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don't know the exact range. The valuesOnly option helps filter
- Insert Range — Tool to insert a new cell range into a worksheet, shifting existing cells down or right. Use when you need to create space for new content without overwriting.
- List Charts — List charts in a worksheet using Microsoft Graph API.
- List Chart Series — Tool to list all data series in a chart. Use when you need to enumerate chart series for further analysis.
- List Comments — Tool to list comments in an Excel workbook. Use when you need to retrieve all workbook comments via Microsoft Graph API.
- List Drive Item Children — Tool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId. Returns an array of child DriveItems with stable identifiers and pagination support.
- List Drive Files — List files and folders in a drive root or specified path.
- List Named Items — List named items in a workbook using Microsoft Graph API.
- List SharePoint Tables — List tables in a SharePoint worksheet using Microsoft Graph Sites API.
- List SharePoint Worksheets — List worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API.
- List Table Columns — List columns in a table using Microsoft Graph API.
- List Table Rows — List rows in a table using Microsoft Graph API.