Customer-Facing Analytics
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.
Datawaves is a powerful API that enables developers to easily and efficiently
access data from a variety of sources. With Datawaves, you can easily connect
to and query data from popular data sources such as Amazon Redshift, Google
BigQuery, and Microsoft SQL Server.
In addition, Datawaves provides a number of features that make it easy to work
with data, including:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
datawaves: {
type: "app",
app: "datawaves",
}
},
async run({steps, $}) {
const data = {
"id": `123`,
"product": `iPhone Charger`,
}
return await axios($, {
method: "post",
url: `https://datawaves.io/api/v1.0/projects/${this.datawaves.$auth.project_id}/events/test`,
headers: {
"Authorization": `${this.datawaves.$auth.secret_key}`,
},
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}`,
},
})
},
})