Get the Zoho invoice contact id for an order in Woocommerce

I am trying to integrate the Woocommerce module with Zoho Invoice to automatically create an invoice.

I have set up a scenario with Woocommerce Get Oder → Zoho Invoice List Contacts → Zoho Invoice Get Contact thinking I could filter the Email id of the customer in the List Contact module, then get the Zoho Contact id of this email with the Get Contact module, and then I could proceed to make an invoice.

But the List Contact module is listing all the contacts from Zoho Invoice, and not really filtering for the email id from the Woocommerce order.

Clearly, I am not setting up the List Contacts module wrong, or using the wrong module altogether. Any help would be helpful.

Thanks.

Welcome back @Reboot_Backend;

When we’ve the case of multiple results returned no matter what, like Zoho Contact, we could run that first and load the information into a data store for later lookup on the first branch of an early router.

Then on a later branch, get the Woocommerce orders, look up the email from the Zoho Contact data store, and finally proceed as you’d like.

https://www.make.com/en/help/tools/data-store

Good luck!