Authentication
Authorize Layest on the provider’s sign-in page. The provider issues access tokens for the permissions you grant.
Connect Layest to Microsoft Excel
Actions from Microsoft Excel
These supported actions can be set up out of the box and used by our agents.
Create a chart on a worksheet from a data range.
Create a workbook-level defined name (named range or formula).
Create a table from an existing range.
Append one or more rows to a table.
Add a new worksheet to a workbook.
Force recalculation of all formulas in the workbook.
Upload a new .xlsx workbook to a drive folder.
Delete a workbook-level defined name.
Delete a table (converts it back to a normal range; does not delete the underlying cell data).
Delete a workbook file.
Delete a worksheet from a workbook.
Render a chart as an image.
Read cell values from a specific range on a worksheet.
Get the default document library (drive) for a SharePoint site.
Read all non-empty cells on a worksheet.
Get a user's personal OneDrive (drive).
Retrieve driveItem metadata for a workbook.
List workbook-level defined names.
Search and list SharePoint sites accessible to the app.
List the columns of a table
List the data rows of a table.
List tables in a workbook.
List/search tenant users, to resolve a user id for personal OneDrive access.
List and search .xlsx files within a drive.
List worksheets in a workbook.
Write cell values into a specific range on a worksheet
Rename a worksheet and/or change its tab position.
Triggers from Microsoft Excel
Once configured in Nango, these sync templates can provide changes as triggers.
Sync .xlsx files within a drive
Sync the worksheets within a specific workbook.
Connect your tools and workflows today
Bring your existing processes and systems together with integrations so your digital worker can handle the work automatically.
Curious about Layest? Ask your favorite AI