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