What do you want to automate

with Smartsheet and Google Calendar?

Prompt, edit and deploy AI agents that connect to Smartsheet, Google Calendar and 2,500+ other apps in seconds.

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

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Add Row to Sheet with Smartsheet API on Upcoming Event Alert from Google Calendar API
Google Calendar + Smartsheet
 
Try it
New Sheet From Template with Smartsheet API on Upcoming Event Alert from Google Calendar API
Google Calendar + Smartsheet
 
Try it
Update Row with Smartsheet API on Upcoming Event Alert from Google Calendar API
Google Calendar + Smartsheet
 
Try it
Add Row to Sheet with Smartsheet API on New or Updated Event (Instant) from Google Calendar API
Google Calendar + Smartsheet
 
Try it
New Sheet From Template with Smartsheet API on New or Updated Event (Instant) from Google Calendar API
Google Calendar + Smartsheet
 
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 Comment Added (Instant) from the Smartsheet API

Emit new event when a comment is added in a sheet.

 
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 Row Added (Instant) from the Smartsheet API

Emit new event when a row is added to a sheet.

 
Try it
New Calendar Created from the Google Calendar API

Emit new event when a calendar is created.

 
Try it
Add Row to Sheet with the Smartsheet API

Adds a row to a sheet. See docs here

 
Try it
New Sheet From Template with the Smartsheet API

Creates a new sheet from a template. See docs here

 
Try it
Update Row with the Smartsheet API

Updates a row in a sheet. See docs here

 
Try it
Add Attendees To Event with the Google Calendar API

Add attendees to an existing event. 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
Integrate the Smartsheet API with the Google Calendar API
Setup the Smartsheet API trigger to run a workflow which integrates with the Google Calendar API. Pipedream's integration platform allows you to integrate Smartsheet and Google Calendar remarkably fast. Free for developers.

Overview of Smartsheet

The Smartsheet API unlocks the power of managing and automating complex workflows, directly interacting with Smartsheet's features such as sheets, rows, columns, and attachments. You can create, read, update, and delete sheets, share them with others, and extract complex data reports. Leveraging the API on Pipedream allows for seamless integration with other services for enhanced productivity and data management. Whether you're orchestrating an approval process, syncing data across platforms, or automating project tracking, the Smartsheet API pairs with Pipedream's serverless platform to build powerful, scalable, and automated workflows.

Connect Smartsheet

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: {
    smartsheet: {
      type: "app",
      app: "smartsheet",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.smartsheet.com/2.0/users/me`,
      headers: {
        Authorization: `Bearer ${this.smartsheet.$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/oauth2/v1/userinfo`,
      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?

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

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo