santhosh18
Member
I am getting an output in the form of a JSON object file from Phantombustor. I want to upload the data in json to Google sheets with new row entries.. how o do implement this in pablyconnect
-
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:
- Pabbly Connect
- Pabbly Subscription Billing
- Pabbly Email Marketing
- Pabbly Form Builder
- Pabbly Email Verification
- Pabbly Hook
- Pabbly Chatflow
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 $249 — View Offer
- 🔥 Pabbly Subscription Billing — Lifetime Access for $249 — View Offer
- 🔥 Pabbly Chatflow — Lifetime Access for $249 — View Offer
Make a one-time investment and enjoy the advantages of robust business management tools for years to come.
-
I want to send a JSON object containing n entries to a Google sheet. how do I do it?
- Thread starter santhosh18
- Start date
- Status
P
Pabblymember11
Guest
Hey @ssanthosh18
Can you please share the workflow URL once and from where you are getting the JSON data to be passed in Google Sheets?
Can you please share the workflow URL once and from where you are getting the JSON data to be passed in Google Sheets?
santhosh18
Member
Hi,
This is the workflow URL .https://connect.pabbly.com/workflow/share/DERWZF8IUDMFTwNpUgFUcwoeBABUDgY7XEVTQQEOUytaAARRUxILYQxAVHZXNlAxBE0HbVIOBD4JHQIGVQMGdVNKUkBcXwB6WhcDeAVIWmkMUlZ-Xz4#
The Phantombustor generates the output through an API command. I want the JSON data to be passed to a Google sheet in a single step instead of using an Iterator
This is the workflow URL .https://connect.pabbly.com/workflow/share/DERWZF8IUDMFTwNpUgFUcwoeBABUDgY7XEVTQQEOUytaAARRUxILYQxAVHZXNlAxBE0HbVIOBD4JHQIGVQMGdVNKUkBcXwB6WhcDeAVIWmkMUlZ-Xz4#
The Phantombustor generates the output through an API command. I want the JSON data to be passed to a Google sheet in a single step instead of using an Iterator
P
Pabblymember11
Guest
Have you used the Line Itemizer action step and can you use the Add Multiple Rows action step which will process the JSON in a spereated manner?
(Watch the last part of the video lesson on how you can apply it to your workflow)
santhosh18
Member
thanks.. it helped..
One more doubt i have.
Is there a way to spilt the json objects into parts then upload it in google sheets..
Google sheets has a limit for entering multiple lines to 60 per minute.. i want to bypass this..
If my json has more than 60 lines of data then I am not able to add it to the sheets..
Can you pls help me out
One more doubt i have.
Is there a way to spilt the json objects into parts then upload it in google sheets..
Google sheets has a limit for entering multiple lines to 60 per minute.. i want to bypass this..
If my json has more than 60 lines of data then I am not able to add it to the sheets..
Can you pls help me out
P
Pabblymember11
Guest
Hey @ssanthosh18
You can make use of the Code by Pabbly action step to break the JSON into two parts or more. With the help of OpenAI, you generate the code accordingly.
You can make use of the Code by Pabbly action step to break the JSON into two parts or more. With the help of OpenAI, you generate the code accordingly.
santhosh18
Member
Thanks for the idea...
Thanks a lot
Thanks a lot
- Status
