Thank you for choosing Microsoft Community.
Running an Excel script through Power Automate without a premium account can be a bit tricky, but there are some options you can explore:
Office Scripts: You can use Office Scripts in Excel Online to automate tasks. While running these scripts through Power Automate typically requires a business license, you can use the Script scheduling feature to run scripts automatically without connecting to other apps.
VBA (Visual Basic for Applications): If you're using Excel on the desktop, you can create VBA scripts to automate tasks. While this doesn't directly integrate with Power Automate, it can be a powerful tool for automation within Excel itself.
Excel Online (Business) Connector: This connector allows you to run scripts stored in OneDrive or SharePoint. While it usually requires a business license, you can explore using it with the available features in your current plan.
For more detailed information, you can refer to the official Microsoft documentation here
If this Post helped you, please click "Does this answer your question" and like this post to help others in the community find the answer too!
Happy to help
Robu 1