Sending Emails to certain customers in Google Sheet

How To
, ,
1

Hello all,

I am trying to create my very first workflow. However, I have encountered some problems.

Workflow Objective: Send emails to customers who meet specific criteria. Before sending, send me ONE approval email first. Customer emails will be sent once approved.

**Problem Encountered:

  • For the approval email, multiple emails will be sent to me. For example, three customers meet the criteria, three seperate emails was sent to me instead of just ONE.
  • After approval, only the last customer emails that meet the criteria received the email.**

This is my Workflow now. The first scenario is to gather the info and send me an approval email. Second scenario is when I click approve, will send emails to customers.

Workflow
Workflow1772×1350 145 KB

I have been trying to fix it but still cannot find a solution. May I know if anyone can help in this situation. Many thanks!

Approval - Workshop Email.blueprint.json (15.5 KB)

Workshop Email.blueprint.json (28.7 KB)

1 Like
3

Hi @kit0407 Welcome to the community!

Can you share Screenshot for email, so we can check in what format from google sheets you are getting those 3 emails?

Best,

4

Hi @kit0407 and welcome to the Make Community!

For the first problem (multiple emails), I suspect your data store is returning multiple requests. And you can see in the run that your data store produces 3 credits, which means that it ran 3 times from the start. It also means that it generated 3 bundles. What you would need to do is use an aggregator to put all those bundles into a single bundle, and then use that to send the email.

Exactly what the format of that email should be depends on what you’re trying to send. As @Prem_Patel , we would need to see the ocntent of the email.

L

1 Like