Yellow arrow graphic

Common questions when considering Google AppSheet

Red arrow graphic

Filter by category

All
Platform
Pricing
Security
Administration

Platform

What types of applications can be built with AppSheet?

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.

Does AppSheet really not require any coding?

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.

How does AppSheet integrate with other Workspace apps?

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.

What other data sources does AppSheet integrate with?

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.

Can I publish AppSheet apps to the Google Play store?

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.

Do I have to have a Gmail or Google Workspace account to use AppSheet?

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.

Where can I learn how to use AppSheet?

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.

How do I start creating an app?

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.

Pricing

What can I do at no cost?

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.

How can I create, update, or delete my subscription?

Please see these instructions on how to manage your subscription plan.

Is AppSheet included in Google Workspace?

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.

How do I start my subscription?

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.

Where can I monitor my app or AppSheet database usage?

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.

How much time do I have to test features?

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.

How does AppSheet define a user?

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.

Can I change my plan?

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.

Can I share my app or AppSheet database externally?

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.

If I'm a Google Workspace customer, what do I have access to?

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

Is there a discount for non-profit organizations?

Yes, we offer discounts for educational and non-profit organizations with verification of tax-exempt status.

How often does AppSheet bill subscribers?

Billing is based on your plan and will either occur monthly or annually.

Where can I see my invoices?

Monthly subscriptions are automatically invoiced, and transaction history is available in the billing tab of 'My Account'.

Learn more about AppSheet’s pricing here.

Security

Does AppSheet store our data in its cloud?

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.

How do I authenticate against AppSheet?

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.

Does AppSheet support domain groups for authentication?

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.

Is AppSheet SOC compliant?

Yes. AppSheet is SOC2 Type 2 audited. Our SOC Report is available to customers under NDA and upon request.

Is AppSheet HIPAA compliant?

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.

Is there granular control over which users can see which applications or AppSheet databases?

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.

Does AppSheet have a REST API for inbound requests?

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.

Administration

Can app creation in a team be controlled?

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.

How do I control AppSheet as a service in my Google Workspace account?

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.

How can I make sure that the applications my team builds are secure?

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.

0
1
2
3
4
5
6
7
8
9
apps

have been created with AppSheet.

Build yours today.

Get started
Build your app