Searchable Web App with Data in Google Sheets

Description

We are looking for someone to assist to create a search function on our Google Sheets (preferably to a webpage). We have a database in which the data was entered from a Google Form by our employees on a daily basis. However, we want our clients to search for their own names and see the feedback without accessing other people's data. Ideally, we want to send the client a link and when they enter the link, they put in their first and last name, they will be able to see all the data entry related to their names.

Works with Apps

Google Sheets Google Forms Gmail Web App

From Ashton

Within this project, we utilized Google Forms as a means to gather user data, which was subsequently stored in Google Sheets. Furthermore, a lightweight web application was developed, leveraging the collected data to enable users to conduct searches. Additionally, the Gmail API played a crucial role in facilitating the delivery of notifications pertaining to the web application. It's noteworthy that this approach represents a typical free solution for web hosting, seamlessly integrated with Google Sheets and Google Apps Script. 

Hire Me on Upwork

From Client

5 stars with no feedback from the client.

Google Apps Script Projects Shared On YouTube

Links

Work with Me on Upwork YouTube Twitter / X Automate The Boring (Blog)