ConditionalVisibility

new-products-promo

zapier-formatter-guide-01-format-dates

Wistia

zapier-formatter-guide-02-split-text

zapier-formatter-guide-03-extract

zapier-formatter-guide-04-capitalize-text

zapier-formatter-guide-05-find-replace

zapier-formatter-guide-06-date-time

zapier-formatter-guide-07-markdown

Zapier Formatter Lookup Table

Zapier feature guides

00-zapier-formatter-logo

Formatter by Zapier

Do your apps play nicely together? With Zapier’s built-in Formatter tool, you can make text work for any of the apps you use, automatically. 

The Zapier Formatter guide: How to automatically format text the way you want

Draft your content in Markdown in GitHub issues and send it directly to your Ghost site with this integration. This allows you to connect your GitHub account, update any repository, and save time importing new draft posts to Ghost Admin.

GitHub is the perfect place to share code and work collaboratively on private and open source software.

GitHub

New Branch

Triggers when you add a new collaborator.

New Collaborator

Triggers when a new comment on a commit is created.

New Commit Comment

New Commit

Triggers when anything happens on a repo.

New Repo Event

Triggers when you add/star a gist (public or private).

New Gist

Triggers when anything happens from or to you, on any repo.

New Global Event

New Issue

New Label

Triggers when your Github username is mentioned in a Commit, Comment, Issue or Pull Request.

New Mention

Triggers when a new milestone is created.

New Milestone

Triggers when a new notification is created.

New Notification

Triggers when a new organization is created.

New Organization

Triggers when a new pull request is created.

New Pull Request

New Release

Triggers when a new repository is created.

New Repository

Triggers when a review is requested from you or a specified user.

New Review Request

New Team

Triggers when a new watcher is added to a repo.

New Watcher

Check Organization Membership

Find an organization, whether or not you are a member.

Find Organization

Find Repository

Find Issue

Find Pull Request

Find User

Finds or creates a specific repo issue by title.

Find or Create an Issue

Finds or creates a specific repo pull by title.

Find or Create a Pull Request

Creates a new comment in an Issue or Pull Request.

Create Comment

Delete Branch

Create Gist

Create Issue

Create a new pull request and merge it (optional).

Create Pull Request

Set Profile Status

Submit Review

Update Issue

Update Pull Request

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.

Work with dates and times to change formatting or add/subtract time (with line-item support).

Date / Time

Work with numeric data to do math operations, reformat currencies, and more (with line-item support).

Numbers

Work with text data to find & replace, capitalize, remove HTML, and more (with line-item support).

Text

Various utilities like "choose value from list" or "look up in table" (with line-item support).

Utilities

A professional creator platform for publishing content, sending newsletters, and running a subscription business.

Ghost

Triggers when a new member is added (requires Ghost 3.0.0 or later).

Member Created

Triggers when a member is deleted (requires Ghost 3.0.3 or later).

Member Deleted

Triggers when a member is updated (requires Ghost 3.0.3 or later).

Member Updated

Page Published

Post Published

Post Scheduled

Triggers when a new subscriber is added (Subscribers feature is deprecated and is replaced by [members](https://ghost.org/docs/members/zapier/) in Ghost 3.0 or later).

Subscriber Created (Deprecated)

Triggers when a subscriber is deleted (Subscribers feature is deprecated and is replaced by [members](https://ghost.org/docs/members/zapier/) in Ghost 3.0 or later).

Subscriber Deleted (Deprecated)

Search for an author by email address or slug.

Find an Author

Find a Member

Search for a subscriber by email address. (Subscribers feature is deprecated and is replaced by [members](https://ghost.org/docs/members/zapier/) in Ghost 3.0 or later)

Find a Subscriber (Deprecated)

Creates a member (Only supported by Ghost 3.0.0 and later)

Create Member

Create Post

Creates a subscriber. (Subscribers feature is deprecated and is replaced by [members](https://ghost.org/docs/members/zapier/) in Ghost 3.0 or later)

Create Subscriber (Deprecated)

Deletes a subscriber. (Subscribers feature is deprecated and is replaced by [members](https://ghost.org/docs/members/zapier/) in Ghost 3.0 or later)

Delete Subscriber (Deprecated)

Updates a member (Only supported by Ghost 3.0.0 and later)

Update Member

Send Markdown drafts from new GitHub issues to Ghost

You use OneNote for your journal, research, notes--why not blogging? After you've set up this automation, it can prepare those posts for you. Whenever you create a new note in a specific section on OneNote, Zapier will then use the details to create a draft post on WordPress, getting everything ready for when you want to finish your work.

Microsoft OneNote is a note-taking app that makes it easy to capture and save ideas, images, audio recordings, and anything else you need to remember.

OneNote

Triggers when a new note is created in a notebook/section.

New Note in Section

Append Note

Creates a note with an embedded image (must have a public URL to that image).

Create Image Note

Create a new note in the "Quick Notes" section of your default notebook.

Create Note

Creates a new note in a specific Notebook/Section

Create Note in Section

Given a URL, we'll download it and place it in your OneNote account!

Create Page/Note From Url Link

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

WordPress is web software you can use to create a beautiful website or blog. Nearly 20% of the top 10 million websites and over 60 million people have chosen WordPress to power the place on the web they call "home".

WordPress

New Comment

New Media

New Post

Updated Post

Updated User

New User

Find Post

Finds a user with a default user role. Does not search users with custom roles created by plugins.

Find or Create User

Upload a new media file, which can be used as featured media.

Upload Media

Update Post

Create User

Add WordPress posts from new notes on OneNote

If you need to keep track of contact data as it comes into your inbox, this is the integration for you. It automatically captures a sender's email address as soon as a new email comes into your Gmail account, then sends that detail to a row in a specified Google Sheets spreadsheet.

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

Gmail

Triggers when you receive a new attachment.

New Attachment

Triggers when you receive a new email and label it within two days.

New Labeled Email

Triggers when a new email appears in the specified mailbox.

New Email

Triggers when you receive a new email that matches a search string you provide.

New Email Matching Search

Triggers when you receive a new email and star it within two days.

New Starred Email

New Thread

Find Email

Find or Send Email

Add Label to Email

Delete Email

Create Draft

Create a draft reply to an existing email.

Create Draft Reply

Create Label

Send Email

Remove Label From Email

Reply to Email

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Google Sheets

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or modified in a spreadsheet - works best with Team Drives.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

The Zapier Formatter guide: How to automatically format text the way you want

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.