Another new feature to come out of Microsoft Ignite 2022- the ability to use Power Automate within Excel Online. This allows you to search for flows that can assist you with data entry or run Office Scripts without leaving Excel.
You will see the Power Automate button in the Automate tab of the ribbon in Excel Online. Note: this is not available in the Excel desktop app. This will bring up a list of flow templates to choose from. If you see one you’d like to use with your spreadsheet, it will take you to https://make.powerautomate.com/ where you can proceed to build on the template provided.