• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Split comma separated list and create a row for each item Google sheet

Status
Not open for further replies.

PRPA

Member
Hi, how do I send the individial items from a comma separated list to a Google sheet please?

I have a list ItemA, ItemB, ItemC.

Each item is separated by a comma.

I use the Pabbly Connect Text Fromatter Split text to separate the items/split them.

This gives me the result:

Result0=ItemA
Result1=ItemB
Result2=ItemC

Now I want to send each of the item to a Google sheet so that each is on its own line.

I use the action step Google Sheet > Add multiple rows.

But this allows me to enter only one item to one row.

How do I add ItemB and ItemC to the Google sheet please? That is how do I get the action to fill the other rows?

Or do I have to copy the action step and repeat for the number of items in the list?

(The above lits with just 3 items is just an example, I will be working with lists of various lengths.)

Thanks.

(I want this to be done automatically. I know that I can send the complete list to Google sheets and then its function Split text into columns and then Transpose to rows, but this is not automated.)
 

Supreme

Well-known member
Staff member
Hey @PRPA

Kindly use the "Google Sheets: Add Multiple Rows" action step to pass multiple items in every new row for a new item bypassing the comma-separated value.

 
Status
Not open for further replies.
Top