Pull data from excel attachment and append to a table

[mbhagwat]

Hi everyone!

I'm trying to set up an automation which is triggered every time I receive an email with a particular subject line. I want it to follow a workflow where Airtable parses through an excel report in the email, extracts the data from the file, and appends it to a pre existing table.

Attached below is a screenshot of what I was trying to do, but I don't see any options to extract data from an attachment.

Can someone please advise on how I can do this?

TIA!

[ScottWorld]

You might be able to write a custom JavaScript for that, but I don’t know JavaScript so I can’t tell you for sure.

For a no-code way of doing it that doesn’t require writing code, I would check out Make’s advanced automations & integrations.

If you’ve never used Make before, it will likely take you several hours to learn how to use it, so I’ve assembled a bunch of Make training resources in this thread. I also give live demonstrations of how I use Make in many of my Airtable podcast appearances here.

— ScottWorld, Expert Airtable Consultant