Skip to Workflow Atlas
Playbook AtlasWorkflow Atlas
Workflow blueprintBrowse workflows
ETL PipelineAI systemIntermediate

Google Docs Sharing & Reporting Automation

Google Docs Sharing & Reporting Automation is a 14-node automation blueprint connecting Google Sheets, Google Drive, Gmail. Inspect its trigger, execution graph, branches, and implementation requirements.

Google SheetsGoogle DriveGmail

Interactive system map

Follow the runtime. Inspect what supports it.

Solid horizontal paths show main-channel execution. Violet dependencies sit beneath the exact step they configure or empower.

14

Nodes

14

Links

1

Run groups

Connected tools

3 integrations

  • Google Sheets
  • Google Drive
  • Gmail

Canvas controls

Fit wide systems, then zoom into any run group.

Google Docs Sharing & Reporting Automation execution lanes1 run groups containing 14 workflow nodes and 14 visible links. Solid horizontal lines are main-channel runtime links. Violet dashed lines connect typed dependencies beneath the runtime step they support. Focus any node to inspect its immediate path.Schedule Trigger. trigger node, scheduleTrigger. 0 incoming and 1 outgoing connections.STARTSchedule TriggerTRIGGERSCHEDULETRIGGER0 IN / 1 OUTCreate New Sheet. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 02Create New SheetGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTGet Recently Active Documents. Google Drive node, googleDrive. 1 incoming and 1 outgoing connections.STEP 03Get Recently Active Docum…GOOGLE DRIVEGOOGLEDRIVE1 IN / 1 OUTHas Shared with External Users. decision node, filter. 1 incoming and 1 outgoing connections.STEP 04Has Shared with External …DECISIONFILTER1 IN / 1 OUTFor Each File. integration node, splitInBatches. 2 incoming and 2 outgoing connections.STEP 05For Each FileINTEGRATIONSPLITINBATCHES2 IN / 2 OUTFile Ref. integration node, noOp. 1 incoming and 1 outgoing connections.STEP 06File RefINTEGRATIONNOOP1 IN / 1 OUTPermissions To Items. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 07Permissions To ItemsTRANSFORMSPLITOUT1 IN / 1 OUTFilter Out Owner of Document. decision node, filter. 1 incoming and 1 outgoing connections.STEP 08Filter Out Owner of Docum…DECISIONFILTER1 IN / 1 OUTNormalise Fields. transform node, set. 1 incoming and 1 outgoing connections.STEP 09Normalise FieldsTRANSFORMSET1 IN / 1 OUTAggregate. transform node, aggregate. 1 incoming and 1 outgoing connections.STEP 10AggregateTRANSFORMAGGREGATE1 IN / 1 OUTFlatten Rows. transform node, set. 1 incoming and 1 outgoing connections.STEP 11Flatten RowsTRANSFORMSET1 IN / 1 OUTRows to Items. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 12Rows to ItemsTRANSFORMSPLITOUT1 IN / 1 OUTAppend to New Sheet. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 13Append to New SheetGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTSend Email Report (Execute Once). Gmail node, gmail. 1 incoming and 0 outgoing connections.OUTCOMESend Email Report (Execut…GMAILGMAIL1 IN / 0 OUT

Signal inspector

Focus, hover, or select a step to isolate its runtime and support links.

Main-channel runtimeTyped dependencytriggeraidecisiontransformintegration
Scroll horizontally to follow every connected flow.14 connected nodesEnter or click to lock · Escape to clear

Runtime breakdown

Read the execution spine before its dependencies.

Each run group separates main-channel steps from the models, tools, retrievers, and data services that support them. Start and outcome labels apply only to runtime nodes.

01

Run Group

Schedule Trigger

14 Execution Links

  1. Start

    Schedule Trigger

    Trigger

  2. Step 2

    Create New Sheet

    Integration

  3. Step 3

    Get Recently Active Documents

    Integration

  4. Step 4

    Has Shared with External Users

    Decision

  5. Step 5

    For Each File

    Integration

  6. Step 6

    File Ref

    Integration

  7. Step 7

    Permissions To Items

    Transform

  8. Step 8

    Filter Out Owner of Document

    Decision

  9. Step 9

    Normalise Fields

    Transform

  10. Step 10

    Aggregate

    Transform

  11. Step 11

    Flatten Rows

    Transform

  12. Step 12

    Rows to Items

    Transform

  13. Step 13

    Append to New Sheet

    Integration

  14. Outcome

    Send Email Report (Execute Once)

    Integration

Turn the map into a plan

Adapt this blueprint to your company.

Bring the system shape into a workspace, then define the production controls, data boundaries, owners, and delivery sequence around your context.

Create a build planReturn to the atlas