Can I use Copilot to help with Sharepoint governance and admin tasks?

Part of my role is to manage governance of a large corporate intranet, which is a Sharepoint site. This includes running reports to see which pages have been updated in the last 24 hours, reviewing pages against a set style guide and identifying duplication and redundancies. I have a Microsoft 365 licence in my role.

Is there any way I can create an agent to crawl the back end of my Sharepoint site and help with the types of admin tasks I've listed above? I've had a few tries, but the agent can't seem to access the site pages etc. lists that I need it to review. Any help would be appreciated, thanks!