+44 203 287 0899 info@solvaa.co.uk
Turquoise letters of the alphabet flying around randomly

If you haven’t used Zapier’s inbuilt text formatting function then you may be surprised by just how powerful it is.  Many zaps process character data in one form or another, and if the data isn’t ‘clean’ then it won’t look neat when it’s output onto invoices, used in emails or printed in a document.

Being able to tidy up your data using Zapier’s formatting function is a real game-changer, and there are so many possibilities for what you can do with it.  Being able to manipulate text allows you to automatically compose emails, write social media posts and replace many manual tasks to save time in your business.

We dive into some of our favourite ways of formatting text here, to give you a flavour of what’s possible and hopefully inspire you to try it out!

 

How to format text using Zapier

When you want to format text then you’ll need to choose the Formatter By Zapier app as your action step.  If you aren’t sure what an action step is, or other Zapier terminology then read our guide on how to get started with Zapier.

The functionality within Formatter By Zapier includes so many different options for text.  You can transform characters from one format to another, and you can also extract text which matches certain criteria.

Text Action Event

You should choose ‘Text’ as your Action Event (see below):

Screen print from the Zapier app showing how to select the Text option in the Formatter By Zapier function.

Transformation Options

Next, you need to choose how you want to Transform the text, and you’ll be presented with a list of options (see below).  There are 26 different ways of formatting text, and they are listed in alphabetic order.  You can click ‘Load More’ to see the full list.

Screen print from the Zapier app showing the list of text transformation options within the Formatter By Zapier function.

In the next sections we explain in a bit more detail how some of the formatting options work, and where you might use them.

So read on for inspiration for how you can supercharge your automations using text transformations!

What options does Formatter By Zapier include for text?

These are some of the most useful ways of transforming character data, and we include some specific, real-life examples below, to show you how to really unlock the power of Zapier’s text formatted.

Capitalize

CAPITALIZE transforms text into ‘proper’ case with the first character of each word capitalized.  For example, this could force an address to be displayed properly, converting it from ‘2 london road’ to ‘2 London Road’.  It can be really useful when people are lazy entering their name and address into a webform as it allows you to clean it up so that it looks nice when used in emails and documents.

Note: if you want to convert ALL of your text into capitals then use the UPPERCASE transformation.

Default Value

If data in your zap could be empty but you want to set a default value then you can use the DEFAULT VALUE transformation function.  For example, if your webform has optional fields but they are mandatory in your CRM then you can set a default value here, maybe setting it to ‘Unknown’ or ‘N/A’.

Extract Email Address

One of the most useful transformations is to use EXTRACT EMAIL ADDRESS to extract an email address from text.  You can then use this to compose an email, add it to your email platform or store in your CRM.

Extract Number

The EXTRACT NUMBER transformation extracts the first number it finds within the text.  It will return numbers with a single decimal point, e.g. 12.34, and also where commas are used to separate groupings of digits, e.g. 123,456,789. 

Note: this function should not be used for extracting phone numbers as that has its own transformation, EXTRACT PHONE NUMBER.

Extract Phone Number

If you want to extract a telephone number from a string then use the EXTRACT PHONE NUMBER transformation to identify certain number groupings.  It will find groups of 3-3-4 and 4-3-3 digits, and additionally find a country code or extension number if they have been provided.  It will identify them even if the numbers are separated by a hyphen, period (full stop) or space.

Finger poised over the numeric keypad on an office phone

It’s worth noting that this won’t work for UK telephone numbers where the groupings are often 5-6, 5-3-3 or 3-4-4.   If you use this function, be sure to test it with some common number formats to ensure it works for your use case.

Find

The FIND transformation finds the first occurrence of a word in the text and returns its numeric position.  It will return a value of -1 if the word doesn’t exist in the text, or a positive number to represent where it appears, if it does exist.

Lowercase

The LOWERCASE transformation converts all the text to lower case.  This could be useful if you’re creating filenames and you want them to be consistent. Making them all lower case would be a good way of achieving that.  You might also want to ensure an email address or URL is all lower case too.

Pluralize

