I want to extract data on an online HTML based site from data saved in Google Drive. Below is link of the file: https://docs.google.com/spreadsheets/d/1N9xUkG435rjiNn80Oe63JzwGPQvodRNh/edit#gid=987223181
I want data with heading as follows:
Name | Codes | Code1 | Brn name | Address | CONTACT | CITY | DISTRICT | STATE
Search can be done with any of the columns content or mix of them.
I am having an excel sheet saved on google spreadsheet can be accessed with above link.
I am creating a single page html file in which any one can find the data which is written in excel file via Input box in html page then click on search button.
Results with the data matched will be shown in table below input button.
Actually I want to create a search box with button in blogger page that can initiate a query which can retrieve record based on search criteria from my Google spreadsheet and display that record on page. But I don't know how to connect blogger to Google spreadsheet. I can embed it but that will display all the records instead of based on criteria. Any help would be great.