Best answer

Xero contacts update/create from google sheets

  • 16 January 2021
  • 6 replies
  • 102 views

Userlevel 1

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

 

 

icon

Best answer by Ennes 16 January 2021, 19:37

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Userlevel 7
Badge +14

Hi @AbuH 

 

Xero has these actions/searches available to try in your Zap.

 

Xero Find Contact

Xero Create/Update Contact

 

Userlevel 5
Badge +5

Hey @AbuH,

I think there is a Xero Action to create/update a contact, see here. Thus, can you not just use the following set up:

  • Trigger: G Spreadsheet - New or Updated Spreadsheet Row
  • Action: Xero - Create/Update contact

Let me know if there are some challenges with matching/finding these users.

Userlevel 1

I shall try these and see 

Userlevel 1

It does some of the stuff, but does not delete text in the xero address areas

Userlevel 7
Badge +11

Hi @AbuH!

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).

Userlevel 1

Thanks nicksimard

Adding a space is worth a try, I'll give that a try