Google Spreadsheet and JavaScript in WordPress?

Question

JavaScript

Hello. There is a website, it has only one page - https://dr-weedy.online/ , there is a table - https://docs.google.com/spreadsheets/d/1LlrsWpwBpq... , I need the page to have text field and button, and when this button is pressed, if, for example, in the second column there is what is written in the text field, display the entire line, and if there are no matches, then redirect to the link, please tell me how to implement this?
Everything, for now, was enough for me, unfortunately, this is all new to me, I’ve been sitting for 3 days and I can’t solve this difficult task for me, because I’m more into console and Windows applications, but the situation forced me to plunge quite strongly into the web , I will be grateful

The beginning of the idea is this: read the word from the input and find it in a certain column of the table (the Google table changes constantly) and give the site an array with the corresponding row values

Answer 1

It's better to write in PHP