Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I am creating a zap that triggers when a new row is created in Google Sheets. The action is that a new invoice should be created in Stax. 

I had trouble finding the customer in Stax, so I created a search step to find the customer (may be unnecessary?). So the zap is currently: Trigger (new row in sheets), Search for customer in Stax, Create invoice in stax. 

I cannot get the final step to execute properly - I keep getting error code 422, which has something to do with the customer ID. The customer is getting found properly in the search step, but in the invoice creation step, something is off and I cannot figure it out. I have tried pulling the customer by the Customer ID created in Stax, customer name, company name, etc. Nothing works. Does anyone have suggestions?

 

 

I found the solution. The error code 422 was being returned because a line item within Stax did not match exactly with the line item I was sending from Google Sheets. When I fixed that issue, the error code resolved.

However, now that I have published my Zap, it is not automatically triggering based on new rows being added in Google Sheets. I am hoping this is a simpler solution that I am just overlooking. Why would the zap not be instantly triggering based on new rows being addd in Google Sheets, as I have set up the trigger?

Hi there @TMAZaps,

Welcome to the Community! 🎉

I’m glad to hear you were able to find a solution for the 422 error.

Regarding your question about the Zap not triggering, if your Google Sheets trigger stops working suddenly, first check if you’ve accidentally inserted a blank row anywhere in the spreadsheet. Zapier interprets a blank row as the end of the spreadsheet and may have trouble finding any new rows below it.

More about that here: https://help.zapier.com/hc/en-us/articles/8495995099533-Common-Problems-with-Google-Sheets-on-Zapier

Hopefully, this helps.

Reply


Terms & Conditions