How to Send Weekly Pipeline Summaries to Slack with N8n

Workflows > + > Schedule Trigger

Create new workflow and add Schedule trigger

Start with N8n's Cron trigger to fire every Monday at 8 AM. This runs on your server timezone, so adjust accordingly.

1. 1Click the purple + button in N8n dashboard
2. 2Select 'Schedule Trigger' from the trigger list
3. 3Set expression to '0 8 * * 1' for Mondays at 8 AM
4. 4Click 'Execute Node' to test the timing

Node > Salesforce > Credentials

Connect Salesforce node

Add Salesforce credentials and configure the API connection. You'll need admin access to generate a connected app.

1. 1Click + after the Schedule node
2. 2Search for 'Salesforce' in the app list
3. 3Select 'Create new credential'
4. 4Enter your Salesforce instance URL, Client ID, and Client Secret
5. 5Click 'Authenticate' and authorize N8n in the popup

Salesforce Node > Query Operation

Query all pipeline opportunities

Set up SOQL query to pull active opportunities with stage, amount, and close date. This gets raw data for processing.

1. 1Set Operation to 'Query'
2. 2Paste SOQL: SELECT Id, Name, StageName, Amount, CloseDate FROM Opportunity WHERE IsClosed = false
3. 3Check 'Return All' to get complete dataset
4. 4Click 'Test step' to verify data returns

Node > Function > JavaScript Code

Add Function node for data processing

Transform the Salesforce data into summary statistics. Calculate totals by stage and identify deals closing this week.

1. 1Click + after Salesforce node
2. 2Select 'Function' from the Data section
3. 3Choose 'Run Once for All Items' mode
4. 4Paste the JavaScript code to group and sum deals by stage
5. 5Add logic to filter deals closing within 7 days

Function Node > Message Formatting

Format the Slack message

Build the weekly summary message with proper Slack formatting. Use blocks for clean presentation.

1. 1Add another Function node after the first
2. 2Create Slack blocks JSON structure
3. 3Insert calculated values using template literals
4. 4Add emoji and formatting for readability
5. 5Format currency values with toLocaleString()

Slack Node > Credentials

Connect Slack credentials

Add your Slack bot token to post messages. The bot needs chat:write permission for your target channel.

1. 1Click + and select 'Slack' from apps
2. 2Choose 'Create new credential'
3. 3Paste your Bot User OAuth Token (starts with xoxb-)
4. 4Test connection by clicking 'Test'
5. 5Verify bot appears in your Slack workspace

Slack Node > Post Message

Configure Slack message posting

Set up the Slack node to post your formatted summary to the sales channel. Map the blocks from your Function node.

1. 1Set Resource to 'Message' and Operation to 'Post'
2. 2Enter your channel name (e.g., #sales)
3. 3Toggle 'Blocks' option to ON
4. 4Map blocks field to output from formatting Function
5. 5Set username to 'Pipeline Bot' or similar

Workflow > Settings > Error Handling

Add error handling

Set up error notification so you know if the weekly report fails. Routes errors to a different Slack channel.

1. 1Click workflow Settings in top menu
2. 2Enable 'Error Workflow' option
3. 3Create simple error workflow with Slack notification
4. 4Test by temporarily breaking the Salesforce query
5. 5Verify error message posts to #alerts channel

Workflow > Execute

Test full workflow execution

Run the complete workflow manually to verify all steps work together. Check data accuracy against Salesforce.

1. 1Click 'Execute Workflow' button in top toolbar
2. 2Watch each node turn green in sequence
3. 3Verify the Slack message posts correctly
4. 4Compare totals against Salesforce reports
5. 5Check that this week's deals are accurate

Workflow > Active Toggle

Activate scheduled execution

Turn on the workflow to run automatically every Monday. Monitor the first few executions to ensure reliability.

1. 1Toggle the 'Active' switch in top right to ON
2. 2Workflow status changes to 'Active' with green dot
3. 3Check execution history after first Monday run
4. 4Verify timing matches your expectations
5. 5Set up execution log monitoring

Drop this into an n8n Code node.

// Group deals by stage and calculate totals
const deals = items[0].json;
const summary = deals.reduce((acc, deal) => {

// Group deals by stage and calculate totals
const deals = items[0].json;
const summary = deals.reduce((acc, deal) => {
  const stage = deal.StageName;
  acc[stage] = acc[stage] || { count: 0, total: 0 };
  acc[stage].count++;
  acc[stage].total += deal.Amount || 0;
  return acc;
}, {});