Pabbly formatting JSON from GSheets
Status: Closed · Asked by NPSource-dev on · 0 views
Hi,
I want to get JSON from a Google Sheets into Pabbly using the webhook.
The original JSON is located in a unique cell, but when I go in my Pabbly workflow, it's returned as multiple lines :

I need it to be maintained undivided as I want to use it with the Iterator as shown in this tutorial :

Why does Pabbly automatically divids the JSON ? How can I simply get it in its original form ?
Sources :
- My Google Sheets
- My Pabbly Workflow
Regards
You need to capture webhook response in advance format.
For that simply disable the simple response option as shown below, and then recapture the webhook response again from your Google Sheet -

Then you should be able to get the response as you where looking forward to -

Perfect, thank you !