Best answer

First Order Zap (Shopify + Google Sheets)

  • 23 October 2020
  • 1 reply

Hi Zap Community!


New to Zapier and was hoping someone might know if this zap is even possible. I’ve tried to set it up and keep running into an error in my last ‘Update Spreadsheet Row in Google Sheets’ action. 


When a new wholesale account reaches out to us, they fill out an application form and the data is automatically imported into a Google Sheet from their form response. It’s contains all the company’s basic details and I’m hoping I can create a Zap to have it function as an account tracking system as well. I would love to be able to run a zap that will tell this Google Sheet when a New Customer places their first order on Shopify. 


My trigger event is a New Customer in Shopify (buyer email)

Filter action is only continue if Total Spent is greater than 1.00

Action - Look Up Spreadsheet Row (column is the buyer email)

Action - Update Spreadsheet Row… this is where I’m stuck! How do I finish this?


Any insight is appreciated :) 



getting stuck here on step 4 :)




Best answer by olivialook 23 October 2020, 16:01

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.

1 reply

Userlevel 2
Badge +1

If the row lookup is successful in your Step 3, you should be able to use it in Step 4 then add the data you need.