Found out that:
If you're using Google Spreadsheets for the Trigger side of a Zap and it suddenly stopped working, verify that you didn't accidentally insert a blank row anywhere. Zapier interprets a blank row as the end of the spreadsheet.
I am using a google form where participants are asked if they would like to receive newsletters from us by putting their e-mail after answering a survey.
Obviously there would be empty rows if they choose not to subscribe. When it happens, zap stops working and I have to manually add the e-mails to mail chimp.
Is there a way to get rid of the empty rows or maybe link the responses to another sheet then paste those nonadjacent cells adjacent/simultaneously so there won’t be any empty rows?
I hope this makes sense.