learn2
July 29, 2026, 7:17pm
1
What is your goal?
To map Google Sheets 2 Zoho books to create an invoice
What is the problem?
product ID in zoho books
What have you tried so far?
mapping
Create public scenario page
I can get successful scenario when I hard for one particular product ID but the scenario is only useful if mapped, but when I get that this error
Screenshots: scenario setup, module configuration, errors
Hello,
Could you please show us how your mapping looks like in Zoho module and show google sheets output?
Most likely you are passing wrong Product ID. Use this method to list all your Zoho Books items and validate if product id used match.
Zoho Books uses numeric-only item_id values.
You’re passing text – Pearls – and that won’t work.
You need the actual Item ID from Zoho Books.
Either put it in column K, or add a separate column for the Zoho item id in your Google Sheets and map that instead.
How to get Item Id’s- I add API request earlier.
Have a nice day,
Michal