Hello together,
i have this spreadsheed.
I have listed different spots an now want that automaticly send an E-Mail as soon as an email address (Column G) is entered and the status is “Steht aus” (Column E).
For this I use a Google Search Rows Modul with a Filter (Column G) Text Contains an “@” and (Column E) Text is equal to “Steht aus”. Than i use the Gmail Modul “Create a Draft”. So far everything is clear.
My Problem:
After the Mail is created, i want that the status in Column E change from “Steht aus” into " Warten auf AW" and in Column I will be writen the current date when the Mail was send. I am strungelling with this point. I tried the Update a Raw Modul, but there i have to link a specific fix Row Number. But i dont know in advanced the Row Number. Is ther en option to generate it dynamicly? Or is there another better modul for my case?
In my case the status update have to be in E2 and E9 and the Date written in I2 and E9.
Can someone please help me.
Cheers Rene