How do I forward gmail raw email to a web service?

What is the best script, plugin or service to convert email to database table?

• We are receiving CSV files every 10 minutes to our email. This consists of a table that needs to be pulled in for our dashboard for administrators to make decisions. What creative solutions exist to do this? I see three potential options: (1) Get a script to go into our gmail account OR another script friendly email provide to pull the CSV file. (2) Use a tool or web service that can receive emails and automatically convert them to a table to pull into our database. (3) Use a plugin for our email that provides this functionality. All suggestions are appreciated! :-)

• Answer:

  Yes this is reasonably simple, and common. I always write these from scratch, because each need is different enough that you will need to customize things. If you are using MS SQL Server, you can do most of this with a tool called SSIS (SQL Server Integration Services). Here is my outline for your problem: Use POP3 or IMAP to actually go and fetch the message itself. Extract the file from message attachments Save the file to disk Start processing it. Depending up on the database you can: Create a file that contains SQL commands to batch. OR Create a load file. Use the tools that come with your database product to load that file into the table you specify. Which of these you choose depends on your business needs. It doesn't even matter what language you use to do this. All of them support this kind of capability. This is something a good Sys-Admin or a Computer Science student should be able to hack together pretty quickly. Have them write you a VB command line tool to do it. Then schedule that  with windows scheduler. put it on a server in your office.