• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Query - Urgent

Devarsh

Member
In Pabbly Connect Action - Google Sheet, how to make label value as key value? because json extractor cannot read label value
 

Pabbly

Administrator
Staff member
In Pabbly Connect Action - Google Sheet, how to make label value as key value? because json extractor cannot read label value
We're not getting what exactly you're trying to do. Please create a video and explain what exactly you're looking forward to doing.

You can make use of this software for creating a video - https://www.loom.com/looms
 

Devarsh

Member
We're not getting what exactly you're trying to do. Please create a video and explain what exactly you're looking forward to doing.

You can make use of this software for creating a video - https://www.loom.com/looms
Here, I want data as image 1
but I am getting image 2(https://forum.pabbly.com/attachments/1653302384856-png.11129/).

1653302561515.png
 
Last edited:
P

Pabblymember11

Guest
Hey @Devarsh

You might be got confused since you are not passing the complete range of the Row as it is available in your Google Sheets. Please check out the following screenshot for your better understanding.

2022-05-23_16h30_40.png
 

Devarsh

Member
Thank you
No, this does not help, even this keeps it as Label and Value. I need Key Value. I followed your youtube video still the same issue occurs.
Kindly arrange a call so I can explain, It's a little urgent.
 
P

Pabblymember11

Guest
Hey @Devarsh

You have to use the "Iterator" action step which will process all the array data one by one in the Key-Value pair.

You can also refer to the following video tutorial for your better understanding.


Kindly arrange a call so I can explain, It's a little urgent,
As of now, we are not proving any assistance on call but you can record a video on your concern. So that we can look into it and can guide you accordingly.
 

Devarsh

Member
Hey @Devarsh

You have to use the "Iterator" action step which will process all the array data one by one in the Key-Value pair.

You can also refer to the following video tutorial for your better understanding.



As of now, we are not proving any assistance on call but you can record a video on your concern. So that we can look into it and can guide you accordingly.
The video that you sent is not useful. I even used iterator but it doesn't help.

In this video at 8:20 you will see key-value after sheet is attached but I see label and value as shown in the image sent earlier. Kindly help out
 
P

Pabblymember11

Guest
Hey @Devarsh

As we can see from your workflow, you are getting the data in the Key-Value pair now.

Please check again and let us know if that is working for you.

2022-05-24_10h40_13.png
 
Top