Looping through line items with unknown/variable number of lines?

Question

I want to zap messages from Slack into a Google Sheet. I want each paragraph to be a separate line on the sheet, except the first line.

So I’m using a formatter step to split into line items using a g:newline:] delimiter, but I’m not quite sure what to do with the looping step.

The issue is not knowing how many paragraphs the Slack message will have - I might be misunderstanding how the looping step works, but is it possible to loop through multiple line items when you don’t know how many line items each thing will have?

SamB · Answer

Hi@sam-accurx, welcome to the Community!👋Yes, it’s definitely possible to loop through varyingamounts of line-items using the Create a loop from line-items event. Each time the Zap runs it would take all the line items it’s given and run through any actions in the loop foreach item individually. There doesn’t need to be a set number supplied every time.One thing I do want to also mention is that when testing in the Zap Editor it will only ever run through the first item in the loop, but when the Zap is switched on it would process the actions for each line items separately. So you’d see a new row created in Google Sheets for each paragraph of the Slack messages.Hope that helps to clarify. If you run into any trouble on that or have further questions just let us know. Always happy to help further!

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded