Create daily task status snapshots from Monday.com to Google Sheets
Ready for 3.0What this workflow does
This workflow has 5 nodes and runs from “Today's Date” (no trigger node, so run it manually or call it from another workflow). Along the way it connects Google Sheets and Monday.com.
How it runs
Trigger: From “Today's Date” (no trigger node, so run it manually or call it from another workflow).
- Today's Date (Code): runs custom JavaScript code
- Get many items (Monday.com): get many (board item)
- Merge: merges the data from its input branches
- Map Fields (Edit Fields (Set)): sets 2 fields: Task Name, Status
- Daily Progress to Sheet (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Monday.com
n8n-nodes-base.mondayCom
From the author
This workflow pulls all tasks from your Monday.com board each day and logs them into a Google Sheet. It creates a daily snapshot of your project’s progress and statuses for reporting, tracking, or analysis. --- ⚙️ Setup Instructions 1️⃣ Connect Monday.com API…