Updating a Zoho Campaigns contact with a calculated field from Google Sheets
Hi, I'm using Zoho Flow to add a new row to a Google Sheet based on a new contact being added to Zoho Campaigns (columns A-H get updated with contact field values from Zoho Campaigns). The next column over, Colomn i, is set up so that a score is automatically inserted into column i based on a calculation of the contact field values in columns A-H.
This works so far. The next part is where I'm stumped.
I want to take that value from column i and assign it back to that new contact in Zoho Campaigns. I tried using a "Fetch row - New version" action , and then using an "Add or Update Contact" action, but I can't get that new value to go anywhere. I also have my Flow set up as a last step to send me an email with the value of column i when a new contact row is added, but that email is arriving blank as well.
What am I doing wrong?
Many thanks in advance.