​@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}

Just came across this thread and wanted to say thanks for sharing your solution, ​@james968! Really appreciate you taking the time to do that—it’s incredibly helpful for others who might have the same question in future.  

Thanks for contributing to and improving the Community! 🧡

Sorry, I just realized the python code got mangled, when I pasted it (hopefully this is more understandable):

 

import re

input_string=input_data.get('DATE', '').split(','))1:]

MyDate=(input_stringg0].split(':'))0])):-3]

TEXT=input_data.get('RAW','')

print(TEXT)

RECEIVED=TEXT.split(' from '))0].split('$'))1]

ACCOUNT=TEXT.split(' - '))1].split('.'))0]

print(RECEIVED)

print(ACCOUNT)

print(help(input_data))

output = {'Date': MyDate,'Account':ACCOUNT,	'Amount':RECEIVED}

Hi ​@james968,

Thank you for sharing the right code for this one. This will significantly help our members with the same issue.