(5/5)

Filter Workflow

Automated workflow: Filter Workflow. This workflow integrates 12 different services: filter, stickyNote, scheduleTrigger, splitOut, googleDrive. It contains 22 nodes and follows best practices for error handling and security.

Integrations Used (4)

Workflow Structure (15 nodes)

100%

Schedule Trigger

Google Sheets

Create New Sheet

Google Drive

Get Recently Active Documents

Filter

Has Shared with External Users

Split In Batches

For Each File

No Op

File Ref

Split Out

Permissions To Items

Filter

Filter Out Owner of Document

Set

Normalise Fields

Aggregate

Set

Flatten Rows

Split Out

Rows to Items

Google Sheets

Append to New Sheet

Gmail

Send Email Report (Execute Once)

Stop And Error

Error Handler

Node Types:

logic

action

transform

default

trigger

Requires credentials

Prerequisites

Required Credentials (3)

Gmail

Used by: Send Email Report (Execute Once)

Docs

Google Drive

Used by: Get Recently Active Documents

Docs

Google Sheets

Used by: Create New Sheet, Append to New Sheet

Docs

Multiple services required

This workflow needs 3 different credentials. Make sure you have accounts for all services before importing.

Complexity

Complex

Advanced features used. Requires n8n experience.

Setup time: ~40 min

Score: 57/100

Loops

8 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Email Automation

Automate email responses, forwarding, or organization based on rules.

Handle routine email tasks automatically and focus on what matters.

Scheduled Operations

Run automated tasks at specific times - daily reports, weekly cleanups, monthly backups.

Set it and forget it - reliable automation that runs on your schedule.

workflow.json

{
  "meta": {
    "instanceId": "workflow-a0996b58",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:53.360361",
    "updatedAt": "2025-09-29T07:07:53.360375",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "nodes": [
    {
      "id": "f8f5a571-c4de-469e-a182-faa60060d06b",
      "name": "Has Shared with External Users",
      "type": "n8n-nodes-base.filter",
      "position": [
        40,
...