blueprint.json (85.6 KB)
Hi,
I am trying to set up a scenario where once the tracking number is updated, it will trigger 2 actions:
- Send an email to the recipient informing them of the tracking information (working)
- Update the “follow-up” column by inserting a Y, so that future runs will not go through those rows where emails have already been sent. I have added a filter in the search row module.
The email part works fine but the update row part isn’t working. How can I make it update the row as the scenario goes through the said row?
Below is the output of the Search Rows module:
[
{
"0": "Faux Eyelashes+Castor Oil",
"1": "Amber Baker",
"2": "15407340491",
"3": "",
"4": "8705 Shane lane apt 216 ",
"5": "Spotsylvania ",
"6": "Virginia",
"7": "22553",
"8": "92144902915417509270072112",
"__ROW_NUMBER__": 2,
"__SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8",
"__SHEET__": "Sheet1",
"__IMTLENGTH__": 8,
"__IMTINDEX__": 1
},
{
"0": "Faux Eyelashes",
"1": "Holly powell",
"2": "14345794120",
"3": "",
"4": "109 Leigh st",
"5": "South Boston ",
"6": "Virginia",
"7": "24592",
"8": "92144902915417509270063097",
"__ROW_NUMBER__": 5,
"__SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8",
"__SHEET__": "Sheet1",
"__IMTLENGTH__": 8,
"__IMTINDEX__": 2
},
{
"0": "Premium Black Castor Oil",
"1": "Rawan Khazil ",
"2": "18582648942",
"3": "",
"4": "3881 Caminito Aguilar, E",
"5": "San Diego",
"6": "California",
"7": "92111",
"8": "92144902915417509270063080",
"__ROW_NUMBER__": 6,
"__SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8",
"__SHEET__": "Sheet1",
"__IMTLENGTH__": 8,
"__IMTINDEX__": 3
},
{
"0": "Premium Black Castor Oil",
"1": "Owen Kiefer",
"2": "12672647294",
"3": "",
"4": "10 Blayze Ct",
"5": "Newtown",
"6": "Pennsylvania",
"7": "18940",
"8": "92144902915417509270063073",
"__ROW_NUMBER__": 7,
"__SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8",
"__SHEET__": "Sheet1",
"__IMTLENGTH__": 8,
"__IMTINDEX__": 4
},
{
"0": "Faux Eyelashes,",
"1": "Viola Golden Flame",
"2": "16053809696",
"3": "",
"4": "1238 Pearl St",
"5": "Alameda ",
"6": "California",
"7": "94501",
"8": "92144902915417509270063066",
"__ROW_NUMBER__": 8,
"__SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8",
"__SHEET__": "Sheet1",
"__IMTLENGTH__": 8,
"__IMTINDEX__": 5
},
{
"0": "Premium Black Castor Oil",
"1": "Jennifer krutsinger",
"2": "16186826004",
"3": "",
"4": "1100 S Washington st ",
"5": "Salem",
"6": "Illinois",
"7": "62881",
"8": "92144902915417509270063059",
"__ROW_NUMBER__": 9,
"__SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8",
"__SHEET__": "Sheet1",
"__IMTLENGTH__": 8,
"__IMTINDEX__": 6
},
{
"0": "Premium Black Castor Oil",
"1": "Tristan Kiperman",
"2": "13105604637",
"3": "",
"4": "1951 Thayer Ave",
"5": "Los Angeles",
"6": "California",
"7": "90025",
"8": "92144902915417509270063042",
"__ROW_NUMBER__": 10,
"__SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8",
"__SHEET__": "Sheet1",
"__IMTLENGTH__": 8,
"__IMTINDEX__": 7
},
{
"0": "Premium Black Castor Oil",
"1": "Rebecca Clayton ",
"2": "19855514910",
"3": "",
"4": "900 mudcut rd. ",
"5": "Pine Knot ",
"6": "Kentucky",
"7": "42635",
"8": "92144902915417509270063035",
"__ROW_NUMBER__": 11,
"__SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8",
"__SHEET__": "Sheet1",
"__IMTLENGTH__": 8,
"__IMTINDEX__": 8
}
]