Ask A Question

Notifications

You’re not receiving notifications from this thread.

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

Daniel Chapman asked in Rails

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.

Reply

Should be pretty straightforward with https://github.com/thoughtbot/griddler

Readme there is pretty clear too!

Reply

Thanks, ill check it out.

Reply

Be sure to add any questions if you have any!

Reply

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.

Reply
Join the discussion

Want to stay up-to-date with Ruby on Rails?

Join 74,071+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more. Icons by Icons8

    © 2023 GoRails, LLC. All rights reserved.