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.
Should be pretty straightforward with https://github.com/thoughtbot/griddler
Readme there is pretty clear too!
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.