I recently scraped lists into google sheets using primarily importxml and two importhtml's. I am interested in monitoring changes made on these lists - new entries to the list and exiters. I have read so many conflicting opinions on whether
- the google import functions will automatically repopulate the data in my sheets as changes occur on the websites and
- the best course of action to trigger updates (coding macros I have had no luck with, doing file --> settings --> calculation --> recalculation --> on change & every hour.
I already set up up email notifications if changes are made in the sheets. I understand the websites are likely updated a monthly basis, but its been two weeks and havent gotten a notification from one of the nine links involved. My plan to assess changes being made is to analyze the version history on the doc and compare the differences. Am I missing a step in triggering auto-updates?
I'd do this in excel but I do not have a recent version where these functions are available.
