[ad_1]
I have a WordPress website and want to create an inquiry page on my website that when people enter an ID on the inquiry page of my website, WordPress should search the specific data from a google sheet. Is this feasible? if yes, how should I implement it?
Thanks!
[ad_2]
It’s possible, but you’ll need a developer to write the code for you.
It is possible. I’ve done this for two clients.
You’ll have to use google appscript to implement this (it’s pretty much javascript). Shouldn’t take more than an hour or two if you know javascript.
Another alternative is to use something like Zapier, that when it detects a row is added or updated fires off a webhook to you site to add/update a record in a regular database for the site to use. (myself, unless there is a ton of data in the spreadsheet being updated very often, this is the way I would go)
I believe both the Sheets and Webhooks tie ins are available on their free tier. The only issue would be it would only check the sheet for updated every 15 minutes, so if that is a concern then you may have to look otherwise.
[https://sheetdb.io/])
See how to use it: [https://www.youtube.com/watch?v=wwq4lqA1fxE])