Auto-Update Custom Zoho CRM Field with value located on "Zoho Spreadsheets"?
Version: Zoho CRM Professional, 4 users.
I'm trying to automatically update a custom Zoho CRM field within the "Leads" module, using a value found on a "Zoho Docs Spreadsheet". I need this field in all zoho crm "lead" records to update automatically daily.
The excel equivalent to what I want is using "VLOOKUP" a value within in another file. For instance, if "Car 123" is the zoho crm custom field value, it looks up "Car 123" in the external spreadsheet in column "A", then if found returns the value in column "B" in the same row, such as "Sold" or "For Sale". Then populates a custom field in zoho CRM using that value of "Sold" or "For sale" depending on what it found.
Where do I start?
Is this a question for a programmer with Zoho API experience?
Is there anything already existing that we could adapt to complete this task?
We're a small business so we're not looking for enterprise answers, hopefully just a simple solution.