Skip to main content

Google Sheet Columns with Slack Messages

  • November 9, 2020
  • 3 replies
  • 80 views

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

Wemakefuture
Forum|alt.badge.img+8
  • Zapier Solution Partner
  • November 10, 2020

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
  • December 17, 2020

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


sudesh
Forum|alt.badge.img+2
  • Zapier Solution Partner
  • December 18, 2020

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