Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

AppSheet Masterclass - Complete Guide to Google AppSheet

Name: AppSheet Masterclass - Complete Guide to Google AppSheet
Rating: 4.6 (1870 reviews)

Create no-code business apps and solutions with AppSheet | Google AppSheet training guide | Build AppSheet applications

Created byHenry Habib

Last updated 4/2025

English

English [Auto],Spanish [Auto],

What you'll learn

Build full business applications and solutions with AppSheet
Learn the basic principles of how AppSheet works, including how to create apps and connect data sources to them
Create and customize apps using AppSheet's drag-and-drop interface, with custom views and styles
Learn how to add procedures to your apps and streamlines your workflows with AppSheet actions and automations

Course content

11 sections • 47 lectures • 4h 17m total length

AppSheet introduction8:44
Course tips0:44
AppSheet components6:10
Course roadmap3:18
Explore the AppSheet course roadmap, from quick environment setup to building, deployment, and mastering core building blocks like data, views, actions, and automation.
Instructor overview1:05
Ways to reach out1:48
Keys to success to learn AppSheet2:17
Practice alongside the instructor, mimic steps in your platform, and explore beyond the lesson to master AppSheet through guided experiential learning and active Q&A.
Leave a rating0:48
Rate this course, leave feedback, and engage in the discussion to help the instructor improve, ask questions, and message for support while enjoying the learning experience.
Watch in 1080p0:50

Reference material2:21
Set up the AppSheet environment quickly by creating or signing into a Google account, logging into Google Drive, and granting AppSheet the necessary permissions to access your data storage.
Environment setup for AppSheet1:36
Download and open the reference material zip to access the mock data, including customers and sales Excel files, then follow along as we set up the AppSheet environment.

Load the data into AppSheet2:38
Create your first AppSheet app by preparing cloud data in a Google sheet or SQL database, then import mock customer data and load it into the app.
Create the AppSheet app6:35
Create a Google Sheets-backed AppSheet app for a car garage to manage customer data. Add, view, edit, and delete records while exploring data, views, actions, and automations.
Go through the AppSheet development environment10:31
Explore the AppSheet development environment, previewing live apps on phone and laptop, switching between legacy and improved editors, and configuring data, views, actions, automations, and deployment.
Errors in previous video0:50
Clarifies that the bottom right section is for simulating how different users—friends, coworkers, managers, and subordinates—view the app, not for emailing test applications.
Deploy and share the AppSheet app3:41
Deploy and test your AppSheet app, then share it via browser and install links, and optionally publish to app stores with the paid core plan while managing access.

Data and columns in AppSheet14:38
Saving changes0:48
Always save after schema changes, then refresh the application to propagate updates. Not saving hides the updated display name, such as customer ID.
Editing data properties and types8:07
Modify data properties and types in AppSheet by setting human readable display names, turning fields into enums and dropdowns, and using enum lists and color types for robust validation.
Data validation14:22
Learn to implement data validation in AppSheet by setting column-level rules, using dynamic year checks, and displaying clear error messages that propagate to the app front end.
Adding virtual columns in AppSheet7:54
Adding datasets5:00
Add a new dataset from Google Sheets to the AppSheet project, import data, rename it car sales, and define fields like sale id and date to enable relationships with customers.
Adding a new view for a dataset3:20
Create a new sales view for the car sales dataset, format the sale amount with currency and display names, and set up a reference to connect sales to customers.
References and relationships in AppSheets9:17
Learn to create references in AppSheet to connect car customers and car sales, define many-to-one relationships, and use labels and virtual columns for rich lookups.

View introduction7:11
View property configuration 111:27
Configure a view in AppSheet by renaming the list, filtering with slices, choosing a deck/table/gallery/card view, and composing a primary header with a secondary header using a virtual column.
View property configuration 25:42
Slices of data in AppSheet5:35
Aggregate values in AppSheet5:35
View configurations on Detail screen7:53
Explore detail view configurations in AppSheet, including header columns, card details, and sum of sales; customize column order, quick edit, display styles, max nested rows, and slideshow mode.
View configurations on Form screen5:42
Configure form views in AppSheet by choosing page style, arranging column order, filtering visible fields, and enabling autosave to streamline editing and adding records.
Charts in AppSheet5:29
Discover how charts in AppSheet act as views to visualize data, showing sum of sales by country or gender and guiding users through a filtered list of data.
Dashboards in AppSheet8:57
Create interactive dashboards in AppSheet that combine multiple views—charts, lists, and details—into one page, enabling interactivity, filtering, and cascading lists for quick insights.

Actions and emails in AppSheet9:11
Learn how AppSheet actions automate navigation, data changes, and external communications, and build custom actions like emailing personalized coupons to customers with subject, body, and records-based data.
Open up a new form6:25
Populate new forms with values3:50
Learn how to populate new app forms by auto-generating sales ids and dates, using max plus one logic and today's date, then pre-fill fields with actions in AppSheet.
Adding and modifying records7:10

Create a data change email automation6:10
Explore AppSheet automations that trigger on data changes or schedules, create a new automation for new sales, and send emails or notifications with optional conditions.
Data automation run-through2:14
Test and monitor a new AppSheet automation by creating a sale, triggering the workflow, and validating email alerts with sale ID, customer ID, date, and amount.
Add conditional statements in AppSheet5:29
Add conditional steps in AppSheet automations by branching on a condition. Trigger on new sales, using a 10,000 threshold to route emails for big or small sales.

Requirements

No prior experience required
Knowledge of Google Sheets and Workspaces is an asset, but not required

Description

*PLEASE READ BELOW *

