Personalized AI assistant with voice support, email/calendar & web tools integration
โจ Intro This workflow shows how to go beyond a โplainโ AI chatbot by: ๐ง Adding a Personality Layer โ Link an extra LLM to inject a custom tone and style. Here, itโs Nova, a sassy, high-fashion assistant. You can swap in any personality without changing the main logic. ๐จ Custom Styling with CSS โ Easily restyle the chatbot to match your brand or project theme. Together, these make your bot smart, stylish, and uniquely yours. โ๏ธ How it Works ๐ฅ Route Input Chat trigger sends messages to a Switch. If a Telegram video note exists โ runs the audio path. Otherwise โ runs the text path. ๐ค Audio Path Telegram Get a File โ OpenAI Speech-to-Text โ pass transcript to the agent. ๐ฌ Text Path Chat text is normalized and sent to the agent. ๐ Agent Brain Uses tools like Gmail ๐ง, Google Calendar ๐ , Google Drive ๐, Airtable ๐, SerpAPI ๐, Wikipedia ๐, Hacker News ๐ฐ, and Calculator โ. ๐งพ Memory Keeps the last 20 messages for context-aware replies. ๐ Optional Personality Polish An LLM Chain adds witty or cheeky tone on top of the agentโs response. ๐ Setup Steps โฑ Time Required ~10โ15 minutes (+5 minutes for each Google/Airtable connection). ๐ Connect Credentials OpenAI (and/or Anthropic) Telegram Bot Gmail, Google Calendar, Google Drive Airtable SerpAPI ๐ Configure IDs Set Airtable base/table. Set Calendar email. Adjust Drive search query defaults if needed. ๐ Voice Optional Disable Telegram + Transcribe nodes if you only want text chat. ๐ญ Choose Tone Edit Chat Triggerโs welcome text/CSS for custom look. Or disable persona chain for neutral voice. ๐ Publish Activate workflow and share the chat URL. ๐ก Detailed behavior notes are available as sticky notes inside the workflow.
By Carl FungAutomatically transcribe Telegram voice messages with OpenAI Whisper & Google Workspace
๐๏ธ VoiceScribe AI: Telegram Audio Message Auto Transcription with OpenAI Whisper > Automatically transcribe Telegram voice messages and store them as structured logs in Google Sheets, while backing up the audio in Google Drive. ๐งโ๐ผ Whoโs it for Journalists, content creators, or busy professionals who often record voice memos or short interviews on the go. Anyone who wants to turn voice recordings into searchable, structured notes. โ๏ธ How it works / What it does User sends a voice message to a Telegram bot. n8n checks if the message is an audio voice note. If valid, it downloads the audio file and: Transcribes it using OpenAI Whisper (or your LLM of choice). Uploads the original audio to Google Drive for safekeeping. The transcript and audio metadata are merged. The workflow: Logs the data into a Google Sheet. Sends a formatted confirmation message to the user via Telegram. If the input is not audio, the bot politely informs the user that only voice messages are accepted. โ Features Accepts only Telegram voice messages. Transcribes via OpenAI Whisper. Logs DateTime, Duration, Transcript, and Audio URL to Google Sheets. Sends user feedback message via Telegram with download + transcript link. ๐ How to set up Prerequisites Telegram Bot connected to n8n (via Telegram Trigger) Google Drive & Google Sheets credentials configured OpenAI or Whisper API credentials (for transcription) Steps Telegram Trigger Start the flow when a new message is sent to your bot. Check Message Type Use a conditional node to confirm it's a voice message. Download Voice Message Download the .oga file from Telegram. Transcribe Audio Send the binary audio to OpenAI Whisper or your transcription service. Upload to Google Drive Backup the original audio file. Merge Outputs Combine transcription with Drive metadata. Transform to Row Format Prepare structured JSON for Google Sheets. Append to Google Sheet Store the transcript log (DateTime, Duration, Transcript, AudioURL). Send Confirmation to User Inform the user via Telegram with their transcript and download link. Unsupported Message Handler Reply to users who send non-audio messages. ๐ Example Output in Google Sheet | DateTime | Duration | Transcript | AudioURL | |-----------------------|----------|--------------------------------------------|------------------------------------------------------------| | 2025-08-07T13:12:19Z | 27 | Dแปฑ รกn Outlet Activation lร ... | https://drive.google.com/uc?id=xxxx&export=download | ๐ง How to customize the workflow Swap Whisper with Deepgram, AssemblyAI, or other providers. Add speaker name detection or prompt-based tagging via GPT. Route transcripts into Notion, Airtable, or CRM systems. Add multi-language support or summarization steps. ๐ฆ Requirements | Component | Required | |---------------------|----------| | Telegram API | โ | | Google Drive API | โ | | Google Sheets API | โ | | OpenAI Whisper API | โ | | n8n Cloud or Self-hosted | โ | Created with โค๏ธ using n8n
By Trung TranAutomate weekly tutorials from trending GitHub repos with Gemini AI to WordPress
Overview: GitHub to WordPress Tutorial Generator This workflow automates the process of creating technical tutorials for your blog. It runs on a weekly schedule, automatically identifies trending GitHub repositories, uses an AI to generate a detailed tutorial for each one, and then saves the content as a draft post on your WordPress site. Finally, it sends you an email notification so you can review and publish the new content. This is an excellent way to keep your blog fresh with relevant, trending topics without manual effort. How It Works Weekly Trigger: The workflow is set to activate every Monday at 10 AM, starting the entire process. Get Trending Repositories: The workflow makes an HTTP request to the GitHub API to find the most popular repositories. Split Items: The Split node processes the list of repositories from the GitHub API, handling each one as a separate item. This ensures that a unique tutorial is created for every trending repository. AI Tutorial Generation: The AI Tutorial Generator node, powered by the Google Gemini Chat Model, takes the information for each repository and, following a detailed prompt, creates a comprehensive tutorial. The prompt instructs the AI to include an introduction, prerequisites, code examples, best practices, and more. Format Content: A Code node then processes the AI's output. It extracts the title and content, ensuring the data is correctly formatted for the next steps. It's a key step to handle potential variations in the AI's output. Create WordPress Post: The WordPress node takes the formatted tutorial content and creates a new post on your blog, automatically setting the title, tags, and categories. It's saved as a draft, allowing you to review and edit it before publishing. Send Notification: Once the post is created, the Email node sends a notification to your email address, letting you know a new tutorial is ready for your review. Setup Steps Configure WordPress Credentials: In the Create Tutorial Post node, add your WordPress credentials. This includes your site URL, username, and application password. Set Up Email Credentials: In the Notify Admin node, add your email service credentials (e.g., SMTP, Gmail) to enable sending email notifications. Configure GitHub API Access: Manual Mapping: Run the Get Trending Repos node once to get sample data. In the Split Repository Items node, manually map the data by setting the "Field to Split Out" to json.items. This tells the workflow to process each repository in the API response. Optional: For higher API limits, you can create a GitHub Personal Access Token and configure the Get Trending Repos node to use it. Review AI Prompt: Go to the AI Tutorial Generator node and read the system message. You can adjust the prompt to change the style, length, or content of the tutorials the AI generates.
By David OlusolaLog new Gmail messages automatically in Google Sheets
๐งโ๐ป Description This workflow automatically fetches new Gmail messages since the last run and appends them into a Google Sheet with their ID, snippet, and timestamp. Itโs designed for professionals, small business owners, and operations teams who need a simple way to keep an ongoing log of emails, build lightweight CRMs, or power downstream automations like email tracking, reporting, or follow-up reminders. --- โ๏ธ Setup Instructions for Gmail โ Google Sheets Email Log 1๏ธโฃ Connect Gmail In n8n โ Credentials โ New โ Gmail OAuth2 Log in with your Gmail account & approve access Attach this credential to the Get new messages node in the workflow 2๏ธโฃ Connect Google Sheets Copy this Google Sheet template into your own Drive In n8n โ Credentials โ New โ Google Sheets (OAuth2) โ log in with your Google account & save In the workflow, select your Spreadsheet ID and Worksheet (Sheet1 by default) in the Google Sheets nodes --- ๐ง How Email Logging Automation Works Get Current Emails โ Reads the last logged messages from Google Sheets Get Max Date โ Finds the most recent email timestamp Combine โ Passes the last timestamp and todayโs date together Get New Messages โ Fetches all new Gmail messages after the last logged date Add Emails to Sheets โ Appends message ID, snippet, and date to the sheet --- ๐๏ธ Customization Guidance Filter by Sender or Subject โ Modify the Gmail query to only log messages from specific addresses or with certain keywords. Track Labels โ Add Gmail labels to your sheet to separate categories (e.g., โLeads,โ โSupport,โ โInvoicesโ). Auto-Reply โ Extend with an additional Gmail node to send automated responses to new messages. Send Alerts โ Add a Slack or Email node to ping your team whenever a new email is logged. Analytics โ Use Google Sheets formulas or connect to BI tools to analyze trends like response times or sender frequency. --- ๐ฌ Contact Need advanced customization (e.g., multi-inbox tracking, CRM integration, or automated follow-ups)? ๐ง robert@ynteractive.com ๐ Robert Breen ๐ ynteractive.com
By Robert BreenAI-powered corporate research system for animal advocacy campaigns with Claude & Gemini
Whoโs it for ๐ฏ This workflow is designed for animal advocacy campaigners, strategists, and researchers who need detailed intelligence on corporate targets and their key stakeholders like executives, investors, and suppliers. How it works / What it does โ๏ธ It uses the Multi-tool Research Agent subworkflow to research a target company, extract relevant sub-targets, and then runs focused research on each sub-target. It compiles all findings into a detailed HTML report outlining tailored campaign tactics. How to set up ๐ ๏ธ Import this workflow and the Multi-tool Research Agent subworkflow. Configure API credentials in n8n. Set the target company and campaign details. Test the workflow to verify multi-level research and report generation. Requirements ๐ n8n instance with internet access Valid API keys The Multi-tool Research Agent subworkflow installed and linked Optional email node for sending reports How to customize ๐ง Modify target inputs and sub-target extraction for different industries. Adjust research prompts in the subworkflow for style or focus. Customize the HTML report template for branding. Attach an email node to send reports automatically or route output as needed. Add error handling or branching for campaign specifics. --- Use this template to generate strategic, research-driven campaigns with actionable intelligence on complex corporate targets.
By Open PawsAutomate lead response with Google Sheets, OpenAI, Gmail, and Slack notifications
Generate and send personalized lead emails from Google Sheets via OpenAI to Gmail with Slack alerts Description This template triggers when a new row appears in Google Sheets (from any intake form that writes to the sheet). It validates key fields, performs light deduplication by email or phone, and sends the data to OpenAI to generate a concise, brand-safe first-touch email. At the same time, the model classifies each lead as High, Medium, or Low based on your criteria for budget, services, and timeline. The email is sent immediately from your connected Gmail (or SMTP) account. The sales team is notified in Slack with the leadโs name, contact details, services of interest, budget, and a deep link to the exact Google Sheets row. The Google Sheet is then updated with send status, lead type, and a timestamp for easy tracking. Setup: Connect Google Sheets (read/write), Gmail/SMTP, Slack (webhook or app), and an OpenAI API key. Provide brief classifier rules and a short tone guide with one clear CTA (reply or booking link). Include a one-line opt-out in the email body to stay compliant. Expected headers are: Timestamp, Name, Email Address, Phone Number, Services Interested In, Budget Range, Preferred Contact Time, Project Timeline, and Additional Comments. The trigger checks the sheet every minute and processes after-hours submissions right away. You can extend the flow with calendar booking links, territory routing, or rate limits as needed.
By Jack Mason