Google Sheets and Microsoft Outlook integration

Description This workflow automates the first line of customer support by intelligently drafting email replies. It bridges the gap between your CRM (Supabase), your technical documentation (Vector Store), and your inbox (Outlook). By analyzing the sender's identity and the technical content of the query, it ensures that every draft reply is personalized, accurate, and follows strict business rules. How It Works Trigger: Monitors a Microsoft Outlook inbox for new incoming messages. Contact Enrichment: Queries a Supabase contacts table using the sender's email to retrieve their name, organization, and department. Context Construction: A Code node prepares a "Chat Input" that includes the email body, sender metadata, and specific brand "Business Rules." AI Intelligence (RAG): An AI Agent (GPT-4o) analyzes the request. If technical details are required, the Agent uses a Supabase Vector Store tool to retrieve semantic matches from your product manuals. Draft Creation: The AI generates an HTML-formatted reply which is saved as a Draft in Outlook for manual review. Audit Trail: Logs the intent, urgency, and outcome into a Google Sheet for performance tracking. Requirements Microsoft Outlook:** Business/Office 365 account. Supabase:** * A table for contact lookups. A vector-enabled database containing document embeddings. OpenAI API:** For the GPT-4o model and embeddings. Google Sheets:** To maintain an execution summary log. Setup Instructions Import: Paste the workflow JSON into your n8n canvas. Credentials: Set up and select credentials for Outlook, OpenAI, Supabase, and Google Sheets. Placeholder Updates: Fetch Contact Info: Set the table name to your specific CRM table. Vector Store: Update the table name and query function to match your Supabase Vector Store setup. Log to Google Sheets: Replace the Document ID and Sheet Name with your specific spreadsheet details. Persona Tuning: Open the AI Support Agent node and the Build AI Prompt code node to replace the [YOUR_COMPANY] and [YOUR_NAME] placeholders with your actual brand identity. Customization Ideas Urgency Routing:** Add an If node after the Agent to send a Slack or Teams notification if the AI detects the urgency is "high." Attachments:** Modify the Outlook node to include specific PDF brochures based on the primary_product_codes identified by the AI. Human-in-the-loop:** Use n8n "Wait for Webhook" or "Manual Approval" nodes if you want to approve the draft within the n8n UI before it hits the Outlook drafts folder.

