Skip to Workflow Atlas
ETL PipelineAI systemIntermediate

Google Drive to Google Sheets Automation

Google Drive to Google Sheets Automation is a 12-node automation blueprint connecting Google Drive, OpenAI, Google Sheets. Inspect its trigger, execution graph, branches, and implementation requirements.

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.

12

Nodes

12

Links

1

Run groups

Connected tools

3 integrations

  • Google Drive
  • OpenAI
  • Google Sheets

Canvas controls

Fit wide systems, then zoom into any run group.

Google Drive to Google Sheets Automation execution lanes1 run groups containing 12 workflow nodes and 12 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.When clicking ‘Test workflow’. trigger node, manualTrigger. 0 incoming and 1 outgoing connections.STARTWhen clicking ‘Test workf…TRIGGERMANUALTRIGGER0 IN / 1 OUTSearch in "Keep" folder. Google Drive node, googleDrive. 1 incoming and 1 outgoing connections.STEP 02Search in "Keep" folderGOOGLE DRIVEGOOGLEDRIVE1 IN / 1 OUTLoop every 10 items. integration node, splitInBatches. 2 incoming and 1 outgoing connections.STEP 03Loop every 10 itemsINTEGRATIONSPLITINBATCHES2 IN / 1 OUTIf extension is json. decision node, filter. 1 incoming and 1 outgoing connections.STEP 04If extension is jsonDECISIONFILTER1 IN / 1 OUTDownload the files. Google Drive node, googleDrive. 1 incoming and 1 outgoing connections.STEP 05Download the filesGOOGLE DRIVEGOOGLEDRIVE1 IN / 1 OUTExtract from File. integration node, extractFromFile. 1 incoming and 1 outgoing connections.STEP 06Extract from FileINTEGRATIONEXTRACTFROMFILE1 IN / 1 OUTFilter. decision node, if. 1 incoming and 1 outgoing connections.STEP 07FilterDECISIONIF1 IN / 1 OUTIf is archived is false. decision node, if. 1 incoming and 1 outgoing connections.STEP 08If is archived is falseDECISIONIF1 IN / 1 OUTPut some AI treatment here if you need it. ai node, agent. 2 incoming and 1 outgoing connections.STEP 09Put some AI treatment her…AIAGENT2 IN / 1 OUTSet the fields for export. transform node, set. 1 incoming and 1 outgoing connections.STEP 10Set the fields for exportTRANSFORMSET1 IN / 1 OUTAdd to google sheet. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.OUTCOMEAdd to google sheetGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTOpenAI Chat Model. OpenAI node, lmChatOpenAi. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1OpenAI Chat ModelOPENAILMCHATOPENAI0 IN / 1 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.12 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

When clicking ‘Test workflow’

11 Execution Links1 Support Dependency
  1. Start

    When clicking ‘Test workflow’

    Trigger

  2. Step 2

    Search in "Keep" folder

    Integration

  3. Step 3

    Loop every 10 items

    Integration

  4. Step 4

    If extension is json

    Decision

  5. Step 5

    Download the files

    Integration

  6. Step 6

    Extract from File

    Integration

  7. Step 7

    Filter

    Decision

  8. Step 8

    If is archived is false

    Decision

  9. Step 9

    Put some AI treatment here if you need it

    AI reasoning

  10. Step 10

    Set the fields for export

    Transform

  11. Outcome

    Add to google sheet

    Integration

Attached dependencies

These nodes support the runtime above; they are not additional starts or outcomes.

1 node
  • OpenAI Chat Model

    AI reasoning dependency

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.