Recipes

Hello! I am trying to see if WordPress is capable of doing an idea that I have, so figured I’d ask here to see if anyone had suggestions or advice on a direction. Here’s my scenario:

I have a gaming website and in the game, someone can make certain items of they’ve learned the recipe. I also have a Google Sheet that lists ALL of the items in the game as well as who can make what item.

Is there some sort of way to integrate the Google Sheet on the backend and tie it to a dropdown option on the front end(the wordpress site) where if someone selects “Chair” on frontend, a text table will “VLOOKUP” the Chair value on the spreadsheet and return the text value in another section that shows WHO can make that Chair? Let’s say for example, column A is the item and column B is the list of what players can make said item.

Right off the bat, I think of using a small database with a SELECT statement to return the value of “Chair” but I feel like there are much easier options… thanks in advance for helping stir my creative juices!