The PLURALIZE transformation turns a singular word into a plural, using the correct English pluralization rules.  For example, ‘car’ becomes ‘cars’.  This could be really useful if you have an e-commerce store, to output product names based on their quantity.  It might look odd on an invoice if it says ‘4 book’ whereas ‘4 books’ looks much nicer.

Replace

The REPLACE transformation will replace a word or phrase with another of your choosing.  This could be useful if you (or a staff member!) commonly misspells a word.  Or you may have a new staff member whose name you’d like to use on a document and want to replace a previous signatory.

You can also space out the text (or remove spaces) using special syntax for carriage returns and new lines.

You simply use the phrase you’d like to replace and define the new text you want to change it to.

You can also replace characters such as tabs.   For these special characters you can use a specific syntax, for example [:newline:] for new line characters, [:space:] for spaces, [:tab:] for tabs and [:return:] for carriage returns.

Split Text

The SPLIT TEXT transformation is really useful and allows you to separate words into different fields.  For example, if somebody’s full name is provided in a web form then you might want to address them by their first name in an email newsletter.  You can split the first and last names using the SPLIT TEXT transformation.

You can also do this with different separators, for example another word, or a tab character (using the [:tab:] syntax).

Titlecase

The TITLECASE transformation is subtly different from ‘capitalize’ in that it doesn’t capitalize the first letter of EVERY word.  It ignores minor words such as ‘to’, ‘of’ and ‘a’.  This can be really useful for headings, blogs and book titles, and also movie names.  For example, if you use ‘how to format text in a sentence’ as the input then the result will be ‘How to Format the Text in a Sentence’.

Trim Whitespace

The TRIM WHITESPACE transformation is useful if you have text in a document or webform with large areas of whitespace.  This transformation will trim the whitespace from before and after the text.

Truncate

The TRUNCATE transformation limits the input text to a certain number of characters.  You can either specify the overall length you’d like to reduce it to, or start at a certain point and just include the next N characters.

This could be really useful when sharing on social media.  The Twitter character limit is very restricted so it could help to reduce the text you post in a controlled manner, with ‘visit our website to read more’ or ‘…’ added to the end of a post.

Key on a computer keyboard with ‘Tweet’ text and a blue bird character.

You can add the ellipsis (…) to the end using a tickbox which asks if you’d like to ‘Append Ellipsis’.

Uppercase

As you might guess, the UPPERCASE transformation converts all the text into upper case.  This could be useful if the target app requires uppercase versions of a value, or if you’re trying to search for some values then converting them all to uppercase could be a good way of finding them consistently.

Real life examples of using Zapier’s text formatter

If you’d like some inspiration for how Zapier’s text formatter could save time (and money!) in your business then here are some examples we’ve seen recently.

Example 1 : save money by using the free version of apps

Some apps have brilliant free versions which can do most of what you need, but may not include a Zapier integration.  One way of circumnavigating this is by thinking outside the box!

Calendly is a great diary tool which allows people to book time with you and automatically set up video-conferencing details.  However, you need the professional plan to integrate it with Zapier.  A great workaround for this is using your calendar app such as Google Calendar or Microsoft Outlook, which Calendly will add an appointment to automatically, along with the relevant videoconferencing link.

A page from a calendar in an unidentified month.

Simply create a zap which triggers when a new event is added to the calendar for a Calendly meeting, and extract the email addresses of the attendees using Zapier’s EXTRACT EMAIL ADDRESS transformation.  Then you can add steps to send attendees a reminder 1 day before along with the Zoom link, via email, or even a sequence of reminders to ensure they don’t forget!

Example 2 : saving time when adding new contacts to your email platform

If someone signs up for your mailing list then it’s useful to be able to address them using their first name when you write to them.  If you have only one field for their name on your webform then you can use the SPLIT TEXT transformation to split out their first and last names before adding them to your email platform.

This saves time from doing it manually or needing a regular task to check that your list is ‘clean’.

Example 3 : Assigning a default value when a task has no owner

If you use a project management tool such as Asana or Trello then the quickest way to get something done is to assign a task to a specific person.  However, if you’re setting up a zap to create tasks automatically then you may use a lookup to assign an owner for it.  However, if the lookup doesn’t return a result then you can use the DEFAULT VALUE transformation function to assign the task to a manager or another member of the team who can then triage the item and pass it onto someone else.

