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

Trouble with Wisp Form+ Google Sheets Automation - NO DATA OUT

  • 31 July 2023
  • 5 replies
  • 19 views
MDEC

The integration used to work perfectly but after a few days, the Zap successfully runs but the DATA OUT says no data so I’m not able to get data from the forms into the sheet at all.

 

 

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @MDEC 

Good question.

What is the GSheets Zap trigger event you are using? (screenshots with how the Zap triggers step 1 is configured)

Looks like an empty row (19) triggered the Zap.

Make sure to review the available help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
MDEC

 

Troy Tessalone
Userlevel 7
Badge +14

@MDEC 

Did you review these?

Make sure to review the available help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
MDEC

Yes and nothing makes sense. I’ve used this same zap for 5 years with Sheets and never had a problem until now.

SamB
Rank
Userlevel 7
Badge +11

Sorry to hear of the troubles here @MDEC.


Can you confirm whether the Wispform response that triggered the Zap and created a blank row (row 19 in Google Sheets) contained any data?

If it didn’t contain data:
Then it may indicate that there is an issue on Wispform’s end where it triggers for blank responses, or for response that weren’t yet completed perhaps? I’m not seeing any existing issues reported for the Wispform app that would match that behaviour so you may need to reach out to our Support team to investigate things further. They’ll be able to open up a bug report if necessary.

If it did contain data:
Do the currently selected Wispform fields in the Google Sheets action match the ones that contained Wispform data when the Zap ran? Or do they have different names? This might happen if the name of a selected form field has been changed after the Zap was intially set up. In which case pulling in a new test record and reselecting the relevant Wispform fields in the Zap should help to get the data from Wispform sent over to Google Sheets correctly. 

Looking forward to hearing from you on this!

Reply


Terms & Conditions