with Dropbox and Google Appsheet?
Emit new event when a new file is added to your account or a specific folder. Make sure the number of files/folders in the watched folder does not exceed 4000.
Emit new event when a new folder is created. Make sure the number of files/folders in the watched folder does not exceed 4000.
Emit new event when a file or folder is added or modified. Make sure the number of files/folders in the watched folder does not exceed 4000.
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
Creates a brand new text file from plain text content you specify. See the documentation
Read existing records in a table in the AppSheet app. See the documentation
The Dropbox API on Pipedream enables you to automate file and folder operations, streamlining workflows that involve storing, syncing, and sharing content. With this API, you can programmatically manage files, set up event-driven triggers based on changes within Dropbox, and leverage Pipedream's capabilities to connect with hundreds of other apps for extended automation scenarios. It's ideal for building custom file management solutions, archiving systems, or collaborative content workflows without writing extensive code.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
dropbox: {
type: "app",
app: "dropbox",
}
},
async run({steps, $}) {
const data = {
"account_id": `${this.dropbox.$auth.oauth_uid}`,
}
return await axios($, {
method: "post",
url: `https://api.dropboxapi.com/2/users/get_account`,
headers: {
Authorization: `Bearer ${this.dropbox.$auth.oauth_access_token}`,
"Content-Type": `application/json`,
},
data,
})
},
})
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,
})
},
})