Automated Web Scraping: email a CSV, save to Google Sheets & Microsoft Excel

n8n template #2275

Summary

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 latt

How to set it up

Open template #2275 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create 3 credentials under Credentials → Add credential: Google Sheets, Microsoft Excel 365, Gmail. Then open each of those nodes and pick the credential.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Automated Web Scraping: email a CSV, save to Google Sheets & Microsoft Excel" (https://n8n.io/workflows/2275). It uses: Google Sheets, HTTP Request, Microsoft Excel 365, Gmail, HTML. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Google Sheets HTTP RequestMicrosoft Excel 365Gmail HTML

Questions

Yes. Mihai Farcas published it free on n8n.io as a verified creator, and it has 99K views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Sheets, Microsoft Excel 365, Gmail. The other 2 nodes are built into n8n.

Similar workflows

NameViews