The intelligent way to create and pay bills, send invoices, and get paid. Get started with BILL.
Emit new events each time a row or rows are added to the bottom of a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Row Added (Shared Drive, Instant) source instead.
Emit new events each time a row or rows are added to the bottom of a spreadsheet in a shared drive
Emit new event each time a row or cell is updated in a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Updates (Shared Drive, Instant) source instead.
Emit new event each time a row or cell is updated in a spreadsheet in a shared drive
Emit new event each time a new worksheet is created in a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Worksheet (Shared Drive, Instant) source instead.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
bill: {
type: "app",
app: "bill",
}
},
async run({steps, $}) {
const data = {
"devKey": `${this.bill.$auth.developer_key}`,
"sessionId": `${this.bill.$auth.sessionId}`,
}
return await axios($, {
method: "post",
url: `https://${this.bill.$auth.environment}.bill.com/api/v2/GetSessionInfo.json`,
data,
})
},
})
Some examples of things you can build using the Google Sheets API include:
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}`,
},
})
},
})