Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Emit new event when a new file is added to your account or a specific folder. Make sure the number of files/folders in the watched folder does not exceed 4000.
Emit new event when a new folder is created. Make sure the number of files/folders in the watched folder does not exceed 4000.
Emit new event when a file or folder is added or modified. Make sure the number of files/folders in the watched folder does not exceed 4000.
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
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}`,
},
})
},
})
With the Dropbox API, you can build a variety of applications that range from
simple file sharing to complex content management systems. Some examples of
what you can build using the Dropbox API include:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
dropbox: {
type: "app",
app: "dropbox",
}
},
async run({steps, $}) {
const data = {
"account_id": `${this.dropbox.$auth.oauth_uid}`,
}
return await axios($, {
method: "post",
url: `https://api.dropboxapi.com/2/users/get_account`,
headers: {
Authorization: `Bearer ${this.dropbox.$auth.oauth_access_token}`,
"Content-Type": `application/json`,
},
data,
})
},
})