AcademyWorkflowsData and reporting

Web Scraping to CSV, Google Sheets and Excel

Operations and analysis teams that need to collect data from a web page and share it in spreadsheets.

  • Recommendedour rating
  • 99,001views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

automated-web-scraping-email-a-csv-save-to-google-sheets-microsoft-excel.json

Loading the file...

What it does

An n8n workflow template that requests a web page, parses the HTML to extract the data you want and converts it to a CSV file. It emails the file as an attachment and saves the same data to Google Sheets and Microsoft Excel 365.

Use cases

  1. 01Collect listings from a web page on demand
  2. 02Email a CSV of scraped data to a colleague
  3. 03Keep a Google Sheet and an Excel file in sync

Connects

Google Sheets · HTTP Request · Microsoft Excel 365 · Gmail · HTML

Questions about
Web Scraping to CSV, Google Sheets and Excel.

What is Web Scraping to CSV, Google Sheets and Excel used for?

Operations and analysis teams that need to collect data from a web page and share it in spreadsheets. An n8n workflow template that requests a web page, parses the HTML to extract the data you want and converts it to a CSV file. It emails the file as an attachment and saves the same data to Google Sheets and Microsoft Excel 365.

How do I import Web Scraping to CSV, Google Sheets and Excel into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Web Scraping to CSV, Google Sheets and Excel safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.