'Spreadsheet Formula Auto Re-Enter (Live Web-Scraping)
I wanted to web-scrape some "live information" from another website on my website. I "scraped" the data to my Google Spreadsheet. Problem: My Google Spreadsheet data won't update until I re-enter the formula "=importXML(B175,"//tr")" -> B175 is the URL and "//tr" is what I am scraping.
The website where I get the data updates like every minute but my spreadsheet won't. Is there a way to automate (Google Script) my Spreadsheet so it re-enters the formula or is there a general better way to do this? I am not an expert
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|