Scheduled Email based on Condition

AppSheet AppSheet Q&A
, , , ,
1

I have to send data every week, to many people. But everyone has to send data according to them. Below I have given an example.

COURIER NAME EMAIL
AMAZON RAHUKH@GMAIL.COM
BLUE DART YUIHIH@GMAIL.COM
DELHIVERY SAIF455@HOTMAIL.COM
DELHIVERY 15KG YASIF4555@GMAIL.COM
ECOM EXPRESS RAHUKH@GMAIL.COM
EKART LOGISTICS YASIF4555@GMAIL.COM
MYNTRA YUIHIH@GMAIL.COM
SHADOWFAX RAHUKH@GMAIL.COM
UNIMOVE ( SNAPDEAL ) YASIF4555@GMAIL.COM
XPRESSBEES SAIF455@HOTMAIL.COM

my data table
my data table1354×768 94 KB

I have to send the details of a week to everyone according to the column [Courier Name]. Can you tell me how can I send with the help of auto bot.

2

Please start by reviewing this document:

Send an Email from automation

You would start by creating a Bot that has Event Type of Schedule, runs against your Data table, add the frequency you wish to run and a Condition to select the rows you wish to generate and send emails for.

When it comes time to update the “To” property with the email addresses to send the email to, you can use an expression to retrieve the email address. It would be something like:

ANY(SELECT(Courier[Email], [Courier Name] = [_THISROW].[Courier Name]))
2 Likes
3 
ANY(SELECT(Auto bot Email[EMAIL], [CHANNEL] = [_THISROW].[CHANNEL]))

The expression is valid but its result type 'Email' is not one of the expected types: Yes/No
4

Please show as screenshot of the entire Expression Assistant window for better clarity on what the problem is.

1 Like