Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Pull data from excel attachment and append to a table

401 1
cancel
Showing results for 
Search instead for 
Did you mean: 
mbhagwat
4 - Data Explorer
4 - Data Explorer

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.

mbhagwat_0-1725561956455.png

Can someone please advise on how I can do this?

TIA!

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

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 threadI also give live demonstrations of how I use Make in many of my Airtable podcast appearances here.

— ScottWorld, Expert Airtable Consultant