Google Slides and Google Drive integration

When you fill out the form with business challenges and requirements GPT-4 analyzes the input and generates a customized proposal using your template System automatically creates a Google Slides presentation with personalized content Professional proposal email is sent directly to the prospect with the presentation link Set up steps Estimated time: 15-20 minutes Connect your OpenAI API key for GPT-4 access Link your Google account for Slides and Gmail integration Create your proposal template in Google Slides with placeholder variables Customize the AI prompt and email template with your branding Test with sample data and activate the workflow

AI-Powered Proposal Generator - Sales Automation Workflow Overview This n8n workflow automates the entire proposal generation process using AI, transforming client requirements into professional, customized proposals delivered via email in seconds. Use Case Perfect for agencies, consultants, and sales teams who need to generate high-quality proposals quickly. Instead of spending hours writing proposals manually, this workflow captures client information through a web form and uses GPT-4 to generate contextually relevant, professional proposals. How It Works Form Trigger - Captures client information through a customizable web form OpenAI Integration - Processes form data and generates structured proposal content Google Drive - Creates a copy of your proposal template Google Slides - Populates the template with AI-generated content Gmail - Automatically sends the completed proposal to the client Key Features AI Content Generation**: Uses GPT-4 to create personalized proposal content Professional Templates**: Integrates with Google Slides for polished presentations Automated Delivery**: Sends proposals directly to clients via email Form Integration**: Captures all necessary client data through web forms Customizable Output**: Generates structured proposals with multiple sections Template Sections Generated Proposal title and description Problem summary analysis Three-part solution breakdown Project scope details Milestone timeline with dates Cost integration Requirements n8n instance** (cloud or self-hosted) OpenAI API key** for content generation Google Workspace account** for Slides and Gmail Basic n8n knowledge** for setup and customization Setup Complexity Intermediate - Requires API credentials setup and basic workflow customization Benefits Time Savings**: Reduces proposal creation from hours to minutes Consistency**: Ensures all proposals follow the same professional structure Personalization**: AI analyzes client needs for relevant content Automation**: Eliminates manual copy-paste and formatting work Scalability**: Handle multiple proposal requests simultaneously Customization Options Modify AI prompts for different industries or services Customize Google Slides template design Adjust form fields for specific information needs Personalize email templates and signatures Configure milestone templates for different project types Error Handling Includes basic error handling for API failures and form validation to ensure reliable operation. Security Notes All credentials have been removed from this template. Users must configure their own: OpenAI API credentials Google OAuth2 connections for Slides, Drive, and Gmail Form webhook configuration This workflow demonstrates practical AI integration in business processes and showcases n8n's capabilities for complex automation scenarios.

