How to get the response in a webpage through a search from a Google Spreadsheet

Question

I have a set of data in a Google spreadsheet. I wanted a webpage where multiple people can use. That webpage should have a search option(may be some keywords or particular headers etc) when the person search with that key word, the output in this webpage should show all the data with headers which has the keyword searched.

Answer 1

Using Google AppScript