HomeAboutMailing ListList Chatter /0/0

Pulling Invoice Data

2019-02-05 by: Ben Romines
From: Ben Romines 
Hi all,

I am wondering if there is a way that I can receive invoices via email and
then use that data to populate google sheets?

The end goal here is to no longer have to manually input the invoice, If
someone could point me in the right direction I would appreciate it.

Ben Romines (Lb)
Sous Chef, Main Street Meats

=============================================================== From: Keith ------------------------------------------------------ What type of files are the invoices (pdf, xlsx, doc, txt, etc)?

=============================================================== From: Ben Romines ------------------------------------------------------ When I receive them they are in html. On Tue, Feb 5, 2019, 6:01 PM Keith What type of files are the invoices (pdf, xlsx, doc, txt, etc)?

=============================================================== From: mcbb@bledsoe.net ------------------------------------------------------ can you send a sample? are they always in the same format?

=============================================================== From: Dan Lyke ------------------------------------------------------ On Thu, 7 Feb 2019 15:27:19 -0600 mcbb@bledsoe.net wrote: Yeah, this sounds like a job for Perl or Python, and some mail filters. Give us some examples and we can talk you through this! Dan

=============================================================== From: Keith ------------------------------------------------------ If it=E2=80=99s all google apps (gmail and sheets) I was thinking a google = app script would be the best bet. There is an importxml function that can import html into sheets I believe.

=============================================================== From: Andrew Rodgers ------------------------------------------------------ Yeah, I've done something like this before with google apps scripting. It's pretty seamless, and the GA APIs have improved a lot since last time I did this. Andrew e app