Do you want to create powerful business no-code applications using Google AppSheet? Do you want to take your Google Sheets and Workspace to the next level by creating a full application to track data?

Then you’re in the right place! This course will go through the complete guide to AppSheet. Learn from over 4 hours of relevant instructional video content with the only course that teaches you how to use AppSheet to create apps from start to finish.

Google AppSheet is a powerful no-code platform that allows users to create custom applications and business solutions with ease. This course is designed to teach you how to use AppSheet to create dynamic applications that can be used in a variety of industries and situations.

In this course, you will learn how to create, customize, and deploy mobile and web applications using Google AppSheet. You will start with the basics of the platform and gradually move to more advanced topics like actions and automations, security and access controls, and more.

Throughout the course, you will have access to step-by-step instructional videos and practical exercises to help you gain confidence in using the platform.

Whether you are a business analyst, entrepreneur, or someone looking to enhance your skills in application development, this course is perfect for you. By the end of the course, you will be able to build custom applications that can be used in a variety of industries and contexts.

No prior experience with Google AppSheet or coding is required to take this course. However, basic knowledge of Google Sheets or other spreadsheet applications will be helpful. By the end of the course, you will be well-equipped with the skills needed to build custom applications and business solutions using Google AppSheet.

What is AppSheet?

Google AppSheet is a no-code platform that enables users to create custom mobile and web applications using data from various sources, including Google Sheets, Salesforce, and SQL databases. AppSheet offers a drag-and-drop interface that allows users to build applications quickly and easily without writing any code. The platform includes features such as data capture, workflow automation, and security and access controls, which make it suitable for a wide range of industries and business contexts. With Google AppSheet, users can create powerful and scalable applications that can help them streamline their workflows and boost productivity.

What are the main features of AppSheet?

No-code platform - AppSheet is designed for users with little to no coding experience. It provides an intuitive interface and easy-to-use tools that enable users to create custom applications without writing any code.
Multi-platform support - Once an application is created in AppSheet, it can be deployed and accessed on various platforms, including mobile devices, tablets, and desktop computers. This makes it easy to access and use the application from anywhere.
Integration with multiple data sources - AppSheet can be integrated with a wide range of data sources, including Google Sheets, SQL databases, Salesforce, and more. This allows users to access and use data from various sources within their applications.
Advanced functionality - AppSheet provides advanced functionality that enables users to create complex applications that meet their specific needs. This includes features such as workflow automation, user access controls, and more.
Customizable design - AppSheet offers a range of design options that allow users to customize the look and feel of their applications. This includes the ability to add custom branding, choose from various themes, and create custom layouts.
Scalability - AppSheet is designed to support applications of any size, from small prototypes to large-scale business solutions. This makes it a flexible tool that can be used in a variety of contexts and industries.

Why learn AppSheet?

Increase your and your organizations productivity - Do you use Google Sheets and Excel files that you manually need to update and share across several users? AppSheet can easily and quickly streamline that for you by creating a data-driven application.
Get hired / increase your employability - No-code application development, like AppSheet, is one of the fastest growing tools in medium-to-large businesses. Put this skill on your resume to boost your chances and pay rate.
No coding necessary - Google AppSheet is a no-code platform, which means you don't need to know how to code to create applications. This makes it accessible to a wider audience and allows users to quickly develop and deploy applications.
Easy to use - Google AppSheet has a drag-and-drop interface, which makes it easy to use for both beginners and advanced users. The platform also offers a range of templates that can be customized to suit individual needs.
Integration with Google Workspace - Google AppSheet is fully integrated with Google Workspace, which means users can easily connect to Google Sheets, Docs, Forms, and other Google applications to access data and build applications.

Why take this course?

Complete guide - this is the 100% start to finish, zero to hero, basic to advanced guide on Google AppSheet. There is no other course like it that teaches you everything from start to finish.
Fully instructional - we not only go through important concepts, but also apply them as we are building our application so that we can solidify them. This is not only a walkthrough of the AppSheet features, but a course that actually builds applications with you
Teacher response If there's anything else you would like to learn, or if there's something you cannot figure out, the community and myself are here for you!
Great resources - Example data, resources, and further reading can help you in your learning journey

Course and Module Overview

Introduction to AppSheet
AppSheet Environment Setup
Build your first AppSheet app
AppSheet BB: Data
AppSheet BB: Views
AppSheet BB: Styles
AppSheet BB: Actions
AppSheet BB: Automations
AppSheet BB: Security
Conclusion

If you want to learn how to create enterprise-grade applications and solutions using Google AppSheet, then this is the course for you. We look forward to having you in the course and hope you earn the certificate.

Music: Bensound

Who this course is for:

Analysts / Managers / Business users who want to automate and streamline their tasks through a Business application without any code
People who are familiar with Google Sheets but want to take it to the next level and build an application or solution that views and modifies the data
Users who want to impress employers with a relevant high-in-demand and growing no-code development skill
People who are interested to build their own web and phone based apps, with minimal coding

AppSheet Masterclass - Complete Guide to Google AppSheet

What you'll learn

Explore related topics

Course content

Introduction to AppSheet9 lectures • 26min

AppSheet Environment Setup2 lectures • 4min

Build your first AppSheet app5 lectures • 24min

AppSheet BB: Data8 lectures • 1hr 3min

AppSheet BB: Views9 lectures • 1hr 4min

AppSheet BB: Styles2 lectures • 17min

AppSheet BB: Actions4 lectures • 27min

AppSheet BB: Automations3 lectures • 14min

AppSheet BB: Security2 lectures • 10min

Conclusion2 lectures • 6min

Requirements

Description

Who this course is for: