Gumroad

E-commerce and audience-building software for creators

Integrate the Gumroad API with the MySQL API

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

Create Row with MySQL API on New Cancellation from Gumroad API
Gumroad + MySQL
 
Try it
Create Row with MySQL API on New Product from Gumroad API
Gumroad + MySQL
 
Try it
Create Row with MySQL API on New Refund from Gumroad API
Gumroad + MySQL
 
Try it
Create Row with MySQL API on New Sale from Gumroad API
Gumroad + MySQL
 
Try it
Delete Row with MySQL API on New Cancellation from Gumroad API
Gumroad + MySQL
 
Try it
New Cancellation from the Gumroad API

Emit new event on a sale is cancelled.

 
Try it
New Product from the Gumroad API

Emit new event on each new product.

 
Try it
New Refund from the Gumroad API

Emit new event on a sale is refunded.

 
Try it
New Sale from the Gumroad API

Emit new event on each new sale.

 
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
Create Row with the MySQL API

Adds a new row. See the docs here

 
Try it
Delete Row with the MySQL API

Delete an existing row. See the docs here

 
Try it
Execute Query with the MySQL API

Find row(s) via a custom query. See the docs here

 
Try it
Execute Raw Query with the MySQL API

Find row(s) via a custom raw query. See the documentation

 
Try it
Execute Stored Procedure with the MySQL API

Execute Stored Procedure. See the docs here

 
Try it

Overview of Gumroad

The Gumroad API lets you tap into your digital storefront with ease, enabling seamless automation of your e-commerce activities. It's a game-changer for creators and entrepreneurs who use Gumroad to sell products. With this API on Pipedream, you can automate tasks like order processing, customer management, and sales reporting. Imagine syncing new purchases with your CRM, sending custom thank-you emails post-purchase, or compiling sales data without lifting a finger. Pipedream's serverless platform turns these ideas into reality, connecting Gumroad to countless other apps with zero server maintenance.

Connect Gumroad

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: {
    gumroad: {
      type: "app",
      app: "gumroad",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.gumroad.com/v2/user`,
      headers: {
        Authorization: `Bearer ${this.gumroad.$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;
  },
});