Script that pulls table data in MKTO report email into Google sheet?

Jared_Eliason1
Level 1

Script that pulls table data in MKTO report email into Google sheet?

Looking to see if anyone has used or is aware of a script that can pull tabulated data in MKTO report email into a Google sheet. 

 

What I want to do: 

  • Example: email performance report, report subscription sends email to inbox, report email table has in each row the name of the email program and the standard email metrics results. (same concept for prog performance report, etc)
  • Script/tool pulls data from the rows in the email table and, in a Google sheet that it's linked to, either A) updates an existing row if there's a program name match, or B) creates a new row. 

Any recommendations on either a tool that does this and/or what kind of developer could build a script like this?

2 REPLIES 2
SanfordWhiteman
Level 10 - Community Moderator

Re: Script that pulls table data in MKTO report email into Google sheet?

Rather not call this a "script" because it could be built in a variety of languages. (Even that ubiquitous language with "script" in its name isn't merely a scripting language anymore!)

 

By sending the report to an email processor like Amazon SES, you can then invoke code (a Lambda fn in this case -- could be JavaScript but also could be Java, Go, whatever) to parse the report, map fields/values, and insert using the Sheets API.

 

There are also some services that package parts of the process (ThinkAutomation/Email2DB et al) though I like the complete control of SES. It's also going to be more cost-effective to use SES after initial dev cost.

Jared_Eliason1
Level 1

Re: Script that pulls table data in MKTO report email into Google sheet?