Integrate the Smartsheet API with the GitHub API

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

Popular Smartsheet and GitHub Triggers#

New Branch (Instant) from the GitHub API

Emit new events when a new branch is created

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 (Instant) from the GitHub API

Emit new events when collaborators are added to a repo

Try it

New Commit (Instant) from the GitHub API

Emit new events on new commits to a repo or branch

Try it

New Commit Comment (Instant) from the GitHub API

Emit new events on new commit comments

Try it

Popular Smartsheet 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 Issue Comment with the GitHub API

Create a new comment in a issue. See docs here

Try it

Create or update file contents with the GitHub API

Create or update a file in a repository. This will replace an existing file. See docs here

Try it

Overview of Smartsheet#

The Smartsheet API gives developers access to Smartsheet platform features and
data, enabling you to build custom applications and integrations that extend
the functionality of Smartsheet. With the Smartsheet API, you can create
powerful integrations that are tailored to your specific business needs.

Using the Smartsheet API, you can:

Create and manage sheets, rows, and columns
Automate and manage sheet features such as formulas and conditional
formatting
Develop custom sheet views, including sorting and filtering options
Capture and track changes with versioning
Read, write, and delete data
Create reports, dashboards, and timelines
Collaborate with comments and notifications
Store and organize files in Google Drive, Box and Dropbox
Run workflows and automate actions

Connect Smartsheet#

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

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