Scrape business leads from Google Maps using OpenAI and Google Sheets
Google Maps Data Extraction Workflow for Lead Generation This workflow is ideal for sales teams, marketers, entrepreneurs, and researchers looking to efficiently gather detailed business information from Google Maps for: Lead generation Market analysis Competitive research --- Who Is This Workflow For? Sales professionals aiming to build targeted contact lists Marketers looking for localized business data Researchers needing organized, comprehensive business information --- Problem This Workflow Solves Manually gathering business contact details from Google Maps is: Tedious Error-prone Time-consuming This workflow automates data extraction to increase efficiency, accuracy, and productivity. --- What This Workflow Does Automates extraction of business data (name, address, phone, email, website) from Google Maps Crawls and extracts additional website content Integrates OpenAI to enhance data processing Stores structured results in Google Sheets for easy access and analysis Uses Google Search API to fill in missing information --- Setup Import the provided n8n workflow JSON into your n8n instance. Set your OpenAI and Google Sheets API credentials. Provide your Google Maps Scraper and Website Content Crawler API keys. Ensure SerpAPI is configured to enhance data completeness. --- Customizing This Workflow to Your Needs Adjust scraping parameters: Location Business category Country code Customize Google Sheets output format to fit your current data structure Integrate additional AI processing steps or APIs for richer data enrichment --- Final Notes This structured approach ensures: Accurate and compliant data extraction from Google Maps Streamlined lead generation Actionable and well-organized data ready for business use 📄 Documentation: Notion Guide Demo Video 🎥 Watch the full tutorial here: YouTube Demo
By Dr. FirasInsert a document in MongoDB
Companion workflow for MongoDB node docs
By amudhanSplit in batches node noItemsLeft example
This workflow demonstrates how to use noItemsLeft to check if there are items left to be processed by the SplitInBatches node. Function node: This node generates mock data for the workflow. Replace it with the node whose data you want to split into batches. SplitInBatches node: This node splits the data with the batch size equal to 1. Based on your use-case, set the value of the Batch Size. IF node: This node check if all the data by the SplitInBatches are not processed or not. It uses the expression {{$node["SplitInBatches"].context["noItemsLeft"]}} which returns a boolean value. If there is data yet to be processed, the expression will return false, otherwise true. Set node: This node prints a message No Items Left. Based on your use-case, connect the false output of the IF node to the input of the node you want to execute, after the data is processed by the SplitInBatches node.
By Harshil AgrawalGenerate professional product images | AI marketing campaign generator
🚀 AI Marketing Campaign Generator Upload product image + details → Get complete professional marketing campaign with 5 custom-generated assets automatically. 🤖 AI Model GPT-4o Mini (OpenAI) - For campaign strategy | Prompt Image generation GPT Image-1 (OpenAI) - For visual asset generation 🔑 Required API Keys OpenAI API - AI analysis & image generation Google Drive API - Asset storage & organization 🎯 What It Generates 5 Marketing Assets: Instagram Post, Instagram Story, Website Banner, Ad Creative, Testimonial Graphic Brand Strategy: Colors, tone, positioning from your product image Campaign Strategy: Messaging, target audience, objectives Visual Analysis: Extracts colors, materials, styling from uploaded image ⚙️ Setup Import JSON to n8n Add OpenAI & Google Drive credentials Configure Google Drive folder for asset storage Deploy form webhook Test with product image upload 📱 How It Works Upload product image → AI analyzes visual + text → Generates complete campaign → Creates 5 custom marketing assets → Saves to Google Drive
By Rami ColeYouTube video transcription & summary to Telegram with GPT-4o
⚠️ Disclaimer This workflow uses a community node: npm install n8n-nodes-supadata Please make sure to install this before running the workflow. 🔎 Who is this for? This workflow is for anyone who wants quick summaries of YouTube videos, such as researchers, students, analysts, or busy professionals. Just send a video link via Telegram and receive a structured summary in seconds—no need to watch the entire video. 🧠 What problem is this workflow solving? Watching long videos to extract key information is time-consuming. This automation solves that by instantly: Fetching the full transcript of the video Summarizing the content with AI Sending a clean summary directly to Telegram for quick reading It’s a fast and reliable way to stay informed without the overwhelm. ⚙️ What this workflow does 💬 Telegram Trigger Start by sending a YouTube link to your Telegram bot. 🎙️ Get Transcript (Supadata) Uses Supadata API to retrieve the full video transcript. 🧠 Summarize with OpenAI GPT-4o Processes the transcript using a structured prompt to extract: Main theme of the video Target audience Key insights and tips Problems discussed and solutions mentioned Notable quotes or highlights 📨 Send to Telegram The final summary is formatted and sent back to your Telegram chat, ready for reading or saving. 🛠️ Requirements n8n instance (Cloud or self-hosted) Supadata API Key OpenAI API Key Telegram Bot Token ✅ Output Example The Telegram summary includes: 🎯 Title and topic 💡 Key learnings 🛠️ Tips or insights 🚨 Issues raised and solutions 📝 Quotes or highlights Just send a link, and get the core message—fast. Perfect for learning on the go. 🧠📲 --- Made by: Khaisa Studio Tag: youtube, summarizer, telegram, openai Category: AI Automation, Video Tools Need a custom? contact me on LinkedIn or Web
By Khairul MuhtadinGenerate and send contract documents with Typeform, Google Docs and Gmail
This workflow is designed for teams or freelancers who want to auto-generate and send contracts based on information gathered from a Typeform (e.g., client name, project scope, deadlines). Perfect for HR onboarding, client agreements, or legal operations. Prerequisites To use this workflow, you’ll need: A Typeform account and a published form Access to Google Docs (or use a local document template) Gmail or SMTP email integration in n8n n8n Desktop or a hosted n8n instance How It Works Trigger: Listens for new Typeform submissions. Extract Data: Parses the answers from the form. Generate Contract: Fills a contract template using form inputs. Create PDF: Exports the filled contract as a PDF. Send Email: Sends the PDF to the client’s email address provided in the form. Nodes Used Typeform Trigger – Triggers on form submission. Set Node – Maps form answers into variables. Google Docs (or HTTP Request) – Uses a template to generate the contract. Google Drive / PDF Converter – Converts to PDF (if needed). Email (Gmail/SMTP) – Sends the completed contract to the recipient. Tips Replace the Google Docs template ID with your own. Ensure the variable placeholders (like {{client_name}}) match your document. Use the Cron node instead of Typeform Trigger if you want to poll periodically.
By Abbas AliHackathon participant badge generator with QR code, PDF & email delivery
Title Hackathon Participant Badge Generator with QR Code & Email Delivery --- Description A fast, reliable, and fully automated workflow that generates professional participant badges for hackathons, tech events, and workshops — complete with unique Badge ID, QR verification, PDF output, and email delivery. This workflow takes any simple registration input and transforms it into a verified, branded participant badge in under 10 seconds. --- What this workflow does Accepts event registrations via a POST Webhook (name, email, event, team, role). Performs input validation and disposable/fake email detection using VerifiEmail. Creates a unique Badge ID (e.g., HACK-2025-1763560499-AB3XYF). Generates a public verification URL and QR code for check-in. Builds a high-resolution badge (1056×816px) with event branding, logo, gradient background, and QR code. Converts the HTML badge design into a print-ready PDF using PDFMunk (htmlcsstopdf). Sends a beautiful HTML email via Gmail that includes: Inline badge preview (visible immediately) Attached PDF badge Verification URL + Badge ID Logs all badge metadata to Google Sheets for audit and check-in tracking. Returns a clean JSON success response to the caller. --- Use Cases Ideal for: Hackathons & tech conferences Engineering fests & competitions Workshops, meetups, bootcamps Any event requiring verified digital badges with QR check-in --- Key Features Real-time email verification blocks fake/disposable registrations. QR code check-in powered by a reliable public QR API. Fully customizable badge design — swap logos, colors, fonts easily. Inline email preview means participants see their badge instantly. Complete event log stored in Google Sheets with timestamps, PDF links, and verification URLs. Extendable (add Slack alerts, Drive uploads, role-based templates, etc.) --- Setup Instructions (5 Minutes) Add your credentials: VerifiEmail PDFMunk (HTML → PDF) Gmail Google Sheets Update your: Logo URL Verification domain Activate the workflow and start sending POST requests to the Webhook. Badges will be generated and emailed automatically — no manual work needed. --- Why this workflow is special It’s built for speed, reliability, visual quality, and zero manual overhead. Participants receive a sleek, branded badge instantly, organizers get automated logs, and your event gets a professional identity. Perfect for teams who want enterprise-grade badge automation without writing a single line of code. --- Tags hackathon, badge, qr-code, pdf, email, gmail, automation, participant, event, check-in, google-sheets
By Jitesh DugarGenerate personalized sales follow-ups from Fireflies transcripts with Gemini & Google Drive
Automatically Generate AI Follow-Up Messages from Fireflies Transcripts This workflow automates creating personalized follow-up messages for your clients based on meeting transcripts fetched from Fireflies. It ensures the right guest information is captured, the transcript is processed by AI, and the output is stored neatly in Google Drive. What it Does Triggers on New Appointment: The workflow starts when a new appointment is created in Google Calendar. Extracts Guest and Appointment Details: The Edit Fields node extract the guest's email, appointment start/end time, status, and creator. Fetches Transcript from Fireflies: The GraphQL node queries Fireflies using the guest email to fetch the meeting transcript, including sentences, participants, and summary. Skip IF Empty: The Filter node skip passing the Info to AI Agent if there is no record in Fireflies Generates Follow-Up Messages via AI: The AI Agent node (powered by Google Gemini) creates 12 personalized follow-up messages/emails for the guest. Messages are conversational, concise, and reference topics and pain points mentioned in the call. The messages are tailored to re-engage the client and guide them towards making a purchase. Stores Messages in Google Drive: The Google Drive node saves the AI-generated messages in a specific folder, named after the guest, for easy reference. Use Cases Missed Follow-Ups: Automatically create personalized follow-ups after client calls without manual effort. Sales & Customer Engagement: Ensure every client gets context-specific messages, improving engagement and conversion. Team Collaboration: Messages are saved in Google Drive, making it easy for your team to review and send manually if needed. Customization Transcript Source: The GraphQL node can be customized to fetch transcripts for specific guests or date ranges. Message Personalization: The AI prompt in AI Agent can be updated to change the tone, style, or length of messages. Storage Folder: You can change the folder in the Google Drive node to organize messages per team, campaign, or client. Troubleshooting AI Messages Not Generated: Verify AI Agent node is connected to Google Gemini Chat Model and has correct API credentials. Messages Not Saved: Check the Google Drive folder ID and access permissions. Requirements An N8N instance (self-hosted or cloud). Google Gemini API credentials. Google Drive account with proper folder access. Fireflies API credentials with GraphQL access. How to Set Up Connect Credentials: In Google Calendar Node, GraphQL, AI Agent, and Google Drive nodes, select your credentials for Google Calendar, Fireflies, Google Gemini, and Google Drive. Set Guest Details Extraction: Verify the Edit Fields node extracts all required fields (first name, last name, email, appointment times, status). Update GraphQL Query: Ensure the query correctly fetches transcripts by guest email. Adjust if your Fireflies workspace uses different fields. Customize AI Prompt: Update AI Agent with the exact instructions for message generation (number of messages, tone, context, platform). Configure Google Drive Storage: Select the proper folder to save messages, ideally using guest name as file name for easy reference. Activate Workflow: Save and activate the workflow. Video Tutorial: Step by step video instructions present here for beginners https://youtu.be/5t9xXCz4DzM
By Websensepro