Configure Google Cloud Storage as a cloud object store as described in the following sections:

  1. Configure Google Cloud Storage as a cloud object store

  2. Create a service account in Google Cloud Console

  3. Add the cloud object store to your AppSheet account

  4. Configure a table in an app to use the cloud object store

Configure Google Cloud Storage as a cloud object store

  1. Create an Google Cloud Storage (GCS) bucket and give it a name, such as mytestbucket:

  2. Choose a storage class, such as Standard:

  3. Choose how to control access to objects.
    We recommend Uniform access, since your entire app will be accessing this storage bucket using the API credentials provided:

  4. Choose the encryption method.
    We recommend using a Google-managed-key:

Create a service account in Google Cloud Console

Create a service account in Google Cloud Console. For more information, see Creating and managing service accounts.

Give your service account a meaningful name (the information is blurred out below):

Give your service account Storage Admin role:

Important: Create a key and store this safely somewhere (you will need it later):

The key should be of type JSON.

Once you create the key, it will also be downloaded to your computer. Open your favorite text editor and then open this JSON file.

Add the cloud object store to your AppSheet account

After you have your Google Cloud Storage configured, you are ready to add it to your AppSheet account:

  1. Sign in to appsheet.com.

  2. Go to the My Account page.

  3. Click the Integrations tab.

  4. Click Stores in the left navigation.

  5. Perform one of the following steps:

    • To add an object store for use by your own account, click New Cloud Store under Object Stores, then click Google Cloud Storage.

    • To add an object store for your team member accounts, click New Cloud Store under Team Object Stores, then click Google Cloud Storage.
      Note: You must be a Team Admin to create a team object store.

  6. Complete the Add Google Cloud Storage integration dialog to create the new object store.

    • Provide a user-friendly name for this storage connection.

    • Copy the entire JSON file from above into the Private Key JSON String field.

    • Enter the exact bucket name.

  7. Click Test Connection to test the connection.

  8. Click Save.

Configure a table in an app to use the cloud object store

After you have added a cloud object store to your account, you can configure a table in an app to use it.

  1. Go to a table definition in the app editor on the Data > Tables page.

  2. In the properties, look for Cloud Object Store and enter the name of the object store that you set up for your account (such as, GCSStore).

  3. Save the change.

Did this answer your question?