Can't Publish have error and unverified test

Question

I’m sending Gravity Forms to Google sheets. I had this Zap working great yesterday but changed the sheet / worksheet names. I reset those and re-mapped it. I also re-send a test.

I can’t publish my zap. The test data goes through but Zapier cant verify it? All it says is “A Spreadsheet Row was sent to Google Sheets about X seconds ago”. I DO logonto google sheets and see the test data there, but now new data is coming thorough. I also got an error email saying “There was an error writing to your Google sheet. Unable to parse range: 'Sheet1'!A:A “ when someone does fill out a form on my site.

All worksheets and spreadsheets are right

ChaseD_ZAP · Accepted Answer

Thank you. However I tried all three of those fixes but they didn't work. What did work, was turning off the Zap, “Reconnect” all apps i was using from the option of the three dots on the left, and then turned it back on. Probably only needed to reconnect google sheets, but Fixed all my problems! Hopefully this helps someone else.

IF you make any changes (name or columns) to google sheets turn off the Zap first or if it gives you errors try this.

Turn Off Zap.
Re connect the Apps in Use
Turn back on Zap and run Test.

ken.a · Answer

Hi there ​@ChaseD_ZAP,Welcome to the Community! 🎉We have a help article regarding the parse range error in Google Sheets here:https://help.zapier.com/hc/en-us/articles/25804519400461-Google-Sheets-error-There-was-an-error-writing-to-your-Google-Sheets-unable-to-parse-rangeKindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Can't Publish have error and unverified test

3 replies

Useful links

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded