Linked API This workflow corresponds to n8n.io template #12915 — 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 →
{
"id": "OpvrOeWl5TEfcezv",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Standard outreach sequence",
"tags": [],
"nodes": [
{
"id": "e65cf150-20e6-48aa-a779-d50da27f69e3",
"name": "\ud83d\udce5 Get All Leads",
"type": "n8n-nodes-base.googleSheets",
"position": [
192,
288
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $json.SHEET_NAME }}"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $json.DOCUMENT_LINK }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "40710f0b-e18f-4c65-bb87-f1e35e3d1a29",
"name": "\u2699\ufe0f Config",
"type": "n8n-nodes-base.set",
"position": [
-16,
288
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "03612969-856a-4cfa-ad5c-b9cd71e255ad",
"name": "DOCUMENT_LINK",
"type": "string",
"value": "https://docs.google.com/spreadsheets/d/141fJskisAQ7H8AxtojQ7LZrnd14EOyB26RdDq5aczEU"
},
{
"id": "a684204c-beb8-4e27-8366-5c00783baa9f",
"name": "SHEET_NAME",
"type": "string",
"value": "Leads"
},
{
"id": "469b1fde-ce1a-4b2e-84cf-46b90d0f4b6f",
"name": "DAILY_CONNECTION_LIMIT",
"type": "number",
"value": 25
},
{
"id": "8a740b2c-471f-44c0-8252-d748dddc1a23",
"name": "HOURS_TO_CHECK_IF_CONNECTION_ACCEPTED",
"type": "number",
"value": 24
},
{
"id": "9e0843c5-f895-4141-8835-1e15c6a88651",
"name": "HOURS_TO_CHECK_IF_REPLIED",
"type": "number",
"value": 4
},
{
"id": "359e2129-27fb-48d6-b618-f382db0f0ce5",
"name": "HOURS_DELAY_AFTER_CONNECTION_ACCEPTED",
"type": "number",
"value": 24
},
{
"id": "d7286a53-6254-4ed3-ad05-494a62284b44",
"name": "DAYS_DELAY_BETWEEN_MESSAGES",
"type": "number",
"value": 2
},
{
"id": "aa8b5fc8-98f5-4489-9fa8-35412193533d",
"name": "DAYS_WAIT_FOR_CONNECTION_ACCEPTANCE",
"type": "number",
"value": 10
},
{
"id": "30a5d273-4f5c-4fcb-9b53-c8b99107b342",
"name": "DAYS_WAIT_AFTER_LAST_MESSAGE",
"type": "string",
"value": "4"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "03397cd7-a589-4491-a464-01aea127df4e",
"name": "\u23f0 Every 2 hours",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-224,
288
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 2
}
]
}
},
"typeVersion": 1.3
},
{
"id": "1f6d7790-04f0-4e2a-800c-e6ae56e32c1c",
"name": "\ud83d\udd0d Filter Active Leads",
"type": "n8n-nodes-base.filter",
"position": [
416,
288
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "0d9a0d4d-77fa-4ce1-bda8-e13b6c09abdf",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "NEW"
},
{
"id": "df82b6bf-5002-4c6a-9789-df4ad4ef3a21",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "PENDING_CONNECTION"
},
{
"id": "51d0073b-93c8-4e19-8a69-78e8e5ef8d80",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "CONNECTED"
},
{
"id": "41d962b1-5882-43aa-b3a6-3faae248b592",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "AWAITING_REPLY_1"
},
{
"id": "38b9c13b-81e6-4ff3-9aa1-8ffa81f12480",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "AWAITING_REPLY_2"
},
{
"id": "c75df52e-9903-4b93-a5ca-1164a54f9f54",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "AWAITING_REPLY_3"
}
]
}
},
"typeVersion": 2.3,
"alwaysOutputData": false
},
{
"id": "a6ff5066-9480-4184-b2f1-6c3641cb72d9",
"name": "\ud83d\udd04 Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
896,
288
],
"parameters": {
"options": {
"reset": false
}
},
"typeVersion": 3
},
{
"id": "0f5307db-96fc-41d5-a28d-3b2d8b0a8afb",
"name": "\ud83d\udd17 Merge Config",
"type": "n8n-nodes-base.set",
"position": [
1136,
304
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "66dee3d9-a69f-4e3f-875d-f6ded281dec4",
"name": "config_document_link",
"type": "string",
"value": "={{ $('\u2699\ufe0f Config').item.json.DOCUMENT_LINK }}"
},
{
"id": "f4448c13-148b-46b4-b7d9-09caa8e78c26",
"name": "config_sheet_name",
"type": "string",
"value": "={{ $('\u2699\ufe0f Config').item.json.SHEET_NAME }}"
},
{
"id": "aac9336a-2e38-4c96-aaed-9c6d0f4195fd",
"name": "config_daily_limit",
"type": "number",
"value": "={{ $('\u2699\ufe0f Config').item.json.DAILY_CONNECTION_LIMIT }}"
},
{
"id": "bec1865c-e6e1-4740-8333-1f6cca1e545b",
"name": "config_hours_check_connection",
"type": "number",
"value": "={{ $('\u2699\ufe0f Config').item.json.HOURS_TO_CHECK_IF_CONNECTION_ACCEPTED }}"
},
{
"id": "e43b0d49-c334-4c2b-b61d-89d24e6cc428",
"name": "config_hours_check_reply",
"type": "number",
"value": "={{ $('\u2699\ufe0f Config').item.json.HOURS_TO_CHECK_IF_REPLIED }}"
},
{
"id": "0eebb0ab-ca64-411e-bab9-7b9df13b9869",
"name": "config_hours_after_connect",
"type": "number",
"value": "={{ $('\u2699\ufe0f Config').item.json.HOURS_DELAY_AFTER_CONNECTION_ACCEPTED }}"
},
{
"id": "b75c49b0-506a-4c20-a470-36a55cfc8ae9",
"name": "config_days_between_msgs",
"type": "number",
"value": "={{ $('\u2699\ufe0f Config').item.json.DAYS_DELAY_BETWEEN_MESSAGES }}"
},
{
"id": "84751bd2-da2e-4653-941c-a397b74be291",
"name": "config_days_wait_connect",
"type": "number",
"value": "= {{ $('\u2699\ufe0f Config').item.json.DAYS_WAIT_FOR_CONNECTION_ACCEPTANCE }}"
},
{
"id": "c1a8812c-4f91-4919-9f7e-b8099012d6b6",
"name": "config_days_wait_last",
"type": "number",
"value": "= {{ $('\u2699\ufe0f Config').item.json.DAYS_WAIT_AFTER_LAST_MESSAGE }}"
},
{
"id": "c3016764-d929-4089-98fa-fd80b3217642",
"name": "lead_url",
"type": "string",
"value": "={{ $json['LinkedIn URL'] }}"
},
{
"id": "f47d50b4-ce10-41bc-bac7-3eae874eff68",
"name": "lead_name",
"type": "string",
"value": "={{ $json.Name }}"
},
{
"id": "296b09e7-c5eb-4faa-81d2-eaf7c4bf20ff",
"name": "lead_company",
"type": "string",
"value": "={{ $json.Company }}"
},
{
"id": "c14eebce-b16f-4621-b2a6-6b69a731aa2c",
"name": "lead_status",
"type": "string",
"value": "={{ $json.Status }}"
},
{
"id": "ea2ac895-a85c-4794-aeb0-5202a630a719",
"name": "lead_next_send",
"type": "string",
"value": "={{ $json['Next send date'] }}"
},
{
"id": "3132088f-bae4-46a3-8ae3-b9da8dec75c8",
"name": "lead_next_check",
"type": "string",
"value": "={{ $json['Next check date'] }}"
},
{
"id": "af022912-88de-4f08-bfdc-e5+1234567890",
"name": "lead_last_action",
"type": "string",
"value": "={{ $json['Last action date'] }}"
},
{
"id": "d3e00c06-1eb9-49ea-9ef4-9fbf0d05f75c",
"name": "lead_message_1",
"type": "string",
"value": "={{ $json['Message 1'] }}"
},
{
"id": "d33089eb-bc0d-4917-940f-b384399b5ed0",
"name": "lead_message_2",
"type": "string",
"value": "={{ $json['Message 2'] }}"
},
{
"id": "39ca1cc2-4769-40f4-9764-8c94daa9ee93",
"name": "lead_message_3",
"type": "string",
"value": "={{ $json['Message 3'] }}"
},
{
"id": "b8ecd27e-3730-4f4e-95e6-147897829ef4",
"name": "lead_connection_note",
"type": "string",
"value": "={{ $json['Connection note'] }}"
},
{
"id": "adc6d3ef-489b-4b62-b089-b60c8eddfce0",
"name": "lead_row_number",
"type": "number",
"value": "={{ $json.row_number }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c822b0d2-a3c9-4c0f-92f9-4c0aca47ff84",
"name": "\ud83d\udd00 Route by Status",
"type": "n8n-nodes-base.switch",
"position": [
1360,
240
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "NEW",
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "a676cd1f-eea0-4457-860e-b264e428ce22",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.lead_status }}",
"rightValue": "NEW"
}
]
},
"renameOutput": true
},
{
"outputKey": "PENDING_CONNECTION",
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "deb85319-3022-4a93-a8fd-c76fc57f0017",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.lead_status }}",
"rightValue": "PENDING_CONNECTION"
}
]
},
"renameOutput": true
},
{
"outputKey": "CONNECTED",
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1d922fb0-0bc4-48d1-b085-f0f3e6b6ab8e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.lead_status }}",
"rightValue": "CONNECTED"
}
]
},
"renameOutput": true
},
{
"outputKey": "AWAITING_REPLY_1",
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "16319afc-5aa5-4a80-80e9-3eefc4616d01",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.lead_status }}",
"rightValue": "AWAITING_REPLY_1"
}
]
},
"renameOutput": true
},
{
"outputKey": "AWAITING_REPLY_2",
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fff765e3-d24e-4381-84c6-355e6017617a",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.lead_status }}",
"rightValue": "AWAITING_REPLY_2"
}
]
},
"renameOutput": true
},
{
"outputKey": "AWAITING_REPLY_3",
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6ab5cff1-54de-4a24-b3bb-1c0a7eaafc55",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.lead_status }}",
"rightValue": "AWAITING_REPLY_3"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.4
},
{
"id": "b411b12d-0b3d-48c6-bc6d-0c15db13aa77",
"name": "\u27a1\ufe0f Combine Branches",
"type": "n8n-nodes-base.noOp",
"position": [
4544,
992
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9bd20d30-86da-4d96-8c71-047e4b1aeb5b",
"name": "Send connection request",
"type": "n8n-nodes-linked-api.linkedApi",
"position": [
1872,
-2112
],
"parameters": {
"operation": "sendConnectionRequest",
"personUrl": "={{ $json.lead_url }}",
"connectionNote": "={{ $json.lead_connection_note }}"
},
"credentials": {
"linkedApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "7a028626-13b0-42c1-917b-c2bb1e8d1278",
"name": "\u2753 Time to Send Connection?",
"type": "n8n-nodes-base.if",
"position": [
1552,
-1904
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "or",
"conditions": [
{
"id": "7680a0b8-0b80-4622-a24f-5dbce9ccee4e",
"operator": {
"type": "string",
"operation": "empty"
},
"leftValue": "={{ $('\ud83d\udd17 Merge Config').item.json.lead_next_send }}",
"rightValue": ""
},
{
"id": "fc44ab90-142b-45e4-bb24-a8742fd135f3",
"operator": {
"type": "dateTime",
"operation": "beforeOrEquals"
},
"leftValue": "={{ DateTime.fromFormat($('\ud83d\udd17 Merge Config').item.json.lead_next_send, 'M/d/yyyy H:mm:ss') }}",
"rightValue": "={{ $today }}"
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.3
},
{
"id": "5aad4c01-5cb4-4481-834b-f4372c3121b1",
"name": "\u2753 Time to Check?",
"type": "n8n-nodes-base.if",
"position": [
1568,
-800
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "7680a0b8-0b80-4622-a24f-5dbce9ccee4e",
"operator": {
"type": "string",
"operation": "empty"
},
"leftValue": "={{ $('\ud83d\udd17 Merge Config').item.json.lead_next_check }}",
"rightValue": ""
},
{
"id": "fc44ab90-142b-45e4-bb24-a8742fd135f3",
"operator": {
"type": "dateTime",
"operation": "beforeOrEquals"
},
"leftValue": "={{ DateTime.fromFormat($('\ud83d\udd17 Merge Config').item.json.lead_next_check, 'M/d/yyyy H:mm:ss') }}",
"rightValue": "={{ $now }}"
}
]
}
},
"typeVersion": 2.3
},
{
"id": "a1c8136b-20c7-4632-a148-b50911567040",
"name": "Check connection status",
"type": "n8n-nodes-linked-api.linkedApi",
"position": [
1776,
-1072
],
"parameters": {
"operation": "checkConnectionStatus",
"personUrl": "={{ $('\ud83d\udd00 Route by Status').item.json.lead_url }}"
},
"credentials": {
"linkedApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "c2526eb5-bd7b-4890-9f43-99283ead2fb5",
"name": "Wait 'Send connection request'",
"type": "n8n-nodes-base.wait",
"position": [
2064,
-2112
],
"parameters": {
"resume": "webhook",
"options": {}
},
"typeVersion": 1.1
},
{
"id": "fba5d8d7-ca26-448f-92c6-fd7055a3c7bc",
"name": "Wait 'Check connection status'",
"type": "n8n-nodes-base.wait",
"position": [
1984,
-1072
],
"parameters": {
"resume": "webhook",
"options": {}
},
"typeVersion": 1.1
},
{
"id": "faaa8143-e850-4c22-a650-d6afef8444aa",
"name": "\ud83d\udd00 Route by Connection Status",
"type": "n8n-nodes-base.switch",
"position": [
2224,
-1184
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "connected",
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bf75fd86-4852-4e45-b686-fddaed02dc0a",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.body.data.connectionStatus }}",
"rightValue": "connected"
}
]
},
"renameOutput": true
},
{
"outputKey": "pending",
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bf8ac072-f78e-4767-8610-6ba85cba72e5",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.body.data.connectionStatus }}",
"rightValue": "pending"
}
]
},
"renameOutput": true
},
{
"outputKey": "notConnected",
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "76e4a931-28aa-4946-a292-213cf7652f23",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.body.data.connectionStatus }}",
"rightValue": "notConnected"
}
]
},
"renameOutput": true
},
{
"outputKey": "other",
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1713c11b-84b0-4fb4-8fac-e090e164090f",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "=",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.4
},
{
"id": "98a364ec-5413-437f-a109-d966efb4cf27",
"name": "\u2753 Connection Expired?",
"type": "n8n-nodes-base.if",
"position": [
2560,
-1264
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e839706d-2eca-4bc2-b9ae-5e062eb5e1ef",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $now.diff(DateTime.fromFormat($('\ud83d\udd17 Merge Config').item.json.lead_last_action, 'M/d/yyyy H:mm:ss'), 'days').days }}",
"rightValue": "={{ $('\ud83d\udd17 Merge Config').item.json.config_days_wait_connect }}"
}
]
}
},
"typeVersion": 2.3
},
{
"id": "e33dc12f-cb7d-4e05-9d85-a382c729fc2a",
"name": "\u2753 Time to Send Message?",
"type": "n8n-nodes-base.if",
"position": [
1584,
-256
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "86ab6e76-7637-49c3-8cd3-3e81a22b7901",
"operator": {
"type": "string",
"operation": "empty"
},
"leftValue": "={{ $('\ud83d\udd17 Merge Config').item.json.lead_next_send }}",
"rightValue": ""
},
{
"id": "4ad83135-624c-4c57-9775-d3a967183b7c",
"operator": {
"type": "dateTime",
"operation": "beforeOrEquals"
},
"leftValue": "={{ DateTime.fromFormat($('\ud83d\udd17 Merge Config').item.json.lead_next_send, 'M/d/yyyy H:mm:ss') }}",
"rightValue": "={{$now}}"
}
]
}
},
"typeVersion": 2.3
},
{
"id": "b346cf78-59f0-493e-b6bc-289d937cb5fa",
"name": "Send message",
"type": "n8n-nodes-linked-api.linkedApi",
"position": [
1792,
-384
],
"parameters": {
"operation": "sendMessage",
"personUrl": "={{ $('\ud83d\udd00 Route by Status').item.json.lead_url }}",
"messageText": "={{ $('\ud83d\udd00 Route by Status').item.json.lead_message_1 }}"
},
"credentials": {
"linkedApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "370c6d59-b6e2-43ba-bb14-83d206b84a6a",
"name": "Wait 'Send message'",
"type": "n8n-nodes-base.wait",
"position": [
1984,
-384
],
"parameters": {
"resume": "webhook",
"options": {}
},
"typeVersion": 1.1
},
{
"id": "ac5c08bc-1281-4002-80d7-2b8a4e81df04",
"name": "\u2753 Successfully Sent Connection?",
"type": "n8n-nodes-base.if",
"position": [
2272,
-2112
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "cdc680c1-a619-4d8b-92da-2d2a4e206995",
"operator": {
"type": "array",
"operation": "empty"
},
"leftValue": "={{ $json.body.errors }}",
"rightValue": ""
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.3
},
{
"id": "825ea7ff-2def-43b7-8eff-772b47c68c02",
"name": "\u2753 Successfully Sent Message?",
"type": "n8n-nodes-base.if",
"position": [
2192,
-384
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 3,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "07fd870d-f3d3-4d0f-869a-d61d138d60b3",
"operator": {
"type": "array",
"operation": "empty"
},
"leftValue": "={{ $json.body.errors }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.3
},
{
"id": "ac57de0f-1038-4697-95f3-fa5957905ff2",
"name": "\ud83d\udcbe Update Sheet (PENDING)",
"type": "n8n-nodes-base.googleSheets",
"position": [
2544,
-2208
],
"parameters": {
"columns": {
"value": {
"Status": "PENDING_CONNECTION",
"row_number": "={{ $('\ud83d\udd17 Merge Config').item.json.lead_row_number }}",
"Next check date": "={{ $now.plus({ hours: $('\ud83d\udd17 Merge Config').item.json.config_hours_check_connection }).toFormat('M/d/yyyy HH:mm') }}",
"Last action date": "={{ $now.toFormat('M/d/yyyy HH:mm') }}"
},
"schema": [
{
"id": "LinkedIn URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "LinkedIn URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Connection note",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Connection note",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 1",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 3",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message stage",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next send date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Next send date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next check date",
"type": "string",
"display": true,
"required": false,
"displayName": "Next check date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last action date",
"type": "string",
"display": true,
"required": false,
"displayName": "Last action date",
"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": "name",
"value": "={{ $('\ud83d\udd17 Merge Config').item.json.config_sheet_name }}"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('\ud83d\udd17 Merge Config').item.json.config_document_link }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "5df8958e-c943-4adb-acc4-438fa6f1bd28",
"name": "\ud83d\udcbe Update Sheet (CONNECTION ERROR)",
"type": "n8n-nodes-base.googleSheets",
"position": [
2544,
-2032
],
"parameters": {
"columns": {
"value": {
"Status": "ERROR",
"row_number": "={{ $('\ud83d\udd17 Merge Config').item.json.lead_row_number }}",
"Last action date": "={{ $now.toFormat('M/d/yyyy HH:mm') }}"
},
"schema": [
{
"id": "LinkedIn URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "LinkedIn URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Connection note",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Connection note",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 1",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 3",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message stage",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next send date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Next send date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next check date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Next check date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last action date",
"type": "string",
"display": true,
"required": false,
"displayName": "Last action date",
"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": "name",
"value": "={{ $('\ud83d\udd17 Merge Config').item.json.config_sheet_name }}"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('\ud83d\udd17 Merge Config').item.json.config_document_link }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "a9778b9b-e0a5-4e85-8f6f-d3152ddaaabd",
"name": "\ud83d\udcbe Update Sheet (CONNECTED)",
"type": "n8n-nodes-base.googleSheets",
"position": [
2768,
-1664
],
"parameters": {
"columns": {
"value": {
"Status": "=CONNECTED",
"row_number": "={{ $('\ud83d\udd17 Merge Config').item.json.lead_row_number }}",
"Next send date": "={{ $now.plus({ hours: $('\ud83d\udd17 Merge Config').item.json.config_hours_after_connect }).toFormat('M/d/yyyy HH:mm') }}",
"Last action date": "={{ $now.toFormat('M/d/yyyy HH:mm') }}"
},
"schema": [
{
"id": "LinkedIn URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "LinkedIn URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Connection note",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Connection note",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 1",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 3",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message stage",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next send date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Next send date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next check date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Next check date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last action date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Last action date",
"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": "name",
"value": "={{ $('\ud83d\udd17 Merge Config').item.json.config_sheet_name }}"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('\ud83d\udd17 Merge Config').item.json.config_document_link }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "337e0bf4-7880-4b3c-a1b8-95ab6baf8c8b",
"name": "\ud83d\udcbe Update Sheet (EXPIRED)",
"type": "n8n-nodes-base.googleSheets",
"position": [
2768,
-1472
],
"parameters": {
"columns": {
"value": {
"Status": "=CONNECTION_EXPIRED",
"row_number": "={{ $('\ud83d\udd17 Merge Config').item.json.lead_row_number }}",
"Message stage": "=",
"Next send date": "=",
"Next check date": "=",
"Last action date": "={{ $now.toFormat('M/d/yyyy HH:mm') }}"
},
"schema": [
{
"id": "LinkedIn URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "LinkedIn URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Connection note",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Connection note",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Message 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Message 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Message 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message stage",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Message stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next send date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Next send date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next check date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Next check date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last action date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Last action date",
"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": "name",
"value": "={{ $('\ud83d\udd17 Merge Config').item.json.config_sheet_name }}"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('\ud83d\udd17 Merge Config').item.json.config_document_link }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "a9cc119c-634e-442f-ae2a-b70807b382e3",
"name": "\ud83d\udcbe Update Sheet (STILL PENDING)",
"type": "n8n-nodes-base.googleSheets",
"position": [
2768,
-1280
],
"parameters": {
"columns": {
"value": {
"row_number": "={{ $('\ud83d\udd17 Merge Config').item.json.lead_row_number }}",
"Next check date": "={{ $now.plus({ hours: $('\ud83d\udd17 Merge Config').item.json.config_hours_check_connection }).toFormat('M/d/yyyy HH:mm') }}"
},
"schema": [
{
"id": "LinkedIn URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "LinkedIn URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Connection note",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Connection note",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Message 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Message 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Message 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message stage",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Message stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next send date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Next send date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next check date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Next check date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last action date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last action date",
"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": "name",
"value": "={{ $('\ud83d\udd17 Merge Config').item.json.config_sheet_name }}"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('\ud83d\udd17 Merge Config').item.json.config_document_link }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "9ad33363-d0d4-493e-9206-58181f8ea8d7",
"name": "\ud83d\udcbe Update Sheet (DECLINED)",
"type": "n8n-nodes-base.googleSheets",
"position": [
2768,
-1088
],
"parameters": {
"columns": {
"value": {
"Status": "=DECLINED",
"row_number": "={{ $('\ud83d\udd17 Merge Config').item.json.lead_row_number }}",
"Last action date": "={{ $now.toFormat('M/d/yyyy HH:mm') }}"
},
"schema": [
{
"id": "LinkedIn URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "LinkedIn URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Connection note",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Connection note",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 1",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Message 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message 3",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Mes
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.
googleSheetsOAuth2ApilinkedApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Automate your LinkedIn outreach with this n8n workflow powered by Linked API. Sends connection requests, monitors acceptance, delivers your pre-written messages, and follows up automatically – all tracked in Google Sheets. Connection phase – Sends connection requests to leads…
Source: https://n8n.io/workflows/12915/ — 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 template is ideal for sales teams, recruiters, business development professionals, and relationship managers who need to monitor changes in their network's LinkedIn profiles. Perfect for agencies
Google Sheets, HTTP Request, Slack
Save time - Eliminate manual LinkedIn posting and content scheduling tasks Stay consistent - Automated daily posting keeps your LinkedIn profile active and engaging Keep control - Preview every post b
HTTP Request, Telegram, Google Sheets +2
Automate LinkedIn organization page posting with precise time scheduling and Google Drive media management. Runs hourly during business hours, processes approved posts scheduled for today, waits until
Google Sheets, Google Drive, LinkedIn
> 📊 See real sample data this workflow collects: > View Sample Google Sheet →
Google Sheets, Data Table, @Apify/N8N Nodes Apify
This workflow is perfect for content creators, social media managers, and businesses who want to schedule and automatically post videos 📹 to multiple platforms (Instagram, LinkedIn, TikTok) without ma
Google Sheets, Telegram, N8N Nodes Upload Post