Question

Want to extract Slack messages containing specific keywords and add to Google Sheets

  • 23 August 2021
  • 3 replies
  • 527 views

Hey folks,

Have a slack channel from where I want to extract only certain messages that have a specific keyword and send them to a google sheet where its auto split into different columns. How do I go about it?

Example of a slack message: 
org name

org id 

org phone number

 

want this in 3 seperate google sheet columns

to summarize:
1. extract certain messages and send to google sheet
2. split that into certain columns


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 5
Badge +6

Hi @Manan Agarwal,

For part 1 you can use a filter step to extract the messages with specific keywords. 

For part 2, how is the text formatted? We would need to identify a word separator so we can split them up into separate fields. 

I hope this helps! 

Nathan - flow.digital

 

Hi @Manan Agarwal,

For part 1 you can use a filter step to extract the messages with specific keywords. 

For part 2, how is the text formatted? We would need to identify a word separator so we can split them up into separate fields. 

I hope this helps! 

Nathan - flow.digital

Hi @Nate , for part 2 the slack message is in the following format:
Org details

Org name:
Org Id:

Admin details

People Id:

People name:

and so on, how do i separate the org name/org id etc  into different columns?

Userlevel 5
Badge +6

@Manan Agarwal in that case you should be able to extract the fields with the Formatter by Zapier split text action. Split by “Org name:” to get the org name and so on. 

Let us know how it goes!