About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How do I extract data from an attached Excel spreadsheet?

  • 30 September 2020
  • 5 replies
  • 2994 views
L
Userlevel 1

Hi!

I’m looking for a way to read data from an excel sheet which is attached to a daily automated email.

The sheet contains some hourly values and a total value for the day. 

I want to get this total value and add it to a central excel sheet to track the changes over time.

I’m struggling with the trigger here in Zapier and not sure if it’s possible to extract data from an email attachment. Unfortunately, I have no other way of sending the data than attached to an email.

icon

Best answer by steph.n 6 October 2020, 04:21

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

T

I’m interested to know the answer to your problem as well !

L
Userlevel 1

Well, I can save the excel sheet attachment to a OneDrive folder. That bit is fine. 

 

But, there’s no trigger to utilise a new excel document, only updates to an existing document.

 

Trying to figure out another way around this… its being quite frustrating TBH!

steph.n
Userlevel 7
Badge +8

Hi @leem209 and @Tizman - I wanted to direct you to this topic in hopes the solution here could be a workaround you can explore:

 

L
Userlevel 1

@Tizman I found MailParser.io is able to extract the required data from my email attachments. It’s really quite good! 
 

from there I can enter it into Zapier as a trigger and send that extracted data over to my central Excel file. 
 

Another step in the process and another account to manage but working so far, so good. 

BlakeBailey
Userlevel 5
Badge +1

I made a video for a question in our Process Street Community (still private/invite-only), and figured that someone might have asked a similar question here.

 

The trigger tool was AppFolio which has no integrations, but any tool that sends a CSV file will work. Obviously, you can strip out the Process Street stuff, or replace with whatever tool you want to use, if anything, after Google Sheets. 

Enjoy!

 

Also, let me know if there is a better thread for this, one of the other ones was already solved so I didn’t post there. 

 

https://www.loom.com/share/d90a8cb337b9483cbdd3a66186bd8efb

Terms & Conditions