Data Extraction is an important capability for saving time and effort in many online operations. AI technology now allows very advanced data extraction for all purposes. However, the services are not completely free for those who need to use it in an unlimited manner. If you ask Chat GPT to extract a large amount of data in a short period of time it will require you to get on a paid plan. If you use the GPT Google Sheets add-ons they give you a limited number of credits and then require you to purchase more. Therefore, having the ability to do some data extraction for the things you specifically need in an unlimited manner free of costs is still essential. Also, AI is not always able to extract certain data from websites. As a result I have continued to find ways to extract data directly into Google Sheets from both websites and text.
I created two functions for extracting data from websites or text into Google Sheets:
1) The main one is "Get Data" which is an add-on that must be manually added to each Google Sheet before use. It creates a menu that you can use to set columns for desired data extraction. It can only do what it has been specifically programmed to do (unlike AI). However, it is extensible meaning that it can be extended to do more without having to rewrite the library code. From a user perspective this means that it can be updated externally without your having to do anything.
Click here to learn more about "Get Data"
2) "Get Price" is another function I made before getdata specifically for extracting prices from online store listings. However, it is somewhat obsolete now that getdata does the same thing and is extensible.