Capture Monday.com Task Status Daily to Google Sheets - n8n Workflow

• Project Managers who need historical records of task progression.


• Teams using Monday.com who require auditing or time-series analysis of project data.


• Users looking for robust, scheduled data logging using an n8n workflow.


• Anyone seeking ready-to-use n8n templates for integration between cloud platforms.

Keeping a historical record of project progress is crucial for auditing, performance analysis, and forecasting. Monday.com provides real-time status, but extracting snapshots of status changes over time often requires manual logging or complex API calls. This n8n workflow solves this by running a daily data extraction process. This specific n8n template provides a reliable, hands-off solution that ensures every day’s task status is logged alongside a timestamp in a centralized Google Sheet. By using this n8n node configuration, users can track metrics like 'how long did a task stay in the In Progress status' without constant manual intervention. This automation leverages the power of n8n to connect your project management data to your reporting tools effortlessly.

This automation is designed to run automatically, typically activated by a Schedule n8n trigger (which you must add to the start of the n8n workflow).

1. Trigger (Implicit Schedule n8n trigger): The workflow is initiated daily at a set time.


2. Monday.com Data Retrieval: The Monday.com n8n node queries a specified board and group, retrieving all active task items. This pulls the task name and current column values (including status).


3. Date Generation: A specialized Code n8n node runs simultaneously to calculate and store today's date (YYYY-MM-DD).


4. Field Mapping: The Set n8n node (Map Fields) processes the incoming Monday.com data, specifically extracting the task name and the status value from the column data, preparing them for the Google Sheet structure.


5. Data Combination: The Merge n8n node combines the list of mapped tasks with the single date object generated by the Code n8n node. This ensures that every row of task data injected into the spreadsheet is stamped with the correct daily date.


6. Google Sheets Append: Finally, the Google Sheets n8n node (Daily Progress to Sheet1) executes an append operation, writing the Date, Task Name, and Status fields as a new set of rows into the specified Google Sheet. This completes the daily snapshot using this highly efficient n8n workflow.

To deploy this n8n workflow successfully, follow these steps:

1. Import the n8n Workflow

1. Copy the entire provided JSON code.


2. In your n8n interface, click 'New' > 'Import from JSON' and paste the code.

2. Set Up Credentials

1. In Monday.com, navigate to Admin -> API and generate a new Personal API Token.


2. In n8n, go to Credentials, create a new 'Monday.com API' credential, and paste your token.


3. Update the Get many items2 n8n node to use this new credential.

B. Google Sheets OAuth2 Credential:

1. In n8n, create a new 'Google Sheets (OAuth2)' credential.


2. Log in with your Google Account and grant n8n the necessary access.


3. Update the Daily Progress to Sheet1 n8n node to use this credential.

3. Configure Nodes

1. Add an n8n trigger: Since this is a daily process, add a 'Schedule' n8n trigger before the Monday.com node and configure it to run at your desired time (e.g., 9:00 AM daily).


2. Monday.com Node: Update the Get many items2 n8n node with your specific Board ID and Group ID.


3. Google Sheets Node: Update the Daily Progress to Sheet1 n8n node by selecting your target Spreadsheet ID and the correct Sheet Name where the data should be logged.

This n8n workflow utilizes several key n8n node types to manage data flow and transformation:

Get many items2 (Monday.com n8n node)
Function: Acts as the primary data source, extracting tasks (items) from Monday.com.
Key Configuration: Resource set to boardItem, Operation set to getAll. Requires specific Board ID and Group ID configuration.

Map Fields (Set n8n node)
Function: Cleans up and standardizes the incoming Monday.com item data into easily recognizable columns.
Key Configuration: Maps {{ $json.name }} to Task Name and {{ $json.column_values[1].text }} to Status.

Today's Date2 (Code n8n node)
Function: Generates the current system date needed for the historical snapshot.
Key Configuration: Uses JavaScript new Date().toISOString().split('T')[0] to format the date as YYYY-MM-DD.

Merge2 (Merge n8n node)
Function: Combines the task data stream and the date stamp stream into a single set of items for final insertion.
Key Configuration: Mode set to combine and combineBy set to combineAll.

Daily Progress to Sheet1 (Google Sheets n8n node)
Function: The final action n8n node, appending the processed, dated task data into the spreadsheet.
* Key Configuration: Operation set to append. Requires correct Document ID, Sheet Name, and mappings for Date, Name, and Status columns.