Fetch Product Details using Pluck and Join in Workflows
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:
{{ 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.
{{ join (pluck order.line_items “title”) “, ” }}
Output:
“TEST OFFER, ANOTHER PRODUCT, LAST ITEM”
