Integrate the Google Calendar API with the MySQL API

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

Start for free — no credit card required

Watch a demo

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Popular Ways to Connect Google Calendar with MySQL#

Create Row with MySQL API on Upcoming Event Alert from Google Calendar API

Google Calendar + MySQL

Try it

Delete Row with MySQL API on Upcoming Event Alert from Google Calendar API

Google Calendar + MySQL

Try it

Execute Query with MySQL API on Upcoming Event Alert from Google Calendar API

Google Calendar + MySQL

Try it

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

Google Calendar + MySQL

Try it

Execute Stored Procedure with MySQL API on Upcoming Event Alert from Google Calendar API

Google Calendar + MySQL

Try it

Popular Google Calendar and MySQL Triggers#

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 Calendar Created from the Google Calendar API

Emit new event when a calendar is created.

Try it

New Event Matching a Search from the Google Calendar API

Emit new event when a Google Calendar event is created that matches a search

Try it

New Cancelled Event from the Google Calendar API

Emit new event when a Google Calendar event is cancelled or deleted

Try it

Popular Google Calendar and MySQL Actions#

Execute SQL Query with the MySQL API

Execute a custom MySQL query. See our docs to learn more about working with SQL in Pipedream.

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 Stored Procedure with the MySQL API

Execute Stored Procedure. See the docs here

Try it

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/users/me/settings`,
      headers: {
        Authorization: `Bearer ${this.google_calendar.$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#

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

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?

Start for free — no credit card required

Watch a demo