Back to Templates

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

Created by

Created by: Rahul Joshi || rahul08

Rahul Joshi

Last update

Last update a day ago

Share


📊 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