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 →
{
"name": "AUTO MESSAGE NEW CONNECTION",
"nodes": [
{
"parameters": {
"content": "## Engage Instantly: Auto-Message New LinkedIn Connections\n### This automates the process of updating a Google Sheets document when a LinkedIn connection request is accepted, marking the invitation as accepted.\n### It also sends a message to the new connection and logs the interaction in a database, ensuring seamless communication and tracking.",
"height": 400,
"width": 2280,
"color": 6
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-112,
-96
],
"id": "6a0d856c-5f26-42e9-a50d-7801267851e6",
"name": "Sticky Note10"
},
{
"parameters": {
"content": "### Fetches the LinkedIn message body from Google Sheet based on the provider ID",
"height": 100,
"width": 320
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
1216,
208
],
"id": "14f655c4-510d-48c6-a0c3-a361c8f264f2",
"name": "Sticky Note8"
},
{
"parameters": {
"content": "### When new message recieved (webhook created in Unipile)",
"height": 100,
"width": 320
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-96,
176
],
"id": "96081f21-5c05-45e0-ab31-c5e4787ee6cd",
"name": "Sticky Note11"
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1tSl-WdN2D6BPtWbE0Yu2WWY4tjfr6likzBHgoNJAnRQ",
"mode": "list",
"cachedResultName": "LN Tracker",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1tSl-WdN2D6BPtWbE0Yu2WWY4tjfr6likzBHgoNJAnRQ/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1tSl-WdN2D6BPtWbE0Yu2WWY4tjfr6likzBHgoNJAnRQ/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"LN_providerID": "={{ $json.LN_providerID }}",
"LN_invitationaccepted": "YES"
},
"matchingColumns": [
"LN_providerID"
],
"schema": [
{
"id": "first_name",
"displayName": "first_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "last_name",
"displayName": "last_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Name",
"displayName": "Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_url",
"displayName": "LN_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_publicID",
"displayName": "LN_publicID",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_providerID",
"displayName": "LN_providerID",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "LN_invitationSent",
"displayName": "LN_invitationSent",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_invitationaccepted",
"displayName": "LN_invitationaccepted",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "LN_msgSent",
"displayName": "LN_msgSent",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "emailSent",
"displayName": "emailSent",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_emailReplied",
"displayName": "LN_emailReplied",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "OriginSpreadsheetID",
"displayName": "OriginSpreadsheetID",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Origin SheetID",
"displayName": "Origin SheetID",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_noofmessages",
"displayName": "LN_noofmessages",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Email",
"displayName": "Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
736,
48
],
"id": "913dac88-fa3f-498d-b474-719ad73af170",
"name": "update LN tracker",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "={{ $('Get the Person1').item.json.OriginSpreadsheetID }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $('Get the Person1').item.json[\"Origin SheetID\"] }}",
"mode": "id"
},
"filtersUI": {
"values": [
{
"lookupColumn": "Linkedin_ProviderID",
"lookupValue": "={{ $json.LN_providerID }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
1360,
48
],
"id": "da7dac36-a264-4bcc-8f1b-29c9003fe676",
"name": "Get LN body",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"schema": {
"__rl": true,
"value": "public",
"mode": "list",
"cachedResultName": "public"
},
"table": {
"__rl": true,
"value": "n8n_chat_histories",
"mode": "list",
"cachedResultName": "n8n_chat_histories"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"session_id": "={{ $('When First Msg Recieved').item.json.body.attendees[0].attendee_provider_id }}",
"messages": "={ \"type\": \"ai\", \"content\": \"{{ $('Get LN body').item.json.linkedin_body.replace(/\\n/g,'') }}\", \"tool_calls\": [], \"additional_kwargs\": {}, \"response_metadata\": {}, invalid_tool_calls\": [] }"
},
"matchingColumns": [],
"schema": [
{
"id": "session_id",
"displayName": "session_id",
"required": true,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "messages",
"displayName": "messages",
"required": true,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.5,
"position": [
1776,
48
],
"id": "d9c49510-e850-4728-b64f-53ff4a90f2d7",
"name": "add first msg to memory"
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1tSl-WdN2D6BPtWbE0Yu2WWY4tjfr6likzBHgoNJAnRQ",
"mode": "list",
"cachedResultName": "LN Tracker",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1tSl-WdN2D6BPtWbE0Yu2WWY4tjfr6likzBHgoNJAnRQ/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1tSl-WdN2D6BPtWbE0Yu2WWY4tjfr6likzBHgoNJAnRQ/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"LN_providerID": "={{ $('When First Msg Recieved').item.json.body.attendees[0].attendee_provider_id }}",
"LN_noofmessages": "1"
},
"matchingColumns": [
"LN_providerID"
],
"schema": [
{
"id": "first_name",
"displayName": "first_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "last_name",
"displayName": "last_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Name",
"displayName": "Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_url",
"displayName": "LN_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_publicID",
"displayName": "LN_publicID",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_providerID",
"displayName": "LN_providerID",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "LN_invitationSent",
"displayName": "LN_invitationSent",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_invitationaccepted",
"displayName": "LN_invitationaccepted",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_msgSent",
"displayName": "LN_msgSent",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "emailSent",
"displayName": "emailSent",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_emailReplied",
"displayName": "LN_emailReplied",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "OriginSpreadsheetID",
"displayName": "OriginSpreadsheetID",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Origin SheetID",
"displayName": "Origin SheetID",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "LN_noofmessages",
"displayName": "LN_noofmessages",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Email",
"displayName": "Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
1984,
48
],
"id": "f8974746-c760-40a4-b18d-9f053bd32b4d",
"name": "Update Message Number in GSheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"httpMethod": "POST",
"path": "deeba7a0-65c1-4c5b-ae32-6a2ff9a006e2",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
16,
48
],
"id": "00a758f9-f02f-4216-ace3-edc7fa6638bf",
"name": "When First Msg Recieved"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "8b46b7be-162d-4f3c-9a99-0daeb1286fc2",
"leftValue": "={{ $json.LN_noofmessages }}",
"rightValue": 0,
"operator": {
"type": "number",
"operation": "equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
432,
48
],
"id": "6530fe33-af6a-4889-a403-2acae6c91822",
"name": "If1"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1tSl-WdN2D6BPtWbE0Yu2WWY4tjfr6likzBHgoNJAnRQ",
"mode": "list",
"cachedResultName": "LN Tracker",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1tSl-WdN2D6BPtWbE0Yu2WWY4tjfr6likzBHgoNJAnRQ/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1tSl-WdN2D6BPtWbE0Yu2WWY4tjfr6likzBHgoNJAnRQ/edit#gid=0"
},
"filtersUI": {
"values": [
{
"lookupColumn": "LN_providerID",
"lookupValue": "={{ $json.body.attendees[0].attendee_provider_id }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
208,
48
],
"id": "e6918a0f-5fda-41ff-b5c2-c3d6277dba7f",
"name": "Get the Person1",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"method": "POST",
"url": "https://[subdomain].unipile.com:[port]/api/v1/chats",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-API-KEY",
"value": "your_unipile_api_key"
},
{
"name": "accept",
"value": "application/json"
},
{
"name": "content-type",
"value": "multipart/form-data"
}
]
},
"sendBody": true,
"contentType": "multipart-form-data",
"bodyParameters": {
"parameters": [
{
"name": "attendees_ids",
"value": "={{ $json.Linkedin_ProviderID }}"
},
{
"name": "account_id",
"value": "your_unipile_account_id"
},
{
"name": "text",
"value": "={{ $json.linkedin_body }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
1584,
48
],
"id": "ec89e4f3-568d-425f-892f-120228eae20c",
"name": "SendMessage1"
},
{
"parameters": {
"amount": "={{ $json.RandomNumber }}"
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
1136,
48
],
"id": "6ca0ce54-1ca8-4da3-8ec1-8b92afa6447b",
"name": "Wait3"
},
{
"parameters": {
"jsCode": "items[0].json.RandomNumber = Math.floor(Math.random() * 8);\nreturn items;"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
944,
48
],
"id": "5edbe144-0683-49d7-a3f6-e73a2a4f5538",
"name": "randomizer2"
}
],
"connections": {
"update LN tracker": {
"main": [
[
{
"node": "randomizer2",
"type": "main",
"index": 0
}
]
]
},
"Get LN body": {
"main": [
[
{
"node": "SendMessage1",
"type": "main",
"index": 0
}
]
]
},
"add first msg to memory": {
"main": [
[
{
"node": "Update Message Number in GSheet",
"type": "main",
"index": 0
}
]
]
},
"When First Msg Recieved": {
"main": [
[
{
"node": "Get the Person1",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "update LN tracker",
"type": "main",
"index": 0
}
]
]
},
"Get the Person1": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"SendMessage1": {
"main": [
[
{
"node": "add first msg to memory",
"type": "main",
"index": 0
}
]
]
},
"Wait3": {
"main": [
[
{
"node": "Get LN body",
"type": "main",
"index": 0
}
]
]
},
"randomizer2": {
"main": [
[
{
"node": "Wait3",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"availableInMCP": false
},
"versionId": "94d6261b-d8c2-4eeb-8e7d-82acd0e16d24",
"id": "URsKYgfWqnnWgjxh",
"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.
googleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
Automatically send a personalised welcome message to new LinkedIn connections, saving you hours of manual outreach and helping build your professional network effortlessly. This workflow is ideal for sales professionals, recruiters, or marketers who connect with dozens of people weekly on LinkedIn and want to nurture leads from the start. It triggers via webhook when a new connection is detected, pulls a custom message template from Google Sheets, stores the interaction in Postgres for tracking, and sends the message using an HTTP request to LinkedIn's API.
Use this workflow when you have a steady influx of LinkedIn connections and need consistent follow-up without constant monitoring. Avoid it if your connections are sporadic or if you prefer fully manual messaging to maintain authenticity. Common variations include adding conditional logic for different industries or integrating email notifications for responses.
About this workflow
AUTO MESSAGE NEW CONNECTION. Uses stickyNote, googleSheets, postgres, httpRequest. Webhook trigger; 13 nodes.
Source: https://github.com/lucky14426/ai-outreach-automation-platform/blob/main/workflows/04-connection-engagement/auto-message-new-connection.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.
Receive request via webhook with customer question Analyze sentiment and detect urgency using JavaScript Send urgent alerts to Slack for critical cases Search knowledge base and fetch conversation his
HTTP Request, Postgres, Email Send +1
This comprehensive n8n workflow automates the entire travel business call management process, from initial customer inquiries to trip bookings and marketing outreach. The system handles incoming calls
Postgres, Google Sheets Trigger, HTTP Request +1
upload_answer. Uses httpRequest, openAi, googleDrive, googleSheets. Webhook trigger; 27 nodes.
HTTP Request, OpenAI, Google Drive +2
BP_check. Uses googleSheets, @n-octo-n/n8n-nodes-json-database, httpRequest, itemLists. Webhook trigger; 99 nodes.
Google Sheets, @N Octo N/N8N Nodes Json Database, HTTP Request +2
This workflow acts as a junior finance research analyst for a UK boutique M&A or corporate finance team. It listens for Slack messages, classifies the request, gathers company or market data, and prod
HTTP Request, Google Drive, Google Docs +5