← Google Drive + Formatting integrations

[Date/Time] Add/Subtract Time with Formatting API on Changes to Specific Files from Google Drive API

Pipedream makes it easy to connect APIs for Formatting, Google Drive and 3,000+ other apps remarkably fast.

Trigger workflow on
Changes to Specific Files from the Google Drive API
Next, do this
[Date/Time] Add/Subtract Time with the Formatting API
No credit card required
Intro to Pipedream
Watch us build a workflow
Watch us build a workflow
8 min
Watch now ➜

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

Developers Pipedream

Getting Started

This integration creates a workflow with a Google Drive trigger and Formatting action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

  1. Select this integration
  2. Configure the Changes to Specific Files trigger
    1. Configure infoAlert
    2. Connect your Google Drive account
    3. Optional- Configure Drive
    4. Configure Push notification renewal schedule
    5. Select one or more Files
    6. Optional- Configure Include Link
    7. Optional- Configure dir
    8. Configure intervalAlert
    9. Optional- Configure Minimum Interval Per File
    10. Select one or more Types of updates
  3. Configure the [Date/Time] Add/Subtract Time action
    1. Connect your Formatting account
    2. Configure Input Date
    3. Optional- Select a Input Format
    4. Select a Operation
    5. Configure Duration
    6. Optional- Select a Output Format
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. Turn on the trigger

Details

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger

