Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Pull data from excel attachment and append to a table

234 0
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