Common questions when considering Google AppSheet
Filter by category
AppSheet apps work great on both desktop and mobile devices, and they are used for a variety of business use cases including project management, operations, field work, human resources, sales, and marketing.
AppSheet is a true no-code platform, which means anyone can build rich apps and automated processes without writing a line of code. The AppSheet Editor helps make creation easier by automatically generating app prototypes and providing smart suggestions for quick customizations. AppSheet also uses spreadsheet-like expressions to incorporate advanced logic to do things like filter data, create dynamic UI elements, and set up workflow automations.
AppSheet integrates directly with Google Workspace in a variety of ways. Some of the most common uses include:
- App data and files can be stored in Google Sheets and Google Drive folders.
- Apps can be integrated directly into Gmail emails using dynamic emails.
- Google Calendar can be connected to incorporate event data in apps.
- Google Meet can be initiated directly from within AppSheet apps.
- AppSheet Automation can be used to move or update data in any connected source.
Learn more about using Google Workspace and AppSheet together here.
Besides AppSheet's native data source, AppSheet databases, apps can connect to various data sources. These include: Google Sheets, Google Drive, Microsoft Excel files, Cloud SQL, Apigee, Microsoft Azure SQL, AWS, Salesforce objects, Smartsheet, OData, and more.
Yes, ‘unbranded’ apps are versions of AppSheet apps that can be published directly to the iOS App Store and Android Play store. Learn more about unbranded white label apps.
No. Although the most common way to get started is by using your Google Workspace account, you can also create apps with a Microsoft, Dropbox, Box, Smartsheet, or Salesforce account.
For quick app creation tutorials, visit the Google Workspace Youtube channel, our “How to create an app” guide, or our AppSheet Training course on Google Cloud Skills Boost. For specific questions and troubleshooting, read AppSheet Help documents and engage with the active community of creators around the world.
Use the complete set of AppSheet features at no cost while building one or many app prototypes. Invite up to 10 users at no cost to test your apps and share feedback.
Basic applications can be created and shared with small teams in any Google Workspace account. In order to scale and share apps with larger teams, an AppSheet subscription is required – AppSheet Core licenses are automatically included in some versions of Google Workspace Enterprise. Contact Workspace sales for more information.
Visit the billing settings in the “My Account” section. Choose the plan level based on the features your apps require. You can also update the number of app user licenses and your credit card details. For enterprise subscriptions, please contact your Google representative.
A summary of your app usage is available in the ”My Account” section of AppSheet, within the ”App Info” tab. Detailed app usage is also available in the app editor in Manage > Monitor section of each app.
A summary of your database usage is available in the “My Account” section of AppSheet, within the “Database Info” tab.
As much as you'd like. We encourage you to try out all the features of the platform in the prototype phase for one or multiple apps.
AppSheet counts each person who signs in to your app or AppSheet database as a user. We count unique users across all apps and databases in your account. Users that are not signed-in are counted as guest-users. You need to subscribe to the number of licenses that will match the number of users you plan to have.
Yes, you can change your plan or number of licenses at any time. You can even revert back to prototyping at no cost and we'll prorate your billing. For enterprise subscriptions, if you wish to change your plan, please contact your Google representative.
A public app can be shared with anyone, without requiring authentication. In addition, secure applications requiring authentication can be shared outside your organization if permitted by account governance policies. Learn more about external user licenses.
An AppSheet database can't be made public. Databases can only be shared with an AppSheet team or email address.
Some Google Workspace subscriptions include access to AppSheet Core for creating and sharing applications within the organization, with options to upgrade to AppSheet Enterprise for advanced integrations and admin governance features. Learn More
Yes, we offer discounts for educational and non-profit organizations with verification of tax-exempt status.
Billing is based on your plan and will either occur monthly or annually.
Learn more about AppSheet’s pricing here.
If you use AppSheet databases, AppSheet will store your data in Google Cloud. Otherwise, data stored in AppSheet applications is primarily stored in a location of your choosing which can either be in a cloud storage service such as Google Sheets, or in a cloud database such as Cloud SQL. In some cases, AppSheet stores your application data temporarily for performance and to support features such as the audit log. You can control these features in the application configuration.
The configuration of your applications (e.g. look-and-feel, branding, sharing) and certain user information (e.g. teams, data source configuration, administrative policy) are stored securely by AppSheet in Google Cloud.
All AppSheet users (including both application creators and users) are authenticated using a single-sign-on provider of your choosing (including Google, Microsoft, Apple, Dropbox, Smartsheet, Box, and Salesforce). AppSheet does not use, process, or store passwords for application creators or users.
When a user authenticates with AppSheet, we store an OAuth2 credential which allows AppSheet to access Cloud Storage services (such as Google Drive) and other data sources (such as Google Calendar).
Some supported data sources such as databases (MySQL, PostgreSQL, etc.) support username/password authentication. AppSheet stores these credentials encrypted in a secure database in Google Cloud.
In some cases AppSheet can integrate with domain groups, such as Google Groups, AD Groups, and Okta. Custom groups defined in your IDP can then be leveraged for roles-based access inside of individual applications. You can read more about this here.
Yes. AppSheet is SOC2 Type 2 audited. Our SOC Report is available to customers under NDA and upon request.
AppSheet supports customers’ compliance with the U.S. Health Insurance Portability and Accountability Act (HIPAA), which governs the safeguarding, use, and disclosure of protected health information (PHI). If you are subject to HIPAA and wish to use AppSheet for PHI processing or storage, please follow the steps outlined here.
Yes. Each app in your organization can have its own security. You can either (A) explicitly list users, (B) enable domain authentication support for this one application, or (C) enable domain group support if your provider supports that feature. You can learn more here.
AppSheet databases have three types of access control levels: Editor, Writer or Viewer. The database owner or anyone with editor access can set these permissions. You can learn more here.
Learn more about AppSheet’s security here.
Yes, AppSheet governance policies can be applied to team accounts, controlling the types of data connected, features added to apps, and level of access for different teams of app users. Learn more about governance features in AppSheet Enterprise.
AppSheet is an additional service in your Google Workspace account, and user access can be controlled by OU, Group, or across the entire domain. Read more about managing AppSheet from the Google Workspace admin console.
AppSheet allows you to govern your team and the apps they build: You can enforce preferred configurations and block unwanted features through policies; you have visibility into and control over integrations used; and you can monitor the usage and activity across the team.
have been created with AppSheet.
Build yours today.Get started