Summarize Trello board activity with Gemini and send updates to Slack

Description

Summarize Trello board activity with Gemini AI and post updates to Slack

Who is this for

Project managers and development teams using Trello for task management who want automated daily standup summaries without manual effort. Perfect for remote teams that need consistent project visibility and communication.

What it does

This workflow automatically generates intelligent daily standup reports from your Trello board activity. Every business day at 5 PM, it collects cards created and updated during the day, sends the data to Gemini AI for analysis, and distributes a human-readable summary via Slack and email. The workflow also logs daily metrics to Google Sheets and sends alerts for overdue cards.

The AI summary includes activity stats, new work highlights, progress updates, blockers, and suggested priorities for the next day.

How to set up

Connect your Trello, Slack, Gmail, and Google Sheets accounts in n8n
Get a Gemini API key from Google AI Studio and add it as an HTTP header credential
Replace placeholder values in the Configuration Settings node: your Trello board ID, Slack channel, team email addresses, and Google Sheets ID
Create a "Standup Metrics" sheet in your Google Sheets with columns: Date, New Cards, Updated Cards, Overdue Cards, Board ID
Test with a manual execution before enabling the schedule

Requirements

Trello account with API access
Slack workspace with bot permissions
Gmail account
Google Sheets document
Gemini API key (free tier available)

How to customize

Modify the Gemini prompt in the Generate AI Summary node to change the summary style or add specific insights. Adjust the schedule trigger timing, change the overdue threshold logic in the code node, or extend to multiple Trello boards by duplicating the data collection nodes.