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 :)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/8f2ed489-aea7-4c52-8301-e8e5cf31bdb5.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/a07080ab-550d-49c2-a9b0-959813e171bf.png)