HomeAboutMailing ListList Chatter /0/0 54.161.31.247

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
4233150360
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KQ2h1Z2FsdWcg
bWFpbGluZyBsaXN0CkNodWdhbHVnQGNodWdhbHVnLm9yZwpodHRwOi8vY2h1Z2FsdWcub3JnL2Nn
aS1iaW4vbWFpbG1hbi9saXN0aW5mby9jaHVnYWx1Zwo=

=============================================================== 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