Use Power Automate Desktop as a Web Scraper for Excel

Update existing Excel spreadsheet with information pulled from any webpage.
Instructions:
  1. Copy-paste Flow Actions to your Power Automate Desktop.
  2. Change C:\\PowerAutomate\\ExcelWorkbook.xlsx to your Excel spreadsheet document path.
  3. Run flow.

This flow is a slightly modified version of Joe Camp’s post on LinkedIn Power Automate Desktop as a Web Scraper.

Changes
  • 2022-01-06: Updated flow actions to work with Power Automate Desktop version 2.15.284.21354
[1]https://www.linkedin.com/pulse/power-automate-desktop-web-scraper-joe-camp/
PAG Admin
Flow Variables
Flow Datatypes
Also See These Flows
Flow Action
Find Text From Images Using Google Vision AI and OCR

This walkthrough shows all the steps it takes to analyze text from images with Optical Character Recognition (OCR) using Power Automate Desktop.

PAG Admin

696

Flow Action
Read Google Sheets API With Power Automate for Desktop

This example uses Invoke Web Service flow action to send a request to Google Sheets API, the response contains spreadsheet values.

PAG Admin

1,578

Flow Action
Basic Web Scraper Built With Power Automate for Desktop

A functional web scraper with complete flow actions. Showing how to scrape websites, traverse links and download content.

PAG Admin

3,945

Flow Action
Write to Google Sheets API Using OAuth 2.0 Power Automate for Desktop

Write cell values to spreadsheets. Includes basic logic for handling refresh tokens for repetitive tasks.

PAG Admin

2,886

Flow Action
Use Power Automate Desktop as a Web Scraper for Excel

Update existing Excel spreadsheet with information pulled from any webpage.

PAG Admin

882