A: 1. Yes you can use the AI with ranges.
2. You can also do this along with the auto completing
3. Never used that product, but it does seem like we have more scraping capabilities especially with the upcoming release of SheetGPT v1.3

Some of the cool new scraping functions coming this week in v1.3:
=getMetaTitle()
=getMetaDescription()
=getH1()
=getH2()
=getHeadings()
=pagedata(Multiple URLs) (this will get all the data above, along with the entire page data and automatically put it into a table so you can easily get all the data organized from a list of URLs)
=serp() (grabs the top 20 search results for a given query and outputs into a table with the URL, Meta title, and Meta description)

ALL of these functions are able to be used in an unlimited fashion in ANY of the tiers you buy SheetGPT. Almost no other software allows for unlimited usage like this.

None of the new functions mentioned above will use any AI credits from OpenAI either so it comes at zero additional cost to you.

Best,
Curran