Google Sheet Columns with Slack Messages

  • 9 November 2020
  • 3 replies
  • 51 views

Userlevel 1

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?


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 6
Badge +7

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. 

Userlevel 1

Hi guys, is there also a no-code way to solve this? I have exactly the same issue :)

Userlevel 3
Badge +2

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