Any good idea how to import CSV via Sendgrid email attachment and update model/database columns.

Basically receive incoming daily emails, with CSV attachment, then importing the CSV rows to your desired model/database.

Anyone done this before?

Thanks for any input.

Thanks, ill check it out.

Daniel I'm with Jack and recommend you use Griddler for inbound email. I currently use it to capture attachments on inbound emails and store them to S3.

Process the email, check for a filetype of CSV (or against name etc.) then process as a normal CSV import. Ruby supports this natively or you can use the smarter-csv gem.