Skip to main content

Hello Zapier Experts !

I have a Zap where an AI assistant generates a precise JSON, which is then sent to the next step, 'Code By Zapier', where a Python script processes the JSON data. The goal is for the data processed by the Python script to be distributed into specific cells and rows in Excel using the 'Add Row' function.

My problem is: when I test my code in 'Code By Zapier', the test results display correctly in the 'Data Out' tab. However, when I try to select a value from the test in the 'Add Row' step, 'Code By Zapier' only offers me completely different test results from a previous attempt.

I have already tried the following steps:

  1. Cleared previous test data.
  2. Refreshed the inputs and outputs.
  3. Re-authorized steps.
  4. Ensured the data format is correct.
  5. Tested with simplified data.

Despite all these efforts, the issue persists. Could you please advise on how to resolve this issue?

I cannot share screenshots due to confidentiality reasons of the company I work for.

Thank you for your assistance :) 

PS : sorry about my English, it’s not my main language.

Hi @VooDoo 

For us to have more info, post screenshots with how your Zap steps are outlined and configured in EDIT mode along with the DATA OUT from the Zap Code step.


Hi @Troy Tessalone 

Here are the screenshots you asked for : 

Is there anything else I can do to help you ? 

As you can see the data out from the code by Zapier is totally different in the “Add Row”. 

Many thanks in advance :) 

 


Hey Everyone,

I sorted this issue out, I just had to re-arrange my Python, to be more precise I had to reorganize the data output format. It seems that my problem is solved. 

Thank you very much :) 

Voodoo


YAY! That’s really fantastic news, @VooDoo! Great work on getting this solved. 🙌

Please do reach back out to the Community in future if you need help at all. Until then, happy Zapping! ⚡️


Reply