Hi Team,
Need help to proceed with a scenario. I am trying to link the output of JSON parser (3 bundles in the scenario) to a Google sheet- update row module. When I run the scenario I see that the the JSON outputs correctly, and the Google module also runs successfully. But I see that the rows get randomly updated or (or not at all). Can someone help with this? I suspect my mapping is incorrect or I am missing a module
P.S I’m not able to share multiple screenshots to this thread (can upload only 1)
The issue seems to be coming from the AI agent’s response format, not from the Google Sheets module.
From the screenshots, the AI agent is returning different JSON structures on different runs. In some cases, the values are inside the results array, sometimes inside the users array as you mapped, and in other cases the fields are returned outside the array or with different key names. Because of this inconsistency, the JSON Parser mappings change, which causes rows to update randomly or not update at all.
To fix this, the AI agent needs to be forced to return a strict and consistent JSON structure every time. Below is the configuration set up that you can follow while creating the AI Agent:
In the Additional system instructions tab:
Add the JSON structure above
Clearly mention that the output must follow this structure
Also include a sample example output using the same format
Screenshot for your reference:
After successfully setting this response format, remap the values in the JSON Parser and Google Sheets module, save the scenario, and rerun the modules. Once this is done, the updates should work correctly.
Best regards, Msquare Automation Platinum Partner of Make @Msquare_Automation
Thanks a ton , that helped! Quick question- do I need to generate the Make schema with sample output or can I just put it in Additional System Instructions? (I did both the things though!)
Thanks a ton for the prompt responses! Wouldn’t be able to proceed w/o you help!
Thank you for your kind words - I’m glad the guidance was helpful.
You can rely on Additional System Instructions alone, and it should work correctly.
However, providing both the Additional System Instructions and the Make schema with a sample output is recommended, as this gives the AI agent a clearer understanding of the expected response structure, improves consistency, and ensures the output aligns better with our intended behavior.
Best regards, Msquare Automation Platinum Partner of Make @Msquare_Automation
Hope the issue with linking the JSON Parser module to the Update Google Sheets module is now resolved. If this solution helped you, we’d really appreciate it if you could mark the answer as Solution. This helps keep the community healthy, organized, and useful for everyone.
What is your goal?
What is the problem & what have you tried?
Error messages or input/output bundles
Screenshots (scenario flow, module settings, errors)
