Make sure your Microsoft 365 license includes Office Scripts. This feature is necessary for the Automate tab to appear.
Platform limits and requirements with Office Scripts - Office Scripts | Microsoft Learn
Could you share the Excel version and subscription?