Automated Multi-Platform Content Generator using AI and Supabase - n8n Workflow

• Content teams and solo marketers seeking high-volume, platform-specific content generation.


• Developers needing robust, structured AI output for seamless integration with frontend applications.


• Users looking for advanced examples of LangChain agents and structured data parsing within an n8n environment.


• Anyone who wants to leverage n8n templates to streamline complex content pipelines.

Generating content tailored for different platforms (like websites, blogs, and landing pages) is time-consuming. This specialized n8n workflow solves this by providing a complete end-to-end automation solution. It utilizes a Google Sheets n8n trigger to initiate the process, employs the Tavily n8n node for real-time external research, and then feeds those findings into a sophisticated OpenAI n8n node (LangChain Agent).

The core value lies in the agent's ability to synthesize information and adhere to strict platform-specific rules, guaranteeing three different content variations from a single topic input, all structured and ready for immediate deployment. This complex n8n automation then handles image download (Google Drive), upload (NextCloud), and final persistent storage in Supabase, ensuring your data is clean and accessible. This is a crucial n8n workflow for scaling digital marketing operations.

This comprehensive n8n workflow follows seven main stages:

1. Trigger and Input Acquisition: The n8n automation starts with the Google Sheets Trigger n8n node, which monitors a specified sheet for a new row containing the TITLE (content topic) and IMAGEURL (for the header image).


2. External Research: The TITLE is passed to the Tavily Research Agent n8n node, which performs an advanced search and retrieves the top three relevant external articles and summaries.


3. AI Content Generation: The primary topic and the three research results are sent to the Multi-Platform Content Generator n8n node (a sophisticated LangChain Agent). This agent, leveraging the OpenAIGPT4Model, applies detailed system instructions to produce three distinct, platform-optimized versions of the content (Website, Blog, Landing Page) in a single, structured JSON output.


4. Content Parsing and Cleaning: The structured output passes through the ContentTextCleaner n8n node (a Code node) to remove residual markdown formatting and clean up the text, making it database-friendly.


5. Parallel Image Processing: Simultaneously, the GoogleDriveImageDownloader n8n node fetches the image binary data. This is then uploaded via the NextCloudImageUploader n8n node.


6. Public URL Generation: The NextCloudPublicURL_Generator n8n node creates a public access link for the uploaded image, ensuring the frontend application can retrieve it.


7. Database Storage: Finally, the cleaned content (Title, Article, Category) and the public image URL are combined and inserted into the target table in Supabase Content Storage n8n node, completing the n8n workflow execution.

1. Import the n8n workflow JSON: Copy the provided JSON data and paste it into your n8n instance using the 'Import Workflow' option.


2. OpenAI Credentials Setup: Configure the 'OpenAI GPT4 Model' n8n node with your OpenAI API Key.


3. Google Sheets Trigger Setup: Configure the 'Google Sheets Trigger' n8n node with your required spreadsheet ID and sheet name. Ensure the credentials allow read access.


4. Tavily Setup: Add your Tavily API Key to the 'Tavily Research Agent' n8n node credentials.


5. Supabase Setup: Configure the 'Supabase Content Storage' n8n node with your Supabase URL, API Key, and specify the target table (works).


6. NextCloud Setup (Optional): If using NextCloud for image hosting, configure the 'NextCloud' n8n nodes with your instance URL and API credentials.


7. Google Drive Setup (Optional): Configure the 'Google Drive Image Downloader' n8n node with credentials authorized to access the image files referenced in your Google Sheet.


8. Activate: Once all credentials and parameters are set, activate the n8n trigger to begin monitoring for new data.

Google Sheets Trigger: The primary n8n trigger. It polls Google Sheets for new rows, providing the source data (Title and Image URL) to the subsequent n8n nodes.
Tavily Research Agent: A research n8n node that performs deep, real-time web searches based on the input title, gathering supporting context for the AI Agent. Key configuration: maxresults: 3 and searchdepth: advanced.
Multi-Platform Content Generator (LangChain Agent): The central processing n8n node. It integrates the research, uses the gpt-4.1-mini model, and follows detailed guidelines to produce platform-specific (Website, Blog, Landing Page) content. The system message ensures compliance with character limits and distinct tones.
ContentTextCleaner (Code): A critical n8n node for data hygiene. It uses JavaScript to normalize the AI's output, removing markdown characters (#, *) to ensure clean text storage in the database.
Google Drive Image Downloader: Downloads the image file based on the URL provided by the n8n trigger, preparing the binary data for external storage.
NextCloud Image Uploader & URL Generator: Manages the cloud storage for the image file, uploading the binary data and then generating a permanent, public access url to be stored in the final record.
Supabase Content Storage: The final data persistence n8n node. It performs an Insert operation, mapping the cleaned title, article content, category, and the generated public image URL into the Supabase table.