Make sure to check out the MCP server that's now exposed to bring the Kapa docs tool into other AI tools of your choice. I've found that it greatly improves what ChatGPT can do. Unfortunately Gemini within Google Sheets doesn't yet make it possible to connect to add tools but hopefully it's coming.
We've been experimenting with some of these kinds of ideas but don't have anything polished enough to share yet.