Best answer

Find Excel row and update another cell

  • 10 March 2021
  • 2 replies
  • 157 views

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

icon

Best answer by Troy Tessalone 10 March 2021, 20:59

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.

2 replies

Userlevel 4
Badge +9

Hey @Timmy!

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

Userlevel 7
Badge +14

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.