Google Appsheet

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

Integrate the Google Appsheet API with the Node API

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

Run Node Code with the Node API

Write custom Node.js code and use any of the 400k+ npm packages available. Refer to the Pipedream Node docs to learn more.

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

Connect Node

1
2
3
4
5
6
7
// To use previous step data, pass the `steps` object to the run() function
export default defineComponent({
  async run({ steps, $ }) {
    // Return data to use it in future steps
    return steps.trigger.event
  },
})

Community Posts

Automate checking a ticket system's availability with Node.js and Pipedream
Automate checking a ticket system's availability with Node.js and Pipedream
How I used Node.js and Pipedream to automatically scrape a ticket booking site and notify me if availability had changed.