Send AI-personalized LinkedIn outreach from Google Sheets with Azure OpenAI and ConnectSafely

Go to Workflow
85 views
Built by Rahul Joshi Rahul Joshi
Created on June 06, 2026

Description

📊 Description
Automate personalized LinkedIn outreach at scale using AI and real prospect data. 🤖📧
This workflow pulls leads from Google Sheets, generates human-like LinkedIn messages with Azure OpenAI, and sends them safely via the ConnectSafely LinkedIn API. It intelligently avoids duplicate messages, validates delivery, and updates message status back into your sheet automatically. Perfect for consistent, non-salesy B2B outreach with zero manual effort.

What This Template Does

⏰ Triggers automatically on a daily schedule to start LinkedIn outreach.

📄 Fetches prospect details from Google Sheets for processing.

🔁 Loops through prospects in controlled batches to avoid API limits.

🧠 Uses AI to generate personalized LinkedIn messages based on role, company, industry, and activity.

✅ Checks if a message already exists to prevent duplicates.

💾 Saves generated messages back to Google Sheets for tracking.

🔍 Fetches LinkedIn profile data and profile URNs via ConnectSafely.

💬 Sends personalized LinkedIn messages safely using the ConnectSafely API.

📊 Updates Google Sheets with message delivery status and LinkedIn profile links.

Key Benefits
✅ Fully automated LinkedIn outreach with no manual copywriting
✅ AI-driven personalization for higher reply rates
✅ Prevents duplicate messages automatically
✅ Centralized tracking inside Google Sheets
✅ Safe LinkedIn messaging using ConnectSafely APIs
✅ Scalable daily outreach without risking account limits

Features
Scheduled trigger for daily LinkedIn outreach
Google Sheets integration for lead management
Azure OpenAI (GPT-4o-mini) for AI message generation
Batch processing for rate-limit safety
Conditional logic to validate message creation
ConnectSafely LinkedIn API for profile lookup and message sending

Requirements
Google Sheets account with prospect data
Azure OpenAI credentials (GPT-4o-mini access)
ConnectSafely LinkedIn API credentials
n8n instance with scheduled workflows enabled

Target Audience
B2B founders and agency owners doing LinkedIn outreach
Sales and lead generation teams
Growth marketers running outbound campaigns
Automation consultants building LinkedIn workflows

Nodes Used (5)

AI Agent
@n8n/n8n-nodes-langchain.agent
Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi
Code
n8n-nodes-base.code
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest