Integrate the Google Appsheet API with the Airtable (OAuth) API

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

Popular Google Appsheet and Airtable (OAuth) Triggers#

New Field from the Airtable (OAuth) API

Emit new event for each new field created in a table

Try it

New Modified or Deleted Records (Instant) from the Airtable (OAuth) API

Emit new event each time a record is added, updated, or deleted in an Airtable table. See the documentation

Try it

New or Modified Field from the Airtable (OAuth) API

Emit new event for each new or modified field in a table

Try it

New or Modified Records from the Airtable (OAuth) API

Emit new event for each new or modified record in a table

Try it

New or Modified Records in View from the Airtable (OAuth) API

Emit new event for each new or modified record in a view

Try it

Popular Google Appsheet and Airtable (OAuth) Actions#

Create Comment with the Airtable (OAuth) API

Create a new comment on a record. See the documentation

Try it

Create Field with the Airtable (OAuth) API

Create a new field in a table. See the documentation

Try it

Create Multiple Records with the Airtable (OAuth) API

Create one or more records in a table by passing an array of objects containing field names and values as key/value pairs. See the documentation

Try it

Create Single Record with the Airtable (OAuth) API

Adds a record to a table.

Try it

Create Single Record Or Update with the Airtable (OAuth) API

Updates a record if recordId is provided or adds a record to a table.

Try it

Overview of Google Appsheet#

The Google Appsheet API enables programmatic interactions with your custom AppSheet applications, allowing you to streamline processes, automate actions, and interlink your apps with other services. Leveraging Pipedream's powerful serverless platform, you can create workflows that react to events in real-time, automate tasks, and connect to countless other services with minimal effort. Whether you're updating datasets, syncing with external systems, or triggering complex chains of actions, combining AppSheet with Pipedream can supercharge your productivity and enhance your app's capabilities.

Connect Google Appsheet#

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 Airtable (OAuth)#

Airtable (OAuth) API on Pipedream allows you to manipulate and leverage your Airtable data in a myriad of powerful ways. Sync data between Airtable and other apps, trigger workflows on updates, or process bulk data operations asynchronously. By using Airtable's structured databases with Pipedream's serverless platform, you can craft custom automation solutions, integrate with other services seamlessly, and streamline complex data processes.

Connect Airtable (OAuth)#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    airtable_oauth: {
      type: "app",
      app: "airtable_oauth",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.airtable.com/v0/meta/whoami`,
      headers: {
        Authorization: `Bearer ${this.airtable_oauth.$auth.oauth_access_token}`,
      },
    })
  },
})