Wouldn’t be a big deal. if you wouldn’t add your additional wish with the Google-Sheets.
Without your additional wish, it would be an ordinary - - → SERCH-ENGINE.
But also an ordinary SEARCH-ENGINE can get complicated ![]()
Take a look here…
A parallel running post, very similar to your needs.
You can used it for your purposes.
Of course you will have to modify and expand this simple example code, to generate what you need.
And about your additional wish…you can start your learning-journey here…
Surely there are also other ways of how to do that.