Daily Trello Task Status Logger to Google Sheets - n8n Workflow

Project Managers needing daily historical reports of Trello board status.
Automation Engineers looking for robust n8n templates for data logging.
Teams requiring persistent, historical tracking of task progress outside of Trello.
Users who want to leverage the power of the n8n node for scheduled data extraction.

This powerful automation solves the common problem of losing historical context on task boards. Trello is dynamic; cards move, and descriptions change. Without external logging, you only see the current state. This specific n8n workflow acts as a daily archivist, ensuring that every task, its list status, and due date are timestamped and logged into a Google Sheet.

By using this reliable n8n template, project stakeholders can analyze daily progress over weeks or months, greatly enhancing oversight and reporting capabilities. This is a foundational n8n workflow for seamless project management reporting and historical data preservation. Every Trello operation relies on dedicated n8n node configuration to maintain data integrity.

1. The n8n trigger, a Schedule Trigger, initiates the flow daily at a preset time.


2. The n8n workflow first retrieves the main Trello board details (Get Board2).


3. Next, it iterates through all lists (Get Lists2) available on that board using a dedicated Trello n8n node.


4. For each list, the n8n node (Get Cards2) pulls all relevant task card information, including names, descriptions, and due dates.


5. Simultaneously, a custom n8n code node (Today's Date1) generates today's date timestamp.


6. The Map Fields2 n8n node standardizes the Trello data structure, ensuring consistent column names like "List Name" and "Task Name."


7. All data streams (tasks and timestamp) are combined using the Merge n8n node.


8. Finally, the Google Sheets n8n node appends all processed task items as new rows, creating the continuous daily progress log, making this an essential n8n template for historical tracking.

1. Import the n8n workflow: Copy the provided JSON data and paste it directly into your n8n instance's canvas.


2. Trello Credentials Setup:

1. Activate: Ensure the initial Schedule Trigger n8n node is active to run the daily n8n workflow automatically.

Schedule Trigger: The starting n8n trigger for this automation. It runs on a configured daily interval, ensuring a consistent snapshot of the Trello board status.
Trello Nodes (Get Board, Get Lists, Get Cards): These sequence of Trello n8n nodes handle the core data extraction. They are chained together, with each subsequent node dynamically fetching data based on the ID passed from the previous step. This forms the data gathering segment of the n8n workflow.
Today's Date1 (Code n8n node): A custom JavaScript code node that generates the current date (today: new Date().toISOString().split('T')[0]) in the required format, vital for timestamping the daily log entries.
Map Fields2 (Set n8n node): This n8n node is crucial for data normalization. It uses expressions to pull specific values (e.g., card URL, list name) from the rich Trello payload and map them to clean, consistent output fields for the Google Sheets n8n node.
Merge1 (Merge n8n node): Combines the standardized task items with the single date item generated by the code n8n node, ensuring every task record in the n8n workflow includes the daily timestamp.
Daily Progress to Sheet (Google Sheets n8n node): The final output node. It uses the Append operation to write all collected and processed data items into the configured Google Sheet document, completing the historical logging function of this n8n template.