Hey!
Can you screenshot the error on the zoho module?
-John
Thanks for the screenshot.
Can you follow this step-by-step fix?
Given the Google Sheet data with fields like item name, item description, items qty, items unit cost:
Pre-create items in Zoho Books under Items > Products & Services for all unique items in your sheet.
In your Make scenario, after the Google Sheets “Watch New Rows” module and before the Zoho Books “Create Invoice” module, add a Zoho Books “Search Items” module.
In the Search Items module, set the search filter to use Item Name = the item name from Google Sheets.
In the Zoho Books “Create Invoice” module, map:
Product/Item ID = item_id from the Search Items output
Item Name = name from the Search Items output (or from Google Sheets)
Item Description = item description from Google Sheets
Quantity = items qty from Google Sheets
Rate = items unit cost from Google Sheets
This way, you’re passing a valid numeric item_id that Zoho Books recognizes, which will resolve the “Invalid value passed for Product ID” error.
What is your goal?
What is the problem & what have you tried?
Screenshots (scenario flow, module settings, errors)
