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!
Citizen developer learning path → goo.gle/3GqKebL
Watch more episodes of this series → goo.gle/BuildingWithAppSheet
What is Google Workspace? → goo.gle/3Beog75
Set up Google Workspace →goo.gle/3InFfYb
Subscribe to Google Workspace →goo.gle/GoogleWorkspace
Follow Google Workspace on Twitter → goo.gle/3dkgQGD
Follow Google Workspace on Facebook→ goo.gle/3xHtxTR
Follow Google Workspace on LinkedIn → goo.gle/2IJgEl2
Follow Google Workspace on Instagram → goo.gle/3zgCIem
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

[@googleworkspace]

Try Google Workspace For Free Now → goo.gle/3pPXrm

[@indangawanvener3776]

Yess

[@candiceerasmus5943]

This is so helpful, thank you!

[@empresariosypropulsiondeem6976]

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

[@gerardonava9000]

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.

[@monicaaraujo4639]

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

[@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! 💯

[@ashotmanukyan64]

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?

[@massimolorenzi6640]

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?

[@brandonacklin1913]

🉐

[@arturasf6740]

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

[@empresariosypropulsiondeem6976]

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

[@dorinxtg]

Look for References between tables

[@AjabaadamUsman]

😂😂😂😊

[@TN2525]

❤

[@Yusufyilmazbursa16]

Y 0:15

[@indangawanvener3776]

Yes I'm interesting