AI Agent Lead Funnel for AI Agencies An End-to-End Automation That Turns Demos Into Booked Calls This n8n workflow is a full inbound → outbound hybrid funnel designed for AI agencies. It captures warm leads through instant AI value, then automatically follows up with personalized, context-aware outreach and reminders until the lead either replies or books a call. No cold scraping. No manual follow-ups. Just leverage + timing. 🚀 How the Workflow Works 📋 PART 1 — Lead Capture & Instant Value 1 — Share High-Impact AI Image Edits You post before/after examples using the NanoBanna / Gemini image-editing model on social platforms. Each post includes a link to a lightweight form. The visual results do the selling for you. 2 — Lead Submits Image & Details The form collects: Image upload Edit instructions Name Email Company name This filters for high-intent prospects only. 3 — AI Edits the Image Instantly Once submitted, the workflow: Sends the image + instructions to the AI image editor Preserves lighting and camera angle unless specified Generates a polished result in seconds 4 — Result Delivered via Email The edited image is emailed directly to the user with: A friendly confirmation message Soft positioning for future work This establishes trust before any sales motion happens. 5 — Lead Is Logged Automatically All lead data is saved to Google Sheets: Name Company Email Timestamp This becomes your live CRM of warm inbound leads. 🤖 PART 2 — AI-Driven Personalized Outreach 6 — AI Analyzes the Lead An AI sales agent: Looks at the company name + context Reviews a library of proven automation ideas Either selects the best fit or creates a simple custom one 7 — AI Writes a Personalized Outreach Email The agent generates a short email that: Mentions a specific automation already built States you can help implement it quickly Invites them to book a call via your calendar No marketing fluff. No generic pitches. Every email feels hand-written. 8 — Outreach Email Is Sent Automatically The email is sent from your inbox (Outlook, Gmail, SMTP, etc.) and includes: Their name Their company A clear calendar booking link 📬 PART 3 — Smart Follow-Up System 9 — Wait 48 Hours The workflow pauses to give the lead time to respond naturally. 10 — Check for a Reply After 48 hours: If the lead replied → they are tagged as Interested If no reply → continue to follow-up (Current reply detection is placeholder logic and can be swapped for a live inbox listener.) 11 — AI Writes a Polite Follow-Up If there’s no response, an AI agent writes: A short, non-pushy follow-up Referencing the original automation idea Under 60 words 12 — Follow-Up Email Is Sent The follow-up goes out automatically and keeps the conversation alive without manual effort. 📈 Why This Workflow Converts So Well Instant Value First Leads experience AI results before being pitched anything. Context-Aware Outreach Every email is personalized based on the lead, not a template. Built-In Persistence The system follows up automatically — no leads fall through the cracks. Fully Automated Once live, this workflow handles: Lead capture AI delivery Outreach Follow-ups CRM updates You just keep posting content. 🔧 Setup Requirements To deploy this workflow, connect: Google Gemini API** (image editing + agents) Email provider** Outlook Gmail SMTP Google Sheets** Columns: Name, Company, Email, Time, Status Calendar booking link** Example: https://cal.com/your-link All credentials are modular and easily swappable. 🎯 Summary This n8n automation turns attention into action by: Delivering immediate AI value Following up with relevant, personalized ideas Nudging leads toward a booked call — automatically It’s not just a lead funnel. It’s an AI sales assistant that runs 24/7.

📊 Description Automatically analyze your Instagram posts’ engagement and audience sentiment using GPT-4 to uncover top-performing content and improvement opportunities. 💬📈 This workflow fetches your latest Instagram posts using the Facebook Graph API, evaluates likes, comments, and tone, then generates structured performance insights. The results are logged into Google Sheets, shared via Slack alerts, and emailed through Outlook — empowering your social media team with daily, AI-powered engagement intelligence. 🚀 What This Template Does 1️⃣ Trigger – Runs daily at 10 AM to fetch the latest Instagram posts. ⏰ 2️⃣ Data Fetching – Uses the Facebook Graph API to extract post data, captions, likes, and comments. 📲 3️⃣ Formatting – Cleans and structures post and comment data for analysis. 🧩 4️⃣ AI Evaluation – GPT-4 analyzes engagement metrics and comment sentiment to score post performance. 🤖 5️⃣ Decision Routing – Flags high- and low-performing posts for separate processing. ⚙️ 6️⃣ Notifications – Sends positive performance summaries or negative alerts to Slack. 💬 7️⃣ Logging – Records engagement metrics, sentiment labels, and AI recommendations in Google Sheets. 📊 8️⃣ Reporting – Emails detailed performance summaries to the marketing team via Outlook. 💌 Key Benefits ✅ Automates social performance tracking across Instagram posts ✅ Provides AI-driven sentiment and engagement insights ✅ Flags top or underperforming content for immediate action ✅ Delivers Slack and email reports for team visibility ✅ Centralizes analytics in Google Sheets for trend tracking Features Facebook Graph API integration for Instagram post and comment retrieval GPT-4 sentiment and engagement evaluation Structured JSON insights and recommendations Slack alerts for both positive and negative performance Google Sheets data logging with trend metrics Outlook email reporting for management visibility Customizable scheduling and thresholds Requirements Facebook Graph API credentials connected to your Instagram Business account OpenAI API key for GPT-4 or GPT-4o-mini Slack Bot token with chat:write permissions Google Sheets OAuth2 credentials with edit rights Microsoft Outlook OAuth2 credentials for email delivery Optional environment variables for IDs: SHEET_ID, SLACK_CHANNEL_ID, OUTLOOK_EMAIL Target Audience Marketing and social media teams optimizing engagement 📣 Agencies managing multiple Instagram accounts 🧑‍💼 Analysts tracking performance metrics and audience tone 📊 Brands automating daily performance reports 📅 Step-by-Step Setup Instructions 1️⃣ Connect your Facebook Graph API to your Instagram Business Account. 2️⃣ Add OpenAI API credentials (use GPT-4 model for best results). 3️⃣ Configure Slack for team notifications and specify the channel ID. 4️⃣ Link Google Sheets and set your sheet ID for data logging. 5️⃣ Connect Microsoft Outlook for daily performance email reports. 6️⃣ Adjust the schedule (default: 10 AM daily) to suit your workflow. 7️⃣ Run a test once, verify data mapping, and enable automation. ✅

