What’s New?
We’ve introduced Pluck and Join helpers to streamline your workflow automation:
Pluck: Extracts specific fields from a dataset such as product titles from an order.
Join: Combines the extracted items into a single formatted string with a custom separator.
This allows for dynamic extraction and formatting of product details from order submissions, enabling seamless integration with external platforms like Google Sheets.
Example Use Case: Every time a new purchase comes in, only the names of the products from the store orders are sent to Google Sheets.
How to Use?
Set Up a Trigger:
Use order form submitted or inbound Webhooks to trigger the workflow.
Process Data:
Use the Pluck Helper to extract specific information, such as product titles:
pluck order.line_items “title”
Then, Use the Join Helper to assemble the extracted data into a single string, separated by a customizable delimiter:
join (pluck order.line_items “title”) “, “
Send Data to External Systems:
Example: Use the “Create Row in Google Sheets” action to record:
Products: join (pluck order.line_items “title”) “, “
Test and Validate:
Before launching the workflow, run test orders to verify that data is being correctly extracted and formatted.
Why We Built It?
We created it to simplify data extraction and formatting for automations users, eliminate the need for manual efforts when integrating product data with external systems like Google Sheets, and to offer versatile workflows catering to specific user needs, such as sending only relevant product details like product titles.
Example Use Case
Example: Sending product titles from online orders to Google Sheets
Let’s say you’re processing an online order, which includes products that have details like names, prices, and quantities. You want to extract a list of product titles from all items in the order and combine these into a single string separated by commas:
join (pluck order.line_items “title”) “, “
Output:
“TEST OFFER, ANOTHER PRODUCT, LAST ITEM”