with SheetDB and Google Calendar?
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.
Emit new event when a Google Calendar events is created or updated (does not emit cancelled events)
Emit new event when a Google Calendar event is created that matches a search
Emit new event when a Google Calendar event is cancelled or deleted
Create rows in a Google Sheet using the SheetDB API. See the documentation
Deletes the specified row(s) in a SheetDB sheet by matching a column name and value. See the documentation
Get column names of a Google Sheet using the SheetDB API. See the documentation
Search for content in a Google Sheet using the SheetDB API. See the documentation
SheetDB API turns your Google Sheets into a JSON API, enabling you to manage the content within your spreadsheet through RESTful endpoints. With Pipedream, you can harness this capability to build robust automations and workflows that interact with your spreadsheet data dynamically. Whether you're updating rows based on external triggers, syncing data to other platforms, or building a makeshift CRM, SheetDB paired with Pipedream's zero-management execution environment lets you deploy these solutions rapidly.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
sheetdb: {
type: "app",
app: "sheetdb",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://sheetdb.io/api/v1/${this.sheetdb.$auth.api_id}`,
})
},
})
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.
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}`,
},
})
},
})