with CommPeak and Google Sheets?
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 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.
Get account information such as balance and tariffs. See the documentation
Add a single row of data to Google Sheets. See the documentation
Get results for a bulk lookup operation. See the documentation
Add multiple rows of data to a Google Sheet. See the documentation
Perform validation or lookup for a single phone number. See the documentation
The CommPeak API offers a suite of telecommunication services, such as sending SMS messages, making voice calls, and managing phone numbers. In Pipedream, harnessing this API lets you automate communication processes, integrate telephony features into your workflows, and connect them with other apps for enhanced functionality. Think of orchestrating SMS notifications based on certain triggers or automating call logs syncing to a database. CommPeak's capabilities, when combined with Pipedream's serverless platform, can streamline complex communication tasks and create powerful, event-driven automations.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
commpeak: {
type: "app",
app: "commpeak",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://hlr.commpeak.com/info`,
headers: {
"Accept": `application/json`,
"Authorization": `${this.commpeak.$auth.api_token}`,
},
})
},
})
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}`,
},
})
},
})