Integrate the Google Appsheet API with the GitHub API

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

Popular Google Appsheet and GitHub Triggers#

New Branch from the GitHub API

Emit new event when a branch is created See the documentation

Try it

New Card in Column (Classic Projects) from the GitHub API

Emit new event when a (classic) project card is created or moved to a specific column. For Projects V2 use New Issue with Status trigger. More information here

Try it

New Collaborator from the GitHub API

Emit new event when a collaborator is added See the documentation

Try it

New Commit from the GitHub API

Emit new event when commits are pushed to a branch See the documentation

Try it

New Commit Comment from the GitHub API

Emit new event when a commit comment is created See the documentation

Try it

Popular Google Appsheet and GitHub Actions#

Create Issue with the GitHub API

Create a new issue in a Gihub repo. See docs here

Try it

Search Issues and Pull Requests with the GitHub API

Find issues and pull requests by state and keyword. See docs here

Try it

Create Branch with the GitHub API

Create a new branch in a Github repo. See docs here

Try it

Create Gist with the GitHub API

Allows you to add a new gist with one or more files. See docs here

Try it

Create Issue Comment with the GitHub API

Create a new comment in a issue. See docs here

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 GitHub#

The GitHub API is a powerful gateway to interaction with GitHub's vast web of data and services, offering a suite of endpoints to manipulate and retrieve information on repositories, pull requests, issues, and more. Harnessing this API on Pipedream, you can orchestrate automated workflows that respond to events in real-time, manage repository data, streamline collaborative processes, and connect GitHub with other services for a more integrated development lifecycle.

Connect GitHub#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    github: {
      type: "app",
      app: "github",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.github.com/user`,
      headers: {
        Authorization: `Bearer ${this.github.$auth.oauth_access_token}`,
        "X-GitHub-Api-Version": `2022-11-28`,
      },
    })
  },
})