AutomationMart
Home/Browse/Automated web scraping: email a CSV, save to Google Sheets & Microsoft Excel
n8n

Automated web scraping: email a CSV, save to Google Sheets & Microsoft Excel

n8nn8n10 modulesv1.0
GmailGoogle SheetsGoogle Drive

How it works: The workflow starts by sending a request to a website to retrieve its HTML content. It then parses the HTML extracting the relevant information The extracted data is storted and converted into a CSV file. The CSV file is attached to an email and sent to your specified address. The data is simultaneously saved to both Google Sheets and Microsoft Excel for further analysis or use. Set-up steps: 1. Change the website to scrape in the "Fetch website content" node 2. Configure Micr

At a glance

Automated web scraping: email a CSV, save to Google Sheets & Microsoft Excel is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, Google Drive
Modules
10
Price
Free
Version
v1.0
Automated web scraping: email a CSV, save to Google Sheets & Microsoft Excel workflow diagram

About this workflow

How it works: The workflow starts by sending a request to a website to retrieve its HTML content. It then parses the HTML extracting the relevant information The extracted data is storted and converted into a CSV file. The CSV file is attached to an email and sent to your specified address. The data is simultaneously saved to both Google Sheets and Microsoft Excel for further analysis or use. Set-up steps: 1. Change the website to scrape in the "Fetch website content" node 2. Configure Microsoft Azure credentials with Microsoft Graph permissions (required for the Save to Microsoft Excel 365 node) 3. Configure Google Cloud credentials with access to Google Drive, Google Sheets and Gmail APIs (the latter is required for the Send CSV via e-mail node).

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Send automated email responses using GMAIL and ChatGPT assistant

Automatically respond to new Gmail messages using ChatGPT assistant with send personalized replies back through Google Email.

Free

Check what's trending in your niche on YouTube and gather creators and videos in one Google Sheet

Streamline your YouTube competitor research with this automated data collection template. Simply input your niche search or hashtag YouTube URLs and this automation will scrape trending videos using Apify's YouTube scraper, then organize all the essential data into a clean Google Sheets table. The template extracts key performance metrics including creator names, video titles, like counts, comment numbers, and direct video links - giving you a comprehensive overview of what's working in your spa

Free

Back up self-hosted workflows to Google Drive daily with change detection

This workflow creates a daily, automated backup of all workflows in a self-hosted n8n instance and stores them in Google Drive. Instead of exporting every workflow on every run, it uses content hashing to detect meaningful changes and only updates backups when a workflow has actually been modified. To keep Google Drive clean and predictable, the workflow intentionally deletes the existing backup file before uploading the updated version. This avoids duplicate files and ensures there

Free

🔐 Double opt-in email verification system with Google Sheets

This template implements a professional Double Opt-In email verification system using Google Sheets as a database. The workflow collects user emails, generates unique verification codes, stores them securely, and validates user access before proceeding with your main form. How it Works 1. User submits their email through an initial form 2. System generates a unique 6-digit verification code 3. Code is stored in Google Sheets along with user data 4. Verification email is sent to the user 5. User

Free

Create engaging Instagram posts from Google Sheets data using Perplexity AI, ChatGPT and Dropbox

Automatically transform Google Sheets data into engaging Instagram posts using OpenAI and Perplexity AI. The file first gets uploaded to Dropbox then to Instagram. Enhance your social media presence with AI-generated content and images.

Free

Automated customer feedback triage with Gemini, Jotform, Google Sheets & Gmail replies

Who’s it for Teams that collect product feedback with Jotform and want automated triage: instant alerts for urgent issues, knowledge-based replies to questions, and a clean backlog for suggestions. How it works / What it does New Jotform submissions are classified by Feedback Type (comments, questions, suggestions) and analyzed for sentiment. Angry or negative messages trigger a Telegram alert to your support channel. Questions are answered automatically using an agent that consults your intern

Free

Private secret santa assignment & notification system with Gmail & verification

Secret Santa (Amigo Invisible) Automation 🎁 This workflow fully automates a Secret Santa (Amic Invisible) event — perfect for friends, families, or office teams who want to make their gift exchange fun, fair, and completely private. It takes a simple list of participant names and emails, then automatically pairs everyone using a non-repeating random assignment system (derangement algorithm) — meaning no one is ever assigned to themselves and every participant both gives and receives a gift exact

Free

Document RAG & chat agent: Google Drive to Qdrant with Mistral OCR

Knowledge RAG & AI Chat Agent: Google Drive to Qdrant Description This workflow transforms a Google Drive folder into an intelligent, searchable knowledge base and provides a chat agent to query it. It’s composed of two distinct flows: - An ingestion pipeline to process documents. - A live chat agent that uses RAG (Retrieval-Augmented Generation) and optional web search to answer user questions. This system fully automates the creation of a “Chat with your

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free