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 answer by Troy TessaloneView original
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.
Did using a Lookup Row action followed by an Update Row action help out here?