📊 Description Simplify your social media publishing process by automating post scheduling from Google Sheets directly to Meta (Facebook Pages). 📅💬 This workflow detects pending posts, uploads images with captions to your Facebook Page, updates the sheet status, and sends real-time notifications via Slack and email — keeping your marketing team always in sync. 🚀 What This Template Does 1️⃣ Trigger – Monitors a Google Sheet for new or pending posts every minute. ⏰ 2️⃣ Filter – Identifies the latest “pending” entry for publishing. 🔍 3️⃣ Extract – Captures post details like caption, image URL, and ID. 🧾 4️⃣ Publish – Uploads the post to your Meta (Facebook) Page using the Graph API. 📤 5️⃣ Validate – Confirms success or failure of the post operation. ✅ 6️⃣ Notify – Sends instant Slack and email updates on publishing status. 💌 7️⃣ Update – Marks the published post as “Completed” in Google Sheets. 📊 Key Benefits ✅ Hands-free publishing from Google Sheets to Meta ✅ Instant Slack and email alerts for post outcomes ✅ Prevents duplicate or failed post uploads ✅ Centralized content tracking and status updates ✅ Improves consistency and speed in social media operations Features Google Sheets trigger for post scheduling Facebook Graph API integration for auto-posting Slack and Outlook notifications for success/error alerts Automatic sheet updates post-publication Error handling and reporting for failed posts Requirements Google Sheets OAuth2 credentials Facebook Page Access Token via Graph API Slack Bot token for notifications Outlook or SMTP credentials for email updates Target Audience Marketing teams managing Facebook content calendars 📆 Social media managers seeking automated posting 📣 Agencies coordinating client content delivery 📋 Teams tracking campaign publishing performance 📊

🛜 Daily Notification on Specific Latest Job Offers 🛜 🌟 Overview: Never miss a job offer again! This n8n workflow automates daily job scraping from LinkedIn, Indeed, Welcome to the Jungle, and more, using Google Dorks and SerpAPI. It filters offers with a Gemini AI agent, stores them in Google Sheets, and sends a sleek HTML newsletter to your inbox or subscribers—all manageable from your phone! 💼 Use Cases: Students hunting for M&A, valuation, or transaction services internships (6+ months). Career switchers seeking automated, curated job alerts. Content creators building a job newsletter to monetize their audience. ⚙️ How It Works: Scrape: Uses SerpAPI with a tailored Google Dork to fetch fresh job listings daily from top platforms. Filter: A Gemini AI agent validates offers to ensure they match corporate finance criteria. Store: Saves new offers in Google Sheets, marking duplicates to avoid spam. Notify: Generates an email/newsletter notification and sends it via Outlook 🛠️ Setup Instructions: Import the JSON workflow into n8n. Add credentials: SerpAPI (API key), Google Sheets (OAuth2), Microsoft Outlook (OAuth2) Customize the Google Dork in the "Edit Fields" node for specific job criteria. Schedule to run daily at 7 AM. Test and tweak the AI prompt for precision. 🔑 Required Credentials & Nodes: Credentials**: SerpAPI, Google Sheets OAuth2, Microsoft Outlook OAuth2 Nodes**: Schedule Trigger, HTTP Request, Google Sheets, AI Agent (Gemini), Microsoft Outlook 🔗 Creator: Louis Delahaye | n8n.io/creators/louisdl 🎥 YouTube @cash-routine My AI Agency : https://agence-alain.fr

