Create daily task status snapshots from Monday.com to Google Sheets
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. --- ⚙️ Set...
Template notes
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 1. In Monday.com → go to Admin → API 2. Copy your Personal API Token - Docs: [Generate Monday API Token](https://developer.monday.com/api-reference/docs/authentication) 3. In n8n → Credentials → New → Monday.com API → paste your token and save
---
2️⃣ Prepare Your Google Sheet - Copy this template to your own Google Drive: [Google Sheet Template](https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit?gid=876214427gid=876214427) - Add your data in rows 2–100. - Make sure each new task row starts with Added = No.
Connect Google Sheets in n8n 1. Go to n8n → Credentials → New → Google Sheets (OAuth2) 2. Log in with your Google account and grant access 3. In the workflow, select your Spreadsheet ID and the correct Sheet Name
---