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

How To
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.