update in table view in the email at the end of the day

[Aman991]

Hi, 
I want to develop a bot that will run and send an email to owner about the activities occurred today let say 6:00pm everyday. 

I tried, one workaround in which we can send an email for each entry in table. in that case if there is 50 events occurred at any particular day than it will send 50 mails at ones. how I can combine them in table and schedule a process for single email task. 

also is multiple tables that are connected to one table we can send one combined data related to it in one email?
@Steve 

[Aurelien]

"I want to develop a bot that will run and send an email to owner about the activities occurred today let say 6:00pm everyday. "

I suggest using a column with type "ChangeTimeStamp".

This way, all update timestamp will be tracked.

Then, run your bot on schedule event "Daily".

In your template app, you will use:

<<Start:FILTER("YourTable", TODAY([ChangeTimeStampColumn])=TODAY())>>
<<[Item information you wish to display 1]>>
<<[Item information you wish to display 2]>>
...
<<[End]>>

 It can be tricky at first, I suggest you read the documentation about template documents: 

Use templates in an automation - AppSheet Help

Use Google Docs templates - AppSheet Help