With Google Sheets, you can create, edit, and collaborate wherever you are
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.
The Company Name to Domain action lets you convert the exact name of a company to a website domain, and a logo. See the docs here.
The Company API allows you to look up a company by their domain. See the docs here.
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}`,
},
})
},
})
Clearbit provides APIs that allow you to retrieve information about companies
and people. This information can be used to build applications that perform
functions such as identifying potential customers, conducting due diligence, or
fraud prevention.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
clearbit: {
type: "app",
app: "clearbit",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://person.clearbit.com/v1/people/email/alex@alexmaccaw.com`,
headers: {
Authorization: `Bearer ${this.clearbit.$auth.secret_api_key}`,
},
})
},
})