Managing your sheet
Once a sheet holds several scrapes, the "This sheet" tab gives you a single place to review them and refresh their data.
Reviewing every scrape
To review every scrape in the spreadsheet, open the "This sheet" tab. WebToSheets lists each scrape and marks it ok, error, or empty, with a count at the top. A broken scrape is easy to spot, and clicking its row jumps you straight to the cell.
Refreshing your data
Your data refreshes in three situations:
- When you reopen the spreadsheet. Google Sheets recalculates the formulas, so your scrapes run again on their own and you rarely need to refresh by hand.
- When you click Refresh all. This re-runs every scrape in the sheet on demand.
- When you click Refresh errors. This re-runs only the scrapes that failed (after you ran out of credits, say, or while a site was briefly down), so you do not pay to redo the ones that already worked.
Refreshing versus the cache
Remember that results are cached for 15 minutes, so a refresh within that window hands back the cached values instantly and costs you no credit. When you genuinely need live data, you should clear the cache first, then refresh.Forcing a live re-fetch
Occasionally a page changes, yet refreshing keeps handing you the same numbers. That is the 15-minute cache at work. Clear cache throws out your saved results, so the next run fetches the page live again.
Still stuck?
We usually reply within 24 hours on business days.