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

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!

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.

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

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 🙂

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

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. 

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