How to Automate Sprint Reports from Trello to Slack with n8n

Workflows > + New Workflow

Create new n8n workflow

Open n8n and create a new workflow for your daily standup automation. You'll set up a scheduled trigger that runs every weekday morning. The workflow will query your Trello boards and format results for Slack.

1. 1Click the + New Workflow button
2. 2Name it 'Daily Standup Reports'
3. 3Save the workflow

Add Node > Trigger > Schedule Trigger

Add Cron Schedule trigger

Replace the manual trigger with a Cron node to run daily at 8:30 AM on weekdays. Use the cron expression to target Monday through Friday only. This ensures reports only generate during work days.

1. 1Delete the Manual Trigger node
2. 2Click + and select Schedule Trigger
3. 3Set Mode to 'Cron'
4. 4Enter cron expression: 30 8 * * 1-5

Add Node > Apps > Trello

Connect to Trello

Add a Trello node and authenticate with your account. You'll need a Trello API key and token from your account settings. This connection lets n8n read your board data and card details.

1. 1Click + after the Schedule node
2. 2Search for and select Trello
3. 3Click 'Create New' credential
4. 4Enter your API Key and Token from trello.com/app-key

Trello Node > Parameters

Configure board selection

Set the Trello node to get all cards from your sprint board. Choose the specific board from the dropdown and set filters for the data you need. This pulls all cards regardless of list position.

1. 1Set Operation to 'Get Cards'
2. 2Select your sprint board from the Board dropdown
3. 3Set 'Return All' to true
4. 4Add additional fields: due date, labels, members

Add Node > Data > Code > Function

Add date filtering logic

Insert a Function node to filter cards by completion date and due dates. This code identifies cards completed yesterday, overdue items, and upcoming deadlines. You'll process the raw Trello data into meaningful categories.

1. 1Add a Function node after Trello
2. 2Paste the date filtering JavaScript code
3. 3Set the function name to 'categorizeCards'
4. 4Connect it to the Trello output

Add Node > Data > Code > Function

Format Slack message

Add another Function node to build the Slack message format. This creates a structured report with sections for each card category. Use Slack's block kit formatting for better readability in channels.

1. 1Add a second Function node
2. 2Write code to format the daily report
3. 3Include card names, assignees, and due dates
4. 4Use Slack markdown for formatting

Add Node > Apps > Slack

Connect Slack integration

Add a Slack node and set up bot authentication. Create a Slack app in your workspace with chat:write permissions. This allows n8n to post messages to your chosen standup channel.

1. 1Add Slack node after the message formatter
2. 2Create new Slack credential
3. 3Add your Bot User OAuth Token
4. 4Set operation to 'Post Message'

Slack Node > Parameters

Configure message posting

Set the target channel and message content for your daily reports. Choose your team's standup channel and map the formatted message from the previous step. Test with a direct message first.

1. 1Select your #standup channel
2. 2Set Text to the formatted message output
3. 3Enable 'As User' to false for bot posting
4. 4Add a thread_ts if replying to a daily thread

Workflow Canvas > Execute Workflow

Test the workflow

Execute the workflow manually to verify all connections and data formatting. Check that cards are properly categorized and the Slack message appears correctly formatted. Fix any authentication or data issues before scheduling.

1. 1Click 'Execute Workflow' button
2. 2Watch each node execute and show data
3. 3Check the final Slack message in your channel
4. 4Verify card counts and formatting

Workflow Canvas > Toggle Active

Activate scheduled execution

Turn on the workflow to run automatically every weekday morning. The schedule trigger will now fire daily and generate reports. Monitor the execution history to catch any API failures or data issues.

1. 1Click the 'Inactive' toggle in the top right
2. 2Confirm activation in the dialog
3. 3Check that status shows 'Active'
4. 4Set up error notifications if desired

Paste this code into the first Function node to properly categorize cards by date ranges and handle timezone conversion for accurate reporting.

const today = new Date();
const yesterday = new Date(today);
yesterday.setDate(today.getDate() - 1);

const today = new Date();
const yesterday = new Date(today);
yesterday.setDate(today.getDate() - 1);
const threeDaysOut = new Date(today);
threeDaysOut.setDate(today.getDate() + 3);

const completed = [];
const overdue = [];
const upcoming = [];

for (const card of $input.all()) {
  const dueDate = card.json.due ? new Date(card.json.due) : null;
  const isComplete = card.json.list?.name?.toLowerCase().includes('done');
  
  // Cards completed yesterday
  if (isComplete && card.json.dateLastActivity) {
    const lastActivity = new Date(card.json.dateLastActivity);
    if (lastActivity.toDateString() === yesterday.toDateString()) {
      completed.push({
        name: card.json.name,
        members: card.json.members?.map(m => m.fullName).join(', ') || 'Unassigned',
        url: card.json.shortUrl
      });
    }
  }
  
  // Overdue cards
  if (dueDate && dueDate < today && !isComplete) {
    overdue.push({
      name: card.json.name,
      due: dueDate.toLocaleDateString(),
      members: card.json.members?.map(m => m.fullName).join(', ') || 'Unassigned',
      url: card.json.shortUrl
    });
  }
  
  // Due in next 3 days
  if (dueDate && dueDate >= today && dueDate <= threeDaysOut && !isComplete) {
    upcoming.push({
      name: card.json.name,
      due: dueDate.toLocaleDateString(),
      members: card.json.members?.map(m => m.fullName).join(', ') || 'Unassigned',
      url: card.json.shortUrl
    });
  }
}

return [{json: {completed, overdue, upcoming}}];