Solutions Hub
Browse the collection of expertly crafted automations, integrations, widgets, and data queries.
Automations
-
Add a column to dictionaries
Use `|merge` filter to add new columns to dictionaries.
-
Append values to arrays and lists
Add new values to existing arrays and lists.
-
Arbitrary records as input
Accept an arbitrary record type and ID as input to create an expandable placeholder.
-
Batch list items into sets
Use `|batch` filter to split lists into smaller sets of items.
-
Break a while loop with a condition
Abort an infinite while loop with conditional logic.
-
Compare with operators
Use comparison operators to evaluate values.
-
Conditional branching statements
Use decision blocks and conditional logic for branching.
-
Conditional values
Perform inline conditional logic in a placeholder value.
-
Convert HTML to Markdown
Use the `|html_to_text` filter to convert HTML content to Markdown format.
-
Convert Markdown to HTML
Use the `|markdown_to_html` filter to convert Markdown content to HTML format.
-
Create a comment
Use `record.create:` to create a comment on any record.
-
Create a dictionary from arrays
Use `array_combine()` to create a dictionary from lists of keys and values.
-
Create an email draft
Create and schedule a draft record for outgoing email.
-
Create a ZIP attachment
Use `file.write:` to create a ZIP archive with arbitrary files.
-
Debug search query SQL
Generate the underlying SQL statement for any record search query.
-
Escape untrusted data query parameters
Safely handle untrusted user input in data queries using query parameters.
-
Escape placeholders
Escape placeholders in a value using the `@raw` annotation.
-
Extract dictionary columns
Extract a column from a list of dictionaries
-
Extract and rewrite URLs in text
Extract all links from a text block and optionally rewrite them (e.g. click tracking).
-
Extract text using regular expressions
Use regular expression patterns to extract matching text within automation scripting.
-
Extract ZIP files
Read a ZIP manifest and extract files from an attachment record.
-
Filter array values
Use the `|filter` modifier with arrow functions to match specific array values.
-
Filter dictionary keys
Use the `|filter` modifier with arrow functions to match dictionary keys.
-
HTTP GET request
Fetch data from an HTTP endpoint.
-
HTTP POST request with a form payload
Make an HTTP POST request with form-encoded data.
-
HTTP POST request with a JSON payload
Send a JSON payload to an HTTP endpoint.
-
HTTP responses with XPath
Make an HTTP GET request and extract data from HTML responses using XPath.
-
Iterate through unknown placeholders
Use `cerb_placeholders_list()` to iterate through placeholders with unknown keys.
-
Key expandable placeholders
Create an arbitrary variable that supports key expansion by using a shared prefix.
-
Loop search results
Use the `repeat:` command to iterate records from search results.
-
Map array values
Use the `|map` modifier with arrow functions to transform array values.
-
Optional conditional keys
Use the `@optional` annotation to omit keys based on conditional values.
-
Page through search results in a sheet
Display a sheet of record search results with paging in a worker interaction.
-
Prepend a prefix to a text block
Add a prefix to each line in a given block of text.
-
Random array values
Generate an array filled with random numeric values.
-
Relay email messages to workers
Relay email messages to workers using an external email client.
-
Report a ticket as spam
Report a ticket as spam with automations.
-
Retroactive metric values
Log retroactive or custom values on a metric.
-
Return dictionary keys
Use the `|keys` filter to get a list of dictionary property names.
-
Round floating point numbers
Various rounding methods to format decimal numbers in automation scripting.
-
Scope scripting variables
Use `with` command to create isolated variable scopes.
-
Search records with a query
Search records with an arbitrary query and save the results into a variable.
-
Set dictionary values
Use dictionary structures to set and expand dynamic values.
-
Set a dynamic key name
Use `var.set:` to make a key with a dynamic name.
-
Shuffle lists and strings
Use the `shuffle` function to randomly reorder lists and strings.
-
Simulate errors
Simulate random errors in automation commands with `on_simulate:`.
-
Sort with comparator
Use the `|sort` filter with arrow functions to create custom sorting rules.
-
Split text with delimiter
Use the `|split` filter to divide text into arrays using delimiters.
-
Strip common prefixes from text lines
Use the `|strip_lines` filter to remove prefixes from each line in a block of text.
-
Validate OAuth2 tokens
Validate OAuth2 bearer tokens in webhook automations.
Integrations
-
Amazon Web Services (AWS)
This page provides a comprehensive guide on integrating Cerb with Amazon Web Services (AWS).
-
Azure
This page provides a detailed guide on integrating Cerb with Office365 by configuring an Azure app and setting up Cerb.
-
Dropbox
A step-by-step guide for integrating Cerb and Dropbox.
-
Facebook
A step-by-step guide for integrating Cerb and Facebook.
-
GitHub
A step-by-step guide for integrating Cerb and GitHub
-
GitLab
A step-by-step guide for integrating Cerb and GitLab.
-
Gmail
This page provides a comprehensive guide on integrating Cerb with Gmail by configuring Google APIs and setting up Cerb.
-
ipstack
A step-by-step guide for integrating Cerb and ipstack.
-
LinkedIn
A step-by-step guide for integrating Cerb and LinkedIn.
-
OpenAI
A step-by-step guide for integrating Cerb and OpenAI.
-
Postmark
A step-by-step guide for integrating Cerb and Postmark.
-
Salesforce
A step-by-step guide for integrating Cerb and Salesforce.
-
Slack
This page provides a comprehensive guide on integrating Cerb with Slack, detailing the steps to create a new Slack app and configure authentication using either bot tokens or OAuth2.
-
Smartsheet
A step-by-step guide for integrating Cerb and Smartsheet.
-
Stripe
A step-by-step guide for integrating Cerb and Stripe.
-
Twilio
A step-by-step guide for integrating Cerb and Twilio.