Google Appsheet

With Google AppSheet, you can build powerful solutions that simplify work. No coding required.

Go to site
Explore
/
Apps
/
Google Appsheet

Google Appsheet API Integrations

Build and run workflows using the Google Appsheet API. Use 1000s of source-available triggers and actions across 1000+ apps. Or write custom code to integrate any app or API in seconds.

Overview

Appsheets is a powerful API that allows you to quickly and easily create apps that can be used on a variety of devices, including smartphones, tablets, and computers. With Appsheet, you can easily create apps that allow you to track and manage your data, create reports and visualizations, and even share your data with other users. Appsheet is also easy to use, with a simple interface that makes it easy to get started.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    google_appsheet: {
      type: "app",
      app: "google_appsheet",
    }
  },
  async run({steps, $}) {
    const data = {
      "Action": "Find",
      "Properties": `{
          "Locale": "en-US",
          "Selector": "Filter(Sheet1, true)",
          "Timezone":
          "Pacific Standard Time"
      }`,
    }
    return await axios($, {
      method: "post",
      url: `https://api.appsheet.com/api/v2/apps/${this.google_appsheet.$auth.app_id}/tables/{{your_table_here}}/Action`,
      headers: {
        "ApplicationAccessKey": `${this.google_appsheet.$auth.access_key}`,
      },
      data,
    })
  },
})

Authentication

Google Appsheet uses API keys for authentication. When you connect your Google Appsheet account, Pipedream securely stores the keys so you can easily authenticate to Google Appsheet APIs in both code and no-code steps.

To retrieve your API key,

  • Navigate to your Google Appsheet account and sign in
  • Go to “My Account” > “Settings” > “API Settings”