Streamlined Workflow Automation with Pluck and Join Helpers

What’s New?

Introducing Pluck and Join helpers to streamline workflow automation:

  • Pluck: Extracts specific fields from a dataset (e.g., product titles from an order).
  • Join: Combines extracted items into a single, formatted string with a custom separator.

This feature 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:

pluck order.line_items “title”

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

join (pluck order.line_items “title”) “, ”

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:

join (pluck order.line_items “title”) “, ”

Output:

“TEST OFFER, ANOTHER PRODUCT, LAST ITEM”

Liked this post? Share with others!

Subscribe to our newsletter

Collect visitor’s submissions and store it directly in your Elementor account, or integrate your favorite marketing & CRM tools.

Do you want to boost your business today?

This is your chance to invite visitors to contact you. Tell them you’ll be happy to answer all their questions as soon as possible.

Learn how we helped 100 top brands gain success