1.Module - Google Sheets - Watch New Rows
I have a spread sheet with 3 headers - First Name, Last Name and Email Address.
The module is setup to react to these rows.
Module - Text Aggregator
Where I have written a custom email message with a mapping to “First Name” so the email dynamically changes based on the row added in the previous module.
Module - Email - Send an Email
This module is supposed to take the text from the previous module and the email address from the first module, but when I try to map it “To - Email Address” it only shows the options to map it to the Text Aggregator - Text
I also see the grey connection ( not sure what this is called ) in the overall scenario connecting only the first modules - if that makes sense. But I’ve tried to manually enter an email to the email module and when I run the scenario then it does work. Could someone help me figure out how I can dynamically connect the first and the last module.
I have a follow up issue. I’ve added Google Sheets - Update a Cell to the previous scenario. This module is supposed to update the the same row, column D called “Follow Up Email” with the date 3 days from now.
I’ve attached a screenshot of how I setup Update a Cell and the error I get.
The issue seems to be with the specific cell, but it is directly linked to the first module, so I’m confused. Maybe you can help me with this one too @Henrik_Martinussen
Just so I understand the logic, do you know why it would not take it when I directly mapped it to the “Follow Up Email” because I also tried it without the brackets?
“Follw Up Email” is having a value - the value change for every rows - so it is not the column name - but the cell value.
When you have run the scenarie one time - you can see the value from last row. See this with the text “6740”, which is the value in column D in my googe sheet.
Hope it makes sence.
