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”