Automation Email - Send a report on all g sheet rows

[GV]

Hi everyone,

I am creating an app to ensure a follow_up during works between architecte, customer and craftsmens

I'd like to send every single week a report after the site meeting creating an e-mail sent to all the stakeholders but not only on one single rows but on all the rows on my underlying gsheet.

So far what I have seen is that : I can send emails for one single row or I can trigger an App Script which will do the job, but I was wondering if I can do it directly on App Sheet.

Thanks for your answers