Google Drive and Webflow integration

Who's it for Content marketers and SEO specialists who need to generate multiple SEO-optimized articles targeting keyword variations. Ideal for affiliate sites, niche blogs, or service-based businesses creating location/product-specific landing pages. How it works This workflow automates bulk content creation from keyword list to Webflow draft: Loads keywords from Google Sheets with structured format (main keyword + slug) AI generates articles - Creates 600+ word content following SEO best practices Creates custom images - Calls a sub-workflow using Gemini 2.5 Flash to generate relevant featured images Quality validation - Ensures minimum word count; expands content if needed HTML conversion - Transforms markdown to Webflow-ready HTML Result tracking - Logs success/errors to separate Google Sheets The workflow includes automatic content expansion, error handling, and uses a separate sub-workflow as a tool for AI image generation. Important: The subworkflow should be created as an individual one. Then, in the Agent Tool node, you need to select it as the tool. DON'T try to run it inside the same workflow. Requirements OpenAI API key (for content generation) OpenRouter API key or similar (for Gemini image generation via sub-workflow) Google Sheets with three tabs: keywords, content_created, webflow_error_logs Webflow site with CMS collection configured Google Drive folder for image storage Companion workflow**: "AI image generation for automatic content creation" (imported separately and called as a tool) How to set up Import both workflows separately: Main workflow: "Bulk SEO content generation and Webflow draft creation with AI images" Sub-workflow: "AI image generation for automatic content creation" Configure your Google Sheet with the recommended structure Required sheets: keywords: id, main keyword, head terms, modifiers, slug, status content_created: id, slug, meta description, content, generatedAt, updated on webflow_error_logs: keyword, error, timestamp, status Add API credentials: OpenAI API OpenRouter API with Gemini access or similar (for image generation) Webflow OAuth2 API (see Webflow setup instructions in sticky note) Google Sheets Google Drive Update workflow configuration: Google Sheets: Update document IDs in all Google Sheets nodes Webflow: Set your Site ID and Collection ID in Create/Update Post nodes Google Drive: Set folder ID in the image generation sub-workflow AI Image Tool: Verify the "AI Image Generation Tool1" node points to your imported sub-workflow Test with a single keyword: Schedule for production: Enable the Schedule Trigger (currently set to monthly) How to customize Content customization: Adjust article length in AI Agent prompt (currently 600-800 words) Modify article structure/sections in the system prompt Change content tone by editing the AI Agent system message Add/remove content sections in the prompt template Image customization: Change AI model in sub-workflow (currently Gemini 2.5 Flash) Modify image style/prompt in the AI Image Generation Tool parameters Update Google Drive destination folder Webflow customization: Add custom CMS fields by updating Create/Update Post nodes Modify field mappings to match your Webflow collection structure Change draft behavior or add auto-publish logic Workflow behavior: Adjust batch size in Loop Over Items node Modify quality threshold (currently 600 words minimum) Change error handling/retry logic Update scheduling frequency in Schedule Trigger

This n8n workflow template lets you easily generate comprehensive FAQ (Frequently Asked Questions) content for multiple services (or any items or pages you need to add the FAQs to). Simply provide the Google Sheets document containing the items to scrape, and the workflow automatically creates detailed, AI-enhanced FAQ documents. How it works The workflow reads data from a Google Sheets document containing information about different services and categories (again, in your case - whatever objects you need). For each service and category, it generates a set of standard questions and answers covering setup, permissions, integrations, use cases, and pricing benefits. An AI model (OpenAI's GPT) is used to enhance or complete some of the answers, making the content more comprehensive and natural-sounding. The workflow formats the Q&A pairs, combining AI-generated content with predefined answers where applicable. It creates a text file (JSON) for each service or category, containing the formatted Q&A pairs. The generated files are saved to specific folders in Google Drive, organized by the type of integration (native, credential-only, non-native) or category. After processing each service or category, it updates the status in the original Google Sheets document to mark it as completed. Ideal for: Marketing teams: Rapidly create comprehensive FAQ documents for multiple products or services. Customer support: Generate consistent and detailed answers for common customer queries. Product managers: Easily maintain up-to-date documentation as products evolve. Content creators: Streamline the process of creating informative content about various offerings. Accounts required Google account (for Google Sheets and Google Drive) OpenAI API account (for AI-enhanced content generation) n8n.io account (for workflow execution) Set up instructions Set up the required credentials for Google Sheets, Google Drive, and OpenAI when you first open the workflow. Prepare your Google Sheets document with the service/category information. Here's an example of Google Sheet. Fill the "Define Sheets" node with your sheets Adjust the folder IDs in the "Prepare Job" node to match your Google Drive structure. Configure the OpenAI model settings in the "OpenAI Chat Model" node if needed. Test the workflow with a small subset of data before running it on your entire dataset. Adjust the questions asked in the "Create your Q&A templates" section After testing, activate your workflow for automated FAQ generation. 🙏 Big, big kudos to Jim Le for his ideas, input and support when building this workflow. Your approach to AI workflows is always super helpful!