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.
Access your files securely from anywhere
Zoho Developer Community
Deliver unforgettable customer experiences
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Desk Resources
-
Desk Community Learning Series
-
-
-
-
-
-
-
-
-
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Zoho Show Resources
Writer Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.