📊 Automated web scraping: email a CSV, save to Google Sheets & Microsoft Excel
⚡ 125,530 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
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:
- Change the website to scrape in the “Fetch website content” node
- Configure Microsoft Azure credentials with Microsoft Graph permissions (required for the Save to Microsoft Excel 365 node)
- 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).
🔗 Nodes Used
Google Sheets, HTTP Request, Microsoft Excel 365, Gmail, Convert to File
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File