Scheduled email to users with data source as Airtable and Glide tables

Hi, I have an app with different leads and different users. The lead database is in Airtable, and the user database is in Glide tables.

Is there anyway I can schedule a daily email at lets say 4:00 PM to let users know how many new leads have been assigned to them today?