Restflow.io

## Introduction

For sales teams, staying updated on CRM changes in real time is crucial to maintain momentum in deal cycles and collaborate effectively. Manually checking the CRM or relying on email notifications can cause delays and lead to missed opportunities. Automating updates from your CRM directly into Slack channels where your team communicates saves time, reduces manual work, and keeps everyone in sync.

In this article, we’ll build a robust automation workflow using n8n, an open-source workflow automation tool, to push CRM updates to Slack instantly. This tutorial is designed for startup CTOs, automation engineers, and sales operations specialists who want to streamline communications between their CRM (such as HubSpot or Salesforce) and Slack.

—

## Problem Statement

Manual CRM notifications are inefficient. Sales reps might miss important account or deal updates, slowing sales cycles. Delays in communication can cause duplicated efforts or overlooked clients. Automating timely notifications in Slack — the hub of team communication — centralizes updates and encourages faster responses.

—

## Tools and Services Integrated

– **n8n**: Open-source workflow automation platform to orchestrate triggers and actions.
– **CRM**: HubSpot CRM (we will use HubSpot API as an example, but this can be adapted to Salesforce or others).
– **Slack**: Messaging platform where updates will be pushed to specific channels.

—

## Workflow Overview

**Trigger:** Periodic polling or webhook from HubSpot when records are updated.

**Process:** Fetch updated CRM record details.

**Action:** Format message and post to designated Slack channel.

This automation ensures that any significant updates on contacts, deals, or companies in the CRM are instantly communicated to the sales team via Slack.

—

## Step-by-Step Technical Tutorial

### Prerequisites

– Access to an n8n instance (cloud or self-hosted).
– HubSpot developer account and API key (or OAuth credentials).
– Slack workspace with permissions to create apps and post messages.

### Step 1: Create a Slack App and Get a Webhook URL

1. Go to https://api.slack.com/apps and create a new app.
2. Under “Incoming Webhooks,” activate webhooks.
3. Create a webhook URL for the target channel (e.g., #sales-updates).
4. Copy the generated webhook URL — you will use this in n8n.

### Step 2: Configure n8n Workflow

Open n8n and create a new workflow.

#### Node 1: Trigger – HubSpot Webhook or Polling

– **Option A: Using HubSpot Webhooks**
– HubSpot supports setting up webhooks on subscription events like contact or deal updates.
– Use “Webhook” node in n8n to receive payloads from HubSpot.
– In HubSpot, configure a webhook subscription using your n8n webhook endpoint URL.

– **Option B: Polling HubSpot API**
– Use the “HTTP Request” node to query endpoint like `/crm/v3/objects/deals` with a filter for recently updated records.
– Schedule this node to run every 5 minutes.

For simplicity here, we’ll proceed with polling.

#### Node 2: HTTP Request – Retrieve Updated Deals

– Use “HTTP Request” node.
– Method: GET
– URL: `https://api.hubapi.com/crm/v3/objects/deals?limit=10&properties=dealname,amount,dealstage&sorts=-lastmodifieddate`
– Add authentication in headers or query param as per HubSpot API requirements (API key or OAuth).

This node fetches the last 10 updated deals.

#### Node 3: Function – Filter New Updates

– To avoid duplicate Slack messages, store last execution timestamp externally (e.g., in a database, or leverage n8n’s workflow static data).
– In the “Function” node, compare the lastmodifieddate of fetched deals to the stored timestamp.
– Only pass deals updated after last run.
– Update stored timestamp with the latest lastmodifieddate.

Example snippet:
“`javascript
const lastRun = $workflow.getStaticData(‘lastRun’) || ‘1970-01-01T00:00:00Z’;
const deals = items.filter(item => new Date(item.json.lastmodifieddate) > new Date(lastRun));
if (deals.length > 0) {
// Update lastRun
const maxDate = deals.reduce((max, item) => new Date(item.json.lastmodifieddate) > new Date(max) ? item.json.lastmodifieddate : max, lastRun);
$workflow.setStaticData(‘lastRun’, maxDate);
return deals;
}
return [];
“`

#### Node 4: Set – Format Slack Message

– Use the “Set” node to construct a message payload for Slack.
– Format can be simple text or Slack Block Kit for rich messages.

Example message text:
“`
Sales Update: *{{dealname}}* has changed to stage: {{dealstage}} with amount ${{amount}}.
“`

You can iterate over each deal update.

#### Node 5: HTTP Request – Post to Slack

– Method: POST
– URL: The Slack webhook URL from Step 1
– Headers: `Content-Type: application/json`
– Body:
“`json
{
“text”: “{{ $json.message }}”
}
“`

Use expression to insert formatted message from previous node.

### Step 3: Execute and Test Workflow

– Run manually to verify fetching recent deals.
– Confirm only newer updates trigger messages.
– Check Slack channel for appearance of messages.

—

## Common Errors and Tips for Robustness

– **API Rate Limits:** HubSpot APIs have rate limits; ensure polling frequency respects these limits (e.g., every 5-10 minutes).
– **Error Handling:** Add error catch nodes to handle API failures gracefully and send alerts.
– **Duplicate Messages:** Use persistent storage or n8n’s static data to track last processed updates and avoid duplicates.
– **Data Security:** Protect API keys and webhook URLs using n8n credentials management.
– **Webhook vs Polling:** For real-time updates, prefer HubSpot webhooks if your plan supports it.
– **Message Formatting:** Use Slack’s Block Kit to improve readability, especially for complex data.

—

## Scaling and Adaptation

– **Multi-Record Types:** Extend the workflow to handle Contacts, Companies, or custom CRM objects by adding additional polling/webhook subscriptions.
– **Multi-Channel Notifications:** Route messages to different Slack channels by deal owner or region using conditional logic.
– **Integrate with Other Tools:** Chain further actions such as creating Jira tickets, updating Google Sheets, or notifying via SMS.
– **Advanced Filtering:** Implement business logic to filter only high-value or high-priority deals.
– **Custom Dashboards:** Aggregate updates into summary messages or dashboards posted periodically.

—

## Summary

Automating CRM updates to Slack with n8n empowers sales teams with timely insights, accelerates decision-making, and fosters collaboration. By integrating HubSpot’s API and Slack through n8n, you create a seamless, scalable notification system.

This guide provided a detailed, technical roadmap for building such a workflow, from setting up Slack incoming webhooks, querying HubSpot’s API, filtering data, formatting messages, and posting to Slack.

### Bonus Tip

For even more responsiveness, consider using HubSpot’s native webhook subscriptions instead of polling. This reduces API usage and delivers events in real time to n8n’s webhook node, enhancing efficiency and speed.

—

Harness the power of workflow automation with n8n to keep your sales team informed and ahead of the curve!