Hi guys,
I have just recently begun working with the n8n for my job so I am a definite beginner and I could use some assistance in creating a relatively simple workflow. I will provide a detailed description of what I want:
I have folder 1(on google drive) with document A from supplier X (lets say an invoice) and a folder 2(google drive) that contains document B from supplier X(lets say a supplier delivery note). The various documents are added to the storage on a daily basis(abt 1-5) , each document has a different formatting and structure however the unique identifier for both doc A and B is a 6 digit number with a letter(for example A123456).
I want to create a workflow that that would check both folders every hour, download files,read them and match them if the criteria is fulfilled which is based on this unique identifier and then merge two pdfs into one and then upload the merged PDF into Folder 3.
I tried to use an LLM for this but I know that I am missing something. I will upload my workflow.
If anyone wishes to create this workflow for me or guide me I would appreciate it greatly.