I am trying to use automations in Google Sheets to set up workflow notifications for different members of my team. I have basically a client waitlist with many columns across the top. I am trying to set up so that the first person who starts the workflow for a new client can notify the person that it is assigned to with an automation email (this part works fine).
The problem starts when that next person picks up the workflow and enters information into subsequent columns in the same row and then triggers a second separate automation for the same row to trigger an email to the next member of the team. That second email does not recognize the new information entered into the subsequent columns. Any data that existed when the first email was sent shows up in the second email just fine, but the next team member needs additional information entered into columns after the first email is sent and that information is being left blank in the second email.
I recognize that this is a rather unusual use of mailmeteor but I am hoping that someone has some experience with this type of thing that they can share to force mailmeteor to recognize the updated data in that row before sending the second email when the trigger is activated.