Hey Guys,
I need help with a Docparser workflow:
What am I trying to do:
I have 2 different document types that I need to verify the data matches. To do this I am using DOCPARSER
I submit a jotform containing the 2 different PDFs that then goes through ZAPIER to send both DOCS to DOCPARSER
Now to retrieve the data from DOCPARSER you need to use a new ZAP so what I have done is:
ZAP 1: Retrieve the first DOC and then CREATE a new google sheet from template and input the Parsed data into required row EASYPEASY.
ZAP 2 Retrieve the SECOND DOC and update the next required row
THE PROBLEM:
With ZAP 2: After I pull in the Parsed Data I need to Lookup the new Google Sheet Created in ZAP 1 But I cant work out how to do this?
Obviously because it will be a new sheet every time I cant just select the required sheet the usual way?
Does anyone have any words of wisdom to help?
Best answer by Danvers
View original