Templates by Xiaoyuan Zhang
Create literary English/German to Chinese dictionary with GPT-4o-mini & Supabase
Description This workflow creates a sophisticated bilingual dictionary that provides literary-style definitions and examples for English and German words. The system automatically detects the input language, generates comprehensive definitions in Chinese, creates three literary-style example sentences with translations, and stores everything in a Supabase database for future reference. Who Is This For? Language Learners & Students: Perfect for those studying English or German who want to understand words in literary contexts with Chinese translations. Writers & Content Creators: Ideal for bilingual writers working with English, German, and Chinese who need rich, literary examples for their work. Educators & Translators: Excellent tool for language teachers and professional translators who need comprehensive word definitions with contextual examples. Literary Enthusiasts: Great for readers of literature who encounter unfamiliar words and want to understand their poetic or literary usage. What Problem Does This Workflow Solve? Traditional dictionaries often provide basic definitions without literary context or cross-language examples. This workflow addresses several key challenges: Limited Literary Context: Most dictionaries lack poetic, expressive, or literary-style examples that help understand how words are used in sophisticated writing. Cross-Language Learning: Provides seamless translation between English/German and Chinese with culturally appropriate examples. Data Persistence: Automatically saves all lookups to a database, creating a personalized vocabulary collection over time. API Accessibility: Provides a clean webhook interface that can be integrated into apps, websites, or other tools. How It Works Main Dictionary Lookup Flow Input Processing: Receives a word via webhook POST request and automatically detects if it's English or German AI Analysis: Uses OpenAI GPT-4o-mini to generate comprehensive definitions with literary context Response Formatting: Processes the AI response to extract structured data (word, meaning, examples) Quality Control: Validates the response and handles unclear or invalid inputs gracefully Database Storage: Saves the word, Chinese meaning, and examples to Supabase for future reference API Response: Returns formatted JSON with the complete dictionary entry Data Storage Flow Parallel Processing: Simultaneously returns the dictionary data to the user and saves it to the database Structured Storage: Organizes data in Supabase with fields for words, Chinese meanings, and example arrays Success Confirmation: Provides confirmation when data is successfully stored Setup Instructions Prerequisites & Accounts You'll need accounts and API access for: n8n (Cloud or self-hosted) OpenAI (API key required) Supabase (Database and API credentials) Webhook Configuration The workflow uses two webhook endpoints with the same path for different operations Note the webhook URL provided by n8n for API integration Test the webhook endpoints to ensure they're accessible approach Customization Options Extend to support additional input languages by modifying the AI prompt Add support for other target languages beyond Chinese Customize the literary style for different cultural contexts This workflow transforms simple word lookups into rich, contextual learning experiences while building a personalized vocabulary database over time.
By Xiaoyuan ZhangTransform event notes to LinkedIn posts with Telegram, Google Calendar & Claude AI
Description This workflow transforms your quick event notes into polished LinkedIn posts. Simply send a message via Telegram with your event name and personal notes, and the system will match it with your calendar events, generate a professional LinkedIn post. And even if you don't feel like posting it on LinkedIn, it still serves you because it saves everything to your database for future reference. In this way you can build a personal library of your professional networking activities and insights! Who Is This For? Professional Networkers: Business professionals who attend events regularly and want to share insights on LinkedIn without spending time on content creation. Event Enthusiasts: Conference attendees, meetup participants, and workshop goers who want to document and share their experiences professionally. Busy Professionals: Anyone who wants to maintain an active LinkedIn presence but lacks time to craft posts from scratch after events. What Problem Does This Workflow Solve? After attending events, I struggle with several challenges: Time Constraints: Writing thoughtful LinkedIn posts takes time. Writer's Block: Difficulty transforming my raw notes and experiences into engaging social media content. Data Organization: Keeping track of event details, personal insights, and networking opportunities in one place. How It Works Telegram Input: Send a message to your Telegram bot with the format "Event Name: Your personal notes" Message Parsing: The system extracts the event name and your personal notes from the message Calendar Matching: Searches your Google Calendar for events from the past 7 days that match the event name Data Enrichment: Combines your personal notes with event details (date, location, attendees) from your calendar AI Content Generation: Uses Claude Opus 4 to transform your notes into a professional LinkedIn post with relevant hashtags Database Storage: Saves the complete event information and generated LinkedIn post to Supabase Ready to Post: Provides you with a polished LinkedIn post ready for publication Setup Instructions n8n (Cloud or self-hosted) Telegram Bot (Create via @BotFather) Google Calendar API (OAuth2 credentials) Anthropic API (Claude access) Supabase (Database and API credentials) My Supabase table consists these columns: Event Date (datetime) Event Title (text) Location (text) Personal Notes (text) LinkedIn Post (text) Created Date (datetime) This workflow transforms the tedious task of creating LinkedIn content into an automated, intelligent system that helps you maintain an active professional presence while building a valuable archive of your networking and learning experiences.
By Xiaoyuan Zhang