with MySQL and Google Drive?
Emit new event when a change is made to one of the specified files. See the documentation
Watches for changes to specific files, emitting an event when a change is made to one of those files. To watch for changes to shared drive files, use the Changes to Specific Files (Shared Drive) source instead.
Watches for changes to specific files in a shared drive, emitting an event when a change is made to one of those files
Emit new event when you add or modify a new row in a table. See the docs here
Emit new event when new rows are returned from a custom query. See the docs here
Emit new event when a new table is added to a database. See the docs here
Emit new event when a new access proposal is requested in Google Drive
Emit new event when a new file is added in your linked Google Drive
Emit new event when a new file is added in your shared Google Drive
Emit new event when a comment is created or modified in the selected file
Emit new event when a file in the selected Drive is created, modified or trashed.
Emit new event when a folder is created or modified in the selected Drive
Emit new event each time a new presentation is created in a drive.
Emit new event when a new spreadsheet is created in a drive.
Add an unanchored comment to a Google Doc (general feedback, no text highlighting). See the documentation
Create a copy of the specified file. See the documentation for more information
Create a new empty folder. See the documentation for more information
Create a new Google Docs file from a template. Optionally include placeholders in the template document that will get replaced from this action. See documentation
Create a new file from plain text. See the documentation for more information
Create a new shared drive. See the documentation for more information
Delete a specific comment (Requires ownership or permissions). See the documentation
Permanently delete a file or folder without moving it to the trash. See the documentation for more information
Delete a shared drive without any content. See the documentation for more information
Search for a specific file by name. See the documentation for more information
Search for a specific folder by name. See the documentation for more information
List Google Form documents or search for a Form by name. See the documentation for more information
Search for a specific spreadsheet by name. See the documentation for more information
Retrieve Google Drive account metadata for the authenticated user via about.get
, including display name, email, permission ID, and storage quota. Useful when flows or agents need to confirm the active Google identity or understand available storage. See the documentation
Get info on a specific file. See the documentation for more information
Retrieve a folderId for a path. See the documentation for more information
Get metadata for one or all shared drives. See the documentation for more information
List access proposals for a file or folder. See the documentation
List files from a specific folder. See the documentation for more information
Move a file from one folder to another. See the documentation for more information
Move a file or folder to trash. See the documentation for more information
Accept or deny a request for access to a file or folder in Google Drive. See the documentation
Search for shared drives with query options. See the documentation for more information
Add a sharing permission to the sharing preferences of a file or folder and provide a sharing URL. See the documentation
Update a file's metadata and/or content. See the documentation for more information
Update an existing shared drive. See the documentation for more information
Upload a file to Google Drive. See the documentation for more information
The MySQL application on Pipedream enables direct interaction with your MySQL databases, allowing you to perform CRUD operations—create, read, update, delete—on your data with ease. You can leverage these capabilities to automate data synchronization, report generation, and event-based triggers that kick off workflows in other apps. With Pipedream's serverless platform, you can connect MySQL to hundreds of other services without managing infrastructure, crafting complex code, or handling authentication.
import mysql from '@pipedream/mysql'; export default defineComponent({ props: { mysql, }, async run({steps, $}) { // Component source code: // https://github.com/PipedreamHQ/pipedream/tree/master/components/mysql const queryObj = { sql: "SELECT NOW()", values: [], // Ignored since query does not contain placeholders }; return await this.mysql.executeQuery(queryObj); }, });
The Google Drive API on Pipedream allows you to automate various file management tasks, such as creating, reading, updating, and deleting files within your Google Drive. You can also share files, manage permissions, and monitor changes to files and folders. This opens up possibilities for creating workflows that seamlessly integrate with other apps and services, streamlining document handling, backup processes, and collaborative workflows.
import { axios } from "@pipedream/platform" export default defineComponent({ props: { google_drive: { type: "app", app: "google_drive", } }, async run({steps, $}) { return await axios($, { url: `https://www.googleapis.com/drive/v3/about?fields=user`, headers: { Authorization: `Bearer ${this.google_drive.$auth.oauth_access_token}`, }, }) }, })