Andrew here, your resident Zapier expert.
After years of being asked (and years behind Make/n8n), Zapier finally supports the use of formulas to transform data inside zap steps, without the need to add a formatter step.
Know someone that needs Zapier help? Refer and earn.
Refer a new client to me, and I’ll match their spend up to $250 as a referral fee to you. Cash or work credit, it’s up to you!
Contact me here.
🧠 What it is (core idea)
In-line formulas let you transform data directly inside a field of a Zap step—no separate Formatter step needed.
Think: lightweight data manipulation at the point of use instead of adding another step.
⚙️ What problem it solves
Previously:
You had to add a Formatter by Zapier step for simple things (e.g. combine text, clean values).
Now:
You can do those transformations inline, reducing:
step count
complexity
maintenance overhead
🧩 How it works (mechanically)
Inside any field in an action step:
Click the + icon in the field
Select Formulas
Choose a formula
Replace placeholder values with:
static text OR
mapped data from previous steps
The formula executes when the Zap runs, and its output is passed forward.
Accio Work: Your Business, On Autopilot
Run your business effortlessly with Accio Work. Our specialized AI agents handle sourcing, supplier deals, store management, and marketing—all automatically. Backed by Alibaba.com’s vast product network, execution is fast and reliable. Skip the complexity—get results instantly while staying in full control of your growth.
🧮 What you can do with it
Typical use cases:
Text ops → concatenate, trim, extract
Data cleanup → format emails, parse JSON
Basic transformations → combine fields, reshape values
Light calculations
Example:
Text.concat("Hello ", "world!") → "Hello world!"
⚠️ Constraints / caveats
It’s early access (still evolving)
Designed for simple transformations, not complex logic
Testing quirk:
Zap editor may show the formula, not the final output during test runs
🆚 Inline formulas vs Formatter step
Inline formulas | Formatter step |
|---|---|
Inside a field | Separate step |
Lightweight transformations | More complex workflows |
Faster, cleaner Zaps | More flexible, powerful |
Fewer steps | More control |
🧠 Bottom line
Use inline formulas for quick, local transformations
Use Formatter when:
logic gets complex
you need multi-step transformations
or structured processing
Learn how to code faster with AI in 5 mins a day
You're spending 40 hours a week writing code that AI could do in 10.
While you're grinding through pull requests, 200k+ engineers at OpenAI, Google & Meta are using AI to ship faster.
How?
The Code newsletter teaches them exactly which AI tools to use and how to use them.
Here's what you get:
AI coding techniques used by top engineers at top companies in just 5 mins a day
Tools and workflows that cut your coding time in half
Tech insights that keep you 6 months ahead
Sign up and get access to the Ultimate Claude code guide to ship 5X faster.