Create an Action with a Report in the Body of a mail

AppSheet AppSheet Q&A
1

I have a Google Appsheet application that allows me to track my cash expenses related to the various withdrawals I make. The database behind the app has the following tables and their respective columns for each of them:

Spese [Somma Spesa, Data, Descrizione, Catogoria di Spesa, Prelievo del, Mese]

Prelievi [Data Prelievo, Data Contabile, Somma Prelevata, Note, Spese del Prelievo, Restante]

Categoria di Spesa [Tipo di Spesa, Spese per la Categoria]

Calendario [Mese, Spese del Mese, Prelevato, Speso, Restante].

I would like to Get a report in body mail like this:

Report of January

Total Withdrawn: 1500

Total Spent: 1200

Withdrawals of the month:

01/01/2025: 200

Expenses of the Withdrawal:

150 Expense

50 Home

08/01/2025: 100

Expenses of the Withdrawal:

50 Sport

50 Health

Some tips? I’m struggling with the expression to use in Body mail

2

Maybe this:

<<Start: FILTER("Calendar", ("January" = "Month"))>>
Report of <<[Month]>>

Total Withdrawn: <<[Withdrawn]>>
Total Spent: <<[Spent]>>

Withdrawals of the month:

<<Start: ORDERBY(FILTER("Withdrawls", ([_THISROW-1].[Month] = TEXT([Withdrawl Date], "MMMM"))), [Withdrawl Date])>>
<<[Withdrawl Date]>>: <<[Amount Withdrawn]>>

    Expenses of the Withdrawal:
<<Start: FILTER("Expenses", ([_THISROW-1] = [Withdrawl of]))>>

        <<[Amount spent]>> <<[Expense Category]>>
<<End>>
<<End>>
<<End>>
2 Likes
3

Hi Steve, thank you for your reply.

I try to use your suggestion with my tables and columns, but I got the error in the image:

Frank_DLF_0-1737980353618.png
Frank_DLF_0-1737980353618.png961×567 28.3 KB

I am not able to find which syntax error is occurring…

4

No :disappointed_face:

I got always the same error: Expression was unable to be parsed.

5

Ah. What you want to do is not possible using the External: start an email action type. My solution requires you use a bot to send the email.

1 Like
6

Oh ok, clear.

I’ll try to do that.

Thanks for the support

1 Like