What do you want to automate
with Google Appsheet and Google Dialogflow?
Prompt, edit and deploy AI agents that connect to Google Appsheet, Google Dialogflow and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Google Appsheet and Google Dialogflow Actions#
Adds a new row to a specific table in the AppSheet app. See the documentation
Deletes a specific row from a table in the AppSheet app. See the documentation
Batch create entities, See REST docs and client API docs
Read existing records in a table in the AppSheet app. See the documentation
Overview of Google Appsheet#
The Google Appsheet API enables programmatic interactions with your custom AppSheet applications, allowing you to streamline processes, automate actions, and interlink your apps with other services. Leveraging Pipedream's powerful serverless platform, you can create workflows that react to events in real-time, automate tasks, and connect to countless other services with minimal effort. Whether you're updating datasets, syncing with external systems, or triggering complex chains of actions, combining AppSheet with Pipedream can supercharge your productivity and enhance your app's capabilities.
Connect Google Appsheet#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_appsheet: {
type: "app",
app: "google_appsheet",
}
},
async run({steps, $}) {
const data = {
"Action": "Find",
"Properties": `{
"Locale": "en-US",
"Selector": "Filter(Sheet1, true)",
"Timezone":
"Pacific Standard Time"
}`,
}
return await axios($, {
method: "post",
url: `https://api.appsheet.com/api/v2/apps/${this.google_appsheet.$auth.app_id}/tables/{{your_table_here}}/Action`,
headers: {
"ApplicationAccessKey": `${this.google_appsheet.$auth.access_key}`,
},
data,
})
},
})
Overview of Google Dialogflow#
Google Dialogflow API empowers you to create conversational interfaces for websites, apps, and messaging platforms. Think chatbots that can engage in human-like dialogue, provide customer support, guide through sales processes, or control smart home devices with voice commands. With Pipedream's integration capabilities, you can create automated workflows that trigger actions in other apps based on Dialogflow's processed input, enabling seamless interaction across a plethora of services.
Connect Google Dialogflow#
module.exports = defineComponent({
props: {
google_dialogflow: {
type: "app",
app: "google_dialogflow",
}
},
async run({steps, $}) {
// Example code from the Dialogflow Node.js library:
// https://github.com/googleapis/nodejs-dialogflow
const dialogflow = require('dialogflow')
const uuid = require('uuid')
// A unique identifier for the given session
const sessionId = uuid.v4()
const key = JSON.parse(this.google_dialogflow.$auth.key_json)
// Creates a session client from a Google service account key.
const sessionClient = new dialogflow.SessionsClient({
projectId: key.project_id,
credentials: {
client_email: key.client_email,
private_key: key.private_key,
}
})
const sessionPath = sessionClient.sessionPath(key.project_id, sessionId)
// The text query request.
const request = {
session: sessionPath,
queryInput: {
text: {
// The query to send to the dialogflow agent
text: 'hello',
// The language used by the client (en-US)
languageCode: 'en-US',
},
},
}
// Send request and log result
const responses = await sessionClient.detectIntent(request)
console.log('Detected intent')
const result = responses[0].queryResult
console.log(`Query: ${result.queryText}`)
console.log(`Response: ${result.fulfillmentText}`)
if (result.intent) {
console.log(`Intent: ${result.intent.displayName}`)
} else {
console.log(`No intent matched.`)
}
},
})
Trusted by 1,000,000+ developers from startups to Fortune 500 companies