Skip to Content
View all events

Developing Robust Applications with Google AppSheet

Published by O'Reilly Media, Inc.

Intermediate content levelIntermediate

Boosting productivity with no-code development

No-code application development is on the rise. Many organizations and teams are gravitating toward no-code technology, as it allows nonprogrammers to design and create applications, opening up the field of software application development to a wider audience. One such technology that has emerged is Google AppSheet, a tool that allows you to create powerful applications in a few steps, while utilizing a variety of data sources such as Google Sheets, PostgreSQL, and Salesforce.

Join expert Aryan Irani to get a guided introduction to Google AppSheet and learn how to build powerful applications through a series of guided demonstrations and hands-on exercises. You'll create two applications from scratch while learning the ins and outs of the tool, and you’ll review components of AppSheet that help make the development experience more user-friendly and secure, including automation, security, and behavior features. In just a few hours, you'll have all the knowledge and experience needed to start creating your own applications with Google AppSheet.

What you’ll learn and how you can apply it

By the end of this live online course, you’ll understand:

  • How to build applications with Google AppSheet
  • Google AppSheet features like automation, security, and behavior
  • How to make the user and admin experience more secure and accessible

And you’ll be able to:

  • Create applications using Google AppSheet
  • Convert a simple Google Sheet into a fully functional app
  • Automate internal processes in your application

This live event is for you because...

  • You’re a developer or enterprise user who wants to create powerful apps with minimal or no coding.
  • You’re a developer who wants to create apps for internal automation in your organization.
  • You want to explore the no-code app development culture.

Prerequisites

  • A Google account
  • A working knowledge of Google Sheets (or Excel)

Schedule

The time frames are only estimates and may vary according to how the class is progressing.

Course overview (30 minutes)

  • Presentation: What is Google AppSheet and why use it?; AppSheet features; six steps to creating powerful apps
  • Q&A

Apps walk-through (35 minutes)

  • Demo: Expense tracking app using Google AppSheet; vehicle inspection app using Google AppSheet
  • Break

Creating a to-do list app (30 minutes)

  • Demo and hands-on exercises: Data source declaration; app setup; setting up data tables; creating app views; setting up slices; sharing with users; deploying app
  • Q&A

Creating an inventory management app (35 minutes)

  • Demo and hands-on exercises: Data source declaration; app setup; setting up data tables; creating app views; setting up formulas; sharing with users; deploying app
  • Q&A
  • Break

AppsScript + AppSheet (30 minutes)

  • Presentation and hands-on exercise: Use AppScript and AppSheet together
  • Demo and hands-on exercise: Automation with AppScript

Outro (20 minutes)

  • Presentation: Additional resources on Google AppSheet
  • Q&A

Your Instructor

  • Aryan Irani

    Aryan Irani is an independent contractor, technical trainer and writer. Google Developer Expert @GoogleWorkspace.

    linkedinXlinksearch

Skill covered

Low Code / No Code