Find out more

If you’d like to find out more, with detailed examples of many of the text transformations mentioned above (and more) then we’d recommend Kelly’s book, Automate It with Zapier, which is available on Amazon.

The book is perfect for new Zapier users as well as seasoned pros. Here are links to Amazon (.co.uk) and Amazon (.com) to get yours now.

 

Free downloads

We also offer a free e-book and cheat sheet if you want to find out more about the no-code revolution and other built-in functions offered by Zapier.

Our free Introduction To Zapier e-book explains the benefits of business process automation, how Zapier fits in and examples of automations for each department within your business.

We have a free cheat sheet with a checklist of Zapier’s inbuilt function which can supercharge your automations.  

 

Read more about how our certified experts use Zapier workflow automations to simplify processes and increase efficiency.

Solvaa is a process and automation consultancy specialising in improving sales, operations and financial administration workflows. We help you to simplify and streamline existing processes, integrate your business tools to make data transfer more efficient and automate manual tasks to increase productivity. We are Zapier Certified Experts, Pipedrive Certified Experts and Xero Certified Advisors. 

Contact us today to discuss how Solvaa can help you simplify, improve and automate all aspects of your business with Zapier to save you time, reduce costs and keep you agile as you grow.

 

 

Related Posts

Small wooden people are lined up to look like members of a membership, next to a sign which says MEMBERSHIP.

How to use Zapier like a boss to run your online membership on autopilot

If you're running an online membership, then you know there are a lot of moving parts.  From managing content to processing payments, it can be a lot to keep track of. But what if there was a way to put some of those repeat tasks on autopilot? That's where Zapier...
Businessman holding a mobile device with automation concept and text which says ‘Marketing Automation’.

How to use Zapier to automate your marketing processes and win more business

Are you tired of doing the same tasks over and over again every day? Do you wish there was a way to automate some of your marketing processes? Well, there is! With Zapier, you can connect different applications to create automated workflows. This can save you time and...
A draft stamp on its side with the word DRAFT with the orange Zapier logo.

New cool Zapier feature coming soon : Zap editor Drafts (in beta now!)

If you’ve ever had to tweak one of your Zaps then you’ve always had to turn it off first, which is always a worry as you may be missing vital automations which should be triggering while you work on it. So, when we received an email from Zapier inviting us to take...
Concept of time with a clock face showing the time at 11:54 and the days in a calendar..

How to use Schedule by Zapier like a pro to run workflows regularly

The brilliant thing about Zapier is that as well as triggering automations when events happen in your apps, you can also make things happen when YOU choose, thanks to Schedule by Zapier. Imagine if you wanted to receive a list of your sales every evening, or get a...
Mobile phone with a ‘new message received’ message with a cursor hovering over a ‘show’ button and thumb poised to select it.

How to harness the power of automating text messages using SMS by Zapier

Automating text messages can be extremely useful in business, and using SMS by Zapier is really powerful, easy – and free! In this article we cover the following: Why is SMS such a powerful business tool? What is SMS by Zapier? What could I use SMS by Zapier for? What...
Computer keyboard with a large blue Help button with the letters lit up and shining upwards.

How to get help with Zapier

If you’re just starting out and need some help with getting the best out of Zapier, or you’re simply stuck and don’t know where to turn, then we have some useful resources for you. Zapier’s Zap Editor has a help icon at the top (the blue question mark button) which...
An accountant at his desk using a calculator and checking invoices, with a laptop and PC monitor in the background.

How accountants and bookkeepers can use Zapier

Running the financial aspects of businesses usually involves performing manual tasks, but if accountants and bookkeepers learn how to use Zapier then many of these can be streamlined and eliminated. We asked a few accountants and bookkeepers how they use automation to...
Mockup of a computer screen in an office with the Zapier homepage displayed on the monitor.

How to get started with Zapier

  If you’ve never used Zapier before then getting started can seem daunting.  Although the Zapier website has many examples of automations you can build, the most important thing to do before you even consider automation is to review your processes. If you’re...
Businessman in a meeting holding a tablet which shows pie charts and bar graphs from a Powerpoint presentation.

What operations processes can be automated?

