new

Fetch Product Details using Pluck and Join in Workflows

What's New?

Introduced

Pluck and Join

helpers to streamline workflow automation:

Pluck

: Extract specific fields from a dataset (e.g., product titles from an order).

Join

: Combine extracted items into a single, formatted string with a custom separator.

Enables dynamic extraction and formatting of product details from order submissions for seamless integration with external platforms like Google Sheets.

Example Use Case: Send only product names from store orders to Google Sheets every time a new purchase is made.

How to Use?

Set Up a Trigger:

Use triggers like Order Form Submitted or Inbound Webhook to initiate the workflow.

Process Data:

Use the Pluck Helper to extract specific information, such as product titles:

Use the Join Helper to combine extracted data into a single string, separated by a custom delimiter:

Send Data to External Systems:

Example

: Use the "Create Row in Google Sheets" action to log:

Products
: {{ join (pluck order.line_items "title") ", " }}

Test and Validate:

Run test orders to verify data extraction and ensure correct formatting before launching the workflow.

Why We Built It?

To simplify data extraction and formatting for automation users.
To reduce manual effort in integrating product data with external systems like Google Sheets.
To enable versatile workflows that cater to specific user needs, such as sending only relevant product details (e.g., product titles).

Example use case

Example

: Send Online Orders product titles to google sheets.

Imagine you’re processing an online order. Each order includes products with details like names, prices, and quantities.

Goal

: Extract Product Titles

You want a list of product names (title) from all items in the order, combined into one string separated by commas.

Solution

Output:

"TEST OFFER, ANOTHER PRODUCT, LAST ITEM"