Insert Ignore in Google Sheets

Hello, who can help me, thank you!

I need to insert phone numbers and a google sheets, but ignoring numbers if they already exist, that is, I’m going to pass an array and I want only the new ones to be inserted.

Thanks!!
image

Hello @Bethoven nice to meet you.

If I clearly understand, you want to add the phone numbers in a Google Sheet. So after the iterator you can use Search Rows (Google Sheets module) and set a filter inside where you check if the phone number exists, following this example:
image

After the Search a row module, you can set a filter where you check if total number of bundles are equal to 0, following this example:
image

Don’t hesitate to contact us if you require further assistance.

//VLAD

1 Like

wow, Nice to meet you, your answer was perfect, it worked exactly as I needed it to.
Thank you for your attention! :star_struck:

1 Like