by Yaron Been
🚀 Automated Funding Intelligence: CrunchBase to Google Sheets Tracking Workflow! Workflow Overview This cutting-edge n8n automation is a sophisticated startup funding intelligence tool designed to transform market research into actionable insights. By intelligently connecting CrunchBase, data processing, and Google Sheets, this workflow: Discovers Funding Opportunities: Automatically retrieves latest funding rounds Tracks industry-specific investments Eliminates manual market research efforts Intelligent Data Processing: Filters funding data by location and industry Extracts key investment metrics Ensures comprehensive market intelligence Seamless Data Logging: Automatically updates Google Sheets Creates real-time investment database Enables rapid market trend analysis Scheduled Intelligence Gathering: Daily automated tracking Consistent market insight updates Zero manual intervention required Key Benefits 🤖 Full Automation: Zero-touch funding research 💡 Smart Filtering: Targeted investment insights 📊 Comprehensive Tracking: Detailed funding intelligence 🌐 Multi-Source Synchronization: Seamless data flow Workflow Architecture 🔹 Stage 1: Funding Discovery Scheduled Trigger**: Daily market scanning CrunchBase API Integration** Intelligent Filtering**: Location-based selection Industry-specific focus Most recent funding rounds 🔹 Stage 2: Data Extraction Comprehensive Metadata Parsing** Key Information Retrieval** Structured Data Preparation** 🔹 Stage 3: Data Logging Google Sheets Integration** Automatic Row Appending** Real-Time Database Updates** Potential Use Cases Venture Capitalists**: Investment opportunity tracking Startup Scouts**: Market trend analysis Market Researchers**: Comprehensive funding insights Investors**: Strategic decision support Business Strategists**: Competitive landscape monitoring Setup Requirements CrunchBase API API credentials Configured access permissions Funding round tracking setup Google Sheets Connected Google account Prepared tracking spreadsheet Appropriate sharing settings n8n Installation Cloud or self-hosted instance Workflow configuration API credential management Future Enhancement Suggestions 🤖 Advanced investment trend analysis 📊 Multi-source funding aggregation 🔔 Customizable alert mechanisms 🌐 Expanded industry coverage 🧠 Machine learning insights generation Technical Considerations Implement robust error handling Use secure API authentication Maintain flexible data processing Ensure compliance with API usage guidelines Ethical Guidelines Respect business privacy Use data for legitimate research Maintain transparent information gathering Provide proper attribution Hashtag Performance Boost 🚀 #StartupFunding #InvestmentIntelligence #MarketResearch #AIWorkflow #DataAutomation #VentureCapital #TechInnovation #InvestmentTracking #BusinessIntelligence #StartupEcosystem Workflow Visualization [Daily Trigger] ⬇️ [Fetch Funding Rounds] ⬇️ [Extract & Format Data] ⬇️ [Log to Google Sheets] Connect With Me Ready to revolutionize your funding intelligence? 📧 Email: Yaron@nofluff.online 🎥 YouTube: @YaronBeen 💼 LinkedIn: Yaron Been Transform your market research with intelligent, automated workflows!
by lin@davoy.tech
This workflow template, "Daily Gratitude Reminder Bot for LINE," is designed to help users cultivate a habit of gratitude by sending personalized, AI-generated reminders every evening at 9:00 PM. Using Azure OpenAI , the bot generates varied and engaging messages to prompt users to reflect on the positive aspects of their day. The reminders are then sent directly to users via the LINE messaging platform , ensuring a seamless and impactful experience. Whether you're a developer, counselor, or business owner, this template offers a customizable and scalable solution for promoting mental wellness and fostering a culture of gratitude. profile Qwen2.5-Max 2:56 pm Here’s a polished and detailed description for your "Daily Gratitude Reminder Bot for LINE" template, following the submission guidelines provided. This description is structured to meet all the requirements, including SEO optimization, clarity, and user convenience. Daily Gratitude Reminder Bot for LINE This workflow template, "Daily Gratitude Reminder Bot for LINE," is designed to help users cultivate a habit of gratitude by sending personalized, AI-generated reminders every evening at 9:00 PM. Using Azure OpenAI , the bot generates varied and engaging messages to prompt users to reflect on the positive aspects of their day. The reminders are then sent directly to users via the LINE messaging platform , ensuring a seamless and impactful experience. Whether you're a developer, counselor, or business owner, this template offers a customizable and scalable solution for promoting mental wellness and fostering a culture of gratitude. Who Is This Template For? Developers who want to integrate AI-powered workflows into messaging platforms like LINE. Counselors & Therapists looking to encourage mindfulness and emotional well-being among their clients. Businesses & Organizations focused on employee wellness or customer engagement through positive reinforcement. Educators & Nonprofits seeking tools to promote mental health awareness and self-care practices. What Problem Does This Workflow Solve? Gratitude journaling has been proven to improve mental health, reduce stress, and increase overall happiness. However, many people struggle to maintain the habit due to busy schedules or forgetfulness. This workflow solves that problem by automating daily reminders to reflect on positive experiences, making it easier for users to build and sustain a gratitude practice. What This Workflow Does Scheduled Trigger: The workflow is triggered every evening at 9:00 PM using a schedule node. AI-Powered Message Generation: An Azure OpenAI Chat Model generates a unique and engaging reminder message with a temperature setting of 0.9 to ensure variety and creativity. Message Formatting: The generated message is reformatted to comply with the LINE Push API requirements, ensuring smooth delivery. Push Notification via LINE: The formatted message is sent to the user via the LINE Push API , delivering the reminder directly to their chat. Setup Guide Pre-Requisites Access to an Azure OpenAI account with credentials. A LINE Developers Console account with access to the Push API. Basic knowledge of n8n workflows and JSON formatting. How to Customize This Workflow to Your Needs Change the Time: Adjust the schedule trigger to send reminders at a different time. Modify the Prompt: Edit the AI model's input prompt to generate messages tailored to your audience (e.g., focus on work achievements or personal growth). Expand Recipients: Update the LINE Push API node to send reminders to multiple users or groups. Integrate Additional Features: Add nodes to log user responses or track engagement metrics. Why Use This Template? Promotes Mental Wellness: Encourages users to reflect on positive experiences, improving emotional well-being. Highly Customizable: Easily adapt the workflow to suit different audiences and use cases. Scalable: Send reminders to one user or thousands, making it suitable for both personal and organizational use. AI-Powered Creativity: Avoid repetitive messages by leveraging AI to generate fresh and engaging content.
by Oneclick AI Squad
This workflow auto-fetches top financial headlines, cleans the content, and uses AI to summarize it into a short investor-friendly email. Good to know The workflow runs daily and relies on stable webpage access; check the URL (e.g., https://www.ft.com/) for availability. AI costs may apply depending on the LLM model used (e.g., GPT-4 or Gemini); refer to provider pricing. How it works Trigger the workflow daily with the Schedule Daily Trigger node. Fetch financial news from a webpage using the Fetch Webpage News node. Add a Delay to Ensure Page Load node to ensure content is fully loaded. Extract and clean headlines with the Extract News Headlines & Clean Extracted Data node. Process the data with the LLM Chat Model node to generate a summary. Send the summarized report via email using the Email Daily Financial Summary node. How to use Import the workflow into n8n and configure the nodes with your webpage URL and email credentials. Test the workflow to verify content fetching and email delivery. Requirements Webpage access (e.g., financial news site API or RSS) Email service (e.g., SMTP or API) LLM model credentials (e.g., GPT-4 or Gemini) Customising this workflow Adjust the Fetch Webpage News node to target different news sources or modify the LLM Chat Model prompt for a different summary style.
by Pavel Duchovny
Who is this for? This workflow is designed for: Database administrators and developers working with MongoDB Content managers handling movie databases Organizations looking to implement AI-powered search and recommendation systems Developers interested in combining LangChain, OpenAI, and MongoDB capabilities What problem does this workflow solve? Traditional database queries can be complex and require specific MongoDB syntax knowledge. This workflow addresses: The complexity of writing MongoDB aggregation pipelines The need for natural language interaction with movie databases The challenge of maintaining user preferences and favorites The gap between AI language models and database operations What this workflow does This workflow creates an intelligent agent that: Accepts natural language queries about movies Translates user requests into MongoDB aggregation pipelines Queries a movie database containing detailed information including: Plot summaries Genre classifications Cast and director information Runtime and release dates Ratings and awards Provides contextual responses using OpenAI's language model Allows users to save favorite movies to the database Maintains conversation context using a window buffer memory Setup Required Credentials: OpenAI API credentials MongoDB connection details Node Configuration: Configure the MongoDB connection in the MongoDBAggregate node Set up the OpenAI Chat Model with your API key Ensure the webhook trigger is properly configured for receiving chat messages Database Requirements: A MongoDB collection named "movies" with the specified document structure Proper indexes for efficient querying Appropriate user permissions for read/write operations How to customize this workflow Modify the Document Structure: Update the tool description in the MongoDBAggregate node to match your collection schema Adjust the aggregation pipeline templates for your specific use case Enhance the AI Agent: Customize the prompt in the "AI Agent - Movie Recommendation" node Modify the window buffer memory size based on your context needs Add additional tools for more functionality Extend Functionality: Add more MongoDB operations beyond aggregation Implement additional workflows for different types of queries Create custom error handling and validation Add user authentication and rate limiting Integration Options: Connect to external APIs for additional movie data Add webhook endpoints for different platforms Implement caching mechanisms for frequent queries Add data transformation nodes for specific output formats This workflow serves as a foundation that can be adapted to various use cases beyond movie recommendations, such as e-commerce product search, content management systems, or any scenario requiring intelligent database interaction.
by Lucas Peyrin
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 ibrhdotme
Learning something new? Endlessly searching to find the best resources? This workflow finds top community-recommended learning resources on any topic from Hacker News, delivered to your inbox. How it works User submits a topic they want to learn via a simple form. The workflow searches for relevant "Ask HN" posts on Hacker News and extracts top-level comments. An LLM analyzes the comments and identifies the best learning resources. A personalized email is sent to the user with a Markdown formatted list of top recommendations, categorized by resource type (e.g., book, course, article) and difficulty level. Set up steps Add your Google Gemini API credentials. You'll need to create a project and enable the Generative Language API. Add your SMTP credentials for sending emails. Customize the Form and email subject (optional) Activate the workflow Screenshots for Workflow, Form and Email Built on Day-03 as part of the #100DaysOfAgenticAi Fork it, tweak it, have fun!
by Mauricio Perera
Overview: This workflow is designed to handle user inputs via a webhook, process the inputs with the Google Gemini API (specifically the gemini-2.0-flash-thinking-exp-1219 model), and return a structured response to the user. The response includes three key elements: reasoning, the final answer, and citation URLs (if applicable). This workflow provides a robust solution for integrating AI reasoning into your processes. This workflow can be utilized as a tool for AI-based agents, intelligent email drafting systems, or as a standalone intelligent automation solution. Setup: Webhook Configuration: Ensure the webhook node is properly set up to accept GET requests with an input parameter. Verify that the webhook path matches your application requirements. Test the webhook using tools like Postman to ensure proper data formatting. Google Gemini API Credentials: Set up your Google Gemini API account credentials in the HTTP Request node. Ensure API access and permissions are valid. Parameter Adjustments: Customize the temperature, topK, topP, and maxOutputTokens parameters to fit your use case. Customization: Input Parameters: Modify the webhook path or parameters based on the data your application will send. Response Formatting: Adjust the JavaScript code in the "Process API Response" node to fit your desired output structure. Output Expectations: Test the response returned by the "Return Response to User" node to ensure it meets your application requirements. Workflow Steps: Receive User Input: Node Type: Webhook Purpose: Captures a GET request containing a user-provided input parameter. Acts as the starting point for the workflow. Send Request to Google Gemini: Node Type: HTTP Request Purpose: Sends the received input to the Gemini-2.0-flash-thinking-exp-1219 model for processing. The API configuration includes parameters for customizing the response. Process API Response: Node Type: Code Node Purpose: Extracts reasoning, the final answer, and citation URLs from the API response. Organizes the output for further use. Return Response to User: Node Type: Respond to Webhook Purpose: Sends the processed and structured response back to the user via the webhook. Ensures the response format meets expectations. Expected Outcomes: Input Handling:** Successfully captures user input via a webhook. AI Processing:* Generates a structured response using the *Gemini-2.0-flash-thinking-exp-1219** model, including reasoning, answers, and citations (if available). Output Delivery:** Returns a user-friendly response formatted to your specifications. Notes: The workflow is inactive by default. Each node is annotated with a Sticky Note to clarify its purpose. Ensure all API credentials are correctly configured before execution. Use this workflow to save time, improve accuracy, and automate repetitive tasks efficiently. Tags: Automation Google Gemini AI Agents Intelligent Automation Content Generation Workflow Integration
by Yaron Been
Transform raw customer feedback into powerful testimonial quotes automatically. This intelligent n8n workflow monitors feedback forms, uses AI to identify and extract the most emotionally engaging testimonial content, and organizes everything into a searchable database for your marketing campaigns. 🔄 How It Works This streamlined 4-step automation turns feedback into marketing assets: Step 1: Continuous Feedback Monitoring The workflow monitors your Google Sheets (connected to feedback forms) every minute, instantly detecting new customer submissions and triggering the extraction process. Step 2: Intelligent Quote Extraction Google Gemini AI analyzes each feedback submission using specialized prompts designed to: Identify emotionally engaging phrases and statements Extract short, impactful testimonial quotes from longer feedback Filter out neutral, irrelevant, or negative content Focus on marketing-ready, quotable customer experiences Preserve the authentic voice and emotion of the original feedback Step 3: Automated Database Population Extracted testimonials are automatically written back to your Google Sheets in a dedicated "Testimony" column, creating an organized, searchable database of customer quotes ready for marketing use. Step 4: Instant Team Notification Email alerts are sent immediately to your marketing team with each new extracted testimonial, ensuring no valuable social proof goes unnoticed or unused. ⚙️ Setup Steps Prerequisites Google Workspace account for Forms, Sheets, and Gmail Google Gemini API access for intelligent quote extraction n8n instance (cloud or self-hosted) Basic understanding of Google Forms and customer feedback collection Required Google Forms Structure Create a customer feedback form with these essential fields: 📝 Required Form Fields: Name (Short answer text) Email Address (Email field with validation) Feedback (Paragraph text - this is where testimonials are extracted from) Testimony (Leave blank - will be auto-populated by AI) Form Design Best Practices: Use open-ended questions to encourage detailed responses Ask specific questions about customer experience and outcomes Include questions about before/after results for powerful testimonials Make the feedback field prominent and easy to complete Configuration Steps 1. Credential Setup Google Sheets OAuth2**: Monitor feedback responses and update testimonial database Google Gemini API Key**: Extract intelligent, emotionally engaging quotes from feedback Gmail OAuth2**: Send automated notifications to marketing team Google Forms Integration**: Ensure seamless data flow from feedback forms 2. Google Sheets Configuration Verify your feedback response sheet contains proper column structure: | Timestamp | Name | Email | Feedback | Testimony | 3. AI Extraction Optimization The default prompt extracts impactful testimonials, but can be customized for: Industry-Specific Language**: Healthcare, technology, finance, retail terminology Quote Length Preferences**: Short punchy quotes vs longer detailed testimonials Emotional Tone Targeting**: Excitement, relief, satisfaction, transformation Content Focus**: Results-oriented, process-focused, or relationship-based testimonials 4. Notification Customization Email alerts can be configured for: Multiple Recipients**: Marketing team, sales team, customer success Custom Subject Lines**: Include customer name, product type, or urgency indicators Rich Content**: Include full feedback alongside extracted testimonial Categorization**: Different alerts for different product lines or service types 5. Quality Control Implementation Extraction Confidence**: Set minimum quality thresholds for extracted quotes Manual Review Process**: Flag testimonials for human review before publication Approval Workflows**: Add approval steps for high-value or sensitive testimonials Version Control**: Track original feedback alongside extracted quotes 🚀 Use Cases E-commerce & Retail Product Reviews**: Extract compelling quotes from detailed product feedback Customer Success Stories**: Identify transformation narratives from user experiences Social Proof Collection**: Build testimonial libraries for product pages and ads Review Mining**: Turn long reviews into short, shareable testimonial quotes SaaS & Technology Companies User Experience Feedback**: Extract quotes about software usability and impact ROI Testimonials**: Identify statements about business results and efficiency gains Feature Feedback**: Capture specific praise for product capabilities and benefits Customer Success Metrics**: Extract quantifiable results and outcome statements Professional Services Client Success Stories**: Transform project feedback into powerful case study quotes Service Quality Testimonials**: Extract praise for expertise, communication, and results Consulting Impact**: Identify statements about business transformation and growth Relationship Testimonials**: Capture quotes about trust, partnership, and collaboration Healthcare & Wellness Patient Experience**: Extract quotes about care quality and health outcomes Treatment Success**: Identify statements about symptom improvement and recovery Provider Relationships**: Capture testimonials about bedside manner and communication Wellness Journey**: Extract quotes about lifestyle changes and health transformations Education & Training Student Success Stories**: Extract quotes about learning outcomes and career impact Course Effectiveness**: Identify statements about skill development and knowledge gains Instructor Praise**: Capture testimonials about teaching quality and support Career Transformation**: Extract quotes about professional growth and opportunities 🔧 Advanced Customization Options Multi-Category Extraction Enhance extraction with specialized processing: Product-Specific: Extract testimonials for different product lines separately Service-Based: Customize extraction for various service offerings Demographic-Focused: Tailor extraction for different customer segments Journey-Stage: Extract testimonials for awareness, consideration, and retention phases Quality Enhancement Features Implement advanced quality control: Sentiment Scoring**: Rate extracted testimonials for emotional impact Authenticity Verification**: Cross-reference testimonials with customer records Duplicate Detection**: Prevent similar testimonials from the same customer Content Enrichment**: Add context and customer details to extracted quotes Marketing Integration Extensions Connect to marketing and sales tools: Social Media Publishing**: Auto-post testimonials to Facebook, LinkedIn, Twitter Website Integration**: Push testimonials to website testimonial sections Email Marketing**: Include fresh testimonials in newsletter campaigns Sales Enablement**: Provide sales team with relevant testimonials for prospects Analytics and Reporting Generate insights from testimonial data: Testimonial Performance**: Track which quotes generate most engagement Customer Satisfaction Trends**: Analyze testimonial sentiment over time Product/Service Insights**: Identify most praised features and benefits Competitive Advantages**: Extract testimonials highlighting differentiators 📊 Extraction Examples Before (Raw Feedback): "I was really struggling with managing my team's projects and keeping track of all the deadlines. Everything was scattered across different tools and I was spending way too much time just trying to figure out what everyone was working on. Since we started using your project management software about 6 months ago, it's been a complete game changer. Now I can see everything at a glance, our team communication has improved dramatically, and we're actually finishing projects ahead of schedule. The reporting features are amazing too - I can finally show my boss concrete data about our team's productivity. I honestly don't know how we managed without it. The customer support team has been fantastic as well, always quick to help when we had questions during setup." After (AI Extracted Testimonial): "Complete game changer - now I can see everything at a glance, our team communication has improved dramatically, and we're actually finishing projects ahead of schedule." Healthcare Example: Before (Raw Feedback): "I had been dealing with chronic back pain for over 3 years and had tried everything - physical therapy, medication, different doctors. Nothing seemed to help long-term. When I found Dr. Martinez, I was honestly pretty skeptical because I'd been disappointed so many times before. But after our first consultation, I felt hopeful for the first time in years. She really listened to me and explained everything clearly. The treatment plan she developed was comprehensive but manageable. Within just 2 months, I was experiencing significant pain reduction, and now after 6 months, I'm practically pain-free. I can play with my kids again, sleep through the night, and even started hiking on weekends. Dr. Martinez didn't just treat my symptoms - she helped me get my life back." After (AI Extracted Testimonial): "Within just 2 months, I was experiencing significant pain reduction, and now I'm practically pain-free. Dr. Martinez didn't just treat my symptoms - she helped me get my life back." 🛠️ Troubleshooting & Best Practices Common Issues & Solutions Low-Quality Extractions Improve Feedback Questions**: Ask more specific, outcome-focused questions Refine AI Prompts**: Adjust extraction criteria for better quote selection Set Minimum Length**: Ensure feedback has sufficient content for meaningful extraction Quality Scoring**: Implement rating system for extracted testimonials Insufficient Feedback Volume Multiple Feedback Channels**: Collect testimonials through various touchpoints Incentivized Feedback**: Offer small rewards for detailed feedback submissions Follow-up Automation**: Send feedback requests to satisfied customers Timing Optimization**: Request feedback at optimal moments in customer journey Privacy and Consent Issues Permission Management**: Ensure customers consent to testimonial use Attribution Control**: Allow customers to specify how they want to be credited Approval Workflows**: Implement customer approval before publishing testimonials Data Protection**: Maintain compliance with privacy regulations Optimization Strategies Extraction Quality Enhancement Prompt Engineering**: Continuously refine AI prompts based on output quality A/B Test Extractions**: Test different extraction approaches for effectiveness Human Review Integration**: Combine AI extraction with human editorial oversight Context Preservation**: Maintain customer context alongside extracted quotes Marketing Integration Campaign Alignment**: Extract testimonials that support specific marketing campaigns Audience Segmentation**: Categorize testimonials for different target audiences Channel Optimization**: Format testimonials for specific marketing channels Performance Tracking**: Monitor which testimonials drive best marketing results Process Automation Multi-Stage Processing**: Implement multiple extraction and refinement steps Quality Gates**: Add checkpoints for testimonial quality and relevance Workflow Branching**: Route different types of feedback to appropriate processes Error Handling**: Implement fallbacks for failed extractions or poor-quality feedback 📈 Success Metrics Extraction Efficiency Processing Speed**: Reduce time from feedback submission to usable testimonial Success Rate**: Percentage of feedback submissions yielding quality testimonials Quote Quality**: Average rating of extracted testimonials by marketing team Volume Increase**: Growth in testimonial collection and database size Marketing Impact Testimonial Usage**: Frequency of extracted testimonials in marketing campaigns Conversion Rates**: Impact of AI-extracted testimonials on sales metrics Social Proof Effectiveness**: Engagement rates on testimonial-based content Customer Acquisition**: Attribution of new customers to testimonial-driven campaigns 📞 Questions & Support Need help implementing your AI Testimonial Extractor Agent? 📧 Specialized Technical Support Email**: Yaron@nofluff.online Response Time**: Within 24 hours on business days Expertise**: AI testimonial extraction, feedback form optimization, marketing automation 🎥 Comprehensive Learning Library YouTube Channel**: https://www.youtube.com/@YaronBeen/videos Complete setup guides for feedback form design and AI extraction Advanced prompt engineering techniques for testimonial quality Integration tutorials for marketing platforms and social media Best practices for customer feedback collection and testimonial usage Troubleshooting common extraction and quality issues 🤝 Professional Marketing Community LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Connect for ongoing testimonial marketing automation support Share your customer success story automation achievements Access exclusive templates for feedback forms and testimonial campaigns Join discussions about social proof marketing and customer experience automation 💬 Support Request Guidelines Include in your support message: Your industry and typical customer feedback patterns Current testimonial collection process and challenges Specific marketing channels where testimonials will be used Volume expectations and quality requirements Integration needs with existing marketing tools Ready to turn every customer feedback into marketing gold? Deploy this AI Testimonial Extractor Agent and build a powerful testimonial database that drives sales and builds trust with prospects automatically!
by Corentin Ribeyre
This template can be used to verify email addresses with Icypeas. Be sure to have an active account to use this template. How it works This workflow can be divided into four steps : The workflow initiates with a manual trigger (On clicking ‘execute’). It reads your Google Sheet file. It connects to your Icypeas account. It performs an HTTP request to scan the domains/companies. Set up steps You will need a formated Google sheet file with company/domain names. You will need a working icypeas account to run the workflow and get your API Key, API Secret and User ID. You will need domain/companies names to scan them.
by Yaron Been
Automated pipeline that exports technology stack data from BuiltWith to Google Sheets for analysis, reporting, and team collaboration. 🚀 What It Does Extracts technology stack data Organizes data in Google Sheets Updates automatically on schedule Supports multiple company tracking Enables easy data sharing 🎯 Perfect For Sales teams Market researchers Business analysts Competitive intelligence Technology consultants ⚙️ Key Benefits ✅ Centralized technology database ✅ Easy data analysis ✅ Team collaboration ✅ Historical tracking ✅ Custom reporting 🔧 What You Need BuiltWith API access Google account n8n instance Google Sheets setup 📊 Data Exported Company information Web technologies Hosting details Analytics tools Marketing technologies Contact information 🛠️ Setup & Support Quick Setup Start exporting in 15 minutes with our step-by-step guide 📺 Watch Tutorial 💼 Get Expert Support 📧 Direct Help Transform raw technology data into actionable business intelligence with automated exports.
by WeblineIndia
Automate Telegram Chat Responses Using Google Gemini By WeblineIndia* ⚡ TL;DR (Quick Steps) Create a Telegram bot using @BotFather and copy the API Token. Obtain Google Gemini API Key via Google Cloud. Set up the n8n workflow: Trigger: Telegram message received. AI Model: Google Gemini generates response. Output: AI reply sent back to user via Telegram. Customize the system prompt, model, or message handling to suit your use case. 🧠 Description This n8n workflow enables seamless automation of real-time chat replies in Telegram by integrating with Google Gemini's Chat Model. Every time a user sends a message to your Telegram bot, the workflow routes it through the Gemini AI, which analyzes and crafts a professional response. This reply is then automatically delivered back to the user. The setup acts as a lightweight but powerful chatbot system — ideal for businesses, customer service, or even personal productivity bots. You can easily modify its tone, intelligence level, or logging mechanisms to cater to specific domains such as sales, tech support, or general Q&A. 🎯 Purpose of the Workflow The primary goal of this workflow is to automate intelligent, context-aware chat responses in Telegram using a robust AI model. It eliminates manual reply handling, enhances user engagement, and ensures 24/7 interaction capabilities — all through a no-code or low-code setup using n8n. 🛠️ Steps to Configure and Use ✅ Pre-Conditions / Requirements Telegram Bot Token**: Get it from @BotFather. Google Gemini API Key**: Available via Google Cloud PaLM/Gemini API access. n8n Instance**: Hosted or local instance with required nodes installed (Telegram, Basic LLM Chain, and Google Gemini support). 🔧 Setup Instructions Step 1: Telegram Trigger – Listen for Incoming Messages Add Telegram Trigger node. Select Trigger On: Message. Authenticate using your Telegram Bot Token. This will capture incoming messages from any user interacting with your bot. Step 2: Google Gemini AI – Generate a Smart Reply Add the Basic LLM Chain node. Connect the input message ({{$json.message.text}}) from the Telegram Trigger. System Prompt: > "You are an AI assistant. Reply to the following user message professionally:" Choose Google Gemini Chat Model (models/gemini-1.5-pro). Connect this node to receive the text input and pass it to Gemini for processing. Step 3: Telegram Reply – Send the AI Response Add a Telegram node (Operation: Send Message). Set Chat ID dynamically from the Telegram Trigger node. Input the generated message from the Gemini output. Enable Parse Mode as HTML for rich formatting. Final Step: Link All Nodes Receive Telegram Message → Generate AI Response → Send Telegram Reply. > Tip: Test the workflow by sending a message to your Telegram bot and ensure you receive an AI-generated reply. 🧩 Customization Guidance ✏️ Modify the AI tone by updating the system prompt. 🤖 Use other AI models (e.g., OpenAI GPT-4o). 🔍 Add filters to respond differently based on specific keywords. 📊 Extend the workflow to store chats in Google Sheets, Airtable, or databases for audit or analytics. 🌐 Multi-language support: Add translation layers before and after AI processing. 🛠️ Troubleshooting Guide No message received?** Check if your Telegram bot is active and webhook is working. AI not responding?** Validate your Google Gemini API key and usage quota. Wrong replies?** Refine the system prompt or validate message routing. Formatting issues?** Ensure Parse Mode is correctly set to HTML. 💡 Use Case Examples Customer Service Chatbot** for product queries. Educational Bots** for answering user questions on a topic. Mental Health Companion** that gives supportive replies. Event-based Announcers** or automatic responders during off-hours. > And many more! This workflow can be easily extended to support advanced use cases with just a few additional nodes. 👨💻 About the Creator This workflow is developed by WeblineIndia, a trusted provider of AI development services and process automation solutions. If you're looking to build or customize intelligent workflows like this, we invite you to get in touch with our team. We also offer specialized Python development and AI developer hiring services to supercharge your automation needs.
by Airtop
Automating Company Data Enrichment and ICP Calculation Use Case This automation identifies a company's LinkedIn profile, extracts key business data, and calculates an ICP (Ideal Customer Profile) score to qualify and enrich company records. It is perfect for sales teams, data enrichment pipelines, and CRM integrations. What This Automation Does Input Parameters Company domain**: The company's website domain (e.g., example.com). Airtop Profile (connected to LinkedIn)**: Your Airtop Profile authenticated for LinkedIn. Company LinkedIn* *(optional): If already known, skips search. Output Includes Verified LinkedIn company URL (if not provided) Company profile (name, tagline, website, location, about) Scale metrics (employee count and bracket) Classification (automation agency status, AI focus, technical level) ICP score with justifications Structured JSON object with all values merged How It Works LinkedIn Detection: If not provided, attempts to locate the LinkedIn URL using website scraping or search. Data Extraction: Uses Airtop to gather structured data from the company’s LinkedIn profile. ICP Scoring: Applies a scoring rubric based on AI/tech orientation, scale, agency status, and geography. Merge Results: All data components are merged into a unified output. Setup Requirements Airtop API Key Airtop Profile with LinkedIn authentication Next Steps Combine with Person Enrichment**: Pair with workflows that enrich individuals tied to the company. Sync to CRM**: Connect the output to your CRM for record enrichment or scoring fields. Adjust ICP Scoring Logic**: Modify the rubric for your organization's ICP model. Read more about company data enrichment and ICP scoring