Description Automate customer feedback analysis and action planning by integrating Monday.com, Azure OpenAI, Jira, Google Sheets, and Outlook. This workflow classifies customer feedback with AI, calculates business impact, creates Jira tasks for high-priority issues, and sends weekly performance summaries — turning raw feedback into actionable insights. 💬📈🤖 What This Template Does Step 1: Triggers automatically every Monday at 9:00 AM to fetch new customer feedback from Monday.com. ⏰ Step 2: Normalizes and structures data into consistent fields (title, account, ARR, NPS, etc.). 🧩 Step 3: Uses Azure OpenAI GPT-4 to classify sentiment and identify feedback themes (e.g., “UI Design,” “App Crash”). 🧠 Step 4: Calculates a business impact score based on ARR, NPS delta, and sentiment weightings. ⚙️ Step 5: Creates Jira tasks for high-impact feedback items for product or engineering follow-up. 🎫 Step 6: Logs all feedback and impact scores into Google Sheets for analytics dashboards. 📊 Step 7: Generates a professional HTML report summarizing metrics, wins, and risks, then emails it via Outlook. 📧 Step 8: Sends automated error-alert emails if any node fails during execution. 🚨 Key Benefits ✅ Converts qualitative feedback into measurable business intelligence ✅ Identifies critical customer issues automatically using AI ✅ Reduces manual effort in triaging and prioritizing feedback ✅ Creates real-time visibility for product and CX teams ✅ Provides weekly executive summaries and performance insights Features Weekly scheduled trigger (every Monday 9 AM) Monday.com data fetching and field normalization Azure OpenAI GPT-4-based sentiment and theme detection Impact scoring combining ARR + NPS + sentiment weighting Jira issue creation with context-rich descriptions Google Sheets logging for dashboards and historical records Outlook HTML email reports for leadership visibility Automated Gmail error-notification system Requirements Monday.com API credentials with board access Azure OpenAI GPT-4 API credentials Jira Software Cloud API credentials Google Sheets OAuth2 credentials with edit permissions Microsoft Outlook OAuth2 credentials for email delivery Gmail OAuth2 credentials for error alerting Target Audience Product and CX teams analyzing customer sentiment SaaS businesses tracking post-implementation feedback Customer-success and support operations teams Product managers prioritizing improvements based on impact Leadership teams monitoring customer health and satisfaction Step-by-Step Setup Instructions 1️⃣ Connect Monday.com API and update your boardId and groupId. 2️⃣ Configure Azure OpenAI GPT-4 credentials for the AI classifier. 3️⃣ Set Jira project ID and issue type for ticket creation. 4️⃣ Link Google Sheets and replace YOUR_SHEET_ID. 5️⃣ Connect Outlook OAuth2 and add recipient email for reports. 6️⃣ Configure Gmail OAuth2 for error alerts. 7️⃣ Adjust the cron expression (0 9 * * 1) to fit your timezone. 8️⃣ Test the workflow end-to-end with sample data. 9️⃣ Enable automation for seamless weekly feedback intelligence. ✅

