Automating Call Reports

Hi There,

We are thinking of automating our fundraiser's call reports where we would require them to put in the information in a specific Constituent Note type and then using Power Automate, pull the reports out each day and email them to the organization for transparency.

Is anyone out there doing this? Is is possible to pull a specific note out from a record and include the contents in an email?

Thank you!