Research business leads with Perplexity AI & save to Google Sheets using OpenAI
Automatically research new leads in your target area, structure the results with AI, and append them into Google Sheets — all orchestrated in n8n. --- ✅ What this template does Uses Perplexity to research businesses (coffee shops in this example) with company name + email Cleans and structures the output into proper JSON using OpenAI Appends the new leads directly into Google Sheets, skipping duplicates > Trigger: Manual — “Start Workflow” --- 👤 Who’s it for Sales & marketing teams who need to prospect local businesses Agencies running outreach campaigns Freelancers and consultants looking to automate lead research --- ⚙️ How it works Set Location → define your target area (e.g., Hershey PA) Get Current Leads → pull existing data from your Google Sheet to avoid duplicates Research Leads → query Perplexity for 20 businesses, excluding already-scraped ones Write JSON → OpenAI converts Perplexity output into structured Company/Email arrays Split & Merge → align Companies with Emails row-by-row Send Leads to Google Sheets → append or update leads in your sheet --- 🛠️ Setup instructions Follow these sticky-note setup steps (already included in the workflow): 1) Connect Google Sheets (OAuth2) In n8n → Credentials → New → Google Sheets (OAuth2) Sign in with your Google account and grant access In the Google Sheets node, select your Spreadsheet and Worksheet Example sheet: https://docs.google.com/spreadsheets/d/1MnaU8hSi8PleDNVcNnyJ5CgmDYJSUTsr7X5HIwa-MLk/editgid=0 --- 2) Connect Perplexity (API Key) Sign in at https://www.perplexity.ai/account Generate an API key: https://docs.perplexity.ai/guides/getting-started In n8n → Credentials → New → Perplexity API, paste your key --- 3) Connect OpenAI (API Key) In n8n → Credentials → New → OpenAI API Paste your OpenAI API key In the OpenAI Chat Model node, select your credential and a vision-capable model (e.g., gpt-4o-mini, gpt-4o) --- 🔧 Requirements A free Google account An OpenAI API key (https://platform.openai.com) A Perplexity API key (https://docs.perplexity.ai) n8n self-hosted or cloud instance --- 🎨 How to customize Change the Search Area in the Set Location node Modify the Perplexity system prompt to target different business types (e.g., gyms, salons, restaurants) Expand the Google Sheet schema to include more fields (phone, website, etc.) --- 📬 Contact Need help customizing this (e.g., filtering by campaign, sending reports by email, or formatting your Google Sheet)? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com
By Robert BreenAutomate cross-posting from Telegram to Facebook with Airtop Browser Automation
Overview This template allows you to automatically post messages from Telegram directly to Facebook using Airtop no-code browser automation. It is designed for creators, social media managers, and businesses that want to streamline their cross-posting workflow without coding. Why this is valuable Manually copying messages from Telegram to Facebook can be time-consuming and error-prone. With this automation: Every Telegram message you send to your bot can instantly appear on Facebook. You save time, reduce repetitive manual work, and ensure consistent messaging across platforms. Perfect for community managers, marketing teams, and content creators who want to grow their Facebook presence while engaging Telegram followers. How it works A Telegram Trigger listens for incoming messages to your bot. Airtop starts a browser session and opens Facebook. The bot clicks into the composer, types your Telegram message, and presses Publish. (Optional) It can also tag followers or add extra text. Finally, Telegram sends you a confirmation: “✅ Facebook: post published.” Setup Connect your Telegram Bot credentials. Add your Airtop API key/account. On first run, log in to Facebook inside Airtop (it will reuse the session later). Customization Change selectors or text if your Facebook interface differs. Add more automation steps (like attaching images, tagging pages, or posting into groups). Adjust Wait nodes if your connection is slower.
By Ivan Maksiuta