Send emails to Mailparser, get structured data in return. Leads, Contact Forms, eCommerce, Shipping Notes, Attachments, Customer Info & more.

Mailparser

Send emails to your custom "@robot.zapier.com" address and extract any data! Visit http://parser.zapier.com/ for more information!

Email Parser by Zapier

Docparser converts your PDF documents into structured and easy-to-handle data. With Docparser you can pull out specific data fields (e.g. Purchase Order Number, Date, Shipping Address, ...) and tabular data from your documents.

Docparser

Parserr allows you to turn incoming emails into useful data to use in various other 3rd party systems.

Parserr

Send documents such as emails, PDFs and spreadsheets to your custom Parseur mailbox and extract any data.

Parseur

We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.

**Highly recommended!** Usually you want the results to be most recent first so we can skim off only new results, so choose something like `date_created` or your autoincrement `id`. Column names that contain a space must be enclosed within brackets `[ ]`.

We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.

Query results must have a unique `id` field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.

**Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows**

Usually something auto-incremented like `id`. Must be unique. Column names that contain a space must be enclosed within brackets `[ ]`.

Usually something like `date_updated` or `last_modified`. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.

Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.

You should include desired ordering and limiting in the query.

**This query must run in less than ~30 seconds.**

You should include desired ordering and limiting (usually to 1 record) in the query.

**This query must run in less than ~30 seconds.**

SQL server (or MS SQL) is a top of the line database geared for the cloud

SQL Server

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

MySQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

PostgreSQL

Firebase Realtime Database and Google Cloud Firestore are flexible databases that give you the ability to easily store and sync app data at global scale.

Firebase / Firestore

Amazon Relational Database Services (RDS) allow you to set up, operate, and scale relational databases in the cloud.

Amazon Relational Database Services (RDS)

Mailparser.io is an easy way to extract data out of automated emails. Once you set up extraction rules, use Zapier to automatically add the data extracted to your SQL Server database as new records. You can include any extracted data in your new database records. 

Once you set up this integration, new emails received in your Mailparser.io mailbox from that point are added to SQL Server as new records. It's the perfect way to log your most important email messages.

A new email is received by a mailparser.io inbox

Zapier adds the extracted email data to your SQL Server database as a new record

A mailparser.io account with an inbox and parser rules set up

Mailparser + SQL Server

Add new Mailparser.io emails to a SQL Server database

New Email Parsed

New Row

Order By

Dedupe Key

New Table

New Row

Find Row

Find Row via Custom Query

New Column

New Row (Custom Query)

New or Updated Row

Trigger Column

Update Row

Find Multiple Rows via Custom Query

About Mailparser

Related categories

Similar apps