Skip to main content
Question

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


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

Did this topic help you find an answer to your question?
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

Nate
Forum|alt.badge.img+6
  • Zapier Expert
  • 131 replies
  • August 23, 2021

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


 

Nate wrote:

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?


Nate
Forum|alt.badge.img+6
  • Zapier Expert
  • 131 replies
  • August 23, 2021

@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!