About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Need WooCommerce order update to change status in Google Sheets - Failed to create a spreadsheet row

  • 4 November 2022
  • 4 replies
  • 142 views
M

I have a WooCommerce zapier that is creating a new row for every new order in GoogleSheets. That is great for my dashboard but I also need it to update the row status for canceled or completed when appropriate. So far I can test the step to find the update in WooCommerce, but when I test the step to locate the correct row in GoogleSheets I keep getting the error below:

 

Failed to create a spreadsheet row in Google Sheets

Cursor has gone out of bounds.

 

The troubleshooting is not helpful. I did find another similar posts and tried to follow the steps prescribed but still getting the same error. 

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @mark-eho 

Good question.

Please post screenshots with how your Zap steps are configured in order for us to have context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
christina.d
Userlevel 7
Badge +9

Hey there, @mark-eho! I wanted to swing by and see if you were able to get this sorted? If you are still experiencing this error, we definitely want to help!

As Troy mentioned, screenshots of your zap search or action step (with any personal details removed. ex. names, phone numbers, emails) would be super helpful. 🙂

Let us know! 

M

 

 

 

 

 

 

 

 

 

chanelle
Userlevel 7
Badge +8

Hi @mark-eho at first glance I am not noticing anything off about the mapping in your Zap. I could totally be overlooking it, but my initial thought is that you currently have “No” selected in Action 2 when asked if it should be considered a success if no matching info was found. Can you try changing it to “Yes” and see what happens? It could be that since there is no matching info to pull, the Zap is held up. I see that it was ran successfully a week ago. If not, then please reach out to our excellent Support team for additional 1:1 guidance! 

Reply


Terms & Conditions