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).
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
