How to send an email on a schedule with data in it

Hi Team, any solutions to this use case…

  1. User filters data based on their criteria eg. name contains a value
  2. User schedules for new records that meet criteria to be emailed eg. daily
  3. User receives email with records, either in email body or attached spreadsheet

Thank you!

I would recommend connecting google sheets and using the time-triggered script.