What do you want to automate
with Linear (OAuth) and Google Sheets?
Prompt, edit and deploy AI agents that connect to Linear (OAuth), Google Sheets and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Ways to Connect Linear (OAuth) with Google Sheets#
Popular Linear (OAuth) and Google Sheets Triggers#
Triggers instantly when a new comment is added to an issue in Linear. Returns comment details including content, author, issue reference, and timestamps. Supports filtering by team. Uses OAuth authentication. See Linear docs for additional info here
Triggers instantly when a new issue is created in Linear. Provides complete issue details including title, description, team, assignee, state, and timestamps. Supports filtering by team and project. Uses OAuth authentication. See Linear docs for additional info here
Triggers instantly when an issue's workflow state changes (e.g., Todo to In Progress). Returns issue with previous and current state info. Can filter by specific target state. Uses OAuth authentication. See Linear docs for additional info here
Triggers instantly when a project update (status report) is created in Linear. Returns update content, author, project details, and health status. Filters by team and optionally by project. Uses OAuth authentication. See Linear docs for additional info here
Triggers instantly when any issue is updated in Linear. Provides complete issue details with changes. Supports filtering by team and project. Includes all updates except status changes. Uses OAuth authentication. See Linear docs for additional info here
Popular Linear (OAuth) and Google Sheets Actions#
Add a single row of data to Google Sheets. See the documentation
Add multiple rows of data to a Google Sheet. See the documentation
Overview of Linear (OAuth)#
Linear (OAuth) API provides access to Linear's issue tracking and project management capabilities, letting you automate tasks, synchronize data across platforms, and enhance your team's productivity. Whether you're reporting bugs, assigning tasks, or tracking progress, the Linear API on Pipedream allows for real-time, event-driven workflows that can increase efficiency and foster collaboration within teams.
Connect Linear (OAuth)#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
linear: {
type: "app",
app: "linear",
}
},
async run({steps, $}) {
const data = {
"query": `{
user(id: "me") {
id
name
email
displayName
}
}`,
}
return await axios($, {
method: "post",
url: `https://api.linear.app/graphql`,
headers: {
Authorization: `Bearer ${this.linear.$auth.oauth_access_token}`,
"Content-Type": `application/json`,
},
data,
})
},
})
Overview of Google Sheets#
The Google Sheets API allows for the creation, reading, updating, and deletion of data within Google Sheets, enabling a robust platform for spreadsheet management and data manipulation. Through Pipedream, you can craft serverless workflows that respond to various triggers, such as webhook events, emails, or scheduled times, to interact with Google Sheets. This synergy can automate reporting, synchronize data across applications, manage inventory, track leads in a CRM, or even conduct survey analysis by updating and retrieving sheet data on the fly.
Connect Google Sheets#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_sheets: {
type: "app",
app: "google_sheets",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.googleapis.com/oauth2/v1/userinfo`,
headers: {
Authorization: `Bearer ${this.google_sheets.$auth.oauth_access_token}`,
},
})
},
})
Related Videos#
Community Posts#
Trusted by 1,000,000+ developers from startups to Fortune 500 companies