Microsoft Excel

You can use Microsoft Graph to allow web and mobile applications to read and modify Excel workbooks stored in OneDrive for Business, SharePoint site or Group drive.

Integrate the Microsoft Excel API with the Google Calendar API

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

Add A Worksheet Tablerow with Microsoft Excel API on New Event Start from Google Calendar API
Google Calendar + Microsoft Excel
 
Try it
Update Worksheet Tablerow with Microsoft Excel API on New Event Start from Google Calendar API
Google Calendar + Microsoft Excel
 
Try it
Add A Worksheet Tablerow with Microsoft Excel API on New Upcoming Event Alert from Google Calendar API
Google Calendar + Microsoft Excel
 
Try it
Update Worksheet Tablerow with Microsoft Excel API on New Upcoming Event Alert from Google Calendar API
Google Calendar + Microsoft Excel
 
Try it
Add A Worksheet Tablerow with Microsoft Excel API on New Created or Updated Event (Instant) from Google Calendar API
Google Calendar + Microsoft Excel
 
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 Item Updated (Instant) from the Microsoft Excel API

Emit new event when an item is updated.

 
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
Add A Worksheet Tablerow with the Microsoft Excel API

Adds rows to the end of specific table. See the documentation

 
Try it
Update Worksheet Tablerow with the Microsoft Excel API

Update the properties of tablerow object. (Only for work or school account) 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
Delete an Event with the Google Calendar API

Delete an event to the Google Calendar. See the documentation

 
Try it

Overview of Microsoft Excel

The Microsoft Excel API on Pipedream allows you to automate spreadsheet tasks, manipulate data, and integrate Excel with other apps and services. Through Pipedream, you can create serverless workflows that react to events, perform operations on Excel files like reading, writing, updating cells, and managing worksheets. This API turns Excel into a powerful tool for data analysis, report generation, and task automation without manual intervention.

Connect Microsoft Excel

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: {
    microsoft_excel: {
      type: "app",
      app: "microsoft_excel",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://graph.microsoft.com/v1.0/me`,
      headers: {
        Authorization: `Bearer ${this.microsoft_excel.$auth.oauth_access_token}`,
      },
    })
  },
})

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?