Google Appsheet

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

Integrate the Google Appsheet API with the Google Drive API

Setup the Google Appsheet API trigger to run a workflow which integrates with the Google Drive API. Pipedream's integration platform allows you to integrate Google Appsheet and Google Drive remarkably fast. Free for developers.

Changes to Specific Files from the Google Drive API

Watches for changes to specific files, emitting an event any time a change is made to one of those files. To watch for changes to shared drive files, use the Changes to Specific Files (Shared Drive) source instead.

 
Try it
Changes to Specific Files (Shared Drive) from the Google Drive API

Watches for changes to specific files in a shared drive, emitting an event any time a change is made to one of those files

 
Try it
New Files (Instant) from the Google Drive API

Emit new event any time a new file is added in your linked Google Drive

 
Try it
New or Modified Comments from the Google Drive API

Emits a new event any time a file comment is added, modified, or deleted in your linked Google Drive

 
Try it
New or Modified Files from the Google Drive API

Emit new event any time any file in your linked Google Drive is added, modified, or deleted

 
Try it
Add File Sharing Preference with the Google Drive API

Add a sharing permission to the sharing preferences of a file or folder and provide a sharing URL. See the docs for more information

 
Try it
Copy File with the Google Drive API

Create a copy of the specified file. See the docs for more information

 
Try it
Create a New File with the Google Drive API

Create a new file from a URL or /tmp/filepath. See the docs for more information

 
Try it
Create Folder with the Google Drive API

Create a new empty folder. See the docs for more information

 
Try it
Create New File From Template with the Google Drive API

Create a new Google Docs file from a template. Optionally include placeholders in the template document that will get replaced from this action. See documentation

 
Try it

Overview of Google Appsheet

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.

Connect Google Appsheet

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,
    })
  },
})

Overview of Google Drive

Using the Google Drive API, you can build applications that:

  • Create and manage files and folders
  • Download and upload files
  • Share and organize files
  • Search for files
  • Track changes to files
  • And much more!

Connect Google Drive

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    google_drive: {
      type: "app",
      app: "google_drive",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://www.googleapis.com/oauth2/v1/userinfo`,
      headers: {
        Authorization: `Bearer ${this.google_drive.$auth.oauth_access_token}`,
      },
    })
  },
})