• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Getting the following error while connecting Zoho Books - 4091

Pranjal

Member
Hi,

I have been trying to integrate a google sheet to create Customers and their invoices in Zoho Books. The step until creating the customers has been resolved but I am not able to create the invoices and I am getting the following error
1744298047425.png
 

ArshilAhmad

Moderator
Staff member
Hi @Pranjal,

The amount you were trying to pass in the 'Create Sales Invoice' action step contained a comma. We used a Text Formatter to remove the comma, and it appears to have resolved the issue.
1744305736180.png
 

Pranjal

Member
Great.. What happens when there are 2 items in the invoice. The invoice generated in zoho has only one item but the sheet which has been uploaded has 2 line items in the invoice.


Kindly advise on that
 

Attachments

  • INDEL25F01321.pdf
    33.9 KB · Views: 28

Preeti Paryani

Well-known member
Staff member
Hello @Pranjal,

As per your current workflow, one invoice is created for each row added in the Google Sheet.

If you want to add multiple line items in a single invoice, please add all item details (like name, quantity, rate) in comma-separated format within a single row.

In the Zoho Books: Create Sales Invoice step, you can directly map these comma-separated values in the line items fields.
 
Top