Data & Analytics Workflows
Data processing and analytics
Automate Professional Report Generation from Excel/CSV with AI and Google Workspace
This workflow automates the transformation of Excel or CSV files into professional reports using AI for analysis and Google Workspace for document creation and distribution.
n8n$19.99Automate YouTube Comment Analysis and Reporting with AI
Leverage AI to transform YouTube comments into actionable insights with automated analysis and professional email reports. This workflow streamlines audience understanding and engagement improvement for content creators.
n8n$14.99Automate LinkedIn Job Scraping and Prospecting with Bright Data and Google Sheets
Automatically scrape LinkedIn job listings using Bright Data, clean the data, and log it into Google Sheets for job hunting and sales prospecting.
n8n$9.99Automate Instagram Profile Scraping with Apify and Google Sheets
This n8n workflow automates the scraping of Instagram profiles using Apify and logs the data into Google Sheets. It processes a list of usernames at scheduled intervals, ensuring efficient data collection and management.
n8n$9.99Batch Scrape Website URLs from Google Sheets to Google Docs with Firecrawl
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. # Firecrawl batch scraping to Google Docs ## Who's it for AI chatbot developers, content managers, and data analysts who need to extract and organize content from multiple web pages for knowledge base creation, competitive analysis, or content migration projects. ## What it does This workflow automatically scrapes content from a list of URLs and converts each page into a structured Google Doc in markdown format. It's designed for batch processing multiple pages efficiently, making it ideal for building AI knowledge bases, analyzing competitor content, or migrating website content to documentation systems. ## How it works The workflow follows a systematic scraping process: - URL Input: Reads a list of URLs from a Google Sheets template - Data Validation: Filters out empty rows and already-processed URLs - Batch Processing: Loops through each URL sequentially - Content Extraction: Uses Firecrawl to scrape and convert content to markdown - Document Creation: Creates individual Google Docs for each scraped page - Progress Tracking: Updates the spreadsheet to mark completed URLs - Final Notification: Provides completion summary with access to scraped content ## Requirements - Firecrawl API key (for web scraping) - Google Sheets access - Google Drive access (for document creation) - Google Sheets template (provided) ## How to set up ### Step 1: Prepare your template - Copy the Google Sheets template - Create your own version for personal use - Ensure the sheet has a tab named Page to doc - List all URLs you want to scrape in the URL column ### Step 2: Configure API credentials Set up the following credentials in n8n: - Firecrawl API: For web content scraping and markdown conversion - Google Sheets OAuth2: For reading URLs and updating progress - Google Drive OAuth2: For creating content documents ### Step 3: Set up your Google Drive folder The workflow saves scraped content to a specific Drive folder - Default folder: Contenu Scrapé (Content Scraped) - Folder ID: 1ry3xvQ9UqM2Rf9C4-AoJdg1lfB9inh_5 (customize this to your own folder) - Create your own folder and update the folder ID in the Create file markdown scraping node ### Step 4: Choose your trigger method Option A: Chat interface - Use the default chat trigger - Send your Google Sheets URL through the chat interface Option B: Manual trigger - Replace chat trigger with manual trigger - Set the Google Sheets URL as a variable in the Get URL node ## How to customize the workflow ### URL source customization - Sheet name: Change Page to doc to your preferred tab name - Column structure: Modify field mappings if using different column names - URL validation: Adjust filtering criteria for URL format requirements - Batch size: The workflow processes all URLs sequentially (no batch size limit) ### Scraping configuration - Firecrawl options: Add specific scraping parameters (wait times, JavaScript rendering) - Content format: Currently outputs markdown (can be modified for other formats) - Error handling: The workflow continues processing even if individual URLs fail - Retry logic: Add retry mechanisms for failed scraping attempts ### Output customization - Document naming: Currently uses the URL as document name (customizable) - Folder organization: Create subfolders for different content types - File format: Switch from Google Docs to other formats (PDF, X, etc.) - Content structure: Add headers, metadata, or formatting to scraped content ### Progress tracking enhancements - Status columns: Add more detailed status tracking (failed, retrying, etc.) - Metadata capture: Store scraping timestamps, content length, etc. - Error logging: Track which URLs failed and why - Completion statistics: Generate summary reports of scraping results ## Use cases ### AI knowledge base creation - E-commerce product pages: Scrape product descriptions and specifications for chatbot training - Documentation sites: Convert help articles into structured knowledge base content - FAQ pages: Extract customer service information for automated support systems - Company information: Gather about pages, services, and team information ### Content analysis and migration - Competitor research: Analyze competitor website content and structure - Content audits: Extract existing content for analysis and optimization - Website migrations: Backup content before site redesigns or platform changes - SEO analysis: Gather content for keyword and structure analysis ### Research and documentation - Market research: Collect information from multiple industry sources - Academic research: Gather content from relevant web sources - Legal compliance: Document website terms, policies, and disclaimers - Brand monitoring: Track content changes across multiple sites ## Workflow features ### Smart processing logic - Duplicate prevention: Skips URLs already marked as Scrapé (scraped) - Empty row filtering: Automatically ignores rows without URLs - Sequential processing: Handles one URL at a time
n8n$9.99Automate Research Paper Collection and Organization with n8n and Bright Data
Streamline the process of collecting and organizing research papers from academic databases into Google Sheets using n8n and Bright Data. This workflow saves time for researchers by automating the search and data extraction process.
n8n$9.99Automate Web Scraping and Data Management with CSV, Google Sheets, and Microsoft Excel
This workflow automates the process of web scraping, extracting data from a website, and managing it by sending a CSV file via email and saving the data to Google Sheets and Microsoft Excel for further analysis.
n8n$9.99Automate Job Scraping from LinkedIn and Indeed to Google Sheets
This n8n workflow automates the extraction of job listings from LinkedIn and Indeed using Bright Data and exports the results to Google Sheets for analysis.
n8n$19.99Automate Recursive Web Scraping with Google Sheets and Google Docs
This workflow automates the process of recursive web scraping, using Google Sheets to manage URLs and Google Docs to store scraped content. It is ideal for collecting data across multiple linked pages for content aggregation, lead generation, or research projects.
n8n$14.99Automate Daily Product Hunt Launch Tracking with Google Sheets Integration
This workflow automates the process of tracking daily launches on Product Hunt by fetching product details, verifying website redirects, and logging the final information into a Google Sheet. Ideal for product managers, indie hackers, and content curators.
n8n$9.99Learn Data Synchronization: Warehouse Inventory Audit Tutorial
## How it works This template is a hands-on tutorial for one of n8n's most powerful data tools: the **Compare Datasets** node. It's the perfect next step after learning basic logic, showing you how to build robust data synchronization workflows. We use a simple **Warehouse Audit** analogy to make the concept crystal clear: * **Warehouse A:** Our main, source of truth database. This is the master list of what our inventory should be. * **Warehouse B:** A second, remote database (like a Notion page or Google Sheet) that we need to keep in sync. * **The Compare Datasets Node:** This is our **Auditor**. It takes both inventory lists and meticulously compares them to find any discrepancies. The Auditor then sorts every item into one of four categories, which correspond to the node's four outputs: 1. **In A only:** New products found in our main warehouse that need to be **added** to Warehouse B. 2. **Same:** Products that match perfectly in both warehouses. **No action needed!** 3. **Different:** Products that exist in both places but have different details (e.g., stock count). These need to be **updated** in Warehouse B. 4. **In B only:** Extra products found in Warehouse B that aren't in our master list. These need to be **deleted**. This pattern is the foundation for any two-way data sync you'll ever need to build. ## Set up steps **Setup time: 0 minutes!** This workflow is a self-contained tutorial and requires no setup or credentials. 1. Click **Execute Workflow** to start the audit. 2. Explore the two `Set` nodes (Warehouse A and Warehouse B) to see the initial data we are comparing. 3. Click on **The Auditor (Compare Datasets node)** to see how it's configured to use `product_id` as the matching key. 4. Follow the outputs to the four `NoOp` nodes to see which products were sorted into each category. 5. Read the sticky notes next to each output—they explain exactly why each item ended up there.
n8n$14.99Automate Multi-Sheet Excel Workbook Creation with Google Drive and Sheets
Automatically generate Excel workbooks with multiple sheets by merging datasets using Google Drive and Google Sheets in n8n. This workflow streamlines reporting by eliminating manual data entry.
n8n$9.99Automate Web Monitoring and Telegram Alerts for Job and Product Updates
This workflow automatically scrapes specific data from websites without APIs or RSS feeds, such as niche job postings or product availability, and sends alerts via Telegram when changes are detected.
n8n$4.99Bulk Export Amazon Product Reviews to Google Sheets via RapidAPI
Effortlessly export up to 700 Amazon product reviews to a Google Sheets tab of your choice using RapidAPI. Ideal for brand managers, marketplace sellers, and agencies looking to analyze customer sentiment and competitor feedback.
n8n$9.99Automate Weekly Google Analytics Insights with AI and Smart Email/Telegram Notifications
This workflow automates the extraction and analysis of Google Analytics data using AI, delivering insights via Gmail and Telegram. It ensures stakeholders receive positive updates while negative trends are promptly addressed.
n8n$9.99Automate Real-Time Stock Price Tracking with Yahoo Finance and Google Sheets
This workflow automates the process of tracking real-time stock prices by scraping data from Yahoo Finance and storing it in Google Sheets for analysis.
n8n$4.99Automate Amazon Book Data Extraction and Report Generation with Decodo Scraper
This workflow uses the Decodo Scraper API to extract Amazon book data, generate a purchase report, and distribute it via Google Docs and Slack. Ideal for creators, analysts, and marketing teams needing structured product insights.
n8n$14.99Automate Company Research and Lead Enrichment with AI and Google Sheets
Enhance your sales and marketing efforts by automating company research and lead enrichment using AI. This workflow extracts critical company data from the web and updates your Google Sheets, saving you time and effort.
n8n$14.99Automate Weekly Energy Reports with EnergiDataService, Email, and Google Drive
This workflow automates the retrieval, formatting, and distribution of energy consumption data into weekly reports via email and Google Drive.
n8n$9.99Beginner Data Analysis: Merge, Filter & Summarize in Google Sheets with GPT-4o
This beginner-friendly n8n workflow teaches essential data manipulation techniques using Google Sheets and AI. You'll learn how to: - Merge two datasets by a shared column (`Channel`) - Filter rows based on performance metrics (`Clicks`, `Spend`) - Branch logic into `Great` vs. `Poor` outcomes - Summarize results by team leader - Use an OpenAI-powered agent to generate a written analysis highlighting the best and worst performers Perfect for marketers, analysts, or anyone learning how to clean, transform, and interpret data inside n8n. Includes: - Sample Google Sheet to copy - Setup instructions for Google Sheets & OpenAI - AI summary powered by `GPT-4-mini` ### Questions or Feedback? Feel free to reach out - I'm happy to help! **Robert Breen** Founder, Ynteractive 📧 [robert@ynteractive.com](mailto:robert@ynteractive.com) 🔗 [YouTube: YnteractiveTraining](https://www.youtube.com/@ynteractivetraining) 🔗 [LinkedIn: linkedin.com/in/robertbreen](https://www.linkedin.com/in/robertbreen)
n8n$14.99Automate Glassdoor Job Searches with Bright Data and Google Sheets Integration
Streamline your job search process by automatically scraping Glassdoor job listings using Bright Data and storing the results in Google Sheets for easy analysis.
n8n$9.99Automate Web Scraping with Selenium and AI in n8n
Leverage Selenium and AI to automate data extraction from web pages, including those requiring login, using n8n. This workflow integrates session cookies and AI for advanced scraping capabilities.
n8n$19.99Automate Financial Data Visualization from Yahoo Finance to Telegram
This n8n workflow automates the process of scraping financial data from Yahoo Finance using Bright Data, visualizing market cap information, and delivering insights to Telegram. It streamlines financial analysis by integrating data collection, processing, and notification.
n8n$9.99Authenticate and Search Reddit Subreddits with OAuth2 in n8n
This workflow reliably searches Reddit subreddits using OAuth2 authentication to bypass request blocks, ensuring accurate data retrieval.
n8n$4.99
Related categories
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work