Generate & optimize brand stories with Ollama LLMs and Google Sheets

Overview This n8n automation template allows marketers, branding teams, and creative professionals to auto-generate, evaluate, and iteratively optimize brand stories using Ollama-hosted LLMs and LangChain agents. Each story is refined until it meets quality criteria and is then saved to Google Sheets for publishing or reuse. ⚠️ Note: This template uses community nodes and requires a self-hosted n8n instance with LangChain and Ollama integrations. What the Workflow Does Receives a chat-triggered brand story request Guides the user to generate a structured brand story Evaluates the story for tone, uniqueness, quote inclusion, and emoji removal Loops through optimization until the story is finalized Saves the final story to Google Sheets Target Users Startup founders Brand consultants Social media strategists Marketers building bios, taglines, intros Step-by-Step Setup Instructions Setup Prerequisites Install self-hosted n8n with LangChain and Ollama nodes Load phi4-mini and qwen3:4b models into your local Ollama instance Create a Google Sheet with a sheet named BrandStories and columns: Name Final Story Timestamp Trigger Configuration Set up the Chat Trigger node (@n8n/n8n-nodes-langchain.chatTrigger) with webhook ID: fab30ad7-8a5a-4477-be98-1aa43b92b052 Customize Prompts Update the Brand Storytelling Agent prompt to reflect your brand tone or story format Optionally refine the Evaluator Agent criteria (e.g., enforce industry tone) Google Sheets Setup Use your Google Sheets OAuth2 credentials Map fields to Name, Final Story, and Timestamp columns Run the Flow On new chat input, the system auto-generates a brand story It loops between Evaluator and Optimizer agents until the output is labeled "Finished" Final output is saved to your Google Sheet Flowchart (mermaid) mermaid Copy Edit flowchart TD A[Chat Trigger: New Message] --> B[Brand Storytelling Agent] B --> C[Set Bio Variable] C --> D[Evaluator Agent] D --> E{Is Output "Finished?"} E -- Yes --> F[Save Brand Story to Sheets] E -- No --> G[Optimizer Agent] G --> H[Update Bio Variable] H --> D Credentials Used Google Sheets OAuth2 for storage Ollama API (local models phi4-mini and qwen3:4b)