Integrate the MySQL API with the Google Calendar API

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

Popular Ways to Connect MySQL with Google Calendar#

Create Row with MySQL API on Event Start from Google Calendar API

Google Calendar + MySQL

Try it

Delete Row with MySQL API on Event Start from Google Calendar API

Google Calendar + MySQL

Try it

Execute Query with MySQL API on Event Start from Google Calendar API

Google Calendar + MySQL

Try it

Execute Raw Query with MySQL API on New Event Start from Google Calendar API

Google Calendar + MySQL

Try it

Execute Stored Procedure with MySQL API on Event Start from Google Calendar API

Google Calendar + MySQL

Try it

Popular MySQL and Google Calendar Triggers#

New Event Start from the Google Calendar API

Emit new event when the specified time before the Google Calendar event starts

Try it

New Upcoming Event Alert from the Google Calendar API

Emit new event based on a time interval before an upcoming event in the calendar. This source uses Pipedream's Task Scheduler. See the documentation for more information and instructions for connecting your Pipedream account.

Try it

New Created or Updated Event (Instant) from the Google Calendar API

Emit new event when a Google Calendar events is created or updated (does not emit cancelled events)

Try it

New Event Created from the Google Calendar API

Emit new event when a Google Calendar event is created

Try it

New Calendar Created from the Google Calendar API

Emit new event when a calendar is created.

Try it

Popular MySQL and Google Calendar Actions#

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 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#

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;
  },
});

Overview of Google Calendar#

The Google Calendar API lets you dip into the powerhouse of scheduling, allowing for the reading, creation, and manipulation of events and calendars directly from your applications. Through Pipedream, you can seamlessly integrate Google Calendar into a myriad of workflows, automating event management, syncing with other services, setting up custom reminders, or even collating data for reporting. The key here is to streamline your calendar-related processes, ensuring that your time management is as efficient and automated as possible.

Connect Google Calendar#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    google_calendar: {
      type: "app",
      app: "google_calendar",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://www.googleapis.com/calendar/v3/calendars/primary`,
      headers: {
        Authorization: `Bearer ${this.google_calendar.$auth.oauth_access_token}`,
      },
    })
  },
})

Community Posts#

Adding Google Calendar to Your Jamstack - with Pipedream

Late last year (remember last year - sigh) I wrote up a post demonstrating how to integrate Google Calendar into your static web site: "Adding Google Calendar to your JAMStack". In that article, I describe how I used Google's Node libraries to read my event data. While it was mostly painless, authentication was a bit difficult to figure out. A few days I was thinking about this usecase and realized I could probably do it a lot easier making use of Pipedream. How so? Don't forget that Nelify lets you create a build hook. This is a unique URL that when hit with a POST request will trigger a new build. In theory, all I have to do is create a Pipedream workflow that's fired on new events. How is that done?