CoinMarketCap telegram price bot
Get real-time cryptocurrency prices directly in Telegram! This workflow integrates CoinMarketCap API with Telegram, allowing users to request live crypto prices simply by sending a message to the bot. Ideal for crypto traders, analysts, and enthusiasts who need quick and easy access to market data. How It Works A Telegram bot listens for user input (e.g., "BTC" for Bitcoin). The workflow sends a request to the CoinMarketCap API to fetch the latest price. The response is processed using an AI-powered language model (GPT-4o-mini) for structured messaging. The workflow logs session data using a memory buffer for better response tracking. The latest price is sent back to the user via Telegram. Set Up Steps Create a Telegram Bot Use @BotFather on Telegram to create a bot and obtain an API token. Get a CoinMarketCap API Key Sign up at CoinMarketCap and retrieve your API key. Configure API Credentials in n8n Add the CoinMarketCap API key under HTTP Header Auth. Add your Telegram bot token under Telegram API credentials. Deploy and Test Send a message (e.g., "BTC") to your Telegram bot and receive live price updates instantly! Automate your crypto price tracking today with this powerful Telegram bot!
By Don Jayamaha JrAI email organizer for GMail - advanced email management & sorting
Video Introduction [](https://www.youtube.com/watch?v=BQARyWMD_lU) Want to automate your inbox or need a custom workflow? đ Book a Call | đŹ DM me on Linkedin --- Transform your messy inbox into a calm, organized command center - in minutes - using this ready-to-use n8n automation! Tired of your Gmail looking like this? With this template, you can have this instead: --- What does this automation do? AI-powered categorization: Every new email is analyzed with OpenRouter AI and sorted into categories you define (like Orders, Support, Invoices, Urgent, etc.). Instant color-coded labels: The workflow creates and applies Gmail labels with custom colors, so you can spot important messages at a glance. Supports Gmailâs Multiple Inboxes: Display different categories in their own sectionsâsee what matters most right away. Flexible and customizable: You control the categories and definitions using a simple Google Sheet. --- How it works â Step by Step See the full setup & demo: [](https://www.youtube.com/watch?v=BQARyWMD_lU) Copy the Template Open the n8n workflow template and click Use for free. Log in (or sign up) for n8n Cloud for the quickest start. Customize Your Categories in Google Sheets Use the provided Google Sheets template linked in the workflow notes. Go to File â Make a copy to your own Drive. Edit the categories and their definitions for your business. Example: Add categories like âExisting Order Questions,â define each one to guide the AI, and copy your Google Sheetâs URL into the workflow config node. Connect AI with OpenRouter Go to OpenRouter.ai, log in, and generate a new API key. Paste your API key into the workflow where prompted. Test and Activate the Workflow Connect your Gmail account to n8n. Hit âTest Workflowââwatch as the AI processes your latest emails and applies labels automatically. Labels will appear instantly in Gmail, and any missing ones are created by the automation. Schedule Automatic Runs Switch workflow status to Active in n8n. Set the scheduler triggerâmost people use hourly, but you can use crontab.guru for custom times (like only business hours). --- Tips for Best Results Color Code Your Labels: In Gmail, you can assign colors to labelsâset high-priority categories (like âCustomer Complaintsâ) to a bright color to stand out. Upgrade Your Gmail View: Enable Multiple Inboxes in Gmailâs settings and set up sections for your key categories. Example search queries: in:inbox label:customer-complaints OR label:urgent-emails in:inbox label:existing-order-questions in:inbox label:support-requests --- Why Use This? Get rid of inbox chaos for good - no more lost emails or missed deadlines Fully customize the system to your business with just a Google Sheet Works with zero coding - set up in 10-15 minutes Flexible: add auto-replies, draft suggestions, and more as you grow
By Milan Vasarhelyi - SmoothWorkAutomate Pinterest analysis & AI-powered content suggestions with Pinterest API
Automate Pinterest Analysis & AI-Powered Content Suggestions With Pinterest API This workflow automates the collection, analysis, and summarization of Pinterest Pin data to help marketers optimize content strategy. It gathers Pinterest Pin performance data, analyzes trends using an AI agent, and delivers actionable insights to the Marketing Manager via email. This setup is ideal for content creators and marketing teams who need weekly insights on Pinterest trends to refine their content calendar and audience engagement strategy. --- Prerequisites Before setting up this workflow, ensure you have the following: Pinterest API Access & Developer Account Sign up at Pinterest Developers and obtain API credentials. Ensure you have access to both Organic and Paid Pin data. Airtable Account & API Key Create an account at Airtable and set up a database. Obtain an API key from Account Settings. AI Agent for Trend Analysis An AI-powered agent (such as OpenAI's GPT or a custom ML model) is required to analyze Pinterest trends. Ensure integration with your workflow automation tool (e.g., Zapier, Make, or a custom Python script). Email Automation Setup Configure an SMTP email service (e.g., Gmail, Outlook, SendGrid) to send the summarized results to the Marketing Manager. --- Step-by-Step Guide to Automating Pinterest Pin Analysis Scheduled Trigger for Data Collection At 8:00 AM (or your preferred time), an automated trigger starts the workflow. Adjust the timing based on your marketing schedule to optimize trend tracking. Fetch Data from Pinterest API Retrieve recent Pinterest Pin performance data, including impressions, clicks, saves, and engagement rate. Ensure both Organic and Paid Ads data are labeled correctly for clarity. Store Data in Airtable Pins are logged and categorized in an Airtable database for further analysis. Sample Airtable Template for Pinterest Pins | Column Name | Description | |---------------|---------------------------------------| | pin_id | Unique identifier for each Pin | | created_at | Timestamp of when the Pin was created | | title | Title of the Pin | | description| Short description of the Pin | | link | URL linking to the Pin | | type | Type of Pin (e.g., organic, ad) | AI Agent Analyzes Pinterest Trends The AI model reviews the latest Pinterest data and identifies: Trending Topics & Keywords Engagement Patterns Audience Interests & Behavior Changes Optimal Posting Times & Formats Generate Content Suggestions with AI The AI Agent recommends new Pin ideas and content calendar updates to maximize engagement. Suggestions include creative formats, hashtags, and timing adjustments for better performance. Summary & Insights Generated by AI A concise report is created, summarizing Pinterest trends and actionable insights for content strategy. Email Report Sent to the Marketing Manager The summary is emailed to the Marketing Manager to assist with content planning and execution. The report includes: Performance Overview of Recent Pins Trending Content Ideas Best Performing Pin Formats AI-Generated Recommendations --- This workflow enables marketing teams to automate Pinterest analysis and optimize their content strategy through AI-driven insights. đ
By Marketing CanopySmart Gmail cleaner with AI validator & Telegram alerts
Automatically clean up your Gmail inbox by deleting unwanted emails, validated by Gemini AI. Ideal for anyone tired of manual inbox cleanup, this workflow helps you save time while staying in control, with full transparency via Telegram alerts. How it works Scans Gmail inbox in adjustable 2-week batches Uses Gemini AI to decide if an email should be deleted or skipped Applies a label to skipped emails to avoid rechecking in future runs Deletes unwanted emails and sends a Telegram message with the AI's reasoning Also notifies on skipped emails, with explanation included Set up steps Connect your Gmail, Gemini AI, and Telegram accounts Adjust the AI baseline to control sensitivity (e.g. how strict the filtering should be) Set your batch range (default: last 2 weeks, adjustable) Define your Telegram chat/channel for notifications --- Note: Thanks to n8n's modular design, you can easily switch Gemini for another AI model (like OpenAI, Claude, etc.) or replace Telegram with Discord, Slack, or even email, no code changes needed, just swap the nodes.
By ReyhanAdd articles to a Notion list by accessing a Discord slash command
This workflow allows you to add articles to a Notion reading list by accessing a Discord slash command. Prerequisites A Notion account and credentials, and a reading list similar to this template. A Discord account and credentials, and Discord Slash Command connected to n8n. Nodes Webhook node triggers the workflow whenever the Discord Slash command is issued. IF node checks the type returned by Discord. If the type is not equal to 1, it will return true, otherwise false. HTTP Request node makes an HTTP call to the link and gets the HTML of the webpage. HTML Extract node extracts the title from the HTML which we will use in the next node. Notion node adds the link to your Notion reading list. Set nodes set the reply values for Discord and register the Interaction Endpoint URL.
By Harshil AgrawalFull blog content automation with GPT-4, Claude & Ghost CMS publisher
đ Complete Workflow Overview The Full Blogging Automation Journey This N8N workflow transforms a simple topic request into a fully published, SEO-optimized blog post through a seamless 7-phase process. Starting with your topic idea, the system automatically researches, creates, optimizes, edits, and publishes professional content to your Ghost CMS website. Think of it as having an entire content team working 24/7 - from initial research to final publication, all orchestrated by AI agents working in perfect harmony. No more writer's block, no more SEO guesswork, just high-quality content that ranks and engages your audience đ Requirements & Setup What You Need to Get Started OpenAI API Key - For GPT models (content generation) Anthropic API Key - For Claude models as failover model Brave Search API Key - For comprehensive research Ghost CMS Admin API Access - For direct publishing Existing Blog Content - Optional but recommended for better research đ§ Workflow Architecture & Process How the AI Agents Work Together This N8N workflow implements a sophisticated multi-agent system where specialized AI agents collaborate through structured data exchange. The workflow uses HTTP Request nodes to communicate with OpenAI and Anthropic APIs, integrates with Brave Search for real-time research, and connects to Ghost CMS via REST API calls. Each agent operates independently but shares data through N8N's workflow context, ensuring seamless information flow from research to publication. The system includes error handling, retry logic, and quality gates at each stage to maintain content standards.
By Christian MendietaExport Zammad objects (users, roles, groups, organizations) to Excel
This n8n workflow enables you to export data from Zammad, including Users, Roles, Groups, and Organizations, into individual Excel files. It simplifies data handling and reporting by creating structured outputs for further processing or sharing. Features Export Users with associated details such as email, firstname, lastname, roleids, and groupids. Export Roles and Organizations with their respective identifiers and names. Convert all data into separate Excel files for easy access and use. Usage Import this workflow into your n8n instance. Configure the required Zammad API credentials (zammadbaseurl and zammadapikey) in the Basic Variables node. Run the workflow to generate Excel files containing Zammad data. Issues and Suggestions If you encounter any issues or have suggestions for improvement, please report them on the GitHub repository. We appreciate your feedback to help enhance this workflow!
By SirhexalotSentiment analysis of product reviews using Google Sheets & OpenAI
đ§ Sentiment Analysis of Product Reviews using Google Sheets & OpenAI đ Quick Implementation Steps Automated customer feedback analyzer: Trigger: Google Sheets triggers on new product review rows. Sentiment Analysis: Review text sent to OpenAI. Writeback: Resulting sentiment (Positive, Neutral, Negative) is written back to the sheet. Just connect your credentials and sheet â you're ready to go! đ What It Does This workflow automatically analyzes user-submitted product reviews and classifies them by sentiment using OpenAIâs powerful language models. It eliminates the need to manually sift through feedback by tagging each review with a sentiment score. The sentiment result is then written back to the Google Sheet next to the original review, enabling you to get a fast, clear snapshot of overall customer perception, satisfaction and pain points. Whether you're monitoring 10 or 10,000 reviews, this process scales effortlessly and updates every minute. đ¤ Whoâs It For This workflow is designed for: E-commerce teams collecting user reviews. Product teams monitoring customer feedback. Marketing teams identifying promotable reviews. Support teams watching for negative experiences. SaaS platforms, apps, and survey tools managing structured text feedback. â Requirements Youâll need: A Google Sheet with two columns: Review and Sentiment Google Sheets OAuth2 credentials in n8n OpenAI API Key (for GPT-4o-mini or GPT-3.5) n8n instance with LangChain and OpenAI nodes enabled âď¸ How It Works Google Sheets Trigger: Watches for new rows every minute OpenAI Integration: Uses LangChainâs Sentiment Analysis node Passes review text into GPT-4o-mini via the OpenAI Chat Model node Sheet Update: The sentiment result (Positive, Negative, or Neutral) is written into the Sentiment column in the same row. Sticky Notes included for better visual understanding inside the workflow editor. đ ď¸ Steps to Configure and Use Prepare Your Google Sheet Make sure your sheet is named Sheet1 with the following structure: | Review | Sentiment | |---------------------------------------|-----------| | Absolutely love it! | | | Not worth the price. | | Set Up Credentials Google Sheets: OAuth2 credentials OpenAI: API Key added via OpenAI API credential in n8n Import & Activate Workflow Import the workflow JSON into your n8n instance. Assign the proper credentials to the trigger and OpenAI nodes. Activate the workflow. 𧊠How To Customize đď¸ Alerting: Add Slack/Email nodes for negative sentiment alerts đ Triggering: Change the polling interval to real-time triggers (e.g., webhook) đ Extended Sentiment: Modify sentiment categories (e.g., "Mixed", "Sarcastic") 𧞠Summary Report: Add Cron + Aggregation nodes for daily/weekly summaries đ§ Prompt Tuning: Adjust system prompt for deeper or context-based sentiment evaluation 𧹠Addâons (Optional Features) Email Digest of Negative Reviews Google Drive Logging Team Notification via Slack Summary to Notion, Airtable, or Google Docs đ Use Case Examples Online Stores: Auto-tag reviews for reputation monitoring Product Teams: See which feature releases generate positive or negative buzz CX Dashboards: Feed real-time sentiment to internal BI tools Marketing: Extract glowing reviews for social proof Support: Triage issues by flagging critical comments instantly ...and many more applications wherever text feedback is collected. 𧰠Troubleshooting Guide | Issue | Possible Cause | Suggested Fix | |-------------------------|---------------------------------------------|---------------------------------------------------| | Sentiment not updating | Sheet credentials missing or misconfigured | Reconnect Google Sheets OAuth2 | | Blank sentiment | Review column empty or misaligned | Ensure proper column header & value present | | OpenAI errors | Invalid or expired API key | Regenerate API Key from OpenAI and re-auth | | Workflow doesnât run | Polling settings incorrect | Confirm interval & document ID in trigger node | đ¤ Need Help? If you need assistance for â Help setting up this workflow âď¸ Customizing prompts or output đ Automating your full review pipeline đ Contact us today at WeblineIndia. We will be happy to assist.
By WeblineIndiaAutomate student admission process with Excel, validation & email notifications
This automated n8n workflow processes student applications on a scheduled basis, validates data, updates databases, and sends welcome communications to students and guardians. Main Components Trigger at Every Day 7 am - Scheduled trigger that runs the workflow daily Read Student Data - Reads pending applications from Excel/database Validate Application Data - Checks data completeness and format Process Application Data - Processes validated applications Update Student Database - Updates records in the student database Prepare Welcome Email - Creates personalized welcome messages Send Email - Sends welcome emails to students/guardians Success Response - Confirms successful processing Error Response - Handles any processing errors Essential Prerequisites Excel file with student applications (student_applications.xlsx) Database access for student records SMTP server credentials for sending emails File storage access for reading application data Required Excel File Structure (student_applications.xlsx): Application ID | First Name | Last Name | Email | Phone Program Interest | Grade Level | School | Guardian Name | Guardian Phone Application Date | Status | Notes Expected Input Data Format: json { "firstName": "John", "lastName": "Doe", "email": "john.doe@example.com", "phone": "+1234567890", "program": "Computer Science", "gradeLevel": "10th Grade", "school": "City High School", "guardianName": "Jane Doe", "guardianPhone": "+1234567891" } Key Features â° Scheduled Processing: Runs daily at 7 AM automatically đ Data Validation: Ensures application completeness đž Database Updates: Maintains student records đ§ Auto Emails: Sends welcome messages â Error Handling: Manages processing failures Quick Setup Import workflow JSON into n8n Configure schedule trigger (default: 7 AM daily) Set Excel file path in "Read Student Data" node Configure database connection in "Update Student Database" node Add SMTP settings in "Send Email" node Test with sample data Activate workflow Parameters to Configure excelfilepath: Path to student applications file database_connection: Student database credentials smtp_host: Email server address smtp_user: Email username smtp_password: Email password admin_email: Administrator notification email
By Oneclick AI SquadAutomate meeting transcription & minutes distribution with OpenAI and Google Drive
Automated Meeting Recording Transcription & Minutes Distribution Workflow Managing meeting recordings manuallyâdownloading audio, transcribing it, summarizing key points, saving documents, and notifying the teamâquickly becomes repetitive and inefficient. This workflow eliminates all of those manual steps by automatically detecting new audio files uploaded to a designated Google Drive folder, converting them into high-quality transcripts using OpenAI, summarizing them into structured meeting minutes, transforming the content into a text file, uploading it back to Google Drive, and finally notifying a Chatwork room with the completed summary. What used to take hours can now be completed automatically within minutes, ensuring consistency, accuracy, and faster information sharing. Whoâs it for This workflow is ideal for: Teams that need high-quality, client-ready meeting minutes generated automatically Project managers who require accurate summaries, decision tracking, and action items without manual effort Cross-functional teams handling multiple meetings and requiring structured, searchable documentation Organizations using Google Meet, Zoom, or Teams where recordings must be turned into polished minutes Anyone who wants a consistent, AI-assisted system that analyzes discussions, extracts insights, and formats them professionally By leveraging an advanced Meeting Minutes Generation Systemâcapable of key-point extraction, noise reduction, speaker/topic organization, and review supportâthis workflow ensures that every meeting is transformed into a clean, structured, and highly usable document. --- How it works Audio file upload triggers the workflow When a new recording is uploaded to the designated Google Drive folder, the Google Drive Trigger immediately activates and begins processing. The audio file is downloaded The file is retrieved from Google Drive and prepared in binary format for accurate transcription. AI-powered transcription The audio is sent to OpenAIâs transcription engine, producing a complete and highly accurate transcript of the meeting. Generate structured, client-ready meeting minutes The transcript is processed by a specialized Meeting Minutes Generation System powered by a multi-step prompt. Instead of using a fixed template, the system intelligently analyzes the transcription and automatically generates a professionally structured document using the following capabilities: Extraction of key points while removing irrelevant conversation Organization of content by speaker, topic, and logical flow Automatic construction of headings and document structure Draft generation based on client-facing writing standards Review-support logic that allows refinement and improved readability Task-based orchestration (ingestion â key-point extraction â draft generation â review â final approval) Because the system dynamically determines the optimal structure, the resulting minutes adapt to the content of each meeting rather than following a rigid set of categories. If certain information cannot be derived from the transcript, the system will appropriately leave it out rather than forcing placeholder sections. Convert the minutes into a file The structured minutes are converted into a .txt or .docx document, ready for submission or archival. Upload the finalized document The completed meeting minutes are uploaded to a specific Google Drive folder and saved using a timestamped filename. Notify Chatwork A formatted notificationâincluding the summarized contentâis automatically posted to a Chatwork room, ensuring immediate team visibility. --- How to set up Import the workflow into your n8n environment. Authenticate Google Drive and select the folder to monitor for new recordings. Connect your OpenAI API keys for both transcription and structured minutes generation. Specify the Google Drive folder where the finished documents should be stored. Add your Chatwork API token and room ID for automated notifications. Upload a sample audio file to confirm the full end-to-end pipeline works correctly. --- Requirements n8n instance (cloud or self-hosted) Google Drive account with appropriate folder permissions OpenAI API credentials Chatwork API token Supported audio formats like mp3, wav, m4a, etc. --- How to customize the workflow Modify the minutes-generation prompt to reflect your organizationâs preferred format Add Slack, Teams, or Discord notifications in addition to Chatwork Route different types of meetings to different folders or templates Save transcript and structured minutes separately for compliance or analysis Log metadata or decisions into Google Sheets or project management tools Store minutes in a vector database to enable semantic search across past meetings Attach the final document directly as a file in Chatwork Extend the system to support revision cycles, reviewer comments, or approval workflows
By Yuki HirotaGenerate pro construction quotes from jotform to email with Supabase CRM
Who it's for Construction and renovation businesses that need to generate detailed quotes from customer inquiriesâplasterers, painters, contractors, renovation specialists, or any construction service provider handling quote requests through online forms. What it does Automatically transforms JotForm submissions into professional, itemized construction quotes with complete CRM trackingâno subscription needed (saving âŹ200-500/year). When a customer fills your project request form (specifying wall/ceiling areas, finish types, ceiling heights, wet areas, prep work), the workflow extracts measurements, normalizes service selections, applies intelligent pricing rules from your Supabase catalog, calculates line items with material and labor costs plus proper VAT handling, stores everything in a structured CRM pipeline (customer â project deal â estimate), and generates a branded HTML email ready for delivery. This self-hosted pricing engine replaces paid invoicing software for quote generation, saving thousands over time while eliminating manual takeoffs and quote preparationâ from 30-60 minutes to under 30 seconds. How it works Stage 1: JotForm webhook triggers â Parser extracts project data (m² measurements, service types, property details) â Normalize Dutch construction terms to database values â Save raw submission for audit trail Stage 2: Upsert customer record (idempotent on email) â Create project deal â Link to form submission Stage 3: Fetch active pricing rules â Calculate line items based on square meters, service type (smooth plaster vs decorative), ceiling height premiums, property status (new build vs renovation), wet area requirements â Apply conditional logic (high ceilings = price multiplier, prep work charges, finish level) â Group duplicate items â Save estimate header + individual lines Stage 4: Query optimized view (single call, all data) â Generate professional HTML email with logo, itemized services table (description, m², unit price, totals), VAT breakdown, CTA buttons, legal disclaimer Setup requirements Supabase account (free tier sufficient) - Database for CRM + pricing catalog JotForm account (free tier works) - Form builder with webhook support Email service - Gmail, SendGrid, or similar (add your own email node) How to set up Database setup (2 minutes): Run this workflow's "SQL Generator" node to output complete schema Copy output â Paste in Supabase SQL Editor â Click Run Creates 9 tables + 1 optimized view + sample construction services (plastering âŹ21-32/m², painting âŹ12-15/m², ornamental work, ceiling finishes) Credentials: Add Supabase credentials to n8n (Project URL + Service Role Key from Supabase Settings â API) No JotForm credentials needed (uses webhook) JotForm webhook: Clone demo construction form: [jotform stucco planet demo](https://form.jotform.com/252844786304060 )- Form fields: Property type, postcode, services needed, wall/ceiling m², finish level, ornament quantities, molding meters, wet areas, ceiling heights, prep removal, start date, customer contact Settings â Integrations â Webhooks â Add your n8n webhook URL Test with preview submission Customize email: Update company info in "Generate Email HTML" node (logo, business address, contact details, Chamber of Commerce number, VAT number) Adjust colors/branding in HTML template Available in Dutch and English versions How to customize Add your construction services: Edit price_catalog table in Supabase (no code changes): sql INSERT INTO pricecatalog (itemcode, name, unitprice, vatrate, unit_type) VALUES ('DRYWALL_INSTALL', 'Drywall Installation', 18.50, 9, 'm²');
By Stephan KoningDaily Bible verse & reflection email with bible.api, Google Gemini, and Gmail
What this does This automation automatically sends an email with a random Bible verse to a specified recipient every morning, as well as some reflections on the meaning of that verse. Start your day off grounded and faithful. Requirements n8n Gmail account with OAuth2 credentials enabled Google Gemini(PaLM) API credentials enabled How this works Runs every morning at 7:00a. Reads the config value sendtoemail Calls bible.api for a random verse Uses Gemini to analyze the random verse and create the body text for the email Sends an Email to the recipient specified by sendtoemail Subject reads "Daily Bible Verse: Inspiration for Today (book :)" How to set up In the "Config - recipient" node, in the sendtoemail field, replace "example@example.com" with the desired recipient email Add your Google Gemini(PaLM) API credentials Add your Gmail OAuth2 credentials (optional) In the "Schedule trigger" node, keep the default schedule at 7:00a or change the hour as desired Test the flow by running it to verify the subject and body content. How to customize the workflow Change the send time in the Schedule Trigger node Change the Bible translation, or specify Old vs. New Testament in the Bible API node Adjust the prompt in the Gemini node to change the email content Modify the subject line in the Gmail node
By Hattie Elbahri