With Google Sheets, you can create, edit, and collaborate wherever you are
Emit an event for each new or modified record in a table
Emit an event for each new or modified record in a view
Emits an event each time a record is added, updated, or deleted in an Airtable table. Supports tables up to 10,000 records
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}`,
},
})
},
})
Using the Airtable API, you can build applications that can:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
airtable: {
type: "app",
app: "airtable",
},
baseId: {
type: "$.airtable.baseId",
appProp: "airtable",
},
tableId: {
type: "$.airtable.tableId",
baseIdProp: "baseId",
},
},
async run({steps, $}) {
return await axios($, {
url: `https://api.airtable.com/v0/${this.baseId}/${this.tableId}`,
headers: {
Authorization: `Bearer ${this.airtable.$auth.api_key}`,
"accept": `application/json`,
},
})
}
})