with Plaid and Google Appsheet?
Emit new event when there are new accounts available at the Financial Institution. See the documentation
Emit new event when there are changes to Plaid Items or the status of asynchronous processes. See the documentation
Emit new event when there are new updates available for a connected account. See the documentation
Exchange a Link public_token
for an API access_token
. See the documentation
Adds a new row to a specific table in the AppSheet app. See the documentation
Creates a valid public_token
for an arbitrary institution ID, initial products, and test credentials. See the documentation
Deletes a specific row from a table in the AppSheet app. See the documentation
Creates a user ID and token to be used with Plaid Check, Income, or Multi-Item Link flow. See the documentation
The Plaid API offers a multitude of financial data operations, enabling developers to manage and interact with user bank accounts, transactions, identity info, and more, all within a secure and compliant ecosystem. Integrating Plaid with Pipedream can unlock powerful automations, like syncing transaction data to accounting software, verifying user identities for KYC compliance, and automating financial alerts or reporting.
module.exports = defineComponent({
props: {
plaid: {
type: "app",
app: "plaid",
}
},
async run({steps, $}) {
const { Configuration, PlaidApi } = require('plaid');
const client = new PlaidApi(
new Configuration({
basePath: this.plaid.$auth.environment,
baseOptions: {
headers: {
'PLAID-CLIENT-ID': this.plaid.$auth.client_id,
'PLAID-SECRET': this.plaid.$auth.client_secret,
},
},
})
);
// Test request
const request = {
count: 10,
offset: 0,
country_codes: ['US'],
};
const response = await client.institutionsGet(request);
return response.data.institutions;
},
})
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.
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,
})
},
})