Why Doesn’t My Google Drive Node Filter Out Non-.png Files?

Below are two common approaches you can try:

---

1. Use an Advanced Query in the Google Drive Node

If you want to leverage Google Drive's API filtering, switch from a basic search to an advanced search. In your Google Drive node (with the Search operation):

• Change the Search Method to Advanced Search.
• Enter a Query String that filters by file type. For example, if you are looking for PNG images you can use:

TXTCopied
mimeType = 'image/png'

Using the MIME type is generally more accurate than filtering by file extension because Google Drive already provides it.

---

2. Use an IF Node to Filter the Results

If you need to filter files based on the file name (for instance, if some files might not have the correct MIME type set but the name ends with “.png”), you can filter after the Google Drive node. Do the following:

1. After your Google Drive Search node (which returns a list of files), add an IF (or Filter) node.

2. Configure the IF node with expression mode checking the file name. For example, set a condition like:

   • Field: {{$json["name"]}}
   • Condition: Use an expression like:

   JSCopied
   {{$json["name"].endsWith('.png')}}

3. Connect the true output of the IF node to subsequent nodes so that only items with a name ending in “.png” pass through.

If you only want a single file, you can further process this output with a Limit node to pass along the first (or desired) item.

---

Additional Notes

• Make sure your expression is correct – the JavaScript method .endsWith() is case sensitive. If your file names might have uppercase extensions (e.g. ".PNG"), you might need to normalize the case:

  JSCopied
  {{$json["name"].toLowerCase().endsWith('.png')}}

• Double-check that the node fields you’re accessing contain the expected data (i.e. the name property) so that the expression evaluates properly.

Using one of these two methods should help you filter your Google Drive file list down to just the single file with a .png extension.