This workflow follows the Google Sheets → HTTP Request 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 →
{
"nodes": [
{
"id": "8e3f167d-cbeb-4f7f-a867-c356d2dca9d0",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
1580,
240
],
"parameters": {
"options": {},
"fieldToSplitOut": "rows"
},
"typeVersion": 1
},
{
"id": "19370d12-f6de-44a1-91a6-da097abdf7de",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"position": [
1780,
240
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7343c80f-37f3-4bb5-84d8-9f21f8a350cd",
"name": "Keyword",
"type": "string",
"value": "={{ $json.keys[0] }}"
},
{
"id": "436e7c8b-2df2-40a9-97af-597dc00cf143",
"name": "clicks",
"type": "number",
"value": "={{ $json.clicks }}"
},
{
"id": "5b4aaffe-391a-4c9d-8249-f447397a3f5d",
"name": "impressions",
"type": "number",
"value": "={{ $json.impressions }}"
},
{
"id": "33677237-57fe-48f4-aff8-72ae81b5f5a2",
"name": "ctr",
"type": "number",
"value": "={{ $json.ctr }}"
},
{
"id": "f961deee-d222-4df7-a7ff-b7286405e4a7",
"name": "position",
"type": "number",
"value": "={{ $json.position }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9eae4908-5266-439c-a66b-5679036234de",
"name": "Split Out1",
"type": "n8n-nodes-base.splitOut",
"position": [
1580,
440
],
"parameters": {
"options": {},
"fieldToSplitOut": "rows"
},
"typeVersion": 1
},
{
"id": "b05926b1-507f-4531-a05c-a15e835ee82e",
"name": "Edit Fields1",
"type": "n8n-nodes-base.set",
"position": [
1780,
440
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7343c80f-37f3-4bb5-84d8-9f21f8a350cd",
"name": "page",
"type": "string",
"value": "={{ $json.keys[0] }}"
},
{
"id": "436e7c8b-2df2-40a9-97af-597dc00cf143",
"name": "clicks",
"type": "number",
"value": "={{ $json.clicks }}"
},
{
"id": "5b4aaffe-391a-4c9d-8249-f447397a3f5d",
"name": "impressions",
"type": "number",
"value": "={{ $json.impressions }}"
},
{
"id": "33677237-57fe-48f4-aff8-72ae81b5f5a2",
"name": "ctr",
"type": "number",
"value": "={{ $json.ctr }}"
},
{
"id": "f961deee-d222-4df7-a7ff-b7286405e4a7",
"name": "position",
"type": "number",
"value": "={{ $json.position }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "42321587-2565-4a0a-9d9d-25cbfdeb9f49",
"name": "Split Out2",
"type": "n8n-nodes-base.splitOut",
"position": [
1580,
620
],
"parameters": {
"options": {},
"fieldToSplitOut": "rows"
},
"typeVersion": 1
},
{
"id": "9e25eef9-daa4-47dd-b2cf-03cfebadb5c6",
"name": "Edit Fields2",
"type": "n8n-nodes-base.set",
"position": [
1780,
620
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7343c80f-37f3-4bb5-84d8-9f21f8a350cd",
"name": "date",
"type": "string",
"value": "={{ $json.keys[0] }}"
},
{
"id": "436e7c8b-2df2-40a9-97af-597dc00cf143",
"name": "clicks",
"type": "number",
"value": "={{ $json.clicks }}"
},
{
"id": "5b4aaffe-391a-4c9d-8249-f447397a3f5d",
"name": "impressions",
"type": "number",
"value": "={{ $json.impressions }}"
},
{
"id": "33677237-57fe-48f4-aff8-72ae81b5f5a2",
"name": "ctr",
"type": "number",
"value": "={{ $json.ctr }}"
},
{
"id": "f961deee-d222-4df7-a7ff-b7286405e4a7",
"name": "position",
"type": "number",
"value": "={{ $json.position }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e8f1ab65-9594-45e7-ba9e-7873bd53a107",
"name": "date",
"type": "n8n-nodes-base.httpRequest",
"position": [
1360,
620
],
"parameters": {
"url": "=https://www.googleapis.com/webmasters/v3/sites/sc-domain:{{$json.domain}}/searchAnalytics/query",
"method": "POST",
"options": {},
"jsonBody": "={\n \"startDate\": \"{{ $now.format('yyyy-MM-dd') }}\",\n \"endDate\": \"{{ $now.minus($json.days, 'days').format('yyyy-MM-dd') }}\",\n \"dimensions\": [\"date\"]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleOAuth2Api"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
},
"httpHeaderAuth": {
"name": "<your credential>"
},
"googleOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "d3bbf719-9524-4269-8c26-0eb7599add55",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
700,
460
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "69cf781d-7ff5-4e2d-ad7d-505a5143710a",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
1220,
160
],
"parameters": {
"color": 4,
"width": 1033,
"height": 660,
"content": "### Output"
},
"typeVersion": 1
},
{
"id": "b701bc62-07e7-4494-a674-560846783a29",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
100
],
"parameters": {
"color": 4,
"width": 645,
"height": 828,
"content": "## \uc0ac\uc6a9\ubc95\n\n1. \uc774 Google \uc2dc\ud2b8\uc758 \uc0ac\ubcf8\uc744 \ub9cc\ub4dc\uc138\uc694: https://docs.google.com/spreadsheets/d/10hSuGOOf14YvVY2Bw8WXUIpsyXO614l7qNEjkyVY_Qg/edit?usp=sharing\n\n2. Google \uc11c\ube44\uc2a4 \uc790\uaca9 \uc99d\uba85\uc744 \uc124\uc815\ud558\uace0 \ub2e4\uc74c \uc2a4\ucf54\ud504\ub97c \ucd94\uac00\ud558\uc138\uc694: `https://www.googleapis.com/auth/webmasters, https://www.googleapis.com/auth/webmasters.readonly, https://www.googleapis.com/auth/adwords`\n\n3. \uc6d0\ud558\ub294 \ub3c4\uba54\uc778\uc73c\ub85c \ub3c4\uba54\uc778\uc744 \uad50\uccb4\ud558\uc138\uc694.\n\n1. **\uc6cc\ud06c\ud50c\ub85c \uc774\ud574:**\n- **\ub178\ub4dc \uac1c\uc694:**\n\uc774 \uc6cc\ud06c\ud50c\ub85c\uc5d0\ub294 \uc5ec\ub7ec \ub178\ub4dc\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4:\n- **\ub3c4\uba54\uc778 \uc124\uc815:** \ucffc\ub9ac\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ub3c4\uba54\uc778\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\n- **\uc2a4\ucf00\uc904 \ud2b8\ub9ac\uac70:** \uc815\uc758\ub41c \uc2a4\ucf00\uc904\uc5d0 \ub530\ub77c \uc6cc\ud06c\ud50c\ub85c\ub97c \uc2dc\uc791\ud569\ub2c8\ub2e4.\n- **HttpRequest (query, page, date):** \uc9c0\uc815\ub41c \ucc28\uc6d0\uacfc \ub0a0\uc9dc\ub97c \uc0ac\uc6a9\ud558\uc5ec Google \uac80\uc0c9 \ucf58\uc194 API\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.\n- **Split Out (x3):** \ub4e4\uc5b4\uc624\ub294 JSON \ubc30\uc5f4\uc744 \uac1c\ubcc4 \ud56d\ubaa9\uc73c\ub85c \ubd84\ud560\ud558\uc5ec \ucd94\uac00 \ucc98\ub9ac\ub97c \ud569\ub2c8\ub2e4.\n- **Edit Fields (x3):** \ub098\uac00\ub294 \ub370\uc774\ud130\ub97c \uc9c0\uc815\ub41c \ud544\ub4dc\ub85c \ub9e4\ud551\ud558\uc5ec Google \uc2dc\ud2b8\uc5d0 \uc0bd\uc785\ud560 \uc900\ube44\ub97c \ud569\ub2c8\ub2e4.\n- **Google Sheets (x3):** \uac00\uc838\uc628 \ub370\uc774\ud130\ub85c \uc9c0\uc815\ub41c Google \uc2dc\ud2b8 \ubb38\uc11c\uc5d0 \ud56d\ubaa9\uc744 \ucd94\uac00\ud558\uac70\ub098 \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4.\n\n- **\uc785\ub825\uacfc \ucd9c\ub825:**\n- \uc785\ub825: \ud0a4\uc6cc\ub4dc, \ud398\uc774\uc9c0 \ub370\uc774\ud130, \ub0a0\uc9dc \ub370\uc774\ud130\uc5d0 \ub300\ud55c Google \uac80\uc0c9 \ucf58\uc194 API \uc751\ub2f5.\n- \ucd9c\ub825: \ud0a4\uc6cc\ub4dc \ub370\uc774\ud130, \ud074\ub9ad \uc218, \ub178\ucd9c \uc218, CTR, \uc704\uce58\ub97c \ud3ec\ud568\ud558\ub294 Google \uc2dc\ud2b8\uc5d0 \uae30\ub85d\ub41c \ud56d\ubaa9.\n\n2. **\uc124\uc815 \uc9c0\uce68:**\n- **\uc804\uc81c \uc870\uac74:**\n- n8n \uc778\uc2a4\ud134\uc2a4\uac00 \uc124\uc815\ub418\uc5b4 \uc2e4\ud589 \uc911\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4.\n- Google \uac80\uc0c9 \ucf58\uc194\uacfc Google \uc2dc\ud2b8\uc5d0 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\ub294 \ud65c\uc131 Google \uacc4\uc815.\n- API \uc561\uc138\uc2a4\ub97c \uc704\ud55c Google OAuth 2.0 \uc790\uaca9 \uc99d\uba85.\n\n- **\ub2e8\uacc4\ubcc4 \uc124\uc815:**\n1. n8n\uc744 \uc5f4\uace0 \uc0c8 \uc6cc\ud06c\ud50c\ub85c\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.\n2. JSON\uc5d0 \uc124\uba85\ub41c \ub300\ub85c \ub178\ub4dc\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4.\n3. n8n\uc5d0\uc11c API \uc561\uc138\uc2a4\ub97c \ud65c\uc131\ud654\ud558\uae30 \uc704\ud574 **Google OAuth2** \uc790\uaca9 \uc99d\uba85\uc744 \uad6c\uc131\ud569\ub2c8\ub2e4.\n4. **\ub3c4\uba54\uc778 \uc124\uc815** \ub178\ub4dc\uc5d0\uc11c \ub3c4\uba54\uc778\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\n5. Google \uc2dc\ud2b8 \ubb38\uc11c URL\uc744 \uac1c\uc778 \uc2dc\ud2b8\ub85c \ub9de\ucda5\ub2c8\ub2e4.\n6. **\uc2a4\ucf00\uc904 \ud2b8\ub9ac\uac70** \ub178\ub4dc\uc5d0\uc11c \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c \uc2a4\ucf00\uc904\uc744 \uc870\uc815\ud569\ub2c8\ub2e4.\n7. \uc6cc\ud06c\ud50c\ub85c\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4.\n\n- **\uad6c\uc131 \uc635\uc158:**\n- **HttpRequest** \ub178\ub4dc\uc758 \ubcf8\ubb38\uc5d0\uc11c \ub0a0\uc9dc \ubc94\uc704\ub97c \ub9de\ucda5\ub2c8\ub2e4.\n- \ub2e4\ub978 \ub370\uc774\ud130 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c **Edit Fields** \ub178\ub4dc\uc758 \ud544\ub4dc\ub97c \uc870\uc815\ud569\ub2c8\ub2e4.\n\n3. **\uc0ac\uc6a9 \uc0ac\ub840 \uc608\uc2dc:**\n- \uac80\uc0c9 \ucf58\uc194 \uc9c0\ud45c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc6f9\uc0ac\uc774\ud2b8 \uc131\ub2a5\uc744 \uc2dc\uac04\uc5d0 \ub530\ub77c \ucd94\uc801\ud558\ub294 \ub370 \uc720\uc6a9\ud569\ub2c8\ub2e4.\n- \ub514\uc9c0\ud138 \ub9c8\ucf00\ud130, SEO \uc804\ubb38\uac00, \uc6f9 \ubd84\uc11d \uc804\ubb38\uac00\uc5d0\uac8c \uc774\uc0c1\uc801\uc785\ub2c8\ub2e4.\n- \uc774\ud574\uad00\uacc4\uc790\ub098 \ud300 \ub9ac\ubdf0\ub97c \uc704\ud55c \uc131\uacfc \ubcf4\uace0\uc11c\ub97c \ucef4\ud30c\uc77c\ud558\ub294 \ub370 \uac00\uce58\uac00 \uc788\uc2b5\ub2c8\ub2e4.\n\n4. **\uc2e4\ud589 \ubc0f \ubb38\uc81c \ud574\uacb0:**\n- **\uc6cc\ud06c\ud50c\ub85c \uc2e4\ud589:**\n- \uc6cc\ud06c\ud50c\ub85c\ub97c \uc218\ub3d9\uc73c\ub85c \ud2b8\ub9ac\uac70\ub098 \uc2a4\ucf00\uc904\uc774 \uc790\ub3d9\uc73c\ub85c \uc2e4\ud589\ub418\ub3c4\ub85d \uae30\ub2e4\ub9bd\ub2c8\ub2e4.\n\n- **\uc2e4\ud589 \ubaa8\ub2c8\ud130\ub9c1:**\n- n8n \ub300\uc2dc\ubcf4\ub4dc\uc758 \uc2e4\ud589 \ub85c\uadf8\ub97c \ud655\uc778\ud558\uc5ec \ubaa8\ub4e0 \ub178\ub4dc\uac00 \uc131\uacf5\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.\n\n- **\uc77c\ubc18\uc801\uc778 \ubb38\uc81c:**\n- \uc798\ubabb\ub41c OAuth \uc790\uaca9 \uc99d\uba85 \u2013 \uc790\uaca9 \uc99d\uba85\uc774 \uc62c\ubc14\ub974\uac8c \uc124\uc815\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.\n- \uc798\ubabb\ub41c Google \uc2dc\ud2b8 URL \u2013 \ubb38\uc11c \ub9c1\ud06c\uc640 \uad8c\ud55c\uc744 \ub2e4\uc2dc \ud655\uc778\ud569\ub2c8\ub2e4.\n- \uc2a4\ucf00\uc904 \ucda9\ub3cc \u2013 \uc124\uc815\ub41c \uc2a4\ucf00\uc904\uc774 \ub2e4\ub978 \uc6cc\ud06c\ud50c\ub85c\uc640 \uacb9\uce58\uc9c0 \uc54a\ub3c4\ub85d \ud569\ub2c8\ub2e4."
},
"typeVersion": 1
},
{
"id": "07432897-f068-4371-9f88-d70340e2082a",
"name": "Sticky Note17",
"type": "n8n-nodes-base.stickyNote",
"position": [
1440,
100
],
"parameters": {
"color": 4,
"width": 503.60808870324274,
"height": 80,
"content": "# \uac80\uc0c9 \ucf58\uc194 \ubcf4\uace0\uc11c"
},
"typeVersion": 1
},
{
"id": "092645b2-9e75-4ff0-8d33-4a3acadac789",
"name": "Set your domain",
"type": "n8n-nodes-base.set",
"position": [
980,
460
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "6f74dee0-3789-433e-b60e-ed2a05202675",
"name": "domain",
"type": "string",
"value": "funautomations.io"
},
{
"id": "8c73135e-9d39-4f66-821d-7decb3c64085",
"name": "days",
"type": "number",
"value": 30
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0b04b552-e484-417b-9a7e-a90d477dd45a",
"name": "Get query Report",
"type": "n8n-nodes-base.httpRequest",
"position": [
1360,
240
],
"parameters": {
"url": "=https://www.googleapis.com/webmasters/v3/sites/sc-domain:{{$json.domain}}/searchAnalytics/query",
"method": "POST",
"options": {},
"jsonBody": "={\n \"startDate\": \"{{ $now.format('yyyy-MM-dd') }}\",\n \"endDate\": \"{{ $now.minus($json.days, 'days').format('yyyy-MM-dd') }}\",\n \"dimensions\": [\"query\"]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleOAuth2Api"
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
},
"googleOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "9f9f2be7-1301-4c91-8da1-86eab5725683",
"name": "Get Page Report",
"type": "n8n-nodes-base.httpRequest",
"position": [
1360,
440
],
"parameters": {
"url": "=https://www.googleapis.com/webmasters/v3/sites/sc-domain:{{$json.domain}}/searchAnalytics/query",
"method": "POST",
"options": {},
"jsonBody": "={\n \"startDate\": \"{{ $now.format('yyyy-MM-dd') }}\",\n \"endDate\": \"{{ $now.minus($json.days, 'days').format('yyyy-MM-dd') }}\",\n \"dimensions\": [\"page\"]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleOAuth2Api"
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
},
"googleOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "737f802f-4629-41f2-9b21-4a98e92d6433",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
880,
380
],
"parameters": {
"color": 4,
"width": 300,
"height": 300,
"content": "\ub3c4\uba54\uc778 \uc124\uc815 \ubc0f \uc77c \ube48\ub3c4"
},
"typeVersion": 1
},
{
"id": "f8f62dde-1529-4d3a-a030-aa952496652d",
"name": "Update queries to Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1980,
240
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "clicks",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "clicks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "impressions",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "impressions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ctr",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ctr",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "position",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "position",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"Keyword"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 996986484,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/10hSuGOOf14YvVY2Bw8WXUIpsyXO614l7qNEjkyVY_Qg/edit#gid=996986484",
"cachedResultName": "Query"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/10hSuGOOf14YvVY2Bw8WXUIpsyXO614l7qNEjkyVY_Qg/edit?usp=sharing"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
},
{
"id": "299c4fa9-fb7e-4c85-a8a5-3cea53ba7136",
"name": "Update Pages to Sheets ",
"type": "n8n-nodes-base.googleSheets",
"position": [
2000,
440
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "page",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "clicks",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "clicks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "impressions",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "impressions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ctr",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ctr",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "position",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "position",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"page"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/10hSuGOOf14YvVY2Bw8WXUIpsyXO614l7qNEjkyVY_Qg/edit#gid=0",
"cachedResultName": "PAGES"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/10hSuGOOf14YvVY2Bw8WXUIpsyXO614l7qNEjkyVY_Qg/edit?usp=sharing"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
},
{
"id": "4cc4197a-7ee5-4cd8-ade7-80bca911a3cf",
"name": "Update date report to sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2000,
620
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "clicks",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "clicks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "impressions",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "impressions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ctr",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ctr",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "position",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "position",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"date"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1823079319,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/10hSuGOOf14YvVY2Bw8WXUIpsyXO614l7qNEjkyVY_Qg/edit#gid=1823079319",
"cachedResultName": "Dates"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/10hSuGOOf14YvVY2Bw8WXUIpsyXO614l7qNEjkyVY_Qg/edit?usp=sharing"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"retryOnFail": true,
"typeVersion": 4.5
}
],
"connections": {
"date": {
"main": [
[
{
"node": "Split Out2",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Split Out1": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Split Out2": {
"main": [
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Update queries to Sheets",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Update Pages to Sheets ",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "Update date report to sheets",
"type": "main",
"index": 0
}
]
]
},
"Get Page Report": {
"main": [
[
{
"node": "Split Out1",
"type": "main",
"index": 0
}
]
]
},
"Set your domain": {
"main": [
[
{
"node": "Get query Report",
"type": "main",
"index": 0
},
{
"node": "Get Page Report",
"type": "main",
"index": 0
},
{
"node": "date",
"type": "main",
"index": 0
}
]
]
},
"Get query Report": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Set your domain",
"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.
googleApigoogleOAuth2ApigoogleSheetsOAuth2ApihttpHeaderAuth
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Workflow 2613. Uses httpRequest, googleSheets. Scheduled trigger; 18 nodes.
Source: https://github.com/n8nKOR/n8n-shared-workflow/blob/62a671327e906c22a40d290b339ff6d2373f8d75/workflows/n8n-workflows-by-Zie619/devops/2613_workflow_2613.json — 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 automates video distribution to 9 social platforms simultaneously using Blotato's API. It includes both a scheduled publisher (checks Google Sheets for videos marked "Ready") and a subwo
Google Sheets, HTTP Request, Form Trigger +2
YogiAI. Uses googleSheets, googleSheetsTool, httpRequest, stopAndError. Scheduled trigger; 61 nodes.
Google Sheets, Google Sheets Tool, HTTP Request +1
This workflow monitors Google Calendar for events indicating that a customer will visit the company today or the next day, retrieves the required details, and sends reminder notifications to the relev
Google Calendar, Google Sheets, HTTP Request +1
ofn hook v0.24.0 beta. Uses start, httpRequest, functionItem, itemLists. Scheduled trigger; 42 nodes.
Start, HTTP Request, Function Item +3
Security teams, DevOps engineers, vulnerability analysts, and automation builders who want to eliminate repetitive Nessus scan parsing, AI-based risk triage, and manual reporting. Designed for orgs fo
Email Send, HTTP Request, Google Sheets +1