Streamline Your Workflow with Pluck and Join Automation Tools

Simplifying Workflow Automation: Fetch Product Details with Pluck and Join

Enhance your workflow automation with our latest feature introduction: Pluck and Join helpers. These powerful tools streamline the extraction and formatting of product details from order submissions, enabling seamless integration with external platforms like Google Sheets. Whether you’re processing online store orders or handling complex data sets, this new feature ensures efficient data handling and reporting.

What Are Pluck and Join?

Pluck and Join are the latest additions to our workflow automation toolkit:

  • Pluck: Extract specific fields from a dataset, such as product titles from an order.
  • Join: Combine extracted items into a single, formatted string with a custom separator.

This update allows dynamic extraction and formatting of product details, minimizing manual efforts and maximizing automation efficiency.

How to Use the New Helpers

Set Up a Trigger

Initiate the workflow using triggers like Order Form Submitted or Inbound Webhook. This sets the stage for the automated process.

Process Data

  1. Pluck Helper: Extract specific information such as product titles.
    {{ pluck order.line_items "title" }}
    
  2. Join Helper: Combine the extracted data into a single string with a custom delimiter.
    {{ join (pluck order.line_items "title") ", " }}
    

Send Data to External Systems

For example, use the “Create Row in Google Sheets” action to log products:

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

Test and Validate

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

Screenshot 2025-01-17 at 16

Screenshot of spreadsheet configuration interface

225847a87520044784e35f916990550d

Why We Built It

Our primary goal is to simplify data extraction and formatting for automation users, reducing manual effort in integrating product data with external systems like Google Sheets. With this update, users can create versatile workflows tailored to specific needs, such as sending precise product details like product titles.

Example Use Case

Scenario: Send online orders’ product titles to Google Sheets.

  • Imagine processing an online order with products details including names, prices, and quantities.
  • Goal: Extract and compile product titles into a single, comma-separated string.
  • Solution:
    {{ join (pluck order.line_items "title") ", " }}
    
  • Output:
    "TEST OFFER, ANOTHER PRODUCT, LAST ITEM"
    

Discover how this feature can enhance your data workflows by exploring more on our Product Updates page.

In Case You Missed It

Check out our latest feature enhancements in our recent posts, such as the Effortless Social Sharing for Your Blogs, to learn more about improving your digital marketing strategies.

SMBcrm ©2024 | All Rights Reserved
A Leads 365 LLC Company