n8nflow.net logo

Daily Trello Task Tracker with Google Sheets History Log

by Robert Breenβ€’Updated: Last update a month agoβ€’Source: n8n.io

Getting Started

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