Our slack messages come in 3 lines like this:
-words
-numbers
-a hyperlink
Is there anyway to get all 3 lines into 3 separate Google Sheet columns for better organization?
Google Sheet Columns with Slack Messages
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+8- Zapier Solution Partner
Yes you can go with regex in code by Zapier and python and check for linebreaks then just create an array/variable and map it to google sheet.
- Beginner
Hi guys, is there also a no-code way to solve this? I have exactly the same issue :)
+2- Zapier Solution Partner
You can use "Formatter by Zapier" as well, this way you won't need to do any custom coding.
You just need to select "Formatter by Zapier" App and "Text" in its Action Event.
Zapier will then show you a dropdown where you select one of the available operations or transforms to perform. There you need to choose "Split Text".
After selecting a transform, on the next screen enter or map your input in the input field, put [:newline:] in the Separator field, and select "All (as Separate fields)" in Segment Index. As shown in the screenshot and test it. You will definitely get the desired output.
https://prnt.sc/w5bady
https://prnt.sc/w5b9se
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.