📋 Daily Trello task tracker with Google Sheets history log
⚡ 1,588 views · 📋 Project Management
Description
This workflow pulls all tasks from your Trello board every day and logs them into a Google Sheet.
Use it to track project progress, due dates, and keep a daily snapshot of your board’s status.
⚙️ Setup Instructions
1️⃣ Connect Trello (Developer API)
- Get your API key: Trello App Key
- On the same page, generate a Token (click Token)
- In n8n → Credentials → New → Trello API, paste your API Key + Token, then save.
- Open each Trello node (Get Board, Get Lists, Get Cards) and select your Trello credential.
🧠 How It Works
- Schedule Trigger: Runs daily (can be customized).
- Get Board → Get Lists → Get Cards: Pulls every task, its list, due date, and description.
- Map Fields: Normalizes the data (board name, list name, task name, description, due date, URL).
- Today’s Date Node: Adds a timestamp column so each run is logged.
- Google Sheets (Append): Appends all task rows into a sheet → creating a daily history log.
📬 Contact
Need help customizing this (e.g., filtering by list, or sending reports by email/Slack)?
📧 rbreen@ynteractive.com
🔗 Robert Breen
🌐 ynteractive.com
🔗 Nodes Used
Google Sheets, Trello, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File