AI powered web scraping with Jina, Google Sheets and OpenAI : the EASY way
Purpose of workflow: The purpose of this workflow is to automate scraping of a website, transforming it into a structured format, and loading it directly into a Google Sheets spreadsheet. How it works: Web Scraping: Uses the Jina AI service to scrape website data and convert it into LLM-friendly text. Information Extraction: Employs an AI node to extract specific book details (title, price, availability, image URL, product URL) from the scraped data. Data Splitting: Splits the extracted information into individual book entries. Google Sheets Integration: Automatically populates a Google Sheets spreadsheet with the structured book data. Step by step setup: Set up Jina AI service: Sign up for a Jina AI account and obtain an API key. Configure the HTTP Request node: Enter the Jina AI URL with the target website. Add the API key to the request headers for authentication. Set up the Information Extractor node: Use Claude AI to generate a JSON schema for data extraction. Upload a screenshot of the target website to Claude AI. Ask Claude AI to suggest a JSON schema for extracting required information. Copy the generated schema into the Information Extractor node. Configure the Split node: Set it up to separate the extracted data into individual book entries. Set up the Google Sheets node: Create a Google Sheets spreadsheet with columns for title, price, availability, image URL, and product URL. Configure the node to map the extracted data to the appropriate columns.
By Derek CheungAutomate call scheduling with Voice AI receptionist using Vapi, Google Calendar & Airtable
Who is this template for? This template is ideal for small businesses, agencies, and solo professionals who want to automate appointment scheduling and caller follow-up through a voice-based AI receptionist. If youโre using tools like Google Calendar, Airtable, and Vapi (Twilio), this setup is for you. What problem does this workflow solve? Manual call handling, appointment booking, and email coordination can be time-consuming and prone to errors. This workflow solves that by automating the receptionist role: answering calls, checking calendar availability, managing appointments, and storing call summariesโall without human intervention. What this workflow does This Agent Receptionist manages inbound voice calls and scheduling tasks using Vapi and Google Calendar. It checks availability, books or updates calendar events, sends email confirmations, and logs call details into Airtable. The workflow includes built-in logic for slot management, email triggers, and storing call transcripts. Setup Instructions Duplicate Airtable Base: Use this Airtable base templateBASE LINK Import Workflow: Load provided JSON into your n8n instance. Credentials: Connect your Google Calendar and Airtable credentials in n8n. Activate Workflow: Enable workflow to get live webhook URLs. Vapi Configuration: Paste provided system prompt into Vapi Assistant. Link the appropriate webhook URLs from n8n (GetSlots, BookSlots, UpdateSlots, CancelSlots, and end-of-call report). Disclaimer Optimized for cloud-hosted n8n instances. Self-hosted users should verify webhook and credential setups.
By SuperAgent๐ Learn Code Node (JavaScript) with an Interactive Hands-On Tutorial
How it works This workflow is a hands-on tutorial for the Code node in n8n, covering both basic and advanced concepts through a simple data processing task. Provides Sample Data: The workflow begins with a sample list of users. Processes Each Item (Run Once for Each Item): The first Code node iterates through each user to calculate their fullName and age. This demonstrates basic item-by-item data manipulation using $input.item.json. Fetches External Data (Advanced): The second Code node showcases a more advanced feature. For each user, it uses the built-in this.helpers.httpRequest function to call an external API (genderize.io) to enrich the data with a predicted gender. Processes All Items at Once (Run Once for All Items): The third Code node receives the fully enriched list of users and runs only once. It uses $items() to access the entire list and calculate the averageAge, returning a single summary item. Create a Binary File: The final Code node gets the fully enriched list of users once again and creates a binary CSV file to show how to use binary data Buffer in JavaScript. Set up steps Setup time: < 1 minute This workflow is a self-contained tutorial and requires no setup. Explore the Nodes: Click on each of the Code nodes to read the code and the comments explaining each step, from basic to advanced. Run the Workflow: Click "Execute Workflow" to see it in action. Check the Output: Click on each node after the execution to see how the data is transformed at each stage. Notice how the data is progressively enriched. Experiment! Try changing the data in the 1. Sample Data node, or modify the code in the Code nodes to see what happens.
By Lucas PeyrinNutrition tracker & meal logger with Telegram, Gemini AI and Google Sheets
๐ค๐ฅ Telegram Nutrition AI Assistant (Alternative to Cal AI App) > AI-powered nutrition assistant for Telegram โ log meals, set goals, and get personalized daily reports with Google Sheets integration. ๐ Description This n8n template creates a Telegram-based Nutrition AI Assistant ๐ฅ๐ฅ designed as an open-source alternative to the Cal AI mobile app. It allows users to interact with an AI agent via text, voice, or images to track meals, calculate macros, and monitor nutrition goals directly from Telegram. The system integrates Google Sheets as the database, handling both user profiles and meal logs, while leveraging Gemini AI for natural conversation, food recognition, and daily progress reports. โจ Key Features ๐ฌ Multi-input support: Text, voice messages (transcribed), and food images (AI analysis). ๐ Macro calculation: Automatic estimation of calories, proteins, carbs, and fats. ๐ User-friendly registration: Simple onboarding without storing personal health data (no weight/height required). ๐ฏ Goal tracking: Users can set and update calorie and protein targets. ๐ Daily reports: Personalized progress messages with visual progress bars. ๐ Google Sheets integration: Profile table for user targets. Meals table for food logs. ๐ Advanced n8n nodes: Includes use of Merge, Subworkflow, and Code nodes for data processing and report generation. ๐ก Acknowledgment Inspired by the Cal AI concept ๐ก โ this template demonstrates how to reproduce its main functionality with n8n, Telegram, and AI agents as a flexible, open-source automation workflow. ๐ท Tags telegram ai-assistant nutrition meal-tracking google-sheets food-logging voice-transcription image-analysis daily-reports n8n-template merge-node subworkflow-node code-node telegram-trigger google-gemini ๐ผ Use Case Use this template if you want to: ๐ฅ Log meals using text, images, or voice messages. ๐ Track nutrition goals (calories, proteins) with daily progress updates. ๐ค Provide a chat-based nutrition assistant without building a full app. ๐ Store structured nutrition data in Google Sheets for easy access and analysis. ๐ฌ Example User Interactions ๐ธ User sends a photo of a meal โ AI analyzes the food and logs calories/macros. ๐ค User sends a voice message โ AI transcribes and logs the meal. โจ๏ธ User types โreportโ โ AI returns a daily nutrition summary with progress bars. ๐ฅ User says โupdate my protein goalโ โ AI updates profile in Google Sheets. ๐ Required Credentials Telegram Bot API (Bot Token) Google Sheets API credentials AI Provider API (Google Gemini or compatible LLM) โ๏ธ Setup Instructions ๐ Create two Google Sheets tables: Profile: UserID, Name, Caloriestarget, Protein_target Meals: UserID, Date, Mealdescription, Calories, Proteins, Carbs, Fats ๐ Configure the Telegram Trigger with your bot token. ๐ค Connect your AI provider credentials (Gemini recommended). ๐ Connect Google Sheets with your credentials. โถ๏ธ Deploy the workflow in n8n. ๐ฏ Start interacting with your nutrition assistant via Telegram. ๐ Extra Notes ๐ฉ Green section: Handles Telegram trigger and user check. ๐ฅ Red section: Registers new users and sets goals. ๐ฆ Blue section: Processes text, voice, and images. ๐จ Yellow section: Generates nutrition reports. ๐ช Purple section: Main AI agent controlling tools and logic. --- ๐ก Need Assistance? If youโd like help customizing or extending this workflow, feel free to reach out: ๐ง Email: johnsilva11031@gmail.com ๐ LinkedIn: John Alejandro Silva Rodrรญguez
By John Alejandro SIlvaAI crew to automate fundamental stock analysis - Q&A workflow
How it works: Using a Crew of AI agents (Senior Researcher, Visionary, and Senior Editor), this crew will automatically determine the right questions to ask to produce a detailed fundamental stock analysis. This application has two components: a front-end and a Stock Q&A engine. The front end is the team of agents automatically figuring out the questions to ask, and the back-end part is the ability to answer those questions with the SEC 10K data. This template implements the Stock Q&A engine. For the front-end of the application, you can choose one of two options: using CrewAI with the Replit environment (code approach) fully visual approach with n8n template (AI-powered automated stock analysis) Setup steps: Use first workflow in template to upsert a company annual report PDF (such as from SEC 10K filling) Get URL for Webhook in second workflow template CrewAI front-end: Youtube overview video Fork this AI Agent environment Crew Agent Environment Set the webhook URL into N8NWEBHOOKURL variable Set OpenAIAPIKEY variable
By Derek CheungAutomate social media posts with AI content and images across Twitter, LinkedIn & Facebook
Auto-generate & post content using AI This workflow helps you create daily content using just a topic prompt. It writes a tweet, generates an image, and publishes across Twitter, Facebook, and LinkedIn โ all on autopilot. --- How it works Triggers daily at 10 PM to start the flow Uses OpenAI to generate a niche topic title Writes a short-form post (tweet style) with hashtags Generates a Japanese anime-style image for visual context Saves everything in Google Sheets Publishes automatically on Twitter, LinkedIn, and Facebook --- Set up steps Youโll need OpenAI, Google Sheets, and social media credentials (Twitter, Facebook, LinkedIn) Takes about 10โ15 minutes to configure if you already have the credentials ready Make sure your Sheet and API keys are properly linked before activating ๐ Keep detailed notes inside the workflow with sticky notes for easier handoff or collaboration.
By Abrar SamiDiscord AI-powered bot
This workflow is a template example for making Discord GPT-powered bots. Incoming user requests are analysed and categorised via OpenAI node with the help of a hand-crafted prompt. The response message is then routed to a different Discord channel.
By EduardEmail support agent w/ Gemini & GPT fallback using Gmail + Google Sheets
๐ง Master Your First AI Email Agent with Smart Fallback! Welcome to your hands-on guide for building a resilient, intelligent email support system in n8n! This workflow is specifically designed as an educational tool to help you understand advanced AI automation concepts in a practical, easy-to-follow way. --- ๐ What You'll Learn & Build: This powerful template enables you to create an automated email support agent that: Monitors Gmail for new customer inquiries in real-time. Processes requests using a primary AI model (Google Gemini) for efficiency. Intelligently falls back to a secondary AI model (OpenAI GPT) if the primary model fails or for more complex queries, ensuring robust reliability. Generates personalized and helpful replies automatically. Logs every interaction meticulously to a Google Sheet for easy tracking and analysis. --- ๐ก Why a Fallback Model is Game-Changing (and Why You Should Learn It): Unmatched Reliability (99.9% Uptime): If one AI service experiences an outage or rate limits, your automation seamlessly switches to another, ensuring no customer email goes unanswered. Cost Optimization: Leverage more affordable models (like Gemini) for standard queries, reserving premium models (like GPT) only when truly needed, significantly reducing your API costs. Superior Quality Assurance: Get the best of both worlds โ the speed of cost-effective models combined with the accuracy of more powerful ones for complex scenarios. Real-World Application: This isn't just theory; it's a critical pattern for building resilient, production-ready AI systems. --- ๐ Perfect for Beginners & Aspiring Automators: Simple Setup: With drag-and-drop design and pre-built integrations, you can get this workflow running with minimal configuration. Just add your API keys! Clear Educational Value: Learn core concepts like AI model orchestration strategies, customer service automation best practices, and multi-model AI implementation patterns. Immediate Results: See your AI agent in action, responding to emails and logging data within minutes of setup. --- ๐ ๏ธ Getting Started Checklist: To use this workflow, you'll need: A Gmail account with API access enabled. A Google Sheets document created for logging. A Gemini API key (your primary AI model). An OpenAI API key (your fallback AI model). An n8n instance (cloud or desktop). --- Embark on your journey to building intelligent, resilient automation systems today!
By David OlusolaAi-powered Telegram task manager with MCP server
Detailed Description The ToDo App workflow is designed to streamline task management through Telegram and Google Tasks integration. This workflow allows users to create, update, and manage tasks via Telegram messages, leveraging AI capabilities to enhance user interaction. The expected outcome is a seamless experience where users can manage their tasks efficiently without needing to switch between applications. Who is this for? This workflow is intended for: Individuals looking for an efficient way to manage their tasks directly from Telegram. Teams that require a collaborative task management solution integrated with Google Tasks. Developers interested in automating task management processes using n8n and Telegram. What problem does this workflow solve? Managing tasks can often be cumbersome, especially when switching between different applications. This workflow addresses the following problems: Fragmented Task Management: Users can manage tasks directly from Telegram, reducing the need to switch to Google Tasks. Inefficient Communication: By integrating AI, users can interact with the task management system in a conversational manner, making it more intuitive. Task Updates: Users can easily update task statuses and details through simple messages, enhancing productivity. What this workflow does The ToDo App workflow performs the following functions: Incoming Message Handling: Listens for messages sent to a Telegram bot. Task Creation: Allows users to create new tasks based on their messages. Task Updates: Users can update existing tasks by sending specific commands. Task Retrieval: Retrieves today's and upcoming tasks from Google Tasks. Voice Note Transcription: Supports voice messages, converting them into text for task management. AI Assistance: Utilizes an AI agent to assist users in managing their tasks effectively. Setup Prerequisites Before setting up the workflow, ensure you have the following: n8n Account: Sign up for an n8n account if you don't have one. Telegram Bot: Create a Telegram bot and obtain the API token. Google Tasks API: Set up Google Tasks API and obtain OAuth2 credentials. OpenAI API Key: Sign up for OpenAI and obtain an API key for AI functionalities. Setup Process Upload the JSON for this workflow and setup the authentication for the different tools. How to customize this workflow To adapt the ToDo App workflow to different needs, consider the following customizations: Change Task Management Platform: If you prefer a different task management tool, replace the Google Tasks nodes with your preferred service's API. Modify AI Responses: Adjust the AI agent's system message to change how it interacts with users. Add Additional Commands: Expand the workflow by adding more commands for different task management functionalities (e.g., deleting tasks). Integrate Other Messaging Platforms: If you want to use a different messaging service, replace the Telegram nodes with the appropriate nodes for that service. Conclusion The ToDo App workflow provides a powerful solution for managing tasks through Telegram, enhancing productivity and user experience. By following the setup instructions and customization options, users can tailor the workflow to meet their specific needs, making task management more efficient and accessible.
By Francis Njenga๐จ Report n8n workflow errors to Telegram
Use case Error workflows are an important part of running workflows in production. Make sure to set them up for all your important workflows. The message links directly to the execution. How to setup Add Telegram creds Set chat id in Telegram node Add this error workflow to other workflows https://docs.n8n.io/flow-logic/error-handling/create-and-set-an-error-workflow
By Mutasem๐ฌ YouTube shorts automation tool ๐
๐ฌ YouTube Shorts Automation Tool ๐ Automate the creation of high-performing YouTube Shorts in minutes! Who is this for? ๐ฏ Content Creators: Generate engaging short videos effortlessly. Marketing Agencies: Produce client-ready content quickly. Business Owners: Promote products/services through viral short-form content. What problem does this solve? ๐ ๏ธ Creating short-form video content is time-consuming, complex, and skill-intensive. This workflow automates video creation, eliminating the need for video editing expertise while ensuring SEO optimization, high-quality visuals, and professional voiceovers. How it works ๐ Enter your video idea into the chat interface. AI generates a script optimized for engagement and SEO. Voiceover is created with realistic AI narration. Relevant visuals are selected to match the script. The video is assembled and delivered via a shareable link. Setup โ๏ธ (5-10 min) Connect required APIs (most have free tiers). Follow the guided setup (video tutorial included). Start generating professional YouTube Shorts instantly! Required APIs ๐ Content Generation: OpenAI, ElevenLabs (script & voiceover) Media Processing: Cloudinary, Replicate (images & storage) Integration Tools: 0codekit, Creatomate (video assembly) Customization ๐จ Adjust script styles & voiceover preferences. Modify visuals to match your brand. Optimize video length and format. ๐ Start automating your YouTube Shorts today and grow your audience effortlessly!
By Jonas BuschAI-powered RAG workflow for stock earnings report analysis
This n8n workflow creates a financial analysis tool that generates reports on a company's quarterly earnings using the capabilities of OpenAI GPT-4o-mini, Google's Gemini AI and Pinecone's vector search. By analyzing PDFs of any company's earnings reports from their Investor Relations page, this workflow can answer complex financial questions and automatically compile findings into a structured Google Doc. How it works: Data loading and indexing Fetches links to PDF earnings document from a Google Sheet containing a list of file links. Downloads the PDFs from Google Drive. Parses the PDFs, splits the text into chunks, and generates embeddings using the Embeddings Google AI node (text-embedding-004 model). Stores the embeddings and corresponding text chunks in a Pinecone vector database for semantic search. Report generation with AI agent Utilizes an AI Agent node with a specifically crafted system prompt. The agent orchestrates the entire process. The agent uses a Vector Store Tool to access and retrieve information from the Pinecone database. Report delivery Saves the generated report as a Google Doc in a specified Google Drive location. Set up steps Google Cloud Project & Vertex AI API: Create a Google Cloud project. Enable the Vertex AI API for your project. Google AI API key: Obtain a Google AI API key from Google AI Studio. Pinecone account and API key: Create a free account on the Pinecone website. Obtain your API key from your Pinecone dashboard. Create an index named company-earnings in your Pinecone project. Google Drive - download and save financial documents: Go to a company you want to analize and download their quarterly earnings PDFs Save the PDFs in Google Drive Create a Google Sheet that stores a list of file URLs pointing to the PDFs you downloaded and saved to Google Drive Configure credentials in your n8n environment for: Google Sheets OAuth2 Google Drive OAuth2 Google Docs OAuth2 Google Gemini(PaLM) Api (using your Google AI API key) Pinecone API (using your Pinecone API key) Import and configure the workflow: Import this workflow into your n8n instance. Update the List Of Files To Load (Google Sheets) node to point to your Google Sheet. Update the Download File From Google Drive to point to the column where the file URLs are Update the Save Report to Google Docs node to point to your Google Doc where you want the report saved.
By Mihai Farcas