Google AppSheet
Training Courses
Learn the fundamentals of Google AppSheet’s no-code platform to rapidly design and deploy applications that digitize processes and enhance business automation.
Google Workspace with Gemini
Accelerate Your Business Digitization with Google AppSheet Training
In today’s fast-paced environment, business speed is key. PointStar’s certified training programs empower you and your team—from business leaders to users—to quickly digitize manual processes and build custom applications without needing to write code. Transform your operations, enhance business automation, and gain a competitive edge using Google AppSheet.
Training Courses
Browse the training courses available below, designed based on your needs and experience level.
Google AppSheet
Fundamentals
This Business Digitization Discovery Workshop is meant to guide business leaders and users to learn how to develop and deploy an application that suits into their business environment.
1-DAY HANDS-ON SESSION
Google AppSheet
Advanced
This workshop is meant to empower technical / business users to design, develop, and deploy intermediate-level AppSheet applications with advanced features to solve complex business problems.
2-DAY HANDS-ON SESSION
COURSE OVERVIEW
Google AppSheet Essential Training Workshop
Business Digitalization Discovery
This course guides business users step-by-step in creating business applications without needing IT programming knowledge. By the end of this workshop, you will build an application and gain the AppSheet knowledge needed to enhance your business automation.
1 Day
Course duration
Up to 10 pax
Course capacity
English
Course medium
On-site
Delivery methods
End user
Participant Group
Module breakdown
This introductory session sets the stage by exploring the rise of no-code platforms and AppSheet. Participants will get a high-level overview of AppSheet's key features, integration capabilities.
- The Rise of No-Code/Low-Code
- Introduction to Cloud Computing
- What is AppSheet?
- Key Features
- Web and mobile UX appearanceÂ
- Plans and Comparisons
- Integration with Business and Productivity Tools
- Setting up your Appsheet Account
This segment will cover the essential principles of data governance and security within the AppSheet environment. Participants will learn about the various deployment options and the key factors to consider before launching an application.
- Data Governance and Security
- Deployment Options and Considerations
Â
Engage in a conceptual session on how to translate business needs into functional application workflows. The hands-on exercise focuses on brainstorming and outlining a digital process.
- Workflow Design Concepts and Walkthrough
- Brainstorm and Creating a Basic Use-case Workflow
- Defining workflows and identifying workflow triggers, steps, and outcomes.
This module showcases the practical application of AppSheet across various industries and departments. Discover real-world examples, providing inspiration and a clear picture of the platform's capabilities.
- Live Demonstrations of Sample Apps
- Industry-Specific Applications
- Department-Specific Applications
Â
This module delves into the foundational building blocks of any AppSheet application. Gain knowledge of proper data design, table structures, and user experience (UX) principles that are crucial for creating effective apps
- Data Design:
- Â Fundamental concepts of Data
- Table Structure, unique key and references
- UX Design
- AppSheet's Key Features for Business
Putting theory into practice, this session provides a step-by-step, guided experience in building a simple application from scratch. Actively work within the AppSheet editor to solidify their understanding of the development process
- Building a Simple App: Step-by-Step
COURSE OVERVIEW
Google AppSheet Advanced Training Workshop
Empower your team to solve complex business problems using advanced AppSheet features without sacrificing security and governance. By the end of this workshop, you will build an application and gain the AppSheet knowledge needed to create a wide range of useful applications to enhance your business.
2 Days
Course duration
Up to 10 pax
Course capacity
English
Course medium
On-site or Online
Delivery methods
End user
Participant Group
Module breakdown
DAY 1 – Advanced AppSheet Features and Application Design
This session briefly recap on core concepts and discussing best practices for data modeling and performance.Â
- Brief recap of core concepts: data sources, data structure, UX design, and key features.
- Best practices for data modeling and performance optimization.
- Q&A to address any lingering questions from the fundamental training.
Witness live demonstrations of complex, feature-rich sample applications. This module is designed to showcase what is possible with advanced AppSheet functionalities and inspire new development ideas.
- Live Demonstrations of Sample Apps
Â
This module moves beyond basic tables to explore complex data relationships, such as parent-child structures and virtual columns. Learn complex techniques for data validation and how to optimize data structures for automation and reporting.
- Working with complex data relationships: Parent-child relationships, lookups, and virtual columns.
- Advanced data validation techniques: Constraints, data validation rules, and error handling.
- Optimizing data structures for advanced features like automation and reporting.
- Introduction to AppSheet DatabaseÂ
Learn to create highly interactive and dynamic user interfaces using expressions, formatting rules, and action buttons. The focus is on designing for different user roles and implementing navigation patterns.
- Creating dynamic and interactive UIs: Using expressions, formatting rules, and action buttons.
- Designing for different user roles and permissions.
- Implementing advanced navigation patterns: Deep linking, branching, and conditional navigation.
Â
Introduces participants to the power of data slicing and filtering. The hands-on configuration of data actions will show attendees how to create more responsive and context-aware applications
- Introduction to data slicing and filtering.
- Configuring data actions.
Â
Discover the logic engine of AppSheet by learning the basics of its expression language. Learn to apply and create conditional formatting and dynamic data validation rules. Covering the foundational understanding needed to start building automated workflows that can handle repetitive tasks.
- Understanding the basics of AppSheet expressions.Â
- Using expressions for conditional formatting.
- Data validation rules.
- Understanding the concept of automation in AppSheet.
DAY 2 – Deployment, Administration, and Reporting
This module provides a deep dive into AppSheet bots. Learn how to configure bots that are triggered by data changes or schedules and will create simple automations like email notifications and data updates.
- Understanding AppSheet bot concepts.
- Exploring different types of automation events (Data change, Scheduled).
- Using automation to streamline workflows and reduce manual tasks.
- Create simple automation tasks: Email notifications, chat notifications, data updates.
Covers the full application lifecycle management process. Participants will learn how to prepare an app for deployment, manage versioning, monitor performance, and collaborate on app authoring with a team.
- Preparing your app for deployment.
- Sharing your app with users.
- Basic app maintenance and updates.
- App Versioning
- Managing feature updates between development and productionÂ
- App monitoring (usage statistic, audit history log)
- App performance
- App authoring and team collaboration.
Â
Explore the AppSheet Admin Console to learn how to effectively manage users, teams, and governance policies. The session also covers how to monitor application usage and performance through analytics and logs
- Exploring the AppSheet Admin Console.
- Managing users and teams.
- Monitoring app usage and performance: Analytics and logging.
- Implementing governance policies.
Â
Learn how to create various types of insightful reports directly within AppSheet and how to connect their app to Looker Studio to build comprehensive dashboards
- Creating insightful reports: Different report types (summary, detail, charts).
- Complete dashboard with LookerStudio and connect it with AppSheet
This session is dedicated to exploring some of AppSheet's most powerful capabilities, including offline functionality, barcode scanning, GPS tracking, and OCR. It will also cover how to extend an application's power by integrating with external APIs and services
- Exploring advanced AppSheet features: Offline capabilities, barcode scanning, and GPS tracking, OCR, AI featureÂ
- Integrating AppSheet with external APIs and services.
The advanced workshop concludes by reviewing all the key concepts and best practices covered. This session will also introduce how generative AI, specifically Gemini, can be used to further enhance and accelerate the application development process.
- Review of key concepts and best practices.
- Using Gemini to enhance your application development.Â
What work with PointStar?
Endorsed by thousands of organizations, PointStar is a specialist in providing digitalization and change management workshop.
1000+
change management workshops conducted by our certified trainers across PointStar, ranging from various industry verticals and business segments.Â
Google Cloud certified
Our business and technical teams are certified by Google Cloud in extending services to customers.
PointStar is a HRD Corp certified training provider and our training programs are HRD Corp certified.
PointStar is a certified Google Cloud Premier Partner in the South East Asia region, in Singapore, Malaysia and Indonesia.
Our business and technical team are certified by Google Cloud in extending services to customers.
Contact us
Our cloud specialist will reach out to you shortly.