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 each time a comment is added to a spreadsheet.
Emit new event each time a row or rows are added to the bottom of a spreadsheet.
Emit new event each time a row or cell is updated in a spreadsheet.
Emit new event each time a new worksheet is created in a spreadsheet.
Add a single row of data to Google Sheets. See the documentation
This action returns a specific contact. The object email is either null when the email is not found, or contains an object with at least email (the email string) and the score. See the docs here
Add multiple rows of data to a Google Sheet. See the documentation
Search emails are based on the full name plus the domain or company name. When your account does not have sufficient credits an HTTP status code of 402 is returned. Also, take into consideration that we check the domain for its validity. So even if you provide a correct name+domain set, we may return a HTTP status code of 400 for the domain if we can't locate it. See the docs here
Get all values or values from a range of cells using A1 notation. See the documentation
The Google Sheets API allows for the creation, reading, updating, and deletion of data within Google Sheets, enabling a robust platform for spreadsheet management and data manipulation. Through Pipedream, you can craft serverless workflows that respond to various triggers, such as webhook events, emails, or scheduled times, to interact with Google Sheets. This synergy can automate reporting, synchronize data across applications, manage inventory, track leads in a CRM, or even conduct survey analysis by updating and retrieving sheet data on the fly.
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}`,
},
})
},
})
VoilaNorbert is a potent tool for finding and verifying email addresses. With its API, you can automate processes like enriching leads with verified contact information, streamlining your email outreach, and maintaining the health of your email lists. The API's main features include searching for email addresses based on names and domains, verifying email deliverability, and managing your contacts. When used within Pipedream, you can leverage these capabilities to create workflows that respond to events, integrate with other services, and process data in real time.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
voilanorbert: {
type: "app",
app: "voilanorbert",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.voilanorbert.com/2018-01-08/account/`,
auth: {
username: ``,
password: `${this.voilanorbert.$auth.api_key}`,
},
})
},
})