🎬 Generate multi-platform content with OpenAI, Tavily Research & Supabase Storage

⚡ 390 views · 🎬 Content Creation & Video

Description

Automated Content Page Generator with AI, Tavily Research, and Supabase Storage

workflow1.png

> ⚠️ Self-Hosted Disclaimer: This template requires self-hosted n8n installation and external service credentials (OpenAI, Tavily, Google Drive, NextCloud, Supabase). It cannot run on n8n Cloud due to dependency requirements.

Overview

Transform simple topic inputs into professional, multi-platform content automatically. This workflow combines AI-powered content generation with intelligent research and seamless storage integration to create website content, blog articles, and landing pages optimized for different audiences.

Key Features

Required Services & APIs

Core Services

Setup Instructions

## Prerequisites

Before setting up this workflow, ensure you have:

## Step 1: Service Account Configuration

OpenAI Setup

  1. Create an OpenAI account at platform.openai.com
  2. Generate API key from the API Keys section
  3. In n8n, create new OpenAI credentials using your API key
  4. Test connection to ensure GPT-4 access

Tavily Research Setup

  1. Sign up at tavily.com
  2. Get your API key from the dashboard
  3. Add Tavily credentials in n8n
  4. Configure search depth to “advanced” for best results

Google Services Setup

  1. Create Google Cloud Project
  2. Enable Google Drive API and Google Sheets API
  3. Create OAuth2 credentials
  4. Configure Google Drive and Google Sheets credentials in n8n
  5. Share your input spreadsheet with the service account

NextCloud Setup

  1. Install NextCloud or use hosted solution
  2. Create application password for API access
  3. Configure NextCloud credentials in n8n
  4. Create /images/ folder for content storage

Supabase Setup

  1. Create Supabase project at supabase.com
  2. Create table with the following structure:
CREATE TABLE works (
  id SERIAL PRIMARY KEY,
  title TEXT NOT NULL,
  content TEXT NOT NULL,
  image_url TEXT,
  category TEXT,
  created_at TIMESTAMP DEFAULT NOW()
);
  1. Get project URL and service key from settings
  2. Configure Supabase credentials in n8n

## Step 2: Google Sheets Input Setup

Create a Google Sheets document with the following columns:

Example format:

TITLE                           | IMAGE_URL
AI Chatbot Implementation       | https://drive.google.com/file/d/your-file-id/view
Digital Marketing Trends 2024   | https://drive.google.com/file/d/another-file-id/view

## Step 3: Workflow Import and Configuration

  1. Import the workflow JSON into your n8n instance

  2. Configure all credential connections:

    • Link OpenAI credentials to “OpenAI_GPT4_Model” node
    • Link Tavily credentials to “Tavily_Research_Agent” node
    • Link Google credentials to “Google_Sheets_Trigger” and “Google_Drive_Image_Downloader” nodes
    • Link NextCloud credentials to “NextCloud_Image_Uploader” and “NextCloud_Public_URL_Generator” nodes
    • Link Supabase credentials to “Supabase_Content_Storage” node

  3. Update the Google Sheets Trigger node:

    • Set your spreadsheet ID in the documentId field
    • Configure polling frequency (default: every minute)

  4. Test each node connection individually before activating

## Step 4: Error Handler Setup (Optional)

The workflow references an error handler workflow (GWQ4UI1i3Z0jp3GF). Either:

## Step 5: Workflow Activation

  1. Save all node configurations
  2. Test the workflow with a sample row in your Google Sheet
  3. Verify content generation and storage in Supabase
  4. Activate the workflow for continuous monitoring

How It Works

## Workflow Process

  1. Trigger: Google Sheets monitors for new rows with content topics
  2. Research: Tavily searches for 3 relevant articles about the topic
  3. Content Generation: AI agent creates multi-platform content (website, blog, landing page)
  4. Content Cleaning: Text processing removes formatting artifacts
  5. Image Processing: Downloads image from Google Drive, uploads to NextCloud
  6. URL Generation: Creates public sharing links for images
  7. Storage: Saves final content package to Supabase database

## Content Output Structure

Each execution generates:

Customization Options

## Content Strategy Modification

## Research Parameters

## Storage Configuration

Troubleshooting

## Common Issues

Workflow not triggering:

Content generation errors:

Image processing failures:

Database storage issues:

## Performance Optimization

Support and Updates

This template is designed for self-hosted n8n environments and requires technical setup. For issues:

  1. Check n8n community forums
  2. Review service-specific documentation
  3. Test individual nodes in isolation
  4. Monitor execution logs for detailed error information

đź”— Nodes Used

Nextcloud, Google Drive, Execute Sub-workflow, Supabase, Google Sheets Trigger, AI Agent

đź“Ą Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup