Possible to pull data from a website to show count of unread faxes?

Kanger14

New Member
Joined
Jan 27, 2020
Messages
12
Office Version
  1. 365
Platform
  1. Windows
Hello, I am looking to see if it is possible to pull data into google sheets (or excel) directly from a website to show a live count of how many unread items there are.

This is for a business where we receive faxes through a system called SRFax.

My best guess for something like this would be somewhere in the websites coding where it shows this:

<tr id="row1" data-readkey="qR10b**T96zHnLsW8GnWlecL**2WgnNhLzhUN1B/xCOU**1ttMG5R7WlzoYNRULmXQPecJGe**OScQ1x1slpLX0xJakOmlNIMM6rCRmB5JsqASRh4aJZ/kWiOww=" class="data-row unreadLine">

I need to count how many items have that "unreadLine" value, and it would be over multiple pages (as each page only displays 100 faxes).


I'm unsure is this is even possible for google sheets, or for excel. Thank you for your assistance.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
This can (usually) be done, but websites can have code that makes it quite difficult. The technique is called Web Scraping (as in scrape not scrap). Google for 'Excel Web Scraping' and many sites are shown. This site Beginner’s guide to Web Scraping using Excel – ProWebScraper has a good walkthrough on the techniques for pulling data from a single page, but others will be needed to automate multi-page data retrieval.
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top