I have a connection that saves new contacts to google sheets,
what I am trying to achieve is when i update a contact in the google sheets, i want that contact to be updated in xero too,
I think it needs a customer id for it to search in xero, i don't see a lookup option when creating the zap
Best answer by Ennes
Hey
I think there is a Xero Action to create/update a contact, see here. Thus, can you not just use the following set up:
Let me know if there are some challenges with matching/finding these users.
+14Hi
Xero has these actions/searches available to try in your Zap.
Xero Find Contact
Xero Create/Update Contact
+5Hey
I think there is a Xero Action to create/update a contact, see here. Thus, can you not just use the following set up:
Let me know if there are some challenges with matching/finding these users.
+11Hi
If you’re looking to update something with a null value (meaning you remove what’s currently there) that’s not something that is possible via Zapier. Some apps have functions that you can use that tells the app you want to delete the value, but I haven’t seen that very often. You could overwrite it with something like a period, or see if adding a space does it (I'm not confident it will).
Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.
Join us September 23rd, 2026 for a free, one-day virtual event with 30+ sessions on AI automation. Get live build-alongs, playbooks, and strategies to lead AI transformation at your organization.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
