Skip to main content

AppSheet

With AppSheet modules in Make, you can manage the records and invoke actions in your AppSheet account.

To use the AppSheet modules, you must have a paid account. For subscription information, refer to the AppSheet Pricing page.

Refer to AppSheet API documentation for a list of available endpoints.

Connect AppSheet to Make

To establish the connection, you must:

  1. Obtain your Application Access Key and App ID in your AppSheet account.

  2. Establish the connection in Make.

Obtain your Application Access Key andApp ID in App Sheet

You need to create an app first. Refer to AppSheet documentation for more information.

To obtain your Application Access Key and App ID from your AppSheet account:

  1. Log in to your AppSheet account.

  2. Open the needed app.

  3. In the left sidebar, click Settings > Integrations.

  4. Copy the App ID value shown and store it in a safe place.

  5. Select the Enable toggle.

  6. Click Create Application Access Key.

  7. Click Show Access Key, copy the value shown and store it in a safe place.

You will use these values in the Application Access Key and App ID fields in Make.

Establish the connection with AppSheet in Make

To establish the connection in Make:

  1. Log in to your Make account, add a AppSheet module to your scenario, and click Create a connection.

  2. Optional: In the Connection name field, enter a name for the connection.

  3. In the Application Access Key field, enter the relevant value that you copied above.

  4. In the App ID field, enter the relevant value that you copied above.

  5. In the Table Name, enter the table you want to connect.

  6. Optional: In the Locale field, select the language applicable for the app.

  7. Optional: In the Location field, enter the value used for ChangeLocation columns.

  8. Optional: In the Timezone field, enter the desired timezone.

  9. Click Save.

  10. If prompted, authenticate your account and confirm access.

You have successfully established the connection. You can now edit your scenario and add more App Sheet modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.

Build AppSheet Scenarios

After connecting the app, you can perform the following actions:

Records

  • Search Records

  • Get a Record

  • Create a Record

  • Edit a Record

  • Delete a Record

Actions

  • Invoke an Action

Other

  • Make an API Call

In this section: