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

[Suvrutt_Gurjar · Accepted solution]

Please take a look at the following articles to get ideas on using <<START>> expressions in templates that help you to include multiple rows.

Use Start expressions in templates - AppSheet Help

Sample email templates - AppSheet Help

For scheduled reports

Events: The Essentials - AppSheet Help

[GV]

Underlying G Sheet

Hi Suvrutt,

I have read carefully the answers and the following instructions, but I didn't get where I should put theses formulas. Into the custom template in my e-mail ? cf below

Thanks for your answer. 

An entire table

The simplest Start expression is the name of a table and its key column:

<<Start:Orders[Order Id]>>

This form of Start expressions is typically only meaningful as the top-level Start expression in a scheduled bot

[GV]

Hi @Suvrutt_Gurjar 

This is the same issue as the one you've just commented "

blank email template fields in start expression"

I'll try to have a look to your solution posted earlier and if not I will write again on this loop

Thanks

[Suvrutt_Gurjar]

You can have it in email body. But then all the records will appear in the email body.

Alternately, you could have a report template and create a PDF file as an attachment to email. 

[GV]

Alternately, you could have a report template and create a PDF file as an attachment to email. 

That's exactly what I'd like to do, how can I make it happen ? Thanks 

[Suvrutt_Gurjar]

Please take a look at this sample app. There are some reports with attachment template.

Order Capture How-to

[GV]

Thanks for the fyi, not sure this example will help me in my work as there is no automation/bot or neither some emails send with PDF attached with variables base on all rows of a specific sheet...

[Suvrutt_Gurjar]

You will of course need to combine some reading and sample apps. Exact match may not be available as sample. Shared the app so that you are aware how to use attachments, since you had shared email body screenshots.. Help articles can help with creating  <<START>> expressions for multiple rows. Also if you look at the sample app's templates there are <<START>> expression for children tables. 🙂

[GV]

Thanks Suvrutt for your help

Best,