Automated Web Scraping: Email CSV, Save to Sheets & Excel

This workflow automates web scraping by fetching HTML content from a specified website, parsing it to extract relevant data (such as book details), and structuring it for export. The extracted information is aggregated, converted into a CSV file, attached to an email sent via Gmail, and uploaded to both Google Sheets and Microsoft Excel (via Microsoft Graph) in parallel. This ensures data is immediately actionable across multiple platforms without manual intervention.

Setup is straightforward: update the target URL in the 'Fetch website content' node, configure Google Cloud credentials for Drive, Sheets, and Gmail APIs, and set up Microsoft Azure credentials with Graph permissions for Excel integration. A manual trigger starts the process, making it ideal for on-demand scraping.

Benefits include significant time savings on data collection, reduced errors from manual copying, and centralized data storage for teams using different tools. Use cases span market research (e.g., scraping product prices or listings), competitive analysis, lead generation, and inventory tracking, empowering non-technical users to harness web data efficiently.