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
Open or Close an Application When Bluetooth Device Is Connected/Disconnected

This example opens and closes Spotify automatically when Bose NC 700 HP headphones are turned on/off. Discover how you can use Bluetooth as a trigger with Power Automate for Desktop. You can use any Bluetooth device and application.

PAG Admin

680

Flow Action
Create Animated Doughnut in Notepad

This example shows how to read JSON data, loop items and print output to screen (Notepad in this case).

PAG Admin

345

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
PowerToys for Power Automate for Desktop

These PowerToy shortcuts are made for Windows users for the purpose of make their computing lives better.

PAG Admin

920

Flow Action
Schedule Flows Using Power Automate for Desktop

Did you know that the free edition of Power Automate Desktop does not include flow scheduling? Use this template to schedule flows.

PAG Admin

10,892