Gmail (Developer App)

Private and secure email by Google at no cost, for business and consumer accounts. Use this app to connect your own developer account credentials.

Integrate the Gmail (Developer App) API with the MySQL API

Setup the Gmail (Developer App) API trigger to run a workflow which integrates with the MySQL API. Pipedream's integration platform allows you to integrate Gmail (Developer App) and MySQL remarkably fast. Free for developers.

Add Label to Email with Gmail (Developer App) API on New Column from MySQL API
MySQL + Gmail (Developer App)
 
Try it
Add Label to Email with Gmail (Developer App) API on New or Updated Row from MySQL API
MySQL + Gmail (Developer App)
 
Try it
Add Label to Email with Gmail (Developer App) API on New Row (Custom Query) from MySQL API
MySQL + Gmail (Developer App)
 
Try it
Add Label to Email with Gmail (Developer App) API on New Row from MySQL API
MySQL + Gmail (Developer App)
 
Try it
Add Label to Email with Gmail (Developer App) API on New Table from MySQL API
MySQL + Gmail (Developer App)
 
Try it
New Attachment Received from the Gmail (Developer App) API

Emit new event for each attachment in a message received. This source is capped at 100 max new messages per run.

 
Try it
New Email Received from the Gmail (Developer App) API

Emit new event when an email is received. This source is capped at 100 max new messages per run.

 
Try it
New Labeled Email from the Gmail (Developer App) API

Emit new event when a new email is labeled.

 
Try it
New Column from the MySQL API

Emit new event when you add a new column to a table. See the docs here

 
Try it
New Sent Email from the Gmail (Developer App) API

Emit new event for each new email sent. (Maximum of 300 events emited per execution)

 
Try it
Add Label to Email with the Gmail (Developer App) API

Add a label to an email message. See the docs

 
Try it
Create Row with the MySQL API

Adds a new row. See the docs here

 
Try it
Create Draft with the Gmail (Developer App) API

Create a draft from your Google Workspace email account

 
Try it
Delete Row with the MySQL API

Delete an existing row. See the docs here

 
Try it
Download Attachement with the Gmail (Developer App) API

Download an attachment by attachmentId to the /tmp directory. See the docs

 
Try it

Overview of Gmail (Developer App)

With the Gmail (Developer App) API on Pipedream, you can automate a variety of email-related tasks, directly manipulating your Gmail account to streamline workflows. From sending emails programmatically to parsing new inbound messages for data extraction, the API allows for deep interaction with your Gmail inbox. Use cases include automating follow-ups, organizing your inbox with filters and labels, and synchronizing important email events with other services to act upon new information instantly.

Connect Gmail (Developer App)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    gmail_custom_oauth: {
      type: "app",
      app: "gmail_custom_oauth",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://www.googleapis.com/oauth2/v1/userinfo`,
      headers: {
        Authorization: `Bearer ${this.gmail_custom_oauth.$auth.oauth_access_token}`,
      },
    })
  },
})

Overview of MySQL

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.

Connect MySQL

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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
    };
    const { rows } = await this.mysql.executeQuery(queryObj);
    return rows;
  },
});