Skip to main content
Best answer

Find Excel row and update another cell


Hey There,

I wanted to create a Zap from Digistore24 to google sheets.

As soon as a purchase was made it should trigger a search for an E-Mail Adress in Google sheets. If it is there than update the row. If not, than create a new one. 

I know how to create a new row if the mail already exists but I dont understand how to update another cell of a existing row. Is that even possible? 

 

Best Regards

Best answer by Troy Tessalone

Hi @Timmy 

Check out the available GSheets triggers/actions/searches: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

Try using the Lookup Row search (else create new Row checkbox option) along with the Update Row action.

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31349 replies
  • Answer
  • March 10, 2021

Hi @Timmy 

Check out the available GSheets triggers/actions/searches: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

Try using the Lookup Row search (else create new Row checkbox option) along with the Update Row action.


Forum|alt.badge.img+9
  • Zapier Staff
  • 238 replies
  • May 19, 2021

Hey @Timmy!

Did using a Lookup Row action followed by an Update Row action help out here?