Daily Trello Task Tracker with Google Sheets History Log

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)

1. Get your API key : Trello App Key
2. On the same page, generate a Token (click Token)
3. In n8n → Credentials → New → Trello API , paste your API Key + Token , then save.
4. 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)?

📧 [email protected]
🔗 Robert Breen
🌐 ynteractive.com