Automated web scraping: email a CSV, save to Google Sheets & Microsoft Excel
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Split Out
n8n-nodes-base.splitOut - Convert to File
n8n-nodes-base.convertToFile - HTML
n8n-nodes-base.html - Sort
n8n-nodes-base.sort - Google Sheets
n8n-nodes-base.googleSheets - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Gmail
n8n-nodes-base.gmail - HTTP Request
n8n-nodes-base.httpRequest
What it does
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).