Robert Breen This workflow corresponds to n8n.io template #7736 — 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 →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "a0911000-e46e-4997-bf20-2dcc78a6a00c",
"name": "Sticky Note63",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1392,
10160
],
"parameters": {
"color": 7,
"width": 1488,
"height": 928,
"content": "# \u2705 Google Sheets to Monday.com Task Creator\n\nThis workflow checks a **Google Sheet** for new tasks (marked `Added = No`) and automatically creates them in a **Monday.com board**. \nOnce added, the workflow updates the sheet to mark the task as `Added = Yes`.\n"
},
"typeVersion": 1
},
{
"id": "17687765-c41a-4418-8b7f-887ab0e3fcdc",
"name": "Sticky Note21",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1840,
10160
],
"parameters": {
"width": 400,
"height": 928,
"content": "## \u2699\ufe0f Setup Instructions\n\n### 1\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- First row should contain **column names** \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 **Worksheet Name**. \n4. Optional: You can connect Airtable, Notion, or your database instead of Google Sheets. \n\n---\n\n### 2\ufe0f\u20e3 Connect Monday.com Node\n1. In **Monday.com** \u2192 go to your **Admin \u2192 API** \n - Copy your **Personal API Token** \n - Docs: [Generate Monday API Token](https://developer.monday.com/api-reference/docs/authentication) \n2. In **n8n** \u2192 **Credentials \u2192 New \u2192 Monday.com API** \n - Paste your token and save. \n3. Open the **Create Monday Task** node \u2192 choose your credential \u2192 select your **Board ID** and **Group ID**. \n\n---\n\n## \ud83d\udcec Contact\nNeed help customizing this (e.g., mapping more fields, syncing statuses, or updating timelines)? \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": "bbff1f85-e15d-4a49-9e78-5e283939a630",
"name": "Get new Monday Tasks",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1152,
10880
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "No",
"lookupColumn": "Added"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit#gid=0",
"cachedResultName": "Sheet1"
},
"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": "6a7a191e-f507-4e7e-8aea-3ca08c03b9d2",
"name": "Create Monday Task",
"type": "n8n-nodes-base.mondayCom",
"position": [
-288,
10768
],
"parameters": {
"name": "={{ $json.Task }}",
"boardId": "9865886546",
"groupId": "new_group29179",
"resource": "boardItem",
"additionalFields": {}
},
"credentials": {
"mondayComApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "a4fb3aaa-dcc3-44e9-8724-15ab99a589e6",
"name": "Mark row as Completed",
"type": "n8n-nodes-base.googleSheets",
"position": [
-720,
10432
],
"parameters": {
"columns": {
"value": {
"Task": "={{ $json.Task }}",
"Added": "Yes"
},
"schema": [
{
"id": "Task",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Task",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Added",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Added",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Task"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit#gid=0",
"cachedResultName": "Sheet1"
},
"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": "c40bab9e-f109-4c4a-a460-c87e6c10ec36",
"name": "Sticky Note67",
"type": "n8n-nodes-base.stickyNote",
"position": [
-352,
10416
],
"parameters": {
"color": 3,
"width": 224,
"height": 480,
"content": "### 2\ufe0f\u20e3 Connect Monday.com Node\n1. In **Monday.com** \u2192 go to your **Admin \u2192 API** \n - Copy your **Personal API Token** \n - Docs: [Generate Monday API Token](https://developer.monday.com/api-reference/docs/authentication) \n2. In **n8n** \u2192 **Credentials \u2192 New \u2192 Monday.com API** \n - Paste your token and save. \n3. Open the **Create Monday Task** node \u2192 choose your credential \u2192 select your **Board ID** and **Group ID**. \n"
},
"typeVersion": 1
},
{
"id": "bfb1cf14-2e89-40de-ba2e-1d0a4aec9c6d",
"name": "Sticky Note24",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1344,
10592
],
"parameters": {
"color": 3,
"width": 512,
"height": 432,
"content": "### 1\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 "
},
"typeVersion": 1
}
],
"connections": {
"Create Monday Task": {
"main": [
[]
]
},
"Get new Monday Tasks": {
"main": [
[
{
"node": "Create Monday Task",
"type": "main",
"index": 0
},
{
"node": "Mark row as Completed",
"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
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
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 your own Google Drive: Google Sheet Template First row should contain column…
Source: https://n8n.io/workflows/7736/ — 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 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 ana
Google Sheets, Monday.com
Import Json Data Into Google Sheets And Csv File. Uses httpRequest, googleSheets, spreadsheetFile, stickyNote. Manual trigger; 6 nodes.
HTTP Request, Google Sheets, Spreadsheet File
Moving metrics from Google Sheets to Orbit. Uses orbit, googleSheets. Manual trigger; 6 nodes.
Orbit, Google Sheets
This workflow gets data from an API and exports it into Google Sheets and a CSV file.
HTTP Request, Google Sheets, Spreadsheet File
Add Data From Google Sheet To Dropbox. Uses googleSheets, spreadsheetFile, dropbox, interval. Manual trigger; 4 nodes.
Google Sheets, Spreadsheet File, Dropbox