Skip to Workflow Atlas
ETL PipelineIntermediate

Keyword Trend Analysis and Storage Workflow

Keyword Trend Analysis and Storage Workflow is a 15-node automation blueprint connecting Google Trends, 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.

15

Nodes

15

Links

1

Run groups

Connected tools

2 integrations

  • Google Trends
  • Google Sheets

Canvas controls

Fit wide systems, then zoom into any run group.

Keyword Trend Analysis and Storage Workflow execution lanes1 run groups containing 15 workflow nodes and 15 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 OUTStart every hour past 11 minutes. trigger node, scheduleTrigger. 0 incoming and 1 outgoing connections.STARTStart every hour past 11 …TRIGGERSCHEDULETRIGGER0 IN / 1 OUTCONFIG. transform node, set. 2 incoming and 1 outgoing connections.STEP 02CONFIGTRANSFORMSET2 IN / 1 OUTGet saved keywords. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 03Get saved keywordsGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTGoogleTrends. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 04GoogleTrendsINTEGRATIONHTTPREQUEST1 IN / 1 OUTXML. integration node, xml. 1 incoming and 1 outgoing connections.STEP 05XMLINTEGRATIONXML1 IN / 1 OUTNew keywords. transform node, code. 1 incoming and 1 outgoing connections.STEP 06New keywordsTRANSFORMCODE1 IN / 1 OUTLoop Over Items. integration node, splitInBatches. 2 incoming and 2 outgoing connections.STEP 07Loop Over ItemsINTEGRATIONSPLITINBATCHES2 IN / 2 OUTMapping. transform node, set. 1 incoming and 1 outgoing connections.STEP 08MappingTRANSFORMSET1 IN / 1 OUTcontent1. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 09content1INTEGRATIONHTTPREQUEST1 IN / 1 OUTIf we have scraped min 1 url -> Save. decision node, if. 1 incoming and 2 outgoing connections.STEP 10If we have scraped min 1 …DECISIONIF1 IN / 2 OUTcontent2. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 11content2INTEGRATIONHTTPREQUEST1 IN / 1 OUTcontent3. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 12content3INTEGRATIONHTTPREQUEST1 IN / 1 OUTGoogle Sheets. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.STEP 13Google SheetsGOOGLE SHEETSGOOGLESHEETS1 IN / 0 OUTAll scraping node failed. Don't save record without summary. integration node, noOp. 1 incoming and 0 outgoing connections.OUTCOMEAll scraping node failed.…INTEGRATIONNOOP1 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.15 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’

15 Execution Links
  1. Start

    When clicking ‘Test workflow’

    Trigger

    Start every hour past 11 minutes

    Trigger

  2. Step 2

    CONFIG

    Transform

  3. Step 3

    Get saved keywords

    Integration

  4. Step 4

    GoogleTrends

    Integration

  5. Step 5

    XML

    Integration

  6. Step 6

    New keywords

    Transform

  7. Step 7

    Loop Over Items

    Integration

  8. Step 8

    Mapping

    Transform

  9. Step 9

    content1

    Integration

  10. Step 10

    If we have scraped min 1 url -> Save

    Decision

  11. Step 11

    content2

    Integration

  12. Step 12

    content3

    Integration

  13. Step 13

    Google Sheets

    Integration

  14. Outcome

    All scraping node failed. Don't save record without summary

    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.