I have a zap which connects jotform with google sheets.
While testing manually when jotform data is passed onto google sheets after some formatting using python code, it successfully enters that data into google sheet and I can open the sheet and see the data present there.
But when this zap run in production i.e when someone enters the entry into jotform and submits that zap triggers and runs successfully with no erros at all. but the catch is it just enters the timestamp into google sheet. apart from that no data is entered there in the sheets, everything is blank.
Has anyone faced this issue?
Best answer by tusharbjobsBest answer by tusharbjobs
To anyone who is dealing with similar problem, this is a Zapier limitation. Zapier auto converts incoming JSON data as string when referenced that input inside the code step.
For more details here you can find the detailed information.
So no code solution will work there. The only solution to this is use Raw webhooks and get the data in raw format then process that further in your code steps to do processing on JSON data.
Things are working for me now after using raw webhook instead of direct JotForm trigger. However, it took me a lot of time to figure that out and I would have appreciated if Zapier could document such limitations easily somewhere.
I did a quick test other way round. I created a duplicate action of insert step and removed all the data from the fields. Now inserted one field data coming from jotform trigger step directly in unformatted state and other field data in formatted step coming from the output of python code step in step 2. Both went again well on manual test run and both fields show up on google sheet in first case. But same story when triggered in production by submitting a form entry.
First field shows up the value on sheets coming from jotform in unformatted state, but second one coming from code step doesn’t show up on sheets.
To anyone who is dealing with similar problem, this is a Zapier limitation. Zapier auto converts incoming JSON data as string when referenced that input inside the code step.
For more details here you can find the detailed information.
So no code solution will work there. The only solution to this is use Raw webhooks and get the data in raw format then process that further in your code steps to do processing on JSON data.
Things are working for me now after using raw webhook instead of direct JotForm trigger. However, it took me a lot of time to figure that out and I would have appreciated if Zapier could document such limitations easily somewhere.
