Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I need to update Google Contact from our CMS through Zapier Webhook. I have created the hook and sends data from our CMS. If the field is not empty it works. But if some field is empty the zap do not update this Google Contact field.

EXAMPLE
Data in Google Contact:
Name: Jordan
Family: Stoichkov
Phone: 999999

Data send from CMS with webhook:
Name: Jordan
Family:
Phone: 0123312

Result: The zap updates Name and Phone field, but not Family because it is emplty and new Contact data is: Name: Jordan
Family: Stoichkov
Phone: 0123312

Expected result is:
Name: Jordan
Family:
Phone: 0123312

I have tried Formatter step with default value, spreadsheets formulas but every time if the data field is empty (nodata) it is not send to clear Google Contacts field.

Hi @jordanstoichkovsmilegalaxy 

 

This is actually the expected behaviour. To clear a field, you need to input 3 spaces but instead you are inputting a blank value.

 

A simple work around would be to input the data you want to remove in the CMS as 3 spaces (not guaranteed to work but worth a shot).

Thanks, @MohSwellam  for the reply :)

 

I tested to send 3 spaces from CMS. The Google Contacts field did not update.

 

I tested with Formatter and formula -

IF("{{174688151__last_name}}" = "", "   ", "{{174688151__last_name}}")

and again 3 spaces are considered as blank and the Google Contacts field is not updated.

Hmmmmm, ya that is always a head scratcher. You can do something (although not optimal) which is passing a dot

Yes, now I’m using _ but the name is made from prefix name surname lastname and is like

_ Jordan Stoichkov _ _
which seems … funny in contacts list.

It will be good to find solution or Zapier creates a fix or upgrade to this functionality.

Terms & Conditions