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
Visit Web Pages Found With Duckduckgo

Run DuckDuckGo in Chrome and visit first three links. Create a variable for CSS selectors to be able to click different links using an incremental loop counter.

PAG Admin

263

Flow Action
Making Microsoft Dataverse OAuth 2.0 Queries Using PAD

This example shows how to retrieve top 3 accounts from your Dataverse / Dynamics 365 environment using Power Automate Desktop.

PAG Admin

1,681

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
Using Bootstrap 5 Components With JavaScript

Code snippets to help building web page automation with JavaScript.

PAG Admin

365

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