Client Search App with Google Sheets and Apps Script

Description

I need to extract a database of clients by their name or place of doing business. The database is on google sheets and is only about 150 lines long and about seven columns wide.

Deliverables:

• The table has to be within the parameters of the web page. (in the page that I attached, you can see that it looks bad because it goes beyond the border of the page)

• Text font are in standard San Serif and color Black

• It's important that it looks nice.

• As for the language, we will use Spanish.

- Search = Buscar

- Country = País

- Zone = Zona

- Select = Seleccionar

• To adapt to computer of cell phone

• Country should come as the first option, then Zone

I'm attaching several files.

This is the database from where the query will occur:

https://docs.google.com/spreadsheets/d/xxx/edit?usp=sharing

This is the page where I want my clients to search for the store.

https://xxx

The problem I had with the previous professional was:

• Some texts were in white

• Some fonts were not SanSerif

• The table was too big making the page look ugly

• I do not know the name of the store "Nombre de la tienda".

Works with Apps

Google Sheets Web App

From Ashton

In this project, we utilize Google Sheets as a compact database to develop a query-driven Web App using the powerful Google Apps Script. This approach aligns with the typical use case for free and lightweight web app hosting, allowing for seamless integration with your website through iframe embedding.

Hire Me on Upwork

From Client

Highly recommendable. Great communication, results and knowledge in his expertise.

Google Apps Script Projects Shared On YouTube

Links

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