Summarize Trello board activity with Gemini and send updates to Slack

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

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