Robert Breen This workflow corresponds to n8n.io template #7739 — we link there as the canonical source.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "fafaf19e-d738-481c-b6c7-715c3d2540ca",
"name": "Sticky Note48",
"type": "n8n-nodes-base.stickyNote",
"position": [
1840,
4944
],
"parameters": {
"color": 7,
"width": 1248,
"height": 928,
"content": "# \ud83d\udccb Monday.com \u2192 Google Sheets Daily Task Status \n\nThis workflow pulls all tasks from your **Monday.com board** each day and logs them into a **Google Sheet**. \nIt creates a daily snapshot of your project\u2019s progress and statuses. \n\n\n"
},
"typeVersion": 1
},
{
"id": "2f7712dd-4e3e-4268-b9c7-252e50d3a85e",
"name": "Map Fields",
"type": "n8n-nodes-base.set",
"position": [
2320,
5344
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d0236a8a-8129-4370-b241-9e27adcb9952",
"name": "Task Name",
"type": "string",
"value": "={{ $json.name }}"
},
{
"id": "4183c1c0-e306-4234-845d-4cb5d0009008",
"name": "Status",
"type": "string",
"value": "={{ $json.column_values[1].text }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "cbe08309-9967-4f39-9cc3-754e69a2a57e",
"name": "Sticky Note57",
"type": "n8n-nodes-base.stickyNote",
"position": [
1920,
5312
],
"parameters": {
"color": 3,
"width": 224,
"height": 448,
"content": "### 1\ufe0f\u20e3 Connect Monday.com API \n1. In **Monday.com** \u2192 go to **Admin \u2192 API** \n2. Copy your **Personal API Token** \n - Docs: [Generate Monday API Token](https://developer.monday.com/api-reference/docs/authentication) \n3. In **n8n \u2192 Credentials \u2192 New \u2192 Monday.com API** \u2192 paste your token and save \n"
},
"typeVersion": 1
},
{
"id": "99184ab6-ac8a-4119-930f-bf0c2079aecc",
"name": "Merge2",
"type": "n8n-nodes-base.merge",
"position": [
2800,
5200
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineAll"
},
"typeVersion": 3.2
},
{
"id": "6541e0f5-f179-45e0-a6b8-a0d04055375d",
"name": "Today's Date2",
"type": "n8n-nodes-base.code",
"position": [
2416,
5104
],
"parameters": {
"jsCode": "return [\n {\n json: {\n badges: {\n today: new Date().toISOString().split('T')[0] \n }\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "34c78214-269a-4ade-8f7d-a1e41adb1819",
"name": "Sticky Note14",
"type": "n8n-nodes-base.stickyNote",
"position": [
1392,
4944
],
"parameters": {
"width": 400,
"height": 928,
"content": "## \u2699\ufe0f Setup Instructions \n\n### 1\ufe0f\u20e3 Connect Monday.com API \n1. In **Monday.com** \u2192 go to **Admin \u2192 API** \n2. Copy your **Personal API Token** \n - Docs: [Generate Monday API Token](https://developer.monday.com/api-reference/docs/authentication) \n3. In **n8n \u2192 Credentials \u2192 New \u2192 Monday.com API** \u2192 paste your token and save \n\n---\n\n### 2\ufe0f\u20e3 Prepare Your Google Sheet \n- Copy this template to your own Google Drive: [Google Sheet Template](https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit?gid=876214427#gid=876214427) \n- Add your data in rows 2\u2013100. \n- Make sure each new task row starts with `Added = No`. \n\n#### Connect Google Sheets in n8n \n1. Go to **n8n \u2192 Credentials \u2192 New \u2192 Google Sheets (OAuth2)** \n2. Log in with your Google account and grant access \n3. In the workflow, select your **Spreadsheet ID** and the correct **Sheet Name** \n\n\n\n## \ud83d\udcec Contact \nNeed help customizing this (e.g., filtering by status, emailing daily reports, or adding charts)? \n\n\ud83d\udce7 **robert@ynteractive.com** \n\ud83d\udd17 **[Robert Breen](https://www.linkedin.com/in/robert-breen-29429625/)** \n\ud83c\udf10 **[ynteractive.com](https://ynteractive.com)**\n"
},
"typeVersion": 1
},
{
"id": "4c139763-0b8b-4f50-8f87-91dd701f91d7",
"name": "Daily Progress to Sheet1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2720,
5696
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $json.badges.today }}",
"Name": "={{ $json['Task Name'] }}",
"Status": "={{ $json.Status }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 876214427,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit#gid=876214427",
"cachedResultName": "Sheet2"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit?usp=drivesdk",
"cachedResultName": "New Monday Tasks"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "a31b430c-022b-44ed-bd41-218b8fdcd263",
"name": "Get many items2",
"type": "n8n-nodes-base.mondayCom",
"position": [
1984,
5632
],
"parameters": {
"boardId": "9865886546",
"groupId": "new_group29179",
"resource": "boardItem",
"operation": "getAll"
},
"credentials": {
"mondayComApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "8ca935cc-a8ec-44ed-ae8c-08a362730d72",
"name": "Sticky Note26",
"type": "n8n-nodes-base.stickyNote",
"position": [
2528,
5424
],
"parameters": {
"color": 3,
"width": 448,
"height": 432,
"content": "### 2\ufe0f\u20e3 Prepare Your Google Sheet \n- Copy this template to your own Google Drive: [Google Sheet Template](https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit?gid=876214427#gid=876214427) \n- Add your data in rows 2\u2013100. \n- Make sure each new task row starts with `Added = No`. \n\n#### Connect Google Sheets in n8n \n1. Go to **n8n \u2192 Credentials \u2192 New \u2192 Google Sheets (OAuth2)** \n2. Log in with your Google account and grant access. \n3. In the workflow, select your **Spreadsheet ID** and the correct **Sheet Name**. \n"
},
"typeVersion": 1
}
],
"connections": {
"Merge2": {
"main": [
[
{
"node": "Daily Progress to Sheet1",
"type": "main",
"index": 0
}
]
]
},
"Map Fields": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 1
}
]
]
},
"Today's Date2": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 0
}
]
]
},
"Get many items2": {
"main": [
[
{
"node": "Map Fields",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApimondayComApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
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. In Monday.com → go to Admin → API Copy your Personal API Token Docs:…
Source: https://n8n.io/workflows/7739/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow checks a Google Sheet for new tasks (marked ) and automatically creates them in a Monday.com board. Once added, the workflow updates the sheet to mark the task as . Copy this template to
Are you tired of manually entering open house visitor information into your CRM? Losing hot leads because you didn't follow up fast enough? This powerful n8n workflow automatically syncs every SignSna
ASM Investigator Enrichment. Uses googleSheets, httpRequest. Manual trigger; 15 nodes.
This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.
This n8n workflow automates bulk AI video generation using Freepik's Image-to-Video API powered by Minimax Hailuo-02-768p. It reads video prompts from a Google Sheet, generates multiple variations of