Google Appsheet

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

Integrate the Google Appsheet API with the Bash API

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

Run Bash Code with the Bash API

Run any Bash in a Pipedream step within your workflow. Refer to the Pipedream Bash 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 Bash

1
2
3
4
5
6
7
# $PIPEDREAM_STEPS file contains data from previous steps
cat $PIPEDREAM_STEPS | jq .trigger.context.id

# Write data to $PIPEDREAM_EXPORTS to return it from the step
# Exports must be written as key=value
echo foo=bar >> $PIPEDREAM_EXPORTS