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.
In addition to Google Sheets and Google Drive, AppSheet apps can connect to hosted Excel files, Cloud SQL, Apigee, 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.
The most common methods for starting an application is to start with an existing data source (usually a Google Sheet) or by copying an app template (that comes with its own data source). Learn about how to prepare a data source for an app.
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.
An overview of all your app usage is available in the ”My Account” section of the platform, within the ”App Info” tab. Detailed app usage is also available in the app editor in the Manage section within the Monitor tab of each app.
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 as a user. We count unique users across all apps 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.
Yes, 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.
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.
Monthly subscriptions are automatically invoiced, and transaction history is available in the billing tab of 'My Account'.
Learn more about AppSheet’s pricing here.
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, in a cloud database such as Cloud SQL, or in a database of your choosing. 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.
Yes. You can invoke add, delete, edit, find, and run actions. We have several help articles to get you started. You can learn more about AppSheet’s REST API 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.
Contact sales if you have additional questions.
Contact support if you’re already an AppSheet customer.
have been created with AppSheet.
Build yours today.Get started