Your operation is the engine room of your business and automating the processes there can free up valuable time to spend winning more business or serving your customers better. If you’re wondering what operations processes can be automated then we have plenty of...
Closeup of a section of a light grey keyboard with a blue ‘Organise’ button. Solvaa logo in top right hand corner.

How to organise your zaps

If you’re a new Zapier user then learning how to organise your zaps will help you manage them efficiently from Day 1.  As an existing Zapier user, if your zaps aren’t organised then you may find that it gets harder and harder to find the zap you’re looking for....
Rear view of successful businessman relaxing in his office with his hands behind his head.

The benefits of automation in business

Everyone is talking about automation in business but many people aren’t sure what it actually means and what the benefits are.  It sounds really complicated and time-consuming, and (even worse) expensive!  Who would actually bother finding out?  We want to bust those...

Automate It with Zapier book : Initial Reviews

Since our founder, Kelly's Automate It with Zapier book was released it has received some fantastic reviews on Amazon.  We knew the book would help new Zapier users but didn’t realise how useful it would be for people with different levels of Zapier knowledge. When...
Illustration of online course concepts including book, pencil, cloud and microphone, with photo of hands holding a smart phone with finger poised on the screen. Light blue background with Solvaa logo in bottom corner.

Why online course providers should learn Zapier

As an online course provider, you wear many hats, juggling the tech, finance, customer service and marketing functions, to name but a few.  Unless you are well established and have a team, then it can be overwhelming being responsible for so many tasks yourself. ...
Cover of the book ‘Automate it With Zapier’ with byline ‘Boost your business productivity using effective workflow automation techniques’ by author Kelly Goss.

Automate It with Zapier Book

Writing a Zapier book was a natural step for our founder, Kelly Goss as she is so passionate about helping business owners increase productivity in their companies.  As a Certified Zapier Expert, Kelly is the perfect person to impart everything she’s learned using...

The Advantage Of Automation

Our Chief Problem Solver, Kelly Goss recently joined Shelley and Jo on the Virtually Amazing podcast to talk about the advantage of automation and how it can help businesses.  They also discussed how automation skills can be used by VAs to broaden their service...
Virtual assistant concept featuring a young woman with background of illustrated icons including 'like', 'share' and other digital marketing themes.

How To Use Zapier As A Virtual Assistant

So many people are choosing to be Virtual Assistants these days, as it is a flexible freelance role that is packed with variety.  There are many different types of VA, for example, Social Media VAs, Marketing VAs, Technical VAs, and eCommerce and Finance VAs. ...
Concept of a sales funnel featuring small silver balls feeding into a metal funnel with a neat row coming out the other side. A red sign is pointing at the funnel which reads 'Leads'.

How to avoid losing leads

  Winning new business isn’t easy, so it’s vital to learn how to avoid losing valuable leads.  Sometimes you’re so busy juggling your everyday tasks that you neglect your prospects and ultimately lose them to a competitor.  Automation can be a game-changer...
Concept of date time with a photo of a hand overlaid with a hand drawn calendar and clock in white.

How to express dates in Zapier

Once you start to unleash the power of Zapier you will more than likely need to schedule a step to run at some point in the future.  For example, you might want to set up a cadence of sales emails to follow up leads.   You may want to automatically create project...
Blackboard with rainbow coloured arrows pointing right, with word PRODUCTIVITY drawn with chalk

How to be more productive in 2021

Have you thought about what it could mean for your business if you were more productive?  It’s sometimes hard to measure productivity gains, but think about how you could use the time you save by being more efficient in your business. Recently, our chief problem...
Side view of a girl with a superhero cape, with Solvaa logo and text 'Become an automation superhero'.

Become an automation superhero with our free cheatsheet

Although Zapier is brilliant at connecting the apps you use every day, it also comes with over 20 inbuilt functions which will help you become an automation superhero in no time! These functions are a range of helper apps that we’ve listed on our free cheatsheet which...
Get our free ebook

Get our free ebook

Learn about how business process automation with Zapier can help you to run your business on autopilot. The ebook is packed with real-life examples, use cases, and success stories. Whatever kind of business you have, you can use automation to help you work smarter, not harder.

Thanks! Your ebook is on the way.

Pin It on Pinterest

Shares