💳 Automate Digital Product Sales & Delivery with Stripe and Email Turn Your Automations into Revenue Sell on n8n using Stripe (Fully Automated Delivery) Stop manually sending files after payment or struggling with clunky checkout flows. Instead of paying ~10% platform fees, you keep control of your sales, your brand, and your files — while giving buyers a smooth, professional experience. 💡 Turn Stripe into your own Gumroad alternative — sell and deliver workflows instantly. This workflow gives you a ready-made storefront system: customers pay via Stripe, and your n8n template is delivered instantly by email with setup guidelines and video instructions. Instant delivery** → No waiting, customers receive their purchase within seconds. No manual work** → Payment verification, file delivery, and confirmation emails are all automated. Professional experience** → Clean emails with branded HTML, Loom walkthroughs, and receipts. Scalable sales** → Sell 1 or 100 templates without adding workload. Who Benefits Most ✅ Automation creators: Sell your n8n templates without coding a shop. ✅ Freelancers & consultants: Package your workflows as digital products. ✅ Agencies: Offer prebuilt automations to clients on autopilot. ✅ SaaS builders: Add a self-serve template store for upsells. “Stop giving 10% of every sale to marketplaces. Keep your profit.” What It Does for You Customer pays securely. Logs the purchase for easy tracking. Pulls the correct workflow. Sends a personalized HTML email with: Workflow JSON file attached. Installation & setup guidelines. Walkthrough video link. Support contact details. Sends you (the seller) an instant purchase notification. Why This Template Instead of Building It Yourself Save 25–40 hours** of coding, testing, and Stripe API integration. Avoid errors in file delivery, duplicate checkouts, and failed notifications. Get a production-ready digital delivery system you can brand and deploy in minutes. Customize effortlessly → add more products, change branding, or connect CRM. Proven flow: already tested (and using ourselves). Requirements n8n (self-hosted or cloud). Active Stripe account with API key. Access for file storage & logging. An email account for delivery. Bottom Line 💡 If you sell even one automation template, this workflow pays for itself. Instead of manually emailing JSON files, every customer gets a smooth, Amazon-like experience: they pay → they instantly receive → you scale without lifting a finger. 👉 By purchasing, you get: Full workflow JSON file. Email delivery with setup guidelines. Contact Us** via [email protected].

This n8n workflow template automatically pulls marketing data from Google Sheets, calculates key performance metrics, and sends beautifully formatted HTML email reports. Perfect for marketing teams, agencies, or businesses that need regular performance reporting without manual data processing. What This Workflow Does This automated workflow: Retrieves marketing campaign data from Google Sheets Calculates 5 key performance metrics (customers, campaigns, clicks, conversions, spend) Merges all statistics into a single data object Sends a professional HTML email report with modern styling Can be run manually or scheduled for regular reporting The workflow processes data including Customer ID, Campaign names, Clicks, Conversions, and Spend amounts to generate comprehensive performance summaries. Tools & Services Used N8N** - Workflow automation platform Google Sheets** - Marketing data source and storage Microsoft Outlook** - Email delivery system HTML/CSS** - Professional report formatting Step-by-Step Implementation Step 1: Set Up Your Google Sheets Data Source Copy the Sample Data Template: Access the template: Marketing Performance Data Template Click "File" → "Make a copy" to create your own version Rename it (e.g., "My Marketing Performance Data") Set Up Your Data Structure: Your Google Sheet should have a "Data" tab with these columns: Customer ID** - Unique identifier for each customer Campaign** - Name of the marketing campaign Clicks** - Number of clicks generated Conversions** - Number of conversions achieved Spend ($)** - Amount spent on the campaign Configure Google Sheets API Access: Go to Google Cloud Console Create a project or select existing one Enable "Google Sheets API" Create OAuth2 credentials or use service account Share your sheet with the service account email (if using service account) Step 2: Import and Configure the N8N Workflow Import the Workflow: Copy the workflow JSON from the template In your N8N instance, go to Workflows → Import from JSON Paste the JSON and import the workflow Step 3: Configure Each Node Node 1: "When clicking 'Execute workflow'" (Manual Trigger) Purpose**: Starts the workflow manually for testing Configuration**: No setup required Note**: You can replace this with a Schedule Trigger for automated reports Node 2: "Get Google Sheets Data" Purpose**: Retrieves all marketing data from your Google Sheet Setup Required**: Click on the node Set up Google Sheets OAuth2 credentials: Click "Create New Credential" Follow OAuth2 setup process Authorize access to your Google account Select your spreadsheet from the dropdown Choose the "Data" sheet Test the connection to ensure data loads Node 3-7: Data Analysis Nodes "Count Unique Customers" Purpose**: Counts how many unique customers were reached Configuration**: Pre-configured to count unique "Customer ID" values No setup required** "Count Unique Campaigns" Purpose**: Counts total number of campaigns run Configuration**: Pre-configured to count unique "Campaign" values No setup required** "Sum Total Clicks" Purpose**: Adds up all clicks across campaigns Configuration**: Pre-configured to sum "Clicks" column No setup required** "Sum Total Conversions" Purpose**: Totals all conversions achieved Configuration**: Pre-configured to sum "Conversions" column No setup required** "Sum Total Spend" Purpose**: Calculates total marketing spend Configuration**: Pre-configured to sum "Spend ($)" column No setup required** Node 8: "Merge" Purpose**: Combines all calculated metrics into one data object Configuration**: Pre-configured to merge by position No setup required** Node 9: "Send Email Report" (Microsoft Outlook) Purpose**: Sends the formatted HTML email report Setup Required**: Click on the node Set up Microsoft Outlook OAuth2 credentials: Click "Create New Credential" Follow OAuth2 setup for your Microsoft account Grant necessary email permissions Configure Email Settings: To Recipients: Change from "[email protected]" to your recipient email(s) Subject: Modify "Daily Marketing Performance" as needed Body Content: Pre-configured with professional HTML template Email Template Features: Modern glassmorphic design Responsive layout for mobile devices Animated gradient accents Hover effects on metric cards Professional typography For professional setup, customization, or troubleshooting of this workflow, contact: Robert - Ynteractive Solutions Email**: [email protected] Website**: www.ynteractive.com LinkedIn**: linkedin.com/in/robert-breen-29429625/ Specializing in AI-powered workflow automation, business process optimization, and custom integration solutions.

