I am very interested in this, but I have a few things I am unclear about:

1.) Can this go to a website, say amazon.com, and scrape data from there?
2.) Can it also crawl the website links, open popovers (for instance clicking a box that then pops out and then crawl the links that are inside there) and things like that and store data in excel like phonenumbers etc?
3.) am I right to understand that I can create my own APIs for pages and websites?
4.) Will I also have access to the code of this self developed API so I can deploy it in another application?
5.) Can I implement my own OpenAI or Gemini access? So if I trained my own LLM, can i use that in the sheet?
6.) Can it enhance any data on a sheet?
7.) Can this work with GEMs?