Skip to main content

Hi,

I have a Zap configrued that takes an email message and then (using python script) it parses the message and inserts it into a spreadsheet.  It works for “New” messages, but for old messages it can’t find them.  (Originally it is based on the “Save new Gmail emails matching certain traits to a Google Spreadsheet” , with an intermediate step to process the message using python).

(I have tried marking the messages as unready, but no luck).

If there a way to tell the zap to proces the histroic email? 

 

 

@james968 

You could try using the New Labelled Email trigger. Create an historic email label, set up and publish your zap. Then label the emails you want to process. You could start with one or two as a test cases then bulk label the ones you need to process.

You could duplicate/copy the original zap then change the trigger to the New Labelled Email and see if that works. 


Thanks for the suggestion.  I actually used google Takeout, to export the Historic data, then used an existing python script to extract the data and then merged it with the data from the Zap. 

 

The Zap has continued to work correctly and merges new data in w/out any issue (knock n wood).

“Basically M1 send my a note saying:

> You got paid $1.35 in Dividends in account 123

So I just want this auto added (in the correct column ) to the sheet. 

Here’s the python code I used to parse out the data….. it is very simple, and it is only to help me track my personal stuff.

import reinput_string=input_data.get('DATE', '').split(',')s1:]MyDate=(input_stringp0].split(':')s0])t:-3]TEXT=input_data.get('RAW','')RECEIVED=TEXT.split(' from ')(0].split('$')s1]ACCOUNT=TEXT.split(' - ')l1].split('.')s0]output = {'Date': MyDate,'Account':ACCOUNT,	'Amount':RECEIVED}

Reply