I need help for A build my workflow

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