Auto-generate SEO content from trends with GPT-4o, FAL AI & multi-storage
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Worth a look
- Spreadsheet File (Read Trends Data): Convert to File / Extract from File
Nodes used (15)
- Spreadsheet File
n8n-nodes-base.spreadsheetFile - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Microsoft SharePoint
n8n-nodes-base.microsoftSharePoint - Switch
n8n-nodes-base.switch - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - Gmail
n8n-nodes-base.gmail - Convert to File
n8n-nodes-base.convertToFile - Webhook
n8n-nodes-base.webhook - Extract from File
n8n-nodes-base.extractFromFile
What it does
Who's it for Content creators, SEO specialists, and marketing teams who want to automatically generate SEO-optimized content based on trending topics—complete with AI-generated images, optional videos, and ready-to-publish HTML. How it works / What it does 1. Webhook receives a request with use case and video preferences. 2. Get Trends XLSX downloads a spreadsheet (created by the Social Media Trends workflow) from SharePoint. 3. Select Topic from Trends randomly picks one trending topic from the spreadsheet. 4. AI Agent (GPT-4o) generates bilingual newsletter content about the selected trend. 5. Get Newsletter Template fetches your HTML template; Build Newsletter injects the AI content. 6. Optional creative assets: • Pollinations AI → generates a 1080 × 1350 image. • FAL AI → creates video from the image + Lyria2 audio → merged via FFmpeg. 7. Gmail Approval sends the draft for review; continues only on approval. 8. Upload all files (HTML + JPG + video URL) to your chosen storage provider. How to set up 1. Import the template into n8n (cloud or self-hosted). 2. Create credentials: OpenAI, Microsoft 365 (SharePoint), Gmail, and FAL AI. 3. Upload your HTML newsletter template to SharePoint (see yellow sticky note for required placeholders). 4. Ensure you have a trends spreadsheet (from the Social Media Trends workflow) in your SharePoint folder. 5. Update Configuration Settings with your ENV variables. 6. Activate the workflow and POST to the webhook: { "text": "usecase: blog post, includevideo: true" }. Requirements - n8n 1.33 + - OpenAI account - Microsoft 365 tenant (SharePoint) - Gmail account - FAL AI API Key (for video generation) - A trends spreadsheet (from the Social Media Trends workflow) How to customize - Change storage provider: replace SharePoint upload nodes with Google Drive, Dropbox, or S3. - Modify topic selection: edit Select Topic from Trends for different selection logic. - Adjust content tone: tweak the prompt in Prepare Newsletter Data. - Skip video generation: set includevideo: false in the webhook request.