Another bounty from me (I will actually pay you for a solution). I am looking to integrate side-wide AJAX search on my site and want to have an option to save the search queries people type in and send them over to another google spreadsheets (or somewhere else I can easily view them).
My main bottleneck so far is that I pull my data from Google Spreadsheets (I use ‘middleman-spreadsheet’ gem for that), not like normally you would pull from
data directory so generating the index and map will be a bit different from the example included on the Github (see link below).
So there are 2 parts of this project:
part a) use external Google spreadsheet as a database, allow the user to input the search query and find related posts **based on the generated
JSON file with the snapshot of google spreadsheet data. I don’t mean the search function to work purely based on google spreadsheet. Google spreadsheet it’s just a database where I keep data but then we still need to have JSON snapshot that is generated by running
part b) create a function where each new search query will be submitted to another spreadsheet (spreadsheet different from the one with data under part 1).
Here is the demo of what exactly I want to achieve (so when you type, it automatically crawls through the content and find related items):
Here is the gem they are using: