Automatically update Google Sheets from a website

First ask for the data, and BrowseWiz writes it into a new Google Sheet. Right after that run, it offers Update this sheet daily. Click it, or say exactly what you want:

Click the suggestion, and BrowseWiz asks what time to run and whether to update the rows or add new ones. Either way, it replies with a plan that shows the schedule, so you can check it before you approve. The first run happens at the next scheduled time.

Each morning's run adds a dated row, so the sheet builds into a log you can chart or total. To keep one row per item instead, ask BrowseWiz to update the rows in place.

1. 1

   Describe the data

   Ask for what you need, such as a table on a public page or yesterday's numbers from your store's admin. Approve the plan, then grant tab access and sign in to Google once when asked. BrowseWiz opens the pages in the BrowseWiz Tabs group, including sites you're signed into, and writes the rows into a new Google Sheet, with a source link per row if you ask.

2. 2

   Ask for a schedule and approve it

   Click Update this sheet daily after the first run, or ask for any schedule: daily at a set time, on set weekdays, or hourly on Pro and Max. The task then sits in the scheduled tasks drawer, where you can run it now or delete it.

3. 3

   Each run updates the sheet

   BrowseWiz checks the pages again and updates each row, or adds dated rows for a log. Each run is saved in History.

4. 4

   You get a notification

   Finished with the run time, or Failed with the reason, even with the side panel closed. Click it to open the run.

A task can also rewrite the same rows on every run. In this example price sheet, a Monday task wrote each new price beside the one it replaced, then sent an alert when it finished. Ask for a Previous column and a Last checked time in your request.

Each can pull live website data into Google Sheets on a schedule, and none is live to the second. They differ in which pages they can read and how much you build.

• Always-on runs. Runs happen only while your computer is on and Chrome is open, never 24/7 in the cloud.
• Existing spreadsheets. BrowseWiz can't refresh a sheet you already have. It creates the sheet in your Google Drive the first time you ask, and each run updates that one. To show the rows in another workbook, use IMPORTRANGE ^{Source 16}.
• Your formulas. An update rewrites the whole row, so keep your own formulas on another tab.
• Speed. Hourly is the fastest schedule. Monitors check a page about every 5 minutes, and nothing is faster.
• AI reading. Two runs may format a value differently. Ask for a source link per row, so you can check any value.
• Scale. It isn't built for volume scraping: thousands of URLs, proxies or captchas.
• Site terms. You're responsible for following each site's terms of use.

Every plan, Free included, can write to Google Sheets on a schedule. The credits a run uses depend on how much page text it reads.

• Free

  $0 / month

  • 1 scheduled task, up to once a day
  • 1 page monitor
  • 10M credits a month

• Pro

  $29 / month

  • Up to 10 scheduled tasks, as often as hourly
  • Up to 30 page monitors
  • 250M credits a month

• Max

  $79 / month

  • Up to 10 scheduled tasks, as often as hourly
  • Up to 30 page monitors
  • 1B credits a month

Prices exclude VAT. See how credits are counted.