Need clarity on oauth connection for M365 EXCEL in the control room

In Microsoft console, I have created an appln project and have the required client ID, Secret ID, etc. But while trying to establish oauth connection, it is asking for admin consent in the client’s dev control room. But i did not face any such issues while establishing oauth connection in google sheet/mail. Is this the procedure for microsoft oauth connection in Automation anywhere?
Also one more question- Do we need to refresh the connection every now and then? If our bots run through out the day, is it reliable? Am trying to replace the Desktop excel with the M365 Excel.