Record tasks in Excel with Automate The Automate tab allows you to create and run Office Scripts, which allow users to automate tasks in Excel.

Within Power Automate, it has been possible to run scripts in Excel using the Run Script actions. Did you know that the is a Run Scripts from SharePoint library action too?

The ability to automate tasks in Excel for the web has been a long wait—but it’s finally here, and it was worth the wait.

Learn how to pass spreadsheet values as parameters to a PowerShell script for more dynamic and functional automation.