Microsoft SQL Server

Unleash the power of your data—on-premises, in the cloud, or at the edge—and reveal insights to transform your business.

Integrate the Microsoft SQL Server API with the Google Calendar API

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

Execute Query with Microsoft SQL Server API on New Event Start from Google Calendar API
Google Calendar + Microsoft SQL Server
 
Try it
Execute SQL Query with Microsoft SQL Server API on New Event Start from Google Calendar API
Google Calendar + Microsoft SQL Server
 
Try it
Insert Row with Microsoft SQL Server API on New Event Start from Google Calendar API
Google Calendar + Microsoft SQL Server
 
Try it
Execute Query with Microsoft SQL Server API on New Upcoming Event Alert from Google Calendar API
Google Calendar + Microsoft SQL Server
 
Try it
Execute SQL Query with Microsoft SQL Server API on New Upcoming Event Alert from Google Calendar API
Google Calendar + Microsoft SQL Server
 
Try it
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 Column from the Microsoft SQL Server API

Triggers when a new column is added to a table. See the documentation

 
Try it
New Event Created from the Google Calendar API

Emit new event when a Google Calendar event is created

 
Try it
Execute Query with the Microsoft SQL Server API

Executes a SQL query and returns the results. See the documentation

 
Try it
Execute SQL Query with the Microsoft SQL Server API

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

 
Try it
Insert Row with the Microsoft SQL Server API

Inserts a new row in a table. See the documentation

 
Try it
Add Quick Event with the Google Calendar API

Create a quick event to the Google Calendar. See the documentation

 
Try it
Create Event with the Google Calendar API

Create an event to the Google Calendar. See the documentation

 
Try it

Overview of Microsoft SQL Server

With the Microsoft SQL Server API on Pipedream, you can automate your database operations and create powerful integrations. This API allows you to execute queries, manage databases, and trigger actions based on data changes. Implementing workflows that react to database events, manipulate data, or synchronize SQL Server data with other services, becomes effortless with Pipedream's serverless platform.

Connect Microsoft SQL Server

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
import sql from "mssql"
export default defineComponent({
  props: {
    microsoft_sql_server: {
      type: "app",
      app: "microsoft_sql_server",
    }
  },
  async run({steps, $}) {
    const { host, username, password, port, database, encrypt,trustServerCertificate } = this.microsoft_sql_server.$auth
    const conn_str = `Server=${host},${port};Database=${database};User Id=${username};Password=${password};Encrypt=${encrypt};TrustServerCertificate=${trustServerCertificate}`;
    await sql.connect(conn_str);
    return await sql.query`SELECT GETDATE()`
  },
})

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

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: {
    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
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?