Transfer data from google sheets to close crm to create a new lead


I am using google sheets as a database and want to transfer the data to close crm to create a new lead.

But the data is inconsistent.
Some leads have 1 and other 2 email adresses or phone numbers. So the field for the second Mail is not always filled out. And that´s when the error happens.

Unfortunately the ifempty function was not working. Any other solutions?
Thank you

Welcome to the Make community!


Please share screenshots of the module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:


Please export the scenario blueprint file to allow others to replicate the issue. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.


Uploading it here will look like this:

blueprint.json (12.3 KB)


Please provide the input/output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the contents as a bundle.json file, and upload it here into this discussion thread:


Following these steps will allow others to assist you here. Thanks!