Slack Bot for Company research

Research companies mentioned in Slack messages and send personalized outreach emails based on revenue
Created by
Shambaditya Mukherjee
Shambaditya Mukherjee
AI Consultant
Relay.app screenshot of: Slack Bot for Company research

Steps in this workflow

1
Slack logo
Message sent to channel
2
Airtable logo
Find record(s)
3
Paths
A
Existing Record
4
Perplexity logo
Prompt Perplexity Sonar
5
Google Gemini logo
Extract with AI
6
Paths
A
Revenue < $5M
7
Airtable logo
Update record
8
Google Gemini logo
Prompt Gemini 2.5 Flash
9
Gmail logo
Send email
10
Airtable logo
Update record
23
Slack logo
Send message

Automate company research and outreach by monitoring Slack messages for company mentions. Here's how it works:

  • The workflow triggers when a message is posted to your specified Slack channel
  • AI researches the company's details including website, revenue, and funding information
  • The workflow either updates an existing Airtable record or creates a new one
  • It automatically sends personalized outreach emails based on the company's revenue tier
  • A confirmation message is sent back to Slack when the process completes
1
Slack logo
Message sent to channel

Monitors a specified Slack channel for new messages. The channel should be configured when setting up the workflow, and you can choose whether to include replies and bot messages.

Relay.app screenshot of: Message sent to channel
2
Airtable logo
Find record(s)

Searches for an existing company record in your Airtable table by matching the company name from the Slack message. If no record is found, the workflow continues without a result.

Relay.app screenshot of: Find record(s)
3
Paths
AExisting Record
BNew record
This path will be taken when the rules below match.
Relay.app screenshot of: Existing Record
Steps in Path A
4
Prompt Perplexity Sonar

Uses Perplexity AI to research the company's website and gather detailed information. The AI extracts company name, website, overview, revenue, and funding details from online sources.

Prompt used
Check the website URL you have and research the company details. Find out their current operating process. Provide the details in the following manner: Name:- Website:- Overvirew;- Revenue:- Funding:-
Relay.app screenshot of: Prompt Perplexity Sonar
5
Extract with AI

Processes the AI research output to extract structured data in a consistent format. This step ensures all company information is properly formatted for use in subsequent steps.

Prompt used
Please extract the following details from the attached ai output: - Name - Website - Overview -revenue -funding -Process -
Relay.app screenshot of: Extract with AI
6
Paths
ARevenue < $5M
BRevenue $5 to $15M
CREvenue $16M to $30M
DRevenue $30M+
This path will be taken when the rules below match.
Relay.app screenshot of: Revenue < $5M
Steps in Path A
7
Airtable logo
Update record

Updates the existing Airtable record with the researched company overview, funding report, and revenue information. This keeps your company database current with the latest information.

Relay.app screenshot of: Update record
8
Prompt Gemini 2.5 Flash

Generates a personalized introduction email using AI based on the company's profile. The email subject and body are tailored to the specific company and its characteristics.

Prompt used
Write an introduction email. Read the company details here:- [data] Subject:- "" Body:-
Relay.app screenshot of: Prompt Gemini 2.5 Flash
9
Gmail logo
Send email

Sends the generated introduction email to the configured recipient address. The email includes the personalized subject line and body content created by the AI.

Relay.app screenshot of: Send email
23
Slack logo
Send message

Posts a confirmation message back to the Slack channel indicating that the record has been updated and the email has been sent. This provides visibility into the workflow's completion.

Relay.app screenshot of: Send message