This powerful n8n workflow helps you automatically re-engage cold leads by summarizing their past emails and generating personalized outreach with OpenAI. It pulls in contacts from Google Sheets, fetches their prior communication from Outlook, and then uses an AI agent to analyze, strategize, and write a draft re-engagement message — all automatically. ⚙️ What the Workflow Does 📄 Get Contacts from Google Sheets Pulls a list of contacts and their email addresses from a Google Sheet. 📥 Search Emails from Outlook For each contact, fetches all emails received from that address since January 1, 2025. 📊 Aggregate Emails Merges relevant email fields (subject, body, createdDateTime) into a single string for analysis. 🧠 Use OpenAI to Analyze and Draft Response AI Agent summarizes the lead’s communication history. Suggests how to re-engage them in bullet points. Writes a personalized draft email to re-initiate the conversation. 📝 Save to Google Sheets Appends or updates the original row with: Summary of communication Re-engagement ideas Suggested subject line Suggested email body 📤 Create Draft Email in Outlook Creates a draft email in your Microsoft Outlook account using the subject and body provided by OpenAI. The email is not sent automatically — giving you a chance to review and personalize further. 🧰 What You'll Need 🔐 Google Sheets API connection** OAuth2 credential setup in n8n Make a copy of this sample sheet 🔐 Microsoft Outlook OAuth2 connection** Connected inbox with access to historical messages 🔐 OpenAI API Key** Add your OpenAI key in the OpenAI Chat Model node Recommended model: gpt-4o-mini or higher 👨‍💼 Built By Robert Breen Automation Consultant | n8n Expert | Data Strategist 🔗 Website: https://ynteractive.com 📧 Email: [email protected] 💼 LinkedIn: https://www.linkedin.com/in/robert-breen-29429625/ 🏷 Tags openai outlook email reengagement lead nurturing automation google sheets ai email gpt-4o crm sales automation