Track real-time stock prices with Yahoo Finance, ScrapegraphAI, and Google Sheets
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. How it works This automated workflow monitors stock prices by scraping real-time data from Yahoo Finance. It uses a scheduled trigger to run at specified intervals, extracts key stock metrics using AI-powered extraction, formats the data through a custom code node, and automatically saves the structured information to Google Sheets for tracking and analysis. Key Steps: Scheduled Trigger: Runs automatically at specified intervals to collect fresh stock data AI-Powered Scraping: Uses ScrapeGraphAI to intelligently extract stock information (symbol, current price, price change, change percentage, volume, and market cap) from Yahoo Finance Data Processing: Formats extracted data through a custom Code node for optimal spreadsheet compatibility and handles both single and multiple stock formats Automated Storage: Saves all stock data to Google Sheets with proper column mapping for easy filtering, analysis, and historical tracking Set up steps Setup Time: 5-10 minutes Configure Credentials: Set up your ScrapeGraphAI API key and Google Sheets OAuth2 credentials Customize Target: Update the website URL in the ScrapeGraphAI node to your desired stock symbol (currently set to AAPL) Configure Schedule: Set your preferred trigger frequency (daily, hourly, etc.) for stock price monitoring Map Spreadsheet: Connect to your Google Sheets document and configure column mapping for the stock data fields Pro Tips: Keep detailed configuration notes in the sticky notes within the workflow Test with a single stock first before scaling to multiple stocks Consider modifying the Code node to handle different stock symbols or add additional data fields Perfect for building a historical database of stock performance over time Can be extended to track multiple stocks by modifying the ScrapeGraphAI prompt
By vinci-king-01Complete backup solution for n8n workflows & credentials (local/FTP)
Automated n8n Workflows & Credentials Backup to Local/Server Disk & FTP Complete backup solution that saves both workflows and credentials to local/server disk with optional FTP upload for off-site redundancy. What makes this workflow different: Backs up workflows AND credentials together Saves to local/server disk (not Git, GitHub, or any cloud services) Optional FTP upload for redundancy (disabled by default) Comprehensive error handling and email notifications Timezone-aware scheduling Ready to use with minimal configuration How it works Backup Process (Automated Daily at 4 AM): Initialisation - Sets up timezone-aware timestamps and configurable backup paths for both local/server disk and FTP destinations Folder Creation - Creates date-stamped backup directories (YYYY-MM-DD format) on local/server disk Dual Backup Operations - Processes credentials and workflows in two separate branches: Credentials Branch: Exports n8n credentials using the built-in CLI command with backup flag Lists exported credential files in the credentials folder Reads each credential file from disk Optional: Uploads to FTP server (disabled by default) Optional: Logs FTP upload results for credentials Workflows Branch: Retrieves all workflows via n8n API Cleans workflow names for cross-platform compatibility Converts workflows to formatted JSON files Writes files to local/server disk Optional: Uploads to FTP server (disabled by default) Optional: Logs FTP upload results for workflows Data Aggregation - Combines all workflow data with binary attachments for comprehensive reporting Results Merging - Consolidates credentials FTP logs, workflows FTP logs, and aggregated workflow data Summary Generation - Creates detailed backup logs including: Statistics (file counts, sizes, durations) Success/failure tracking for local and FTP operations Error tracking with detailed messages Timezone-aware timestamps Notifications - Sends comprehensive email reports with log files attached and saves execution logs to disk How to use Initial Setup: Configure the Init Node - Open the "Init" node and customize these key parameters in the "Workflow Standard Configuration" section: javascript // Admin email for notifications const N8NADMINEMAIL = $env.N8NADMINEMAIL || 'youremail@world.com'; // Workflow name (auto-detected) const WORKFLOW_NAME = $workflow.name; // Projects root directory on your server const N8NPROJECTSDIR = $env.N8NPROJECTSDIR || '/files/n8n-projects-data'; // projects-root-folder/ // └── Your-project-folder-name/ // ├── logs/ // ├── reports/ // ├── ... // └── [other project files] // Project folder name for this backup workflow const PROJECTFOLDERNAME = "Workflow-backups"; Then customize these parameters in the "Workflow Custom Configuration" section: javascript // Local backup folder (must exist on your server) const BACKUPFOLDER = $env.N8NBACKUP_FOLDER || '/files/n8n-backups'; // FTP backup folder (root path on your FTP server) const FTPBACKUPFOLDER = $env.N8NFTPBACKUP_FOLDER || '/n8n-backups'; // FTP server name for logging (display purposes only) const FTPName = 'Synology NAS 2To'; These variables can also be set as environment variables in your n8n configuration. Set Up Credentials: Configure n8n API credentials for the "Fetch Workflows" node Configure SMTP credentials for email notifications Optional: Configure FTP credentials if you want to enable off-site backups Configure Backup Folder: Ensure the backup folder path exists on your server Verify proper write permissions for the n8n process If running in Docker, ensure volume mapping is correctly configured Customize Email Settings: Update the "Send email" node with your recipient email address or your "N8NADMINEMAIL" environment value Adjust email subject and body text as needed Enabling FTP Upload (Optional): By default, FTP upload nodes are disabled for easier setup. To enable off-site FTP backups: Simply activate these 4 nodes (no other changes needed): "Upload Credentials To FTP" "FTP Logger (credentials)" "Upload Workflows To FTP" "FTP Logger (workflows)" Configure FTP credentials in the two upload nodes The workflow will automatically handle FTP operations and include upload status in reports Requirements n8n API credentials (for workflow fetching) SMTP server configuration (for email notifications) Adequate disk space for local backup storage Proper file system permissions for backup folder access Docker environment with volume mapping (if running n8n in Docker) Optional: FTP server access and credentials (for off-site backups) Good to know Security: Credentials are exported using n8n's secure backup format - actual credential values are not exposed in plain text Timezone Handling: All timestamps respect configured timezone settings (defaults to Europe/Paris, configurable in Init node) File Naming: Automatic sanitization ensures backup files work across different operating systems (removes forbidden characters, limits length to 180 characters) FTP Upload: Disabled by default for easier setup - simply activate 4 nodes to enable off-site backups without any code changes Connection Resilience: FTP operations include error handling for timeout and connection issues without failing the entire backup Graceful Degradation: If FTP nodes are disabled, the workflow completes successfully with local backups only and indicates FTP status in logs Error Handling: Comprehensive error catching with detailed logging and email notifications Dual Logging: Creates both JSON logs (for programmatic parsing) and plain text logs (for human readability) Storage: Individual workflow JSON files allow for selective restore and easier version control integration Scalability: Handles any number of workflows efficiently with detailed progress tracking --- This automated backup workflow saves your n8n data to both local disk and FTP server. To restore your backups, use: "n8n Restore from Disk - Self-Hosted Solution" for local/server disk restores "n8n Restore from FTP - Remote Backup Solution" for FTP remote restores
By FlorentGenerate qualified Instagram leads from hashtags with Apify and Google Sheets
Instagram Hashtag Lead Generation Automate the process of finding and qualifying Instagram leads based on hashtags. This workflow reads hashtags from Google Sheets, scrapes Instagram for posts using Apify, analyzes caption content and language, compiles unique usernames, gathers detailed user info, and filters leads based on follower count. --- How It Works Fetch Hashtags The workflow starts and pulls a list of hashtags from a Google Sheet. Scrape Instagram Posts For each hashtag, it builds Instagram explore URLs and scrapes posts using Apify. Analyze Captions Each caption is cleaned, hashtags and links are removed, and language/content is analyzed (English/French/Spanish). Extract & Filter Usernames Usernames are combined and deduplicated, their Instagram profiles scraped for follower counts and other details. Qualified Leads Only users with followers in your target range are kept as qualified leads for outreach or analysis. --- Requirements An n8n instance. Apify API key. Google account with a Sheet containing hashtags. Apify Instagram Scraper actor access. The Google Sheet should have a column with hashtags. --- Setup Instructions Add Credentials In n8n, add your Apify API key and Google Sheets credentials. Configure Google Sheets Nodes Choose your credentials, spreadsheet, and sheet name in the “Get list of Hashtags” node. Configure Apify Request Nodes Enter your Apify API key and select the Instagram scraper actors. Adjust Filtering Edit the min/max follower count in the relevant filter node to match your needs. Test & Run Manually execute the workflow or add a trigger to run on a schedule. --- Customization Options 💡 Trigger: Add a schedule or webhook to automate execution. Language Filtering: Modify keyword lists or add language detection logic. Lead Output: Extend the workflow to save leads to a CRM or send notifications. --- Details Nodes used in workflow: Manual Trigger Google Sheets Code HTTP Request (Apify) IF (Conditional) Aggregate Remove Duplicates Sticky Note
By MatthewGenerate SEO blog posts from web searches with Mistral AI and Google Drive
📖 Overview This template automates the process of researching a keyword, scraping top-ranking articles, cleaning their content, and generating a high-quality SEO-optimized blog post. It uses Google Search via RapidAPI, Ollama with Mistral AI, and Google Drive to deliver an end-to-end automated content workflow. Ideal for content creators, SEO specialists, bloggers, and marketers who need to quickly gather and summarize insights from multiple sources to create superior content. ⚙️ Prerequisites Before using this workflow, make sure you have: n8n installed (Desktop, Docker, or Cloud). Ollama installed with the mistral:7b model: ollama pull mistral:7b RapidAPI account (for Google Search API). Google Drive account (with a target folder where articles will be saved). 🔑 Credentials Required RapidAPI (Google Search API) Header authentication with your API key. Example headers: x-rapidapi-key: YOURAPIKEY x-rapidapi-host: google-search74.p.rapidapi.com Google Drive OAuth2 Allow read/write permissions. Update the folderId with your Drive folder where articles should be stored. Ollama API Base URL: http://localhost:11434 (local n8n) http://host.docker.internal:11434 (inside Docker) Ensure the mistral:7b model is available. 🚀 Setup Instructions Configure RapidAPI Sign up at RapidAPI . Subscribe to the Google Search API. Create an HTTP Header Auth credential in n8n with your API key. Configure Google Drive In n8n, add a Google Drive OAuth2 credential. Select the Drive folder ID where output files should be saved. Configure Ollama Install Ollama locally. Pull the required model (mistral:7b). Create an Ollama API credential in n8n. Run the Workflow Trigger by sending a chat message with your target keyword. The workflow searches Google, extracts the top 3 results, scrapes the articles, cleans the content, and generates a structured blog post. Final output is stored in Google Drive as a .docx file. 🎨 Customization Options Search Engine → Swap out RapidAPI with Bing or SerpAPI. Number of Articles → Change limit: 3 in the Google Search node. Content Cleaning → Modify the regex in the “Clean Body Text” node to capture <div> or <article> tags. AI Model → Replace mistral:7b with llama3, mixtral, or any other Ollama-supported model. Storage → Save output to a different Google Drive folder or export to Notion/Slack. 📌 Workflow Highlights Google Search (RapidAPI) → Fetch top 3 results for your keyword. HTTP Request + Code Nodes → Extract and clean article body text. Mistral AI via Ollama → Summarize, optimize, and refine the content. Google Drive → Save the final blog-ready article automatically.
By ZakwanAI email support system: Gmail, Gemini, GPT-4, Slack & Google Sheets workflow
🚀 Transform Your Customer Support with AI Automation! Unlock unparalleled efficiency and elevate customer satisfaction with our AI-Powered Customer Support: Email, Knowledge Base & Human Escalation Automation template. This sophisticated n8n workflow is engineered to streamline your support operations, ensuring every customer interaction is intelligent, consistent, and handled with speed. --- ✨ How It Works: Your Automated Support Powerhouse Witness the magic as customer inquiries are seamlessly transformed into resolved tickets, often without human intervention: Effortless Email Intake: Your journey to automated excellence begins the moment a customer email lands in your Gmail inbox. Our workflow instantly captures new inquiries, ensuring no request ever falls through the cracks. Intelligent Inquiry Classification: Say goodbye to manual triage! An advanced AI text classifier immediately analyzes incoming emails, intelligently categorizing each inquiry into precise buckets like Technical Support, Billing Support, Urgent Escalation, or General Support. This ensures every query is sent to the right specialist—virtual or human—from the start. AI-Driven, Context-Rich Responses: The classified inquiry is routed to a specialized AI agent (powered by Google Gemini), which taps into your comprehensive Pinecone knowledge base. This Retrieval-Augmented Generation (RAG) ensures every response is not only fast and accurate but also deeply informed by your company's specific policies and documentation, providing personalized and expert answers. Instant Communication & Meticulous Logging: Once generated, the AI's professional response is automatically sent back to the customer via Gmail. Simultaneously, every detail of the interaction – from the classified service type to the full AI response and a unique ticket ID – is meticulously logged in your Google Sheet. This creates an invaluable, searchable record for unparalleled insights and accountability. Seamless Urgent Human Escalation: For critical or complex issues requiring a human touch, the workflow instantly escalates the ticket. Your team is notified via Slack with all pertinent details, ensuring urgent matters are always prioritized and resolved swiftly, maintaining high customer satisfaction even in challenging situations. Self-Updating Knowledge Base: Keep your AI agents perpetually smart! Our workflow effortlessly maintains your Pinecone knowledge base by automatically processing and ingesting new documents uploaded to a designated Google Drive folder. This ensures your AI always has the most current information, without any manual data entry from your side. --- 🛠️ Effortless Setup: Go Live in Under an Hour! Getting started with this powerful automation is surprisingly simple. You can typically have your core setup ready and operational in just 30-60 minutes, freeing you to focus on strategic growth rather than tedious setup. Connect Your Services: Quickly link your existing accounts for Gmail, OpenAI, Google Gemini, Pinecone, Google Sheets, Slack, and Google Drive using n8n's intuitive credential management. Prepare Your Data Hub: Link the workflow to your Google Sheet with pre-defined columns for seamless logging of all support interactions. Empower Your AI with Knowledge: Simply upload your company's FAQs, policies, and documentation into a specified Google Drive folder. Our workflow handles the rest, automatically building and enriching your Pinecone knowledge base. Activate & Automate: With your credentials connected and data sources in place, activate the workflow in n8n, and watch your customer support transform! For comprehensive, step-by-step guidance on advanced customization, API key configuration, and fine-tuning every aspect to your unique business needs, refer to the detailed Sticky Notes embedded directly within the n8n workflow. They are your personal setup assistant!
By David OlusolaAutomate tax deduction processing with GPT-4 receipt analysis and Gmail reporting
How It Works This workflow automates monthly tax processing by ingesting expense receipts alongside revenue data, extracting structured deduction details using GPT-4, and accurately matching expenses to their corresponding revenue periods. It retrieves receipts with built-in type validation, parses deduction information through OpenAI structured output extraction, and consolidates revenue records into a unified dataset. The system then intelligently aligns expenses with revenue timelines, calculates eligible deductions, and generates well-formatted tax reports that are automatically sent to designated agents via Gmail. Designed for accountants, tax professionals, and finance teams, it enables automated expense categorization and optimized deduction calculations. Setup Steps Configure receipt storage source and OpenAI Chat Model API key. Connect Gmail for report delivery and set up tax agent email. Define expense categories, revenue periods, and deduction rules. Schedule monthly trigger and test extraction Prerequisites Expense receipt repository; OpenAI API key; Gmail account; revenue data source Use Cases Accountants automating receipt processing for multiple clients; Customization Adjust extraction prompts for industry-specific expenses, modify deduction rules Benefits Eliminates manual receipt review, reduces categorization errors
By Cheng Siong Chin