Who This Is For / When to Use
This article is for users who:
Capture orders using forms, funnels, or checkout pages.
Need to extract multiple product values (for example, product titles) from an order.
Want to store or send those values as a single formatted string to another system, such as Google Sheets.
What “Pluck” and “Join” Do
Pluck
Extracts a single field from each object in an array.
Example:
From order.line_items, extract all product titles.
{{ pluck order.line_items "title" }}Output:
["Product A", "Product B", "Product C"]
Join
Combines multiple values into one string using a separator.
Example:
{{ join (pluck order.line_items "title") ", " }}Output:
Product A, Product B, Product C
Step-by-Step: Log Ordered Products to Google Sheets
Step 1: Create or Open a Workflow
Go to Automations > Workflows.
Click Create Workflow or open an existing one.
In the builder, click Add New Trigger.
Step 2: Configure the Order Trigger
Choose Order Form Submission as the trigger.
(Optional) Add filters to limit which orders should enter the workflow (for example, by funnel or website).
Save the trigger.
Step 3: Add a Google Sheets Action
Click the + icon below the trigger.
Select Google Sheets.
Choose Create Spreadsheet Row as the action.
Step 4: Configure the Google Sheets Action
Select the connected Google account.
Choose the Drive, Spreadsheet, and Worksheet.
Click Refresh Headers to load column names.
Step 5: Map Product Data Using Pluck and Join
In the column where you want product details (for example, Products or CompanyID), enter:
{{ join (pluck order.line_items "title") ", " }}This ensures:
All product titles are extracted from the order.
The titles are combined into one readable string.
Step 6: Save, Test, and Publish
Click Save Action.
Use Test Workflow to submit a test order.
Confirm a new row appears in Google Sheets with formatted product names.
Publish the workflow.
Example Result in Google Sheets
Name | Products | |
Alice | Product A, Product B | |
Bob | Single Item |
Common Issues and Fixes
Products Column Is Empty
Confirm the trigger is Order Form Submission.
Ensure the order actually contains
line_items.
Output Shows Brackets Instead of Text
You used
pluckwithoutjoin.Use
join(pluck(...), ", ")to format correctly.
Wrong Separator
Replace
", "with any separator:"; "" | "" / "
Frequently Asked Questions
Can I pluck fields other than product titles?
Yes. You can pluck any available field inside order.line_items, such as price or quantity.
What happens if there is only one product?
The output is still a valid string with a single value.
Can I use this output in other actions?
Yes. The formatted result can be used in any workflow action, including webhooks, CRM updates, or notifications.