I have a zap where each time a row is entered or edited in Google sheets, it creates an item in podio. This zap was working fine for weeks and now all of a sudden it has stopped. The error code in zapier says “the app returned invalid value”. I understand this means that a field came back empty or not formatted correctly. I turned the zap off, went into google sheets, fixed the fields that zapier said were empty or not formatted correctly, and then turned the zap back on. It is still not working. The weird thing is that for weeks prior to now, zapier was pulling the info from google sheets into podio even if there were empty fields. Now all of a sudden, those empty fields are causing a problem. Even if I fill the field and retry the zap it still is not working. What can I do to fix this? The zap worked 70+ times last month without a problem and now it’s not even though nothing has changed. Please help! TIA!
Best answer by Liz_Roberts
Circling back on this as I see you have been working with Support! It looks like the character limit in the phone number field was causing the error. Once the Google sheet cell that mapped the phone numbers is less than 50 characters, this error should be resolved!
Please let us know if you are still encountering any issues and we’ll be happy to help!