Adrian This workflow corresponds to n8n.io template #9409 — we link there as the canonical source.
This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.
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": "2346a47e-4dc0-4017-83f4-c45098e88319",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1568,
-288
],
"parameters": {
"rule": {
"interval": [
{
"daysInterval": 7
}
]
}
},
"typeVersion": 1
},
{
"id": "ac1a1dc4-ab83-41cc-a4f9-78f200aeb324",
"name": "Get Tasks",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1296,
-288
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ghJREX21axnMDVF5tndQMIh6MWYUJevNRV9Ji4kBG7s/edit#gid=0",
"cachedResultName": "Tasks"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1ghJREX21axnMDVF5tndQMIh6MWYUJevNRV9Ji4kBG7s",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ghJREX21axnMDVF5tndQMIh6MWYUJevNRV9Ji4kBG7s/edit?usp=drivesdk",
"cachedResultName": "Chore_scheduler"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 3
},
{
"id": "cb86134c-7f25-48f2-af87-2297386ca3be",
"name": "Get People",
"type": "n8n-nodes-base.googleSheets",
"position": [
-992,
-288
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 307557581,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ghJREX21axnMDVF5tndQMIh6MWYUJevNRV9Ji4kBG7s/edit#gid=307557581",
"cachedResultName": "Persons"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1ghJREX21axnMDVF5tndQMIh6MWYUJevNRV9Ji4kBG7s",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ghJREX21axnMDVF5tndQMIh6MWYUJevNRV9Ji4kBG7s/edit?usp=drivesdk",
"cachedResultName": "Chore_scheduler"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 3
},
{
"id": "5870874f-35ce-4b0d-8230-ec7c27fa71eb",
"name": "Send a message",
"type": "n8n-nodes-base.gmail",
"position": [
-384,
-288
],
"parameters": {
"sendTo": "={{ $('Filter Data and Assign Tasks').item.json.email }}",
"message": "=Hello {{ $('Filter Data and Assign Tasks').item.json.assigned_to }}!\n\nThe homework assigned to you this week is: {{ $('Filter Data and Assign Tasks').item.json.task }}.\n{{ $('Filter Data and Assign Tasks').item.json.description }}\n\nHave a good day!",
"options": {},
"subject": "=Task selection"
},
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "0c83e351-1158-4577-9f24-06297d7477fb",
"name": "Filter Data and Assign Tasks",
"type": "n8n-nodes-base.code",
"position": [
-688,
-288
],
"parameters": {
"jsCode": "let tasks = $items('Get Tasks');\nlet people = $items('Get People');\n\n// Filter persons without Email\npeople = people.filter(item => {\n const email = item.json.email;\n return email && email.toString().trim() !== '';\n});\n\n// Filter tasks undefined\ntasks = tasks.filter(item => {\n const task = item.json.task;\n return task && task.toString().trim() !== '';\n});\n\n// Error if there aren\u00b4t any persons\nif (people.length === 0) {\n throw new Error('No hay personas con correo electr\u00f3nico para asignar las tareas.');\n}\n\n// Assign Tasks\nconst assignments = tasks.map((taskItem, index) => {\n const personItem = people[Math.floor(Math.random() * people.length)];\n return {\n json: {\n row_number: taskItem.json.row_number,\n task: taskItem.json.task,\n description: taskItem.json.description,\n assigned_to: personItem.json.name,\n email: personItem.json.email,\n }\n };\n});\n\nreturn assignments;\n"
},
"typeVersion": 2
},
{
"id": "d5692ac3-3119-4466-a557-15bf38acb8c0",
"name": "Update assign_to in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-80,
-288
],
"parameters": {
"columns": {
"value": {
"row_number": "={{ $('Filter Data and Assign Tasks').item.json.row_number }}",
"assigned_to": "={{ $('Filter Data and Assign Tasks').item.json.assigned_to }}"
},
"schema": [
{
"id": "task",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "task",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "assigned_to",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "assigned_to",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ghJREX21axnMDVF5tndQMIh6MWYUJevNRV9Ji4kBG7s/edit#gid=0",
"cachedResultName": "Tasks"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1ghJREX21axnMDVF5tndQMIh6MWYUJevNRV9Ji4kBG7s",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ghJREX21axnMDVF5tndQMIh6MWYUJevNRV9Ji4kBG7s/edit?usp=drivesdk",
"cachedResultName": "Chore_scheduler"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "d60ce508-5931-4250-968b-79f1064ed6de",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2000,
-224
],
"parameters": {
"color": 2,
"width": 320,
"content": "## Sheets Tasks Example\n"
},
"typeVersion": 1
},
{
"id": "17b51b73-044f-4798-a939-fac4daa167df",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2016,
-672
],
"parameters": {
"color": 2,
"width": 352,
"height": 832,
"content": "## Setup steps before start\n1.\tSpreadsheet \u2013 Create a Google Sheets document with two sheets (\u201cTasks\u201d and \u201cPersons\u201d) You can see examples in the **images**.\n2.\tCreate your credential for Google Sheets with read and write permissions.\n3. Create your credential to send messages from Gmail.\n"
},
"typeVersion": 1
},
{
"id": "97d87ab3-a03d-4522-b516-3bbde84306f3",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1984,
-448
],
"parameters": {
"color": 2,
"width": 288,
"height": 208,
"content": "## Sheet Persons "
},
"typeVersion": 1
},
{
"id": "d8e31fc6-60b1-4ca5-ad1b-70b396bc53e3",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2000,
-48
],
"parameters": {
"color": 2,
"width": 320,
"height": 192,
"content": "## How to customise it\n\nChange the schedule interval to suit your rotation, edit the email template to include due dates or motivational messages, or modify the assignment script to weight tasks by difficulty. You could also send notifications via Slack or Telegram."
},
"typeVersion": 1
},
{
"id": "289e4235-712e-4b95-bace-0eb749181767",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-768,
-464
],
"parameters": {
"color": 7,
"width": 256,
"height": 352,
"content": "**Filter Data and Assign Tasks Node (Optional):** \n\nIt's preconfigured but you can or modify the assignment script to weight tasks by difficulty.\n"
},
"typeVersion": 1
},
{
"id": "ea1dd9bf-3a8c-42cf-b43e-cb5e6fe12d66",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-464,
-464
],
"parameters": {
"color": 7,
"width": 256,
"height": 352,
"content": "**Send a message node:** \n\nSelect your Gmail credential. If you want you can customise the subject and body of the email."
},
"typeVersion": 1
},
{
"id": "ee4d6fb2-e4a4-44c9-9d1a-ea348ec2ca5f",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-464
],
"parameters": {
"color": 7,
"width": 256,
"height": 352,
"content": "**Update sheet assign_to in sheet node:** \n\nThe workflow uses the row_number to match the row being updated. Ensure mapping writes the assigned person\u2019s name to the correct row. "
},
"typeVersion": 1
},
{
"id": "75fc9783-7d22-448b-bd52-559f3ec38ca6",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1072,
-464
],
"parameters": {
"color": 7,
"width": 256,
"height": 352,
"content": "**Get People Node:** \n\nSelect the credential for your Google account and search for your Persons sheet in drive.\n"
},
"typeVersion": 1
},
{
"id": "b2b88914-0526-4936-8d5a-b6215dd05eb9",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1376,
-464
],
"parameters": {
"color": 7,
"width": 256,
"height": 352,
"content": "**Get Tasks Node:** \n\nSelect the credential for your Google account and search for your Tasks sheet in drive.\n"
},
"typeVersion": 1
}
],
"connections": {
"Get Tasks": {
"main": [
[
{
"node": "Get People",
"type": "main",
"index": 0
}
]
]
},
"Get People": {
"main": [
[
{
"node": "Filter Data and Assign Tasks",
"type": "main",
"index": 0
}
]
]
},
"Send a message": {
"main": [
[
{
"node": "Update assign_to in sheet",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get Tasks",
"type": "main",
"index": 0
}
]
]
},
"Update assign_to in sheet": {
"main": [
[]
]
},
"Filter Data and Assign Tasks": {
"main": [
[
{
"node": "Send a message",
"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.
gmailOAuth2googleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow automates the assignment of household chores. It reads tasks and a list of people from Google Sheets, pairs each task with someone, updates the spreadsheet with the assignments and emails each person their chores.
Source: https://n8n.io/workflows/9409/ — 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.
YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.
Gmail, Google Drive, Google Sheets +1
Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google
Google Sheets, HTTP Request, WhatsApp +1
This workflow automatically sends a beautifully designed HTML newsletter every Sunday at 8 AM, featuring products currently on sale from your Algolia-powered e-commerce store.
Google Sheets, HTTP Request, Gmail
This n8n template demonstrates how to build a Auto Lead Gen & Outreach System for Local Businesses specifically designed to help businesses that don’t have a website yet.
Google Sheets, HTTP Request, Google Drive +1
The workflow is triggered automatically every day at 12:00 PM using a Cron node.
RSS Feed Read, Google Sheets, Gmail +1