Preparing your Google Sheet for AppSheet

Google Sheets is a great way to keep your data organized and shareable across your organization. However, did you know that AppSheet can automate data collection and organization into a single app? In this episode of Building with Appsheet, Google Developer Advocate Christian Schalk discusses some best practices for prepping your Google Sheet for use with AppSheet. Watch to learn how you can best prepare your Google Sheet to work with AppSheet!

Product: Google Workspace, Add-ons - App Sheet, Workspace - Applications - Sheets; fullname: Christian Schalk;
#BuildingWithAppSheet
#GoogleWorkspace

Chapters:
0:00 - Intro
0:21 - Preparing your Sheet for AppSheet
0:44 - Column Names
1:07 - Column Names and AppSheet Data Types
1:41 - How to Use Keys
2:38 - Sheets Tips and Tricks
3:24 - Demo: Preparing a Task Tracking Sheet for AppSheet
10:47 - Summary & More Info

[RobertSutkowski-lh]

Appsheet 👍👍
... just name can be diferent ... Marketing name

[ashotmanukyan]

hey, I have Core google workspace account but cannot publish my app for external users. I only can share with my domain users. is that ok?

[arturasf]

User's image is displayed, based on his gmail email account? How to do that?

[mrmortgage]

The App templates in Google do not have a basic mortgage or loan application. Any ideas on where I can find something ?

[massimolorenzi]

I am a beginner, I have a big problem, I made an application for a simple shopping list to be brought to Android, but when I add or modify an existing item does not allow me to save the modification do not appear the save / delete keys on the 'Android preview, how can I remedy this problem?

[empresariosypropulsiondeem]

Hello, Can you share the Data Sheets, in order to repeat the exercise with this information ?

[RobertSutkowski-lh]

It's for EVERYONE !!!👍 MORE ADVERTISING ... TUTORIALS IN MULTI LANGUAGE

[monicaaraujo]

Where can I find that file you are using on this training?

[empresariosypropulsiondeem]

The App Creation does not generate links between tables, so it's important to explain how generate it manually.

[gerardonava]

I've already activated preview new features in UX options, but when I create a send email bot on Automation Menu, the system doesn't offer the preview Dinamic Email Menu, and thus, it doesn´t offer the Project Aprovals_Form, neither The Project Aprovals_Detail.

[MarownIOM]

Thank you! That was a really clear overview of AppSheets. Your voice was well controlled (no um, er, or annoying noises). And your speaking speed was just right. I didn't speed it up at all. Well done! 💯