Google Spreadsheets on WordPress and how to implement search?

Question

WordPress

Hello, such a task has appeared before me, since I am a beginner, do not throw slippers, let's start:
I need to make an Input and a button on a site that is on the WordPress platform on the page (this is the only thing I can do from what I need next), then somehow search this query in Google Spreadsheet by column, and if it finds this query in the column, it displays the entire row on the site. Please describe the steps in as much detail as possible, because I don’t know how, for example, and where to shove php-files, js-files to process some actions. I would be most grateful for any help.

Answer 1

https://spark.ru/user/77099/blog/45653/google-tablit...
https://habr.com/ru/post/432740/
should help.
google google spreadsheet as a database. if it doesn't work out, we'll break apart together