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 →
{
"name": "01 - Google Sheets Append Row Test",
"nodes": [
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e11",
"name": "\u041e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u0432\u043e\u0440\u043a\u0444\u043b\u043e\u0443",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-200,
-300
],
"parameters": {
"content": "Workflow 01 \u2014 \u0442\u0435\u0441\u0442 \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 Google Sheets. \u041f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u0442, \u0447\u0442\u043e n8n \u043c\u043e\u0436\u0435\u0442 \u0432\u0437\u044f\u0442\u044c \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0435 \u0442\u0435\u0441\u0442\u043e\u0432\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0438 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0438\u0445 \u0441\u0442\u0440\u043e\u043a\u043e\u0439 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0443. Claude API, Apify \u0438 Firecrawl \u043f\u043e\u043a\u0430 \u043d\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442\u0441\u044f.",
"height": 200,
"width": 580,
"color": 4
}
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e12",
"name": "Manual Start",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
100,
100
],
"parameters": {}
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e13",
"name": "Set Test Competitor Data",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
380,
100
],
"parameters": {
"mode": "manual",
"assignments": {
"assignments": [
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e21",
"name": "platform",
"value": "test",
"type": "string"
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e22",
"name": "source_url",
"value": "https://example.com/test-google-sheets",
"type": "string"
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e23",
"name": "company_name",
"value": "Test Competitor",
"type": "string"
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e24",
"name": "profile_name",
"value": "Test Profile",
"type": "string"
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e25",
"name": "profile_url",
"value": "https://example.com/profile",
"type": "string"
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e26",
"name": "region",
"value": "\u041c\u043e\u0441\u043a\u0432\u0430",
"type": "string"
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e27",
"name": "text_context",
"value": "\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442 \u043a\u0440\u0435\u0434\u0438\u0442 \u043f\u043e\u0434 \u0437\u0430\u043b\u043e\u0433 \u0430\u0432\u0442\u043e\u043c\u043e\u0431\u0438\u043b\u044f. \u0420\u0435\u0448\u0435\u043d\u0438\u0435 \u0437\u0430 1 \u0434\u0435\u043d\u044c. \u0420\u0430\u0431\u043e\u0442\u0430\u0435\u043c \u043f\u043e \u041c\u043e\u0441\u043a\u0432\u0435 \u0438 \u043e\u0431\u043b\u0430\u0441\u0442\u0438.",
"type": "string"
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e28",
"name": "parsed_at",
"value": "2026-06-04",
"type": "string"
}
]
},
"options": {}
}
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e14",
"name": "Mock Marketing Analysis",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
660,
100
],
"parameters": {
"mode": "runOnceForAllItems",
"jsCode": "const item = $input.first().json;\nconst now = new Date().toISOString();\n\nreturn [\n {\n json: {\n created_at: now,\n source_type: \"manual_test\",\n platform: item.platform,\n source_url: item.source_url,\n parsed_at: item.parsed_at,\n published_at: \"\",\n freshness_status: \"unknown\",\n entity_type: \"competitor\",\n company_name: item.company_name,\n profile_name: item.profile_name,\n profile_url: item.profile_url,\n region: item.region,\n service_type: \"secured_auto_loan\",\n offer_text: \"\u041a\u0440\u0435\u0434\u0438\u0442 \u043f\u043e\u0434 \u0437\u0430\u043b\u043e\u0433 \u0430\u0432\u0442\u043e\u043c\u043e\u0431\u0438\u043b\u044f, \u0440\u0435\u0448\u0435\u043d\u0438\u0435 \u0437\u0430 1 \u0434\u0435\u043d\u044c\",\n terms: \"\u0422\u0435\u0441\u0442\u043e\u0432\u044b\u0435 \u0443\u0441\u043b\u043e\u0432\u0438\u044f, \u043d\u0435 \u0440\u0435\u0430\u043b\u044c\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435\",\n contact_public: \"\",\n text_context: item.text_context,\n detected_need: \"\u041f\u043e\u0442\u0440\u0435\u0431\u043d\u043e\u0441\u0442\u044c \u0432 \u0431\u044b\u0441\u0442\u0440\u043e\u043c \u0437\u0430\u0439\u043c\u0435 \u043f\u043e\u0434 \u0437\u0430\u043b\u043e\u0433 \u0430\u0432\u0442\u043e\",\n competitor_strength: 60,\n lead_signal_score: 40,\n content_idea_score: 70,\n quality_score: 75,\n reason: \"Test Google Sheets row processed successfully\",\n recommended_action: \"Use this as a baseline row format before connecting Claude API\",\n status: \"analyzed\"\n }\n }\n];"
}
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e15",
"name": "Append Row to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
940,
100
],
"parameters": {
"authentication": "serviceAccount",
"operation": "append",
"documentId": {
"__rl": true,
"value": "PASTE_SPREADSHEET_ID_HERE",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "results",
"mode": "name"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [],
"schema": []
},
"options": {}
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"retryOnFail": true,
"maxTries": 3,
"waitBetweenTries": 5000
},
{
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e16",
"name": "\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u043f\u0435\u0440\u0435\u0434 \u0437\u0430\u043f\u0443\u0441\u043a\u043e\u043c",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
940,
320
],
"parameters": {
"content": "\u041f\u0435\u0440\u0435\u0434 \u0437\u0430\u043f\u0443\u0441\u043a\u043e\u043c \u0432\u044b\u0431\u0435\u0440\u0438 credential: Google Sheets - Marketing Scout Service Account. \u0417\u0430\u0442\u0435\u043c \u0443\u043a\u0430\u0436\u0438 Spreadsheet ID \u0441\u0432\u043e\u0435\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b Marketing Scout Results \u0438 \u043b\u0438\u0441\u0442 results. \u0423\u0441\u043f\u0435\u0448\u043d\u044b\u0439 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u2014 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0440\u043e\u043a\u0430 \u043f\u043e\u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0432 Google Sheet.",
"height": 200,
"width": 460,
"color": 5
}
}
],
"connections": {
"Manual Start": {
"main": [
[
{
"node": "Set Test Competitor Data",
"type": "main",
"index": 0
}
]
]
},
"Set Test Competitor Data": {
"main": [
[
{
"node": "Mock Marketing Analysis",
"type": "main",
"index": 0
}
]
]
},
"Mock Marketing Analysis": {
"main": [
[
{
"node": "Append Row to Google Sheets",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e01",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "c5d6e7f8-a9b0-4c1d-2e3f-4a5b6c7d8e00",
"tags": []
}
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.
googleApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
01 - Google Sheets Append Row Test. Uses googleSheets. Event-driven trigger; 6 nodes.
Source: https://github.com/CodeVinci8/vinci-ai-pilot/blob/main/n8n/workflows/01_google_sheets_append_row_test.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.
TrackCollect_deeper. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 80 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +1
This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.
HTTP Request, Gmail, Twilio +3
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
Product Ad Machine. Uses googleDrive, googleSheets, httpRequest, @ffmpeg-micro/n8n-nodes-ffmpeg-micro. Event-driven trigger; 60 nodes.
Google Drive, Google Sheets, HTTP Request +2
Basic AI SEO KW Research n8n DataForSEO Gumroad 030125. Uses googleSheets, googleDrive, httpRequest. Event-driven trigger; 56 nodes.
Google Sheets, Google Drive, HTTP Request