Google AppSheet — No-Code Business Apps
AppSheet is a no-code app development platform included with **Google Workspace Business Plus and Enterprise** plans (and available as a standalone subscription).
### What AppSheet Can Build
- Mobile data-entry apps (field inspections, delivery confirmations)
- Inventory and asset tracking apps
- Customer-facing apps (appointment booking, service requests)
- HR apps (expense reports, leave requests, shift management)
- Simple CRM tools
### Accessing AppSheet
Go to **appsheet.com** → sign in with your Google Workspace account
Or from Google Sheets: Extensions → AppSheet → Create an app
### Creating Your First App from a Google Sheet
1. Open Google Sheets → Extensions → AppSheet → Create an app
2. AppSheet analyses the sheet structure and auto-generates an app
3. Customise in the AppSheet editor:
- Views: Gallery, Table, Form, Map, Calendar, Chart
- Columns: adjust data types, mark required fields, add validation
- Behaviour: Actions (buttons), workflows (automated emails/notifications)
4. Test on mobile using the AppSheet preview
### Key Concepts
**Tables:** Sheets or database tables that store data
**Views:** How the data is displayed (table, form, gallery, map)
**Actions:** Buttons that trigger workflows (mark as complete, send email, set a value)
**Automation:** Send email/push notification when data changes, run on schedule
### Data Sources AppSheet Supports
- Google Sheets (most common)
- Google Drive (CSV files)
- Smartsheet
- Salesforce
- SQL databases (MySQL, PostgreSQL)
- REST APIs
### Deploying to Users
AppSheet → Manage → Users → Add users by email
Users open the app in a browser or install the AppSheet mobile app.
### Pricing Note
AppSheet Core is free for limited use (up to 10 users). Full features require AppSheet Core or Enterprise subscription, or a qualifying Google Workspace plan.