With Glide and Google Spreadsheets, this is how you can build a mobile app in just FIVE minutes
Using Spreadsheets to build a web application is now very easy with the help of Google Sheet and Glide – Do you want to design it for your own in just 5 minutes? Keep reading…
Martin N. Gregersen
23 June, 2020
Everyone uses Spreadsheets for their business. Spreadsheets vary in complexity. Their primary business purpose is to organize and categorize data into a logical format. Also, web apps are now the next step in handling data in the modern business environment. Both are highly important for smooth business functioning. However, think about amalgamating both! Did you know that you can easily create a web app with the help of your Google Sheet for FREE?
Creating a Web App with Glide and Google Sheets
You can add, edit and delete Spreadsheet data with Glide instantly to create a web application based on useful app templates. We just have to select one Google Sheet and Glide will immediately convert our inserted information in Google Sheet into an app that can be easily customized, shared and published in just 5 minutes.
How is Glide used?
It is very simple and easy to build a customized application with no coding involved. As a matter of fact, Glide doesn’t take more than 5 minutes to develop and then you can easily customize the features.
Google Sheet and Glide will immediately convert inserted information in Google Sheet into an app
Do you want to learn how it works? Follow these steps:
1. Go to the Glide Website
(Image Source: Glide)
2. Click on Create Button to Sign-In with your Google Account
3. Click on New Application and Search for the Google Sheet
4. Choose a Template and Wait For the New App Created by Glide for You
Process of Building A web application for FREE with Glide
1. Ideation Stage
This stage can be considered as the idea and planning when you need to decide which kinds of an application you want to design. Let’s suppose – you need to build an event organizing app, for this, you need to consider the following things:
Overview of event info and details
- Ticket type, pricing and payment mode
- Speakers Lineup, Profile and Destination
- Event Schedule
- List of FAQs
- CC Support
2. Go to the Glide Website (Getting Started)
Go to Glide website and create a free account, it can be possible by selecting one Google Sheet and creating a new virtual web database for your event based application. Once you login through an authenticated google account, you will follow these steps:
- Create a new application in Glide after logging in with your Google account
- Select a new spread file where you will see the app UI with the outcome result data linked with the Spreadsheet
(Image Source: Medium)
You can optimize your Spreadsheet with the help of Glide. To do so, simply choose a particular Spreadsheet and edit it, and Glide will update the data in your web app. You can create new app pages with the help of new sheets in the same file.
Each sheet can contain a database as a formula bracket to create a new page of your event application.
- About page
- Event info page
- Speaker Page
- FAQs page
- Event Schedule Page
- Ticket and Payment page
(Image Source: Medium)
Create App Pages
Creating new application pages need different Google sheets as per the number of pages required like – about page, schedule page, info page, ticket payment page etc. Through Glide you need to create a link for each page and sync them out to the relevant sheet and database (given in step 3). Make sure, you do not forget to refresh the database you created earlier; it helps you to “reload sheet” in Glide.
How to add tabs in Glide?
- Go to “Tabs” on the left sidebar in Glide
- Add the new tab button (or rename) , e.g. “About”
- Link the data “Source” related to the “About” Sheet
The same page can be cloned to produce new pages such as Schedule page, Event info page etc.
(Image Source: Glide)
Create and Customize Application Details
Displaying and customizing details is another step you have to do after building your pages for your application. Cover page, event details pages tiles, descriptions and other infos are needed to be displayed. After creating event descriptions, you need to decide and build the CTA buttons. Creating CTA buttons helps to direct the user on particular a page you want them to go and explore.
For this purpose, go to the left side bar of the Glide, click on the “Layout” button for customizing the screen layout of your application. Then select the “Detail” mode to customize the layout description to add new components e.g. Image, Title, Basic Text, Button, Separator, Title, Rich Text (and other elements you see fit). Each component represents the design blocks with a description which you link them with a database created in step 3.
For an instance, in order to create a team, go to the left side in Glide and select the team layout created earlier, write the description and select image layouts then create a link to attach them with the database created earlier.
(Image Source: Glide)
After continuing with the About page and creating similar other pages as you required for your application, now last but not least you need to manage and customize your info and description. For example, in this application, event managers need to create tickets, so the application needs to show different ticket orders, payment modes, services etc. Now, follow a few logical steps to create clicks on required buttons:
- Go to Glide where you can search for required buttons as per your page requirement
- For Instance, if you are creating an event application then you should create a purchase ticket page, where you can create a ‘purchase’ button for visitors where they can click on it to buy the event ticket
- A click on the purchase button will redirect the users to the payment page. Here, you can edit the CTA button features and link it to the screen you want them to visit. For example, on clicking a ‘purchase’ button, users can be redirected to the confirmation page first and then payment page
“List relation” needs to be Linked with Specific Topic Database
Each Session or topic should correspond to the speakers/guests who will be in the event. As you are creating an event application, you need to show the data who will be the speakers and guests in the events. Create a list and link them to the specific database as you have created for About, Info, Services and other different pages to reuse the database
- Go to the “Data” Icon given on the left side of the Glide taskbar
- Select the “Schedule” tab in the database
- Add different column from the top to the right corner and edit the whole settings
Give It A Try:
Glide is an easy and flexible service for creating a web application free of cost. After using it, you will be surprised to see how easily it works for you. A great thing about Glide is its two-way authenticated connection with the application andGoogle Sheet. Once you put all information regarding the application you want to build, the app syncs with Glide and gets updated from your Google sheet. So, you don’t need to worry about updating it manually, it synchronizes the app automatically with your Spreadsheet. This means edits and changes made in Google Sheet will directly update your app quickly without any requirement of republishing it again.
Whether you want to turn an idea into a business, boost your sales, automate routine business processes or scale your business – we make it simple. Book Automation Audit Today to Get Started!
mr noe is on a mission to uplift humanity and align with equally purpose-driven entrepreneurs by implementing automation strategies. We build automation systems that replace processes that require neither human empathy nor intelligence.
Q. Why should I convert my excel sheet into a web app?
Spreadsheets usually contain your company’s valuable data and when attached to emails, can be sent to unauthorized people purposely or accidentally. Therefore, converting excel Spreadsheets into a web application would be a great and secure solution.
Q. Will I get notifications from my web app if it is created from Spreadsheet?
You can customize these excel applications in such a way so that you get an email notification every time the data gets modified or any other change is made.
Q. Can this excel web application be useful for solopreneur and small businesses?
Yes, they are! The excel web applications can be used to track expenses, sales figures, client contact information, time records, sales commissions, etc.