AI Proposal Generator System Categories* Sales Automation Document Generation AI Business Tools This workflow creates a complete AI-powered proposal generation system that transforms simple form inputs into professional, personalized proposals in under 30 seconds and can be deployed during live sales calls, allowing you to send polished proposals before the call even ends. Benefits* Instant Proposal Generation - Convert 30-second form inputs into professional proposals automatically High-Value Business Tool - Generates $1,500-$5,000 per client implementation Live Sales Integration - Generate and send proposals during active sales calls Complete Automation Pipeline - From form submission to email delivery with zero manual work Professional Presentation - Produces proposals indistinguishable from manually crafted documents Dual Platform Support - Works with both Google Slides (free) and PandaDoc (premium) integration How It Works* Smart Form Interface: Simple N8N form captures essential deal information Collects prospect details, problems, solutions, scope, timeline, and budget Designed for rapid completion during live sales conversations Advanced AI Processing: Uses sophisticated GPT-4 prompting with example-based training Converts basic form inputs into professionally written proposal sections Applies consistent tone, formatting, and business language automatically Dynamic Document Generation: Creates duplicate proposal templates for each new prospect Replaces template variables with AI-generated personalized content Maintains professional formatting and visual consistency Automated Email Delivery: Sends personalized email with proposal link immediately after generation Includes professional messaging and clear next steps Optionally includes invoice for immediate payment processing Premium PandaDoc Integration: Advanced version includes built-in payment processing Combines proposal, agreement, and invoice in single document Enables immediate signature and payment collection Business Use Cases* Service-Based Businesses - Generate proposals for consulting, agencies, and professional services Automation Agencies - Offer proposal generation as a high-value service to clients Sales Teams - Accelerate proposal creation and improve close rates Freelancers - Professionalize client interactions with instant custom proposals Consultants - Streamline business development with automated proposal workflows B2B Companies - Scale personalized proposal generation across entire sales organization Difficulty Level: Intermediate Estimated Build Time: 2-3 hours Monthly Operating Cost: $20-150 (depending on Google Slides vs PandaDoc) Watch My Complete Live Build* Want to see me build this entire $2,485 proposal system from scratch? I walk through every component live - including the AI prompting strategies, form design, Google Slides integration, and the advanced PandaDoc setup that enables payment collection. 🎥 See My Live Build Process: "I Built A $2,485 AI Proposal Generator In N8N (Copy This)" This comprehensive tutorial shows the real development process - including advanced AI prompting, template design, API integrations, and the exact pricing strategy that generates $1,500-$5,000 per client. Required Template Setup* Google Slides Template: Create a professional proposal template with these variable placeholders (wrapped in double curly braces): {{proposalTitle}} - Main proposal heading {{descriptionName}} - Project subtitle/description {{oneParagraphProblemSummary}} - Problem analysis section {{solutionHeadingOne}}, {{solutionHeadingTwo}}, {{solutionHeadingThree}} - Solution titles {{shortScopeTitleOne}} through {{shortScopeTitleThree}} - Scope sections {{milestoneOneDay}} through {{milestoneFourDay}} - Timeline milestones {{cost}} - Project pricing Form Field Requirements: The N8N form must include these exact field labels: First Name, Last Name, Company Name, Email, Website Problem (textarea) - Client's current challenges Solution (textarea) - Your proposed approach Scope (textarea) - Specific deliverables Cost - Project pricing How soon? - Timeline expectations PandaDoc Setup (Premium): Configure PandaDoc template with token placeholders matching the AI-generated content structure. Template must include pricing tables and signature fields for complete proposal-to-payment automation. Set Up Steps* Form Design & Integration: Create N8N form with optimized fields for proposal generation Design form flow for rapid completion during sales calls Configure form triggers and data validation AI Content Generation Setup: Configure OpenAI API for sophisticated proposal writing Implement example-based training with input/output pairs Set up JSON formatting for structured content generation Google Slides Integration (Free Version): Create professional proposal templates with variable placeholders Set up Google Cloud Console API access and credentials Configure template duplication and text replacement workflows Email Automation Setup: Configure Gmail integration for automated proposal delivery Design professional email templates with proposal links Set up dynamic content insertion and personalization PandaDoc Integration (Premium Version): Set up PandaDoc API for advanced document generation Configure payment processing and signature collection Implement proposal-to-payment automation workflows Testing & Quality Control: Test complete workflow with various proposal scenarios Validate AI output quality and professional presentation Optimize form fields and content generation based on results Advanced Features* Premium system includes: Payment Processing Integration: Collect payments immediately after proposal acceptance Digital Signature Collection: Streamline agreement execution with electronic signatures Custom Branding: Apply company branding and visual identity automatically Multi-Template Support: Generate different proposal types based on service offerings CRM Integration: Automatically sync proposal data with existing sales systems Why This System Works* The competitive advantage lies in speed and professionalism: 30-second generation time vs. hours of manual proposal writing Professional presentation that matches or exceeds manual proposals Live sales integration - send proposals during active conversations Consistent quality - eliminates human error and formatting inconsistencies Immediate follow-up - maintain sales momentum with instant delivery System Architecture* The workflow follows a simple but powerful 6-step process: Form Trigger - Captures essential deal information AI Processing - Converts inputs to professional content Template Duplication - Creates unique document for each prospect Content Replacement - Populates template with AI-generated content Email Delivery - Sends proposal with professional messaging Payment Collection (PandaDoc) - Enables immediate signature and payment Check Out My Channel* For more high-value automation systems and proven business-building strategies, explore my YouTube channel where I share the exact systems used to build successful automation businesses and scale to $72K+ monthly revenue.

This n8n template offers a free and automated way to convert images from a Google Drive folder into a single PDF document. It uses Google Slides as an intermediary, allowing you to control the final PDF's page size and orientation. If you're looking for a no-cost solution to batch convert images to PDF and need flexibility over the output dimensions (like A4, landscape, or portrait), this template is for you! It's especially handy for creating photo albums, visual reports, or simple portfolios directly from your Google Drive. How it works The workflow first copies a Google Slides template you specify. The page setup of this template (e.g., A4 Portrait) dictates your final PDF's dimensions. It then retrieves all images from a designated Google Drive folder, sorts them by creation date. Each image is added to a new slide in the copied presentation. Finally, the entire Google Slides presentation is converted into a PDF and saved back to your Google Drive. How to use Connect your Google Drive and Google Slides accounts in the relevant nodes. In the "Set Pdf File Name" node, define the name for your output PDF. In the "CopyPdfTemplate" node: Select your Google Slides template file (this sets the PDF page size/orientation). Choose the Google Drive folder containing your source images. Ensure your images are in the specified folder. For best results, images should have an aspect ratio similar to your chosen Slides template. Run the workflow to generate your PDF by clicking 'Test Workflow' Requirements Google Drive account. Google Slides account. Google Slides Template stored on your Google Drive Customising this workflow Adjust the "Filter: Only Images" node if you use image formats other than PNG (e.g., image/jpeg for JPGs). Modify the image sorting logic in the "Sort by Created Date" node if needed.

