PCG logo

From Idea to App in 5 Minutes With Google AppSheet

A finished app in just a few minutes? No problem with the no-code platform Google AppSheet.


In this video, we'll show you how to set up a task tracking appExternal Link within five minutes, complete with a connection to another table and automation for sending dynamic emails.


For the data table, we will use Google Sheets, with separate tabs for tasks and projects.


With the Google Sheets completed, we can jump right into AppSheet via the Extensions -> AppSheet -> Create App tab.

Column Types

We arrive at the 'Tables' view and add the 'Task' tab in addition to the 'Task' table tab. Under Data -> Columns, we set up the attributes of each column field. After creating the app, only a few adjustments are needed. These include changing the Status field to 'Enum' and adding the available options.


In the application we also assign the created task to a project, so that a relation from one table to another is created.



In order for the task owner to be informed about the task assigned to him, we add a bot to automatically send an email as soon as a new entry is created. AppSheet does a lot of work for us here as well through the suggestion bar, where we just enter the keywords "Task", "created" and "email" and get the desired process pre-configured. We also select "Embedded app view" as the email type and the corresponding view "Task_Form", so that the recipient can adjust the record directly in the email.



Now we are just three clicks away from deploying the application. Under "Not Deployed", on the top left of the developer console, we run the deployment check. Once it has run, we can deploy the app.

You can view and make a copy of the app at this linkExternal Link.


Do you want to empower employees without programming skills from specialist departments to create their own apps? Contact us now.

Services Used

Continue Reading

The most important announcements at Google Cloud Next '24

Google Cloud Next, Google's most important cloud conference, took place in Las Vegas from April 9 to 11. You can find the most significant information in our blog article!

Learn more
PCG renews Google Cloud "Infrastructure" specialization

The Public Cloud Group has held the Google Cloud Partner Specialization in Infrastructure since 2018. We are pleased to announce that we have now successfully renewed it.

Learn more
Ippen Digital Chooses Google Workspace

Ippen Digital, Europe's largest regional news network, embraced Google Workspace for seamless collaboration and enhanced productivity.

Learn more
Cloud Native Rockstar Award 2022

Benny Woletz earns recognition for excellence in the 'New Work & Collaboration' category for our solution for air conditioning specialist Viessmann.

Learn more
See all

Let's work together

United Kingdom
Arrow Down