Skip to main content

Can I automate adding records to a table via CSV attachments to email?

  • September 7, 2018
  • 3 replies
  • 52 views

Every day, I receive an automated email from my reporting system that includes a CSV attachment.
Every day, I open that CSV attachment, copy all the data, and manually paste it over one of the tables in my base, overwriting whatever was already there.
I’m trying to come up with a way of doing this that doesn’t require my manual copy-paste. I can’t use an API or any direct integration … all I have are these CSV attachments. I’m hoping to find a service where I can just forward on these emails, and the updating happens automatically.
Is there any Block or 3rd party integration that would allow me to do this?
Thank you!

This topic has been closed for replies.

3 replies

Forum|alt.badge.img+18

Every day… :man_facepalming: ugh

There is a Block that should make it a bit easier. The “CSV import” block should make it a drag-n-drop process for you. No need to even open the file up once you get your fields set up in the block:


Forum|alt.badge.img+19
  • Inspiring
  • September 7, 2018

You could likely do this with Zapier. Let me know if you need assistance (dan@openside.com)


Tuur
Forum|alt.badge.img+20
  • Inspiring
  • September 8, 2018

If it doesn’t work out for you with standard tools I’d be happy to help you with a custom solution.

Feel free to contact me in that case… :slightly_smiling_face: