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 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

Woocommerce to google sheets internal error

1

I’ve been running the same zap for two years to add line item order details from woocommerce to google sheets. Last night it stopped working. No changes were made to the zap and there was no update in woocommerce.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

jesse
Userlevel 7
Badge +9

Hey @19eighty Sorry to hear you’re running into some issues here, especially after that Zap has been working successfully for so long!

I see this error is from testing your action. Are there also errors within your Zap History? https://zapier.com/app/history Those can often give us more information on why something may have been turned off.

If not, and we’re only working with the error in the test step, it would be helpful to do 3 things:

  1. Retest your Google Sheets connection: https://zapier.com/app/connections
  2. Make sure the correct spreadsheet/worksheet are selected
  3. Send over screenshots of how you have you have your action step congured for your Google Sheets step, being mindful to not include any PII in those

From there, we may be able to further understand and troubleshoot what’s happening here!

P.S. If you skip the tests, turn the Zap on from your dashboard, and then trigger the Zap, doesn’t anything come across to your Zap History? Does the Zap turn off again? Let us know!

1

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

1

The two circled were the only ones that did not propagate on the sheet. All the other errored ones did.

D
Userlevel 2
Badge +3

Hi @19eighty ! 

Thank you for sending those details. It looks like the worksheet can be found. Is it possible the original one was deleted, or has changed?


Please clear both the selected spreadsheet and worksheet in the Zap, and then re-select them -- this should ensure the Zap sends the requests to the correct ones.

Let us know if it works 🙂

1

@Daniela_Paulo I’ve already tried that. I also tried backing the spreadsheet up to a previous version when it was working correctly. 

1

The issue is resolved it seems it may have been an issue within Zapier as it started working as abruptly as it stopped again not related to any changes we made. 

D
Userlevel 2
Badge +3

Hi @19eighty , thank you for getting back to us. I’m glad to hear it is working now!

If this happens again and re-selecting the spreadsheet and worksheet doesn’t fix it please reach out to our Support team through our contact form: https://zapier.com/app/get-help

They’ll be able to help with it.

 

Happy Zapping!

Terms & Conditions