Here my workflow to get only pdf from Gmail and upload to Google Drive and Append in g sheet .
My problem is ones i upload a pdf i want to filtered out the existing pdf in Google Drive , I want to upload only new pdf.
I am can’t able to do this , please Help me
There are different ways to achieve this functionality.
How I would go about this:
- Create a Label in Gmail e.g.: “Uploaded”
- Filter your received Gmail messages, so only proceed with the items that are not having this label
- When successfully uploaded, add the label via Gmail node to the email item
Another option:
- Add a column to your sheet that is populated with the Gmail message Id
- Filter your gmail items by this Id and only proceed with the items that are not in your sheet
- When appending the row in sheet, add the message Id
2 Likes
What if you append the row before adding the PDF to your drive? Then your flow will know what’s already been added and only add the new PDF.
1 Like
Hey @For_n8n_learning !
Between your Code and the Drive nodes, you can put an “Remove Duplicates” node…
It has a very extensive flexibility, for remembering node or workflowexecution data.
Check here docs :
Cheers!
3 Likes
This problem has bin Solved
1 Like