👥 Who Is This For? Sales and marketing teams seeking efficient, hands‑free generation of personalized slide decks for each prospect from CSV lead lists. 🛠 What Problem Does This Solve? Manually editing presentation decks for large lead lists is slow and error‑prone. This workflow fully automates: Importing and parsing CSV lead data Logging leads and outputs in Google Sheets Duplicating a master Slides template per lead Injecting lead‑specific variables into slides 🔄 Node‑by‑Node Breakdown | Step | Node | Purpose | | ---- | ---------------------------------------- | -------------------------------------------------------- | | 1 | New Leads Arrived | Detect new CSV uploads in Drive | | 2 | File Type? | Filter for .csv files only | | 3 | Download by ID | Download the CSV content | | 4 | Create new Sheet | Create a Google Sheet to record lead data | | 5 | Combine Empty New Document with CSV Data | Structure each lead record for slide creation | | 6 | Merge Data for new Lead Document | Map template placeholders to lead values | | 7 | Get all Leads | Retrieve sheet rows to iterate through each lead | | 8 | MoveToLeadListFolder | Move processed CSV to an archive folder | | 9 | Copy Slides Template | Make a copy of the master Slides deck | | 10 | Create Custom Presentation | Replace placeholders in the copied deck with lead data | | 11 | Add Presentation ID to Lead | Write the generated presentation URL back into the Sheet | ⚙️ Pre‑conditions / Requirements n8n with Google Drive, Sheets, and Slides credentials A master Google Slides deck with placeholder tokens (e.g. {{Name}}, {{Company}}) A Drive folder for incoming CSV lead files ⚙️ Setup Instructions Import this workflow into your n8n instance. Configure the New Leads Arrived node to watch your CSV folder. Enter your Google credentials in the Drive, Sheets, and Slides nodes. Specify the master Slides template ID in the Copy Slides Template node. In Create Custom Presentation, map slide tokens to sheet column names. Disable “Keep Binary Data” in Copy Slides Template to conserve memory. Upload a sample CSV (with headers like Name, Company, Metric) to test. 🎨 How to Customize Add or remove variables by editing the CSV headers and updating the mapping in Merge Data for new Lead Document. Insert an AI/natural‑language node before slide creation to generate more advanced and personalized text blocks. Use SplitInBatches to throttle API calls and avoid rate‑limit errors. Add error‑handling branches to capture and log failed operations. 🔐 Security and Privacy The workflow uses placeholder variables for file and folder IDs, so no actual IDs are exposed in the template. Ensure OAuth scopes are limited to only the required Google APIs.

Generate and publish Instagram carousels automatically Turn a single topic into a published Instagram Carousel in minutes. Creating educational carousel posts usually takes hours: writing the script, designing the slides in Figma/Canva, exporting images, and scheduling. This workflow automates the entire pipeline using Gemini AI, Google Slides, and the Meta Graph API. It generates the content, designs the visuals by manipulating a template, and publishes the carousel directly to your Instagram Business account. 🚀 What this workflow does Script Generation: Runs daily (or on demand) to prompt Google Gemini to write a 6-slide educational script (Hook, Mistake, Why It Matters, Value, Tip, CTA). Design Automation: Copies a master Google Slides template. Uses a "Find & Replace" operation to insert the AI-generated text into the correct placeholders. Generates thumbnail images for each slide. Image Hosting: Uploads the slide images to ImgBB to get public URLs (required by Meta's API). Publishing: Creates a carousel container on Instagram using the Meta Graph API. Checks the container status until it is "FINISHED". Publishes the media to your feed. Logging: Records the post details, captions, and status in Google Sheets. 💡 Key Features True Design Automation:** Doesn't just overlay text on images; it uses real Google Slides templates, allowing for complex layouts and branding. Smart Polling:** Includes a "Wait & Check" loop to ensure the media container is fully processed by Facebook before attempting to publish (prevents API errors). Structured Content:** The AI is prompted to follow a proven "Viral Educational" framework (Hook -> Value -> Action). Asset Management:** Automatically organizes generated slide images and links in Google Sheets for your archives. 🛠️ Prerequisites Google Cloud:** Enabled APIs for Drive, Slides, Sheets, and Gemini. Meta Developer App:** An Instagram Business account connected to a Facebook Page, with a System User token (instagram_basic, instagram_content_publish, pages_read_engagement). ImgBB Account:** A free API key for temporary image hosting. Templates:** A Google Sheet and Google Slide template (links provided in the workflow sticky notes). 📝 Setup Instructions Resources: Copy the provided Google Sheet and Slide templates to your Drive. Credentials: Authenticate Google, Meta, and ImgBB in n8n. Configuration: Update the Google Drive node with your Slide Template ID. Update the Google Sheets nodes with your Sheet ID. Update the HTTP Request nodes with your ImgBB API Key and Instagram Account ID. Run: Activate the schedule or click "Execute" to generate your first post! Need help setting this up or want a custom automation for your agency? I specialize in building agentic workflows for consultants and agencies. 📧 Contact me: [email protected]