How to Automatically Parse CSV Attachment to Database

Parse CSV attachments to database

Sometimes it’s just easier to email a file than upload it to a server. If you run an online business, you may receive transaction confirmation emails with CSV attachments, or monthly sales reports with attached CSV documents, or support tickets with attachments. And you may need to regularly update your database with the data received via CSV files arriving as email attachments.

How to Automatically Parse Emails from Web Forms

Parse email from web form

Many online businesses have web forms that visitors fill in such as newsletter subscription forms, registration forms, contact forms, survey forms etc. After a visitor submits the form, the content is sent to the web site owner via email. Getting the form data as emails is a very convenient way to collect user responses very quickly. But when you have hundreds of responses per day, processing them manually can be very challenging.

How to Create PDF Documents from Received Emails

Create PDF from Email

G-Lock Email Processor can automate the conversion of emails into PDF files as you receive. Thus, it’s a great way to create PDF receipts or invoices from order confirmation emails sent to you by your payment system.  

Then G-Lock Email Processor can automatically send the PDF file as an attachment on outgoing messages, or add it to your file system or database, or upload to DropBox, OneDrive or other virtual file storage system. 

How to Automatically Parse Email to Database

Extract data and parse email to database

Extract Data from Incoming Emails and Convert It to Database

If you’re doing business online, you probably maintain a database of your customers, clients, or subscribers. Typically you store the customers’ email addresses, names, order numbers, and purchased products in the database. Plus, you may want to keep the customer’s personal information such as postal addresses, phone numbers, fax numbers and much more in your database. It’s a large volume of data that you need to keep in order — add new customers, remove customers, and update the customer’ information on their request.

How to Automatically Parse Email to an Excel Spreadsheet

Extract data and parse email to Excel

Extract Data from Incoming Emails and Convert It to Excel

Many people receive hundred emails to their Inbox containing data filled out via a website form and they are looking for a solution how to parse these emails into an Excel spreadsheet automatically.

Is there a tool where you can define a parse “template” which would filter incoming messages, extract the desired data from the messages and auto parse the data into the Excel columns? 

Yes, you can use G-Lock Email Processor to automate parsing emails to Excel spreadsheets.

How to Automatically Parse Email to CSV

Extract data and parse email to CSV

Extract Data from Incoming Emails and Convert It to CSV

If it happened to you to copy data from incoming messages and paste it to a CSV file, manually, you know what time consuming and boring this work is.  And if you have dozens or even hundreds emails you need to process? This is eating almost all working time. 

Luckily, now you can stop your manual work and use G-Lock Email Processor to automate your email workflow.

How to Extract Email Attachments and Save Them to a Network Drive

G-Lock Email Processor offers great features for automatic attachment processing. With G-Lock Email Processor you can automatically extract attachments from incoming messages and save them to the hard disc. Plus, G-Lock Email Processor can rename the attachment based on your settings and save it to a folder under a new name. This program recognizes email attachments in most standard business formats, including PDF, TIFF, Word and Excel documents.

How to Process Bounced Emails

G-Lock Email Processor is supplied with the rule which collects bounced emails from your mail server (POP3 or IMAP), extracts the email addresses from bounced emails and saves them to different files depending on the bounced email type.

The rule is called "Collect Bounced Emails" and includes the "Bounce Processor" and "Save Bounced Emails" components.

The Bounce Processor component identifies bounced emails on the server and extracts the following fields from bounced emails: