Extracting First Values (Make.com)

Step-by-Step Guide: Extract the First Value from Any Comma-Separated Field in Make.com

This guide shows you how to extract only the first value from any field that contains multiple comma-separated entries (like emails, phone numbers, tags, etc.) using Make.com. This is perfect for sending just the primary value to tools like Instantly, Google Sheets, Airtable, or Slack.


โœ… Use Case Examples

  • Emails:
    • BUSINESS_EMAIL = "john@example.com, support@brand.com, info@brand.com"
      โ†’ Extracted: john@example.com
  • Phone Numbers:
    • MOBILE = "1234567890, 9876543210"
      โ†’ Extracted: 1234567890
  • Tags:
    • TAGS = "sales, marketing, enterprise"
      โ†’ Extracted: sales

๐Ÿ”ง Step-by-Step Setup in Make.com

STEP 1: Webhook (or Any Input Source)

Start with a module that receives data, typically:

  • Webhook > Custom Webhook

Make sure the field (like BUSINESS_EMAIL or MOBILE) contains values separated by commas.


STEP 2: Add an Iterator (if your data is bundled)

If your webhook sends data in an array (e.g. result[]):

  • Add: Tools > Iterator
  • Set array to: {{1.payload.result}}

This will process each row (lead/user) one by one.


STEP 3: Set Variable โ€“ Extract the First Value

Add: Tools > Set Variable

Create a variable for each field where you want only the first value:

๐ŸŸฉ First Email

Variable Name: FirstEmail
Value: {{trim(get(split(2.BUSINESS_EMAIL; ","); 1))}}

๐ŸŸฆ First Phone

Variable Name: FirstMobile
Value: {{trim(get(split(2.MOBILE; ","); 1))}}

๐ŸŸจ First Tag

Variable Name: FirstTag
Value: {{trim(get(split(2.TAGS; ","); 1))}}

Update the 2. reference depending on your scenario (it refers to the previous module number).


STEP 4: Send to Any App

You can now use these variables in:

  • Instantly โ†’ Email: {{3.FirstEmail}}
  • Google Sheets โ†’ Email column: {{3.FirstEmail}}
  • Webhook > Make a Request โ†’ Map in JSON body
  • Airtable โ†’ Insert as field value

๐Ÿง  Tips

  • Always use trim(...) to remove extra spaces
  • You can safely apply this pattern to any text field
  • Works even without an Iterator if you're processing one record at a time

๐Ÿ“ฆ Universal Formula Template

Copy-paste this into any Set Variable value field:

{{trim(get(split(YOUR_FIELD; ","); 1))}}

Replace YOUR_FIELD with whatever field you need.


โœ… Summary

This method gives you a clean, consistent way to always pull just the first value from any multi-entry string. Itโ€™s reusable across:

  • Emails
  • Phone numbers
  • Tags
  • Names
  • Lists of any kind

Set it once, and confidently send only the data you actually want to downstream tools.

Did this answer your question?
๐Ÿ˜ž
๐Ÿ˜
๐Ÿคฉ

Last updated on August 6, 2021