How can I send two separate emails based on data availability in a single Google Sheet row?

Questions
1

Hi everyone,

I’m building a scenario in Make that pulls data from a Google Sheet used for container collections. I want to automate two separate emails to the client, based on the timing of when data becomes available in the row.

Here’s the logic I’m trying to implement:

  1. Initial Email (Partial Data Available)
    When a new row is added or updated and contains only the container number, seal number, and tare weight (but no VGM), I want an email to be sent immediately with the available info.
  2. Follow-up Email (Once VGM is Available):
    Later, once the same row is updated with the VGM (verified gross mass), I want a second email to be sent to the client referencing the same container, now including the VGM.

I’d like to handle this in one scenario using a router with conditional filters. I’m also using a Status column to keep track of what’s already been sent (e.g., First Sent, VGM Sent).

Here are my questions:

  • Is this approach sound?
  • Should I use an Iterator after the “Watch Rows” module? (Each row only contains one container’s data)
  • How would you structure the filters and router logic to ensure each email is only sent once?
  • Is there a better way to structure this for reliability and scalability?

Thanks in advance for your help — I’m learning fast and really appreciate the wisdom here!

2

Hey Tashreeq,

it would be better to have these in two separate scenarios. Because one would be triggered by a new row being added and the other by when an existing row is updated.

3

Hi Stoyan,

Thank you for your reply, I’ll do just that.

With that being said, how do I add a filter that checks if the container weight field is empty or not, and if it is empty, send a mail saying it’s not yet available. And if it is available, send a mail with the container weight information included?

4

You can have a router and then set two routes with filters. Map the variable there and change the filter condition to exists on one of them and doesn’t exist on the other.