What do you want to automate

with Pipedream Utils and PostgreSQL?

Get memory usage statistics for the current Pipedream workflow.

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

Convert an object to a JSON format string

Deletes a row or rows from a table. See the documentation

Parse a JSON string

Finds a row in a table via a lookup column. See the documentation

Add or subtract time from a given input

Finds a row in a table via a custom query. See the documentation

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

Adds a new row. See the documentation

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

Format a number as a currency

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

Convert valid HTML to Markdown text

Convert valid HTML to text

Convert Markdown text to HTML

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

Decode a URL string

Updates an existing row. See the documentation

Encode a string as a URL

Adds a new row or updates an existing row. See the documentation

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

Find matches for regular expressions. Returns all matched groups with start and end position.

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

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

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

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

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

Return a default value if the text is empty

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

Transform case for a text input

Removes leading and trailing whitespace

Accepts a base64-encoded string, returns a decoded UTF-8 string

Get the difference, intersection, union, or symetric difference of two arrays/sets.

Convert an amount between currencies. See the documentation

Converts an HTML string to the Slack mrkdwn format using

Accepts a JavaScript object, returns that object converted to a JSON string

Return the country name (in English) when given the 2-letter country code

Convert a CSV file to an array of objects.

Downloads a file to your workflow's /tmp directory

Export variables for use in your workflow

Use the moment.js npm package to format an ISO8601 date/time as Google Sheets friendly formats. This action exports an object with compound date/time, date-only, and time-only values.

Returns the current time, tied to this workflow invocation, in the target timezone

Returns an ISO string (UTC TZ) N days ago

Given an ISO 8601 timestamp, and a timezone, convert the time to the target timezone.

Convert via turndown

Schedule a task with an existing task scheduler source. See here for more details.

Pretty print a JavaScript object or value

Generate a random integer (whole number). Useful for random delays.

Returns a randomly selected value(s) from a user-defined list of options.

Retrieve all stories from one or more RSS feeds.

Gets new stories from a specified RSS feed that have not already been processed.

Sends an email using the nodemailer package

Send data to Amazon S3 using Pipedream's destination integration. See https://docs.pipedream.com/destinations/s3/

Trigger another Pipedream workflow in your workspace.

See xml-js