Google Sheets workflow'ları
4.090 sonuç — 488 indirilebilir workflow dosyası, 3.602 kaynağa bağlı n8n referansı
WForm-Triggered Instagram Video Downloads to Google Drive with Sheets Logging
📥 Instagram to MP4 Converter with Google Drive Integration This n8n workflow enables users to convert Instagram video links into downloadable MP4 files, store them in Google Drive, and log the results (success or failure) in Google Sheets. 🔧 Node-by-Node Overview On form submission – Triggers when a user submits an Instagram video URL. Instagram Downloader API Request – Calls the Instagram Downloader API to retrieve a downloadable link for the video. If – Checks if the API response indicates success. MP4 Downloader – Downloads the video from the provided media URL. Upload To Google Drive – Uploads the MP4 video to a specified folder in Google Drive. Google Drive Set Permission – Sets the uploaded file to public with a sharable link. Google Sheets – Logs successful conversions, including the original URL and Drive link. Wait – Adds a pause before logging failure to avoid rapid writes to Google Sheets. Google Sheets Append Row – Logs failed attempts with Drive_URL marked as N/A. 🚀 Key Features 🔗 Uses the Instagram Downloader API to convert Instagram video URLs 🗂 Uploads MP4s directly to Google Drive 📊 Logs all actions in Google Sheets 🧠 Smart error handling using conditional a
WDownload Watermark-free TikTok Videos to Google Drive with Automated Sheets Logging
📥 TikTok to MP4 Converter with Google Drive & Sheets Convert TikTok videos to MP4 , MP3 (without watermark), upload to Google Drive, and log conversion attempts into Google Sheets automatically — powered by TikTok Download Audio Video API. 📝 Description This n8n automation accepts a TikTok video URL via a form, sends it to the TikTok Download Audio Video API, downloads the watermark-free MP4, uploads it to Google Drive, and logs the result (success/failure) into Google Sheets. 🧩 Node-by-Node Overview | # | Node | Functionality | |---|-------------------------------|-------------------------------------------------------------------------------| | 1 | 🟢 Form Trigger | Displays a form for user input of TikTok video URL. | | 2 | 🌐 TikTok RapidAPI Request | Calls the TikTok Downloader API to get the MP4 link. | | 3 | 🔍 If Condition | Checks if the API response status is "success". | | 4 | ⬇️ MP4 Downloader | Downloads the video file using the returned "no watermark" MP4 URL. | | 5 | ☁️ Upload to Google Drive | Uploads the video file to Google Drive root folder. | | 6 | 🔑 Set Google Drive Permission | Makes the file publicly shareable via link. | | 7 | 📄 Google Sheets (Success)
Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato
Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato Who is this for? This workflow is designed for content creators, marketers, and entrepreneurs who want to automate their video production and social media publishing process. If you regularly post promotional or viral-style content on platforms like TikTok, YouTube Shorts, Instagram Reels, LinkedIn, and more, this template will save you hours of manual work. What problem is this workflow solving? / Use case Creating viral short-form videos is often time-consuming: You need to generate visuals, write scripts, edit videos, and then manually upload them to multiple platforms. Staying consistent across TikTok, YouTube Shorts, Instagram Reels, LinkedIn, Twitter/X, and others requires constant effort. This workflow solves the problem by automating the entire pipeline from idea → video creation → multi-platform publishing. What this workflow does Collects an idea and image from Telegram. Enhances visuals with NanoBanana for user-generated content style. Generates a complete video script with AI (OpenAI + structured prompts). Creates the final video with VEO3 using your custom prompt and visuals. Rewrites captio
WScrape Jobs from Indeed, LinkedIn & More with RapidAPI to Google Sheets
Active Job Scraper Workflow Using RapidAPI Jobs Search Realtime Data API This powerful Active Job Scraper workflow uses the RapidAPI Jobs Search Realtime Data API to fetch real-time job listings from leading job boards like Indeed, LinkedIn, ZipRecruiter, and Glassdoor. Overview Leverage the Jobs Search Realtime Data API on RapidAPI to gather fresh job data from Indeed, LinkedIn, ZipRecruiter, and Glassdoor. This n8n workflow lets you: Search jobs by location, keywords, job type, and remote options across these major platforms. Collect detailed job information including descriptions and metadata. Automatically save the scraped results into Google Sheets for easy tracking and analysis. Why Choose This Workflow? By integrating the RapidAPI Jobs Search Realtime Data API, you can scrape job listings from the most popular job sites—Indeed, LinkedIn, ZipRecruiter, and Glassdoor—all in one place. Customize your search parameters and get results tailored to your needs. Workflow Components | Node | Description | |------------------|-----------------------------------------------------------------| | Form Trigger | Collects input such as location, search term, job type, and remote status. |
WCheck Domain Authority Metrics in Bulk and Log to Google Sheets with RapidAPI
🌐 Bulk Domain Authority (DA/PA) Checker And Google Sheet Logging Easily check Domain Authority (DA) and Page Authority (PA) for multiple domains using this automated n8n workflow powered by the Bulk DA PA Checker API on RapidAPI. Simply submit your domains via a web form, and the workflow fetches detailed SEO metrics and logs the data into Google Sheets. 🚀 What This Workflow Does This automation leverages the Bulk DA PA Checker API from RapidAPI to: Accept multiple domains via a user-friendly form Send bulk requests to the Bulk DA PA Checker API for fast SEO metric retrieval Process and reformat the API response for easy consumption Append the domain authority data directly into Google Sheets for tracking and analysis Perfect for SEO pros, marketers, and agencies looking to streamline their domain analysis with the power of RapidAPI. ⚙️ Workflow Highlights | 🧩 Node | 🔍 Description | |--------|----------------| | 📝 Form Trigger | User submits comma-separated domains through a simple form. | | 🌐 Check DA PA Bulk (RapidAPI) | Sends a POST request to the Bulk DA PA Checker API to fetch DA/PA and related SEO metrics. | | 🛠️ Re Format | Parses and extracts each domain’s data from
WAutomatically Collect Bug Bounty Tips from Twitter to Google Sheets
How it works Automatically monitors Twitter for bug bounty tips and educational content every 4 hours, then saves valuable insights to Google Sheets for easy reference and organization. Set up steps Get your API key from https://twitterapi.io/ (free tier available) Configure Google Sheets credentials in n8n Create a Google Sheet with the required columns Update the Sheet ID in the final node What you'll get A continuously updated database of bug bounty tips, techniques, and insights from the security community, perfectly organized in Google Sheets with: Tweet content and URLs Engagement metrics (likes, retweets, replies) Formatted timestamps for easy sorting Automatic duplicate prevention Perfect for security researchers, bug bounty hunters, and cybersecurity professionals who want to stay updated with the latest tips and techniques from Twitter's security community.
Extract Physician Orders from Documents to Google Sheets with VLM Run AI
Process Physician Orders into Google Sheets with VLM Run AI Extraction What this workflow does Monitors Google Drive for new physician order files in a target folder Downloads the file automatically inside n8n for processing Sends the file to VLM Run for AI transcription and structured data extraction Parses healthcare-specific details from the healthcare.physician-order domain as JSON Appends normalized attributes to a Google Sheet as a new row Setup Prerequisites: Google account, VLM Run API credentials, Google Sheets access, n8n. Install the verified VLM Run node from the n8n node list, then click Install. Once installed, you can integrate it directly in your workflow. Quick Setup: Create the Drive folder you want to watch and copy its Folder ID Create a Google Sheet with headers such as: timestamp, file_name, file_id, mime_type, size_bytes, uploader_email, patient_name, patient_dob, patient_gender, patient_address, patient_phone_no, physician_name, physician_phone_no, physician_email, referring_clinic, diagnosis, exam_date, form_signed_in, …other physician order fields as needed Configure Google Drive OAuth2 for the trigger and download nodes Add your VLM Run API credentials fr
Construction Blueprint to Google Sheets Automation with VLM Run and Google Drive
Automatically process Construction Blueprints into structured Google Sheets entries with VLM extraction What this workflow does Monitors Google Drive for new blueprints in a target folder Downloads the file inside n8n for processing Sends the file to VLM Run for VLM analysis Fetches details from the construction.blueprint domain as JSON Appends normalized fields to a Google Sheet as a new row Setup Prerequisites: Google account, VLM Run API credentials, Google Sheets access, n8n. Install the verified VLM Run node by searching for VLM Run in the node list, then click Install. Once installed, you can start using it in your workflows. Quick Setup: Create the Drive folder you want to watch and copy its Folder ID Create a Google Sheet with headers like: timestamp, file_name, file_id, mime_type, size_bytes, uploader_email, document_type, document_number, issue_date, author_name, drawing_title_numbers, revision_history, job_name, address, drawing_number, revision, drawn_by, checked_by, scale_information, agency_name, document_title, blueprint_id, blueprint_status, blueprint_owner, blueprint_url Configure Google Drive OAuth2 for the trigger and download nodes Add VLM Run API credentials fr
Automate Birthday Discount Emails for E-Commerce using Google Sheets and Gmail
⚙ How It Works & Setup Steps: Automated Birthday Discount How It Works This workflow is a powerful yet simple automation to delight your customers on their birthdays. It runs every day on a schedule you define and automatically pulls data from your customer list on Google Sheets. The workflow then checks to see if any customer has a birthday on the current day. If a match is found, it generates a unique discount code and sends a personalized, celebratory email with the code directly to the customer. This ensures no birthday is ever missed, fostering customer loyalty and driving sales with zero manual effort. Setup Steps Follow these steps to get the workflow running in your n8n instance and start sending automated birthday discounts. 1. Prerequisites You will need a working n8n instance and a few key accounts: Google Sheets:* To store your customer data, including their email address and birthday. The birthday column should be formatted as *MM-dd** (e.g., 08-27). Gmail:** To send the personalized birthday emails to your customers. 2. Workflow Import Import the provided workflow JSON into your n8n canvas. All the necessary nodes will appear on your canvas, ready for configuration. 3
WSEO Keyword Difficulty & SERP Analysis with RapidAPI and Google Sheets
🚀 Automated Keyword Difficulty & SERP Checker with Google Sheets Integration Description: This n8n workflow automates keyword SEO analysis by collecting user input via a form, querying the Difficulty Checker API on RapidAPI to retrieve keyword difficulty and SERP data, and storing the results in Google Sheets for further SEO tracking and decision-making. 🔗 Node-by-Node Breakdown 1. 📝 On form submission Triggers the workflow by capturing keyword and country from a user-submitted form. 2. 🌐 Keyword Difficulty Checker Makes a POST request to the Keyword Difficulty Checker API on RapidAPI to fetch keyword difficulty index and SERP results. 3. 📦 Reformat 1 Extracts only the keywordDifficulty value from the API response JSON. 4. 📊 Keyword Difficulty Checker1 Appends the keyword and its difficulty index to the "backlink overflow" Google Sheet for structured keyword tracking. 5. 📦 Reformat 2 Extracts the serpResults list from the API response for additional ranking data. 6. 📄 SERP Results Stores the extracted SERP data into the "backlinks" Google Sheet for ranking comparison and analysis. ✅ Benefits of This Workflow Automation of SEO research* — Eliminates manual keyword analysis b
WDownload Videos from Any Platform to Google Drive with RapidAPI Integration
🚀 All-In-One Video Downloader to Google Drive (via RapidAPI best All-In-One Video Downloader) Description: This n8n workflow automates the process of downloading videos from any supported platform (like LinkedIn, Facebook, or Instagram) using the RapidAPI best All-In-One Video Downloader. It then uploads the video to your Google Drive and shares it publicly, while logging any failures in Google Sheets for tracking. 📦 Node-by-Node Breakdown | 🧩 Node Name | 📝 One‑Line Explanation | |-------------------------------|-------------------------------------------------------------------------------| | On form submission | Triggers the workflow when a user submits a video URL through a web form. | | All in one video downloader | Sends a POST request to RapidAPI best All-In-One Video Downloader to fetch downloadable video links. | | If | Checks whether the API response includes an error and routes accordingly. | | Download mp4 | Downloads the video using the direct media URL received from the API. | | Upload To Google Drive | Uploads the MP4 file to a designated folder in your Google Drive. | | Google Drive Set Permission | Makes the uploaded file publicly shareable with a viewable link.
WAnalyze Competitor Keywords with RapidAPI and Google Sheets Reporting
🔍 Analyze Competitor Keywords with RapidAPI and Google Sheets Reporting 📄 Description This n8n workflow streamlines the process of analyzing SEO competitor keywords using the Competitor Keyword Analysis API on RapidAPI. It collects a website and country via form submission, calls the API to retrieve keyword metrics, reformats the response, and logs the results into Google Sheets — all automatically. It is ideal for SEO analysts, marketing teams, and agencies who need a hands-free solution for competitive keyword insights. 🧩 Node-by-Node Explanation 📝 On form submission (formTrigger) Starts the workflow when a user submits their website and country through a form. 🌐 Competitor Keyword Analysis (httpRequest) Sends a POST request to the Competitor Keyword Analysis API on RapidAPI with form input to fetch keyword data. 🔄 Reformat Code (code) Extracts the domainOrganicSearchKeywords array from the API response for structured processing. 📊 Google Sheets (googleSheets) Appends the cleaned keyword metrics into a Google Sheet for easy viewing and tracking. 🚀 Benefits of This Workflow ✅ Automates SEO research using the Competitor Keyword Analysis API. ✅ Eliminates manual data entry —
WTrack Website Traffic Data with SEMrush API and Google Sheets
🚀 Website Traffic Monitoring with SEMrush API and Google Sheets Integration Leverage the powerful SEMrush Website Traffic Checker API to automatically fetch detailed website traffic insights and log them into Google Sheets for real-time monitoring and reporting. This no-code n8n workflow simplifies traffic analysis for marketers, analysts, and website owners. ⚙️ Node-by-Node Workflow Breakdown 1. 🟢 On Form Submission Trigger:** The workflow is initiated when a user submits a website URL via a form. This serves as the input for further processing. Use Case:** When you want to track multiple websites and monitor their performance over time. 2. 🌐 Website Traffic Checker API Request:* The workflow makes a POST request to the *SEMrush Website Traffic Checker API** via RapidAPI using the website URL that was submitted. API Data:** The API returns detailed traffic insights, including: Visits Bounce rate Page views Sessions Traffic sources And more! 3. 🔄 Reformat Parsing:** The raw API response is parsed to extract the relevant data under trafficSummary. Data Structure:** The workflow creates a clean dataset of traffic data, making it easy to store in Google Sheets. 4. 📄 Google Sheets
Automate Sales Call Research and Follow-Ups with GPT-4, Tavily, Google Sheets
Description This n8n template automates prospect research and personalized follow-up writing right after a sales call is booked. It gathers company background, tech stack, and updates; suggests relevant solutions; and then drafts a handcrafted email, subject line, and SMS, all saved back into Google Sheets. Benefits Always show up to calls with prepared context. Ensure no follow-up slips through the cracks. Keep all notes, research, and outreach in a single system of record. Scale personalized outreach without losing the human touch. Use cases Prep for sales calls with richer prospect context. Save hours writing personal follow-ups. Keep sales records neatly in one shared sheet. Requirements Google Sheets with: Meeting Data → prospect info + enrichment fields Success Stories → testimonials (company, industry, results, solution used) Tavily API key OpenAI API key (GPT-4.1 or later recommended) n8n account with Google Sheets + LangChain enabled Google Sheets Template You’ll need two sheets inside one Google Spreadsheet: 1. Meeting Data (input + output) Columns: Name Email Company Website Job Title Meeting Date Company Overview (AI-filled) Tech Stack (AI-filled) Company Updates (AI-fi
WAutomate SEO Keyword Analysis with RapidAPI and Log to Google Sheets
Automated Keyword Analysis and Google Sheets Logging Automate keyword research with n8n and log essential SEO data like search volume, trends, competition, and keyword difficulty directly into Google Sheets. Simplify your SEO efforts with real-time insights. Node-by-Node Explanation 1. On form submission (Trigger) Purpose:** Triggers the workflow when a user submits the form with "country" and "keyword" as inputs. Explanation:** This node initiates the process by accepting user input from the form and passing it to the next node for analysis. 2. Keyword Analysis (HTTP Request) Purpose:** Sends a request to an external SEO API to analyze the provided keyword, fetching data like search volume, trends, and competition. Explanation:* This node calls the *Keyword Research Tool API** with the country and keyword inputs from the form, retrieving essential keyword data for further processing. 3. Re-format output (Code) Purpose:** Processes and reformats the API response into a structured format suitable for logging into Google Sheets. Explanation:** Extracts and organizes the keyword data (e.g., competition, CPC, search volume) into a format that can be easily mapped to Google Sheets colum
WAnalyze Website Backlinks with Top Backlink Checker API and Google Sheets Logging
Backlink Checker with Google Sheets Logging (Seo) Description: This workflow helps you analyze top backlinks using Semrush API and logs the results directly into Google Sheets for easy SEO tracking and reporting. It integrates the Top Backlink Checker API from RapidAPI, providing in-depth backlink analysis, and combines that with Google Sheets for efficient data storage and tracking. Node-by-Node Explanation: 1. On form submission Captures the website URL submitted by the user through a form. This node triggers the workflow when the form is filled with a website URL. The Top Backlink Checker API (via RapidAPI) is used to check backlinks after this step. 2. Check webTraffic Sends a request to the Top Backlink Checker API to gather traffic data for the submitted website. This includes important metrics like visits, bounce rate, and more, which will later be stored in Google Sheets for analysis. 3. Reformat output Extracts and re-formats the traffic data received from the Top Backlink Checker API. This node cleans and structures the raw data for easier processing, ensuring it is usable for later stages in the workflow. 4. Reformat Processes the backlink data received from the Top Back
WTrack Website Traffic with Semrush API and Log Results to Google Sheets
Automated Seo Website Traffic Checker with Google Sheets Logging (Seo) Description: This workflow uses the Website Traffic Checker Semrush API to analyze website traffic and performance. It collects data through a user-submitted website URL and stores the results in Google Sheets for easy access and reporting. Ideal for SEO analysis and data tracking. Node-by-Node Explanation: 1. On form submission Captures the website URL submitted by the user through a form. Triggers the workflow when a website URL is submitted via the form interface. 2. Check webTraffic Sends a request to the Website Traffic Checker Semrush API to gather traffic data for the submitted website. Uses the provided URL to fetch real-time traffic statistics using the Semrush API. 3. Re format output Extracts and reformats the raw traffic data from the API response. Cleans and structures the traffic data for easy readability and reporting. 4. Google Sheets Appends the formatted traffic data into a Google Sheet for storage and further analysis. Stores the data in a Google Sheets document for long-term tracking and analysis. Benefits of This Flow: Real-Time Data Collection:** Collects real-time website traffic data dire
WTrack YouTube Trends by Country and Language with RapidAPI & Google Sheets
📈 YouTube Trend Finder Workflow using n8n & RapidAPI Description: Easily discover trending YouTube videos by country and language using this automated n8n workflow. The flow leverages the YouTube Trend Finder API and logs insights to Google Sheets — ideal for content creators, marketers, and researchers. 🔗 Node-by-Node Explanation | Node Name | Type | Description | |-----------------------------|--------------------|-----------------------------------------------------------------------------| | 1. On form submission | Form Trigger | Captures user input for country and language through a web form. | | 2. Trend Finder API Request | HTTP Request | Sends a request to YouTube Trend Finder API with the form data. | | 3. Re format output | Code | Extracts and reshapes API response data like title, link, and tags. | | 4. Google Sheets | Google Sheets | Appends the trending video data into a structured spreadsheet. | 🎯 Use Cases 🔍 Content Research: Find top-trending videos in any region or language for idea inspiration. 📈 Marketing Intelligence: Track video trends to tailor your video marketing strategy. 📰 Trend Monitoring: Journalists and analysts can quickly surface viral video top
WDownload Facebook Videos to Google Drive with Automated Logging in Sheets
🚀 Facebook to MP4 Video Downloader – Fully Customizable Automated Workflow Easily convert Facebook videos into downloadable MP4 files using Facebook Video Downloader API. This n8n workflow automates fetching videos, downloading them, uploading them to Google Drive, and logging results in Google Sheets. Users can modify and extend this flow according to their own needs (e.g., add email notifications, change storage location, or use another API). 📝 Node-by-Node Explanation On form submission → Triggers when a user submits a Facebook video URL via the form. (You can customize this form to include email or multiple URLs.) Facebook RapidAPI Request → Sends a POST request to Facebook Video Downloader API to fetch downloadable MP4 links. (Easily replace or update API parameters as needed.) If Node → Checks API response for errors before proceeding. (You can add more conditions to handle custom error scenarios.) MP4 Downloader → Downloads the Facebook video file from the received media URL. (You can change download settings, add quality filters, or store multiple resolutions.) Upload to Google Drive → Uploads the downloaded MP4 file to a Google Drive folder. (Easily switch to Dropbox, S3
Automated Company Research & Lead Enrichment with GPT-4o and Google Sheets
Supercharge your sales and marketing with this AI-powered workflow! 🚀 Stop wasting hours on manual company research. This template deploys an autonomous AI agent that takes a list of company names from a Google Sheet, scours the web to find critical information, and automatically updates your sheet with the enriched data. What it does: Reads a list of companies to research from a Google Sheet. Uses an AI agent equipped with Google Search and web scraping tools. Extracts key data points like LinkedIn URLs, pricing details, integrations, market focus (B2B/B2C), and more. Structures the output into a clean JSON object. Updates the original Google Sheet with the new information. Key Features & Customization: This workflow is built to be easily customized. You can modify the AI's prompt in the "AI company researcher" node and adjust the "Structured Output Parser" to gather any public data point you need, such as recent news, key executives, or their technology stack. Required Credentials: OpenAI Google Sheets SerpApi or ScrapingBee for search capabilities
WValidate & Enrich Phone Numbers in Google Sheets with RapidAPI
📞 Phone Number Validator with Google Sheets Validate and enrich phone numbers from Google Sheets using the phone number validator API. 📌 Use Case: Contact Validation & Enrichment Automatically check if phone numbers are valid and enrich them with metadata (country, location, timezone). Ideal for CRMs, lead management, and contact cleanup workflows. 🗂️ Google Sheets Columns | Column Name | Description | |-------------|-------------| | phone | The original phone number to validate (input column). | | is_valid | Result from API indicating if the phone number is valid (true / false). | | country | Country where the phone number is registered (e.g. "US"). | | location | More specific location info, such as city or region. | | timezone | The primary timezone associated with the phone number. | 🎯 Benefits ✅ Accurate Contact Data – Identify invalid or fake phone numbers automatically. 🌐 Geolocation Enrichment – Add country, location, and timezone for better segmentation. 🔁 Full Automation – No manual lookups or copying data between tools. 📊 Live Google Sheets Sync – Enriched data is updated directly into your spreadsheet. 🧠 Workflow Nodes Explained | Node | Purpose | |------|------
Social Media Sentiment Analysis Dashboard with Custom AI for Twitter, Reddit & LinkedIn
Social Media Sentiment Analysis Dashboard with AI and Real-time Monitoring 🎯 Target Audience Social media managers and community managers Marketing teams monitoring brand reputation PR professionals tracking public sentiment Customer service teams identifying trending issues Business analysts measuring social media ROI Brand managers protecting brand reputation Product managers gathering user feedback 🚀 Problem Statement Manual social media monitoring is overwhelming and often misses critical sentiment shifts or trending topics. This template solves the challenge of automatically collecting, analyzing, and visualizing social media sentiment data across multiple platforms to provide actionable insights for brand management and customer engagement. 🔧 How it Works This workflow automatically monitors social media platforms using AI-powered sentiment analysis, processes mentions and conversations, and provides real-time insights through a comprehensive dashboard. Key Components Scheduled Trigger - Runs the workflow at specified intervals to maintain real-time monitoring AI-Powered Sentiment Analysis - Uses advanced NLP to analyze sentiment, emotions, and topics Multi-Platform Integr
W
Real-Time Security Threat Dashboard with Google Sheets, AI Risk Analysis & Email Alerts
👤 Who it’s for Blue Team leads, CISOs, and SOC managers who want automated visibility into threat metrics, endpoint alerts, and response actions — without needing a full SIEM or BI platform. Great for teams using Modules 1–5 and now ready to report, review, or share BlueOps data across stakeholders. ⚙️ How it works / What it does Fetches threat + response data from up to 5 Google Sheets Aggregates data into four key slices: summary_metrics: Total threats, actions, endpoints daily_trends: Time-based charting top_assets: High-risk endpoints or systems actions_taken: Logged IR activity Generates a clean HTML report and sends via email Logs report summary to a central reporting tracker sheet Optionally converts and stores PDF versions or links 🛠️ How to set up Google Sheets: Connect your live sheets from previous BlueOps modules (M1–M5) Email Setup: Insert sender credentials and recipient(s) Customize Your Charts: Edit the “📈 Format Charts” and “📋 Structure Report Body” nodes Trigger Options: Run weekly, monthly, or on-demand via Webhook/Cron Add PDF Generator (Optional): Use Puppeteer, HTML → PDF services, or internal scripts 📋 Requirements Google account with access to all BlueO
Automate News Article Scraping with ScrapegraphAI and Store in Google Sheets
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. News Article Scraping and Analysis with AI and Google Sheets Integration 🎯 Target Audience News aggregators and content curators Media monitoring professionals Market researchers tracking industry news PR professionals monitoring brand mentions Journalists and content creators Business analysts tracking competitor news Academic researchers collecting news data 🚀 Problem Statement Manual news monitoring is time-consuming and often misses important articles. This template solves the challenge of automatically collecting, structuring, and storing news articles from any website for comprehensive analysis and tracking. 🔧 How it Works This workflow automatically scrapes news articles from websites using AI-powered extraction and stores them in Google Sheets for analysis and tracking. Key Components Scheduled Trigger**: Runs automatically at specified intervals to collect fresh content AI-Powered Scraping**: Uses ScrapeGraphAI to intelligently extract article titles, URLs, and categories from any news website Data Processing**: Formats extracted data for optimal spreadsheet compatibilit