Pabbly formatting JSON from GSheets

Status: Closed · Asked by NPSource-dev on · 0 views

NPSource-dev — Question ·

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

Pabbly — Reply ·

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 -

NPSource-dev — Reply ·

Perfect, thank you !

Back to all forum threads · Log in to reply