Best answer

Search Duplicate and if found then move exisitng row to bottom

  • 17 January 2023
  • 4 replies

Userlevel 3

We are using Zapier for Cloud calling service where phone number and date of call get updated in google spread sheet at the bottom when we receive call on board line.

Problem: when same customer is calling again then number don’t get updated because we implemented duplicate filter in zapier.

Expected Solution : We want a system where existing row should move to the bottom or date column should get updated there only.

If you have better idea plz suggest.


Best answer by jesse 18 January 2023, 20:53

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.

4 replies

Userlevel 7
Badge +14

Hi @aJAX 

Good question.

Sounds like you may want to consider using Airtable instead of GSheets.

Airtable has Views which can be Sorted.

Userlevel 7
Badge +9

Hey @aJAX! Troy’s suggestion of using Airtable is certainly something to look into. However, if you were wanting to stick with Google Sheets, you could set up a Zap like so:

  1. Phone call received
  2. Google Sheets “Find Row” (to look for the number - you can also check a box to create a new row if one isn’t found)
  3. Google Sheets “Update Row” (to update the “date” column for the existing number with the current day/time)

Does that sound like it would work for your use case? Let us know which you end up trying and using - we want to make sure you’re taken care of here! 

Userlevel 3

Hello, create a Zapier like as you suggested but got the error 


Userlevel 3

Thanks a ton, I am able to solve the problem.