Welcome back to Zapier University! Through our 102 videos, you'll learn mostly about the Formatter and a few other built-in Zapier apps. If you aren't familiar with Zapier or our lingo, we recommend you check out Zapier 101 first.
Formatter: Recap and Quick Tips
Formatter: Spreadsheet Style Formulas
This lesson will get you ready, able, and confident in creating spreadsheet-style formulas directly in your Zaps, so you don't have to rely on a spreadsheet or even worse—math by hand.
Formatter: Lookup Table
In this lesson, we'll take advantage of one of the most useful tools in the Formatter, the lookup table. This function lets you match information from one app with information that would get added in another app so that you can have multiple workflows in just one Zap.
What you'll learn
How to create and use the lookup table to create key/value pairs in your Zap
Resources
Formatter: Dates & Times
In this lesson, we'll look at how to work with dates and times in Zapier's Formatter app. In this lesson, we'll look at how to add and subtract time and change the format or time zone of a date.
What you'll learn
How to add or subtract time to an event
How to format a date or timezone to work with an app's needs
Resources
Formatter: Text (Reformatting)
In this lesson, we'll look at how to use Zapier's Formatter app to manipulate text. For example, we can change the case of a letter in the text, make a word plural, or replace part of that text with a different character.
What you'll learn
How to split text to extract only part of a response
How to manipulate the text, with options such as changing the case, pluralizing a word, or replacing part of the text with different text
Resources
Formatter: Text (Extract and Structure)
In this lesson, we take a look at how to extract elements such as an email address, phone number, or URL from a block of text so it can be used in your Zap.
What you'll learn
How to extract a phone number from a block of text
How to extract an email address from a block of text
How to extract a URL from a block of text
Resources
Formatter: Text (Editing)
In this lesson, we will manipulate our text even more by removing extraneous characters, such as extra spaces or HTML tags, split our text to extract a specific section of that text and count the words in the text being provided.
What you'll learn
How to remove extraneous information like an extra space or HTML
How to split text into multiple pieces
How to check the word count of a block of text
Resources
Formatter: Text (Editing)
In this lesson, we will manipulate our text even more by removing extraneous characters, such as extra spaces or HTML tags, split our text to extract a specific section of that text and count the words in the text being provided.
What you'll learn
How to remove extraneous information like an extra space or HTML
How to split text into multiple pieces
How to check the word count of a block of text
Resources
Schedule
In this lesson, we explore the Schedule app by Zapier. The Schedule app allows you to tell your Zap to only trigger at a certain time on a recurring basis. Explore the basics of scheduling and how to set up a workflow to do some dynamic time calculations.
What you'll learn
How to use the Schedule trigger to tell your Zap when to run
How to use Filter, Formatter, and Delay to get the exact outcome you're looking for
When not to use the Schedule trigger
Resources
Email Parser
It is not uncommon for services to send emails when an order is made, a shipment delivered, and a whole host of other reasons. Parser by Zapier will let you receive and decompose the entire email into small pieces that can be used in Actions in a Zap.
While unable to deal with non-form emails or very complex structures, the standard transactional email that you receive for many business interactions is the perfect type of email to use in conjunction with Parser.
This video details how to make a Parser account and then how to access that data in the trigger of a Zap.
Resources