Description:Watches for changes to specific files, emitting an event when a change is made to one of those files. To watch for changes to [shared drive](https://support.google.com/a/users/answer/9310351) files, use the **Changes to Specific Files (Shared Drive)** source instead.
Version:0.3.2
Key:google_drive-changes-to-specific-files

Google Drive Overview

The Google Drive API on Pipedream allows you to automate various file management tasks, such as creating, reading, updating, and deleting files within your Google Drive. You can also share files, manage permissions, and monitor changes to files and folders. This opens up possibilities for creating workflows that seamlessly integrate with other apps and services, streamlining document handling, backup processes, and collaborative workflows.

Trigger Code

import cronParser from "cron-parser"; import includes from "lodash/includes.js"; import { v4 as uuid } from "uuid"; import { MY_DRIVE_VALUE } from "../../common/constants.mjs"; import changesToSpecificFiles from "../changes-to-specific-files-shared-drive/changes-to-specific-files-shared-drive.mjs"; import { ConfigurationError } from "@pipedream/platform"; import sampleEmit from "./test-event.mjs"; /** * This source uses the Google Drive API's * {@link https://developers.google.com/drive/api/v3/reference/files/watch files: watch} * endpoint to subscribe to changes to specific files in the user's drive. */ export default { ...changesToSpecificFiles, key: "google_drive-changes-to-specific-files", name: "Changes to Specific Files", description: "Watches for changes to specific files, emitting an event when a change is made to one of those files. To watch for changes to [shared drive](https://support.google.com/a/users/answer/9310351) files, use the **Changes to Specific Files (Shared Drive)** source instead.", version: "0.3.2", type: "source", // Dedupe events based on the "x-goog-message-number" header for the target channel: // https://developers.google.com/drive/api/v3/push#making-watch-requests dedupe: "unique", props: { infoAlert: { type: "alert", alertType: "info", content: "This source uses `files.watch` and supports up to 10 file subscriptions. To watch for changes to more than 10 files, use the **Changes to Files in Drive** source instead (uses `changes.watch`).", }, ...changesToSpecificFiles.props, drive: { type: "string", label: "Drive", description: "Defaults to `My Drive`. To use a [Shared Drive](https://support.google.com/a/users/answer/9310351), use the **Changes to Specific Files (Shared Drive)** source instead.", optional: true, default: MY_DRIVE_VALUE, }, updateTypes: { propDefinition: [ changesToSpecificFiles.props.googleDrive, "updateTypes", ], }, includeLink: { label: "Include Link", type: "boolean", description: "Upload file to your File Stash and emit temporary download link to the file. Google Workspace documents will be converted to PDF. See [the docs](https://pipedream.com/docs/connect/components/files) to learn more about working with files in Pipedream.", default: false, optional: true, }, dir: { type: "dir", accessMode: "write", optional: true, }, }, hooks: { ...changesToSpecificFiles.hooks, async deploy() { if (this.files.length > 10) { throw new ConfigurationError("This source only supports up to 10 files"); } await changesToSpecificFiles.hooks.deploy.bind(this)(); }, async activate() { // Called when a component is created or updated. Handles all the logic // for starting and stopping watch notifications tied to the desired // files. // You can pass the same channel ID in watch requests for multiple files, so // our channel ID is fixed for this component to simplify the state we have to // keep track of. const channelID = uuid(); // Subscriptions are keyed on Google's resourceID, "an opaque value that // identifies the watched resource". This value is included in request // headers, allowing us to look up the watched resource. let subscriptions = this._getSubscriptions() || {}; const files = this.files; for (const fileID of files) { const { expiration, resourceId, } = await this.googleDrive.activateFileHook( channelID, this.http.endpoint, fileID, ); // The fileID must be kept with the subscription metadata so we can // renew the watch request for this specific file when it expires. subscriptions[resourceId] = { expiration, fileID, }; } // Save metadata on the subscription so we can stop / renew later this._setSubscriptions(subscriptions); this._setChannelID(channelID); }, async deactivate() { const channelID = this._getChannelID(); if (!channelID) { console.log( "Channel not found, cannot stop notifications for non-existent channel", ); return; } const subscriptions = this._getSubscriptions() || {}; for (const resourceId of Object.keys(subscriptions)) { await this.googleDrive.stopNotifications(channelID, resourceId); } // Reset DB state this._setSubscriptions({}); this._setChannelID(null); }, }, methods: { ...changesToSpecificFiles.methods, _getSubscriptions() { return this.db.get("subscriptions") || {}; }, _setSubscriptions(subscriptions) { this.db.set("subscriptions", subscriptions); }, _getNextTimerEventTimestamp(event) { if (event.cron) { return cronParser .parseExpression(event.cron) .next() .getTime(); } if (event.interval_seconds) { return Date.now() + event.interval_seconds * 1000; } }, async renewFileSubscriptions(event) { const subscriptions = this._getSubscriptions() || {}; const channelID = this._getChannelID(); const newChannelID = uuid(); const nextRunTimestamp = this._getNextTimerEventTimestamp(event); for (const [ currentResourceId, metadata, ] of Object.entries(subscriptions)) { const { fileID } = metadata; const subscription = { ...metadata, resourceId: currentResourceId, }; const { expiration, resourceId, } = await this.googleDrive.renewFileSubscription( subscription, this.http.endpoint, channelID, newChannelID, fileID, nextRunTimestamp, ); subscriptions[resourceId] = { expiration, fileID, }; } this._setSubscriptions(subscriptions); this._setChannelID(newChannelID); }, }, async run(event) { // This function is polymorphic: it can be triggered as a cron job, to make sure we renew // watch requests for specific files, or via HTTP request (the change payloads from Google) // Component was invoked by timer if (event.timestamp) { return this.renewFileSubscriptions(event); } const channelID = this._getChannelID(); let subscriptions = this._getSubscriptions() || {}; const { headers } = event; if ( !headers["x-goog-resource-state"] || !headers["x-goog-resource-id"] || !headers["x-goog-resource-uri"] || !headers["x-goog-message-number"] ) { console.log("Request missing necessary headers: ", headers); return; } const incomingChannelID = headers["x-goog-channel-id"]; if (incomingChannelID !== channelID) { console.log( `Channel ID of ${incomingChannelID} not equal to deployed component channel of ${channelID}`, ); return; } if (subscriptions[headers["x-goog-resource-id"]] === undefined) { console.log( `Resource ID of ${headers["x-goog-resource-id"]} not currently being tracked. Exiting`, ); return; } if (!includes(this.updateTypes, headers["x-goog-resource-state"])) { console.log( `Update type ${headers["x-goog-resource-state"]} not in list of updates to watch: `, this.updateTypes, ); return; } // We observed false positives where a single change to a document would trigger two changes: // one to "properties" and another to "content,properties". But changes to properties // alone are legitimate, most users just won't want this source to emit in those cases. // If x-goog-changed is _only_ set to "properties", only move on if the user set the prop if ( !this.watchForPropertiesChanges && headers["x-goog-changed"] === "properties" ) { console.log( "Change to properties only, which this component is set to ignore. Exiting", ); return; } const file = await this.googleDrive.getFileMetadata( headers["x-goog-resource-uri"], ); if (!file || !Object.keys(file).length) { console.log("No file metadata returned, nothing to emit"); return; } const [ checkedFile, ] = this.checkMinimumInterval([ file, ]); if (checkedFile) { await this.processChange(file, headers); } }, sampleEmit, }; 

Trigger Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.
LabelPropTypeDescription
Google DrivegoogleDriveappThis component uses the Google Drive app.
N/Adb$.service.dbThis component uses $.service.db to maintain state between executions.
N/Ahttp$.interface.httpThis component uses $.interface.http to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the run() method of the component.
Drivedrivestring

Defaults to My Drive. To use a Shared Drive, use the Changes to Specific Files (Shared Drive) source instead.

Filesfilesstring[]Select a value from the drop down menu.
Include LinkincludeLinkboolean

Upload file to your File Stash and emit temporary download link to the file. Google Workspace documents will be converted to PDF. See the docs to learn more about working with files in Pipedream.

dirdir
Minimum Interval Per FileperFileIntervalinteger

How many minutes to wait until the same file can emit another event.

If set to 0, this interval is disabled and all events will be emitted.

Types of updatesupdateTypesstring[]Select a value from the drop down menu:{ "label": "'sync' - A channel was successfully created. You can expect to start receiving notifications for it.", "value": "sync" }{ "label": "'add' - A resource was created or shared.", "value": "add" }{ "label": "'remove' - An existing resource was deleted or unshared.", "value": "remove" }{ "label": "'update' - One or more properties (metadata) of a resource have been updated.", "value": "update" }{ "label": "'trash' - A resource has been moved to the trash.", "value": "trash" }{ "label": "'untrash' - A resource has been removed from the trash.", "value": "untrash" }{ "label": "'change' - One or more changelog items have been added.", "value": "change" }

Trigger Authentication

Google Drive uses OAuth authentication. When you connect your Google Drive account, Pipedream will open a popup window where you can sign into Google Drive and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Google Drive API.

Pipedream requests the following authorization scopes when you connect your account:

https://www.googleapis.com/auth/drive

About Google Drive

Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.

Action

Description:Add or subtract time from a given input
Version:0.0.6
Key:formatting-add-subtract-time

Action Code

import { defineAction } from "@pipedream/types"; import { ConfigurationError } from "@pipedream/platform"; import app from "../../app/formatting.app.mjs"; import commonDateTime from "../../common/date-time/commonDateTime.mjs"; import { DATE_FORMAT_PARSE_MAP, DEFAULT_FORMAT_VALUE, } from "../../common/date-time/dateFormats.mjs"; import { DATE_TIME_UNITS } from "../../common/date-time/dateTimeUnits.mjs"; import sugar from "sugar"; const OPERATION_OPTIONS = { ADD: "Add", SUBTRACT: "Subtract", }; export default defineAction({ ...commonDateTime, name: "[Date/Time] Add/Subtract Time", description: "Add or subtract time from a given input", key: "formatting-add-subtract-time", version: "0.0.6", annotations: { destructiveHint: false, openWorldHint: true, readOnlyHint: false, }, type: "action", props: { ...commonDateTime.props, operation: { label: "Operation", description: "Whether to add or subtract time.", type: "string", options: Object.values(OPERATION_OPTIONS), }, duration: { label: "Duration", description: "The duration for the operation. You can use the shorthand duration, for example: `1s`, `1m`, `1h`, `1d`, `1w`, `1y` equal one second, minute, hour, day, week, and year respectively", type: "string", }, outputFormat: { propDefinition: [ app, "outputFormat", ], }, }, methods: { ...commonDateTime.methods, getOperationMilliseconds(str) { let result = 0; const { second, minute, hour, day, week, year, } = DATE_TIME_UNITS; Object.entries({ s: second, m: minute, h: hour, d: day, w: week, y: year, }).forEach(([identifier, multiplier,]) => { const substr = str.match(new RegExp(`[0-9]+\\s*${identifier}`))?.[0]; if (substr) { const value = Number(substr.match(/[0-9]+/)); result += value * multiplier; } }); return result; }, }, async run({ $ }) { const { operation, duration, outputFormat, } = this; const dateObj = this.getDateFromInput(); const value = dateObj.valueOf(); let amount = this.getOperationMilliseconds(duration); if (operation === OPERATION_OPTIONS.SUBTRACT) amount *= -1; const result = value + amount; const format = outputFormat ?? this.inputFormat ?? DEFAULT_FORMAT_VALUE; try { const { outputFn } = DATE_FORMAT_PARSE_MAP.get(format); const output = outputFn(sugar.Date.create(result)); $.export("$summary", `Successfully ${operation === OPERATION_OPTIONS.SUBTRACT ? "subtracted" : "added"} time`); return output; } catch (err) { console.log("Error parsing date", err); throw new ConfigurationError("**Parse error** - check your input and if the selected format is correct."); } }, }); 

Action Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

LabelPropTypeDescription
FormattingappappThis component uses the Formatting app.
Input DateinputDatestring

A valid date string, in the format selected in Input Format. If the format is not set, Pipedream will attempt to infer it using the parser from Sugar Date library

Input FormatinputFormatstringSelect a value from the drop down menu:Sun Jan 22 23:04:05 +0000 2006January 22 2006 23:04:05January 22 2006Jan 22 20062006-01-22T23:04:052006-01-22T23:04:05+00002006-01-22 23:04:05 +00002006-01-22 23:042006-01-2201-22-200601/22/200601/22/0622-01-200622/01/200622/01/06Unix time (seconds) Eg. 1137971045Unix time (milliseconds) Eg. 1137971045000
OperationoperationstringSelect a value from the drop down menu:AddSubtract
Durationdurationstring

The duration for the operation. You can use the shorthand duration, for example: 1s, 1m, 1h, 1d, 1w, 1y equal one second, minute, hour, day, week, and year respectively

Output FormatoutputFormatstringSelect a value from the drop down menu:Sun Jan 22 23:04:05 +0000 2006January 22 2006 23:04:05January 22 2006Jan 22 20062006-01-22T23:04:052006-01-22T23:04:05+00002006-01-22 23:04:05 +00002006-01-22 23:042006-01-2201-22-200601/22/200601/22/0622-01-200622/01/200622/01/06Unix time (seconds) Eg. 1137971045Unix time (milliseconds) Eg. 1137971045000

Action Authentication

The Formatting API does not require authentication.

About Formatting

Pre-built actions to make formatting and manipulating data within your workflows easier.

More Ways to Connect Formatting + Google Drive

[Date/Time] Add/Subtract Time with Formatting API on New Presentation (Instant) from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Compare Dates with Formatting API on New Presentation (Instant) from Google Drive API
Google Drive + Formatting
 
Try it
[Text] Convert HTML to Markdown with Formatting API on New Presentation (Instant) from Google Drive API
Google Drive + Formatting
 
Try it
[Data] Convert JSON to String with Formatting API on New Presentation (Instant) from Google Drive API
Google Drive + Formatting
 
Try it
[Text] Convert Markdown to HTML with Formatting API on New Presentation (Instant) from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Add/Subtract Time with Formatting API on Changes to Specific Files (Shared Drive) from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Add/Subtract Time with Formatting API on New Files (Instant) from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Add/Subtract Time with Formatting API on New or Modified Comments from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Add/Subtract Time with Formatting API on New or Modified Files from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Add/Subtract Time with Formatting API on New or Modified Folders from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Add/Subtract Time with Formatting API on New Shared Drive from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Add/Subtract Time with Formatting API on New Spreadsheet (Instant) from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Format with Formatting API on New Presentation (Instant) from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Compare Dates with Formatting API on Changes to Specific Files (Shared Drive) from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Compare Dates with Formatting API on Changes to Specific Files from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Compare Dates with Formatting API on New Files (Instant) from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Compare Dates with Formatting API on New or Modified Comments from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Compare Dates with Formatting API on New or Modified Files from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Compare Dates with Formatting API on New or Modified Folders from Google Drive API
Google Drive + Formatting
 
Try it
[Date/Time] Compare Dates with Formatting API on New Shared Drive from Google Drive API
Google Drive + Formatting
 
Try it
Changes to Files in Drive from the Google Drive API

Emit new event when a change is made to one of the specified files. See the documentation

 
Try it
Changes to Specific Files from the Google Drive API

Watches for changes to specific files, emitting an event when a change is made to one of those files. To watch for changes to shared drive files, use the Changes to Specific Files (Shared Drive) source instead.

 
Try it
Changes to Specific Files (Shared Drive) from the Google Drive API

Watches for changes to specific files in a shared drive, emitting an event when a change is made to one of those files

 
Try it
New Access Proposal from the Google Drive API

Emit new event when a new access proposal is requested in Google Drive

 
Try it
New Files (Instant) from the Google Drive API

Emit new event when a new file is added in your linked Google Drive

 
Try it
New Files (Shared Drive) from the Google Drive API

Emit new event when a new file is added in your shared Google Drive

 
Try it
New or Modified Comments (Instant) from the Google Drive API

Emit new event when a comment is created or modified in the selected file

 
Try it
New or Modified Files (Instant) from the Google Drive API

Emit new event when a file in the selected Drive is created, modified or trashed.

 
Try it
New or Modified Files (Polling) from the Google Drive API

Emit new event when a file in the selected Drive is created, modified or trashed. See the documentation

 
Try it
New or Modified Folders (Instant) from the Google Drive API

Emit new event when a folder is created or modified in the selected Drive

 
Try it
New Presentation (Instant) from the Google Drive API

Emit new event each time a new presentation is created in a drive.

 
Try it
New Shared Drive from the Google Drive API

Emits a new event any time a shared drive is created.

 
Try it
New Spreadsheet (Instant) from the Google Drive API

Emit new event when a new spreadsheet is created in a drive.

 
Try it
Add Comment with the Google Drive API

Add an unanchored comment to a Google Doc (general feedback, no text highlighting). See the documentation

 
Try it
Copy File with the Google Drive API

Create a copy of the specified file. See the documentation for more information

 
Try it
Create Folder with the Google Drive API

Create a new empty folder. See the documentation for more information

 
Try it
Create New File From Template with the Google Drive API

Create a new Google Docs file from a template. Optionally include placeholders in the template document that will get replaced from this action. See documentation

 
Try it
Create New File From Text with the Google Drive API

Create a new file from plain text. See the documentation for more information

 
Try it
Create Shared Drive with the Google Drive API

Create a new shared drive. See the documentation for more information

 
Try it
Delete Comment with the Google Drive API

Delete a specific comment (Requires ownership or permissions). See the documentation

 
Try it
Delete File with the Google Drive API

Permanently delete a file or folder without moving it to the trash. See the documentation for more information

 
Try it
Delete Reply with the Google Drive API

Delete a reply on a specific comment. See the documentation for more information

 
Try it
Delete Shared Drive with the Google Drive API

Delete a shared drive without any content. See the documentation for more information

 
Try it
Download File with the Google Drive API

Download a file. See the documentation for more information

 
Try it
Find File with the Google Drive API

Search for a specific file by name. See the documentation for more information

 
Try it
Find Folder with the Google Drive API

Search for a specific folder by name. See the documentation for more information

 
Try it
Find Forms with the Google Drive API

List Google Form documents or search for a Form by name. See the documentation for more information

 
Try it
Find Spreadsheets with the Google Drive API

Search for a specific spreadsheet by name. See the documentation for more information

 
Try it
Get Comment By ID with the Google Drive API

Get comment by ID on a specific file. See the documentation for more information

 
Try it
Get Current User with the Google Drive API

Retrieve Google Drive account metadata for the authenticated user via about.get, including display name, email, permission ID, and storage quota. Useful when flows or agents need to confirm the active Google identity or understand available storage. See the documentation

 
Try it
Get File By ID with the Google Drive API

Get info on a specific file. See the documentation for more information

 
Try it
Get Folder ID for a Path with the Google Drive API

Retrieve a folderId for a path. See the documentation for more information

 
Try it
Get Reply By ID with the Google Drive API

Get reply by ID on a specific comment. See the documentation for more information

 
Try it
Get Shared Drive with the Google Drive API

Get metadata for one or all shared drives. See the documentation for more information

 
Try it
List Access Proposals with the Google Drive API

List access proposals for a file or folder. See the documentation

 
Try it
List Comments with the Google Drive API

List all comments on a file. See the documentation

 
Try it
List Files with the Google Drive API

List files from a specific folder. See the documentation for more information

 
Try it
List Replies with the Google Drive API

List replies to a specific comment. See the documentation for more information

 
Try it
Move File with the Google Drive API

Move a file from one folder to another. See the documentation for more information

 
Try it
Move File to Trash with the Google Drive API

Move a file or folder to trash. See the documentation for more information

 
Try it
Reply to Comment with the Google Drive API

Add a reply to an existing comment. See the documentation

 
Try it
Resolve Access Proposals with the Google Drive API

Accept or deny a request for access to a file or folder in Google Drive. See the documentation

 
Try it
Resolve Comment with the Google Drive API

Mark a comment as resolved. See the documentation

 
Try it
Search for Shared Drives with the Google Drive API

Search for shared drives with query options. See the documentation for more information

 
Try it
Share File or Folder with the Google Drive API

Add a sharing permission to the sharing preferences of a file or folder and provide a sharing URL. See the documentation

 
Try it
Update Comment with the Google Drive API

Update the content of a specific comment. See the documentation for more information

 
Try it
Update File with the Google Drive API

Update a file's metadata and/or content. See the documentation for more information

 
Try it
Update Reply with the Google Drive API

Update a reply on a specific comment. See the documentation for more information

 
Try it
Update Shared Drive with the Google Drive API

Update an existing shared drive. See the documentation for more information

 
Try it
Upload File with the Google Drive API

Upload a file to Google Drive. See the documentation for more information

 
Try it
[Data] Convert JSON to String with the Formatting API

Convert an object to a JSON format string

 
Try it
[Data] Parse JSON with the Formatting API

Parse a JSON string

 
Try it
[Date/Time] Add/Subtract Time with the Formatting API

Add or subtract time from a given input

 
Try it
[Date/Time] Compare Dates with the Formatting API

Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.

 
Try it
[Date/Time] Format with the Formatting API

Format a date string to another date string. For more examples on formatting, see the Sugar Date Format documentation.

 
Try it
[Numbers] Format Currency with the Formatting API

Format a number as a currency

 
Try it
[Numbers] Format Number with the Formatting API

Format a number to a new style. Does not perform any rounding or padding of the number.

 
Try it
[Text] Convert HTML to Markdown with the Formatting API

Convert valid HTML to Markdown text

 
Try it
[Text] Convert HTML to text with the Formatting API

Convert valid HTML to text

 
Try it
[Text] Convert Markdown to HTML with the Formatting API

Convert Markdown text to HTML

 
Try it
[Text] Decode URL with the Formatting API

Decode a URL string

 
Try it
[Text] Encode URL with the Formatting API

Encode a string as a URL

 
Try it
[Text] Extract by Regular Expression with the Formatting API

Find a match for a regular expression pattern. Returns all matched groups with start and end position.

 
Try it
[Text] Extract Email Address with the Formatting API

Find an email address out of a text field. Finds the first email address only.

 
Try it
[Text] Extract Number with the Formatting API

Find a number out of a text field. Finds the first number only.

 
Try it
[Text] Extract Phone Number with the Formatting API

Find a complete phone number out of a text field. Finds the first number only.

 
Try it
[Text] Extract URL with the Formatting API

Find a web URL out of a text field. Finds the first URL only.

 
Try it
[Text] Replace Text with the Formatting API

Replace all instances of any character, word or phrase in the text with another character, word or phrase.

 
Try it
[Text] Set Default Value with the Formatting API

Return a default value if the text is empty

 
Try it
[Text] Split Text with the Formatting API

Split the text on a character or word and return one or all segments

 
Try it
[Text] Transform Case with the Formatting API

Transform case for a text input

 
Try it
[Text] Trim Whitespace with the Formatting API

Removes leading and trailing whitespace

 
Try it

Explore Other Apps

1
-
24
of
3,000+
apps by most popular

Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
Notion
Notion
Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Anthropic (Claude)
Anthropic (Claude)
AI research and products that put safety at the frontier. Introducing Claude, a next-generation AI assistant for your tasks, no matter the scale.
Google Sheets
Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Telegram
Telegram
Telegram, is a cloud-based, cross-platform, encrypted instant messaging (IM) service.
Google Drive
Google Drive
Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.
HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Google Calendar
Google Calendar
With Google Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.
Pipedream Utils
Pipedream Utils
Utility functions to use within your Pipedream workflows
Shopify
Shopify
Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.
Supabase
Supabase
Supabase is an open source Firebase alternative.
MySQL
MySQL
MySQL is an open-source relational database management system.
PostgreSQL
PostgreSQL
PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
AWS
AWS
Premium
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Twilio SendGrid
Twilio SendGrid
Premium
Send marketing and transactional email through the Twilio SendGrid platform with the Email API, proprietary mail transfer agent, and infrastructure for scalable delivery.
Amazon SES
Amazon SES
Amazon SES is a cloud-based email service provider that can integrate into any application for high volume email automation
Klaviyo
Klaviyo
Premium
Klaviyo unifies your data, channels, and AI agents in one platform—text, WhatsApp, email marketing, and more—driving growth with every interaction.
Zendesk
Zendesk
Premium
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
ServiceNow
ServiceNow
Premium
Beta
The smarter way to workflow
Slack
Slack
Slack is the AI-powered platform for work bringing all of your conversations, apps, and customers together in one place. Around the world, Slack is helping businesses of all sizes grow and send productivity through the roof.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.