Skip to Workflow Atlas
Playbook AtlasWorkflow Atlas
Workflow blueprintBrowse workflows
ETL PipelineIntermediate

HubSpot-Google Sheets Data Automation

HubSpot-Google Sheets Data Automation is a 26-node automation blueprint connecting HubSpot, Google Sheets. Inspect its trigger, execution graph, branches, and implementation requirements.

HubSpotGoogle Sheets

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.

26

Nodes

26

Links

2

Run groups

Connected tools

2 integrations

  • HubSpot
  • Google Sheets

Canvas controls

Fit wide systems, then zoom into any run group.

HubSpot-Google Sheets Data Automation execution lanes2 run groups containing 26 workflow nodes and 26 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.File upload form. trigger node, formTrigger. 0 incoming and 2 outgoing connections.STARTFile upload formTRIGGERFORMTRIGGER0 IN / 2 OUTGet the content of file. integration node, extractFromFile. 1 incoming and 1 outgoing connections.STEP 02Get the content of fileINTEGRATIONEXTRACTFROMFILE1 IN / 1 OUTTo get the first line of file. integration node, extractFromFile. 1 incoming and 1 outgoing connections.STEP 02To get the first line of …INTEGRATIONEXTRACTFROMFILE1 IN / 1 OUTSet the real fields. transform node, set. 1 incoming and 1 outgoing connections.STEP 03Set the real fieldsTRANSFORMSET1 IN / 1 OUTMerge fields and data. decision node, merge. 2 incoming and 1 outgoing connections.STEP 04Merge fields and dataDECISIONMERGE2 IN / 1 OUTGet the fields from the sheet. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 05Get the fields from the s…GOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTCheck if all fields from input are defined. transform node, code. 1 incoming and 1 outgoing connections.STEP 06Check if all fields from …TRANSFORMCODE1 IN / 1 OUTIf all fields are defined. decision node, if. 1 incoming and 2 outgoing connections.STEP 07If all fields are definedDECISIONIF1 IN / 2 OUTSet the values for each field. transform node, code. 1 incoming and 1 outgoing connections.STEP 08Set the values for each f…TRANSFORMCODE1 IN / 1 OUTCreates the correspondance table. transform node, code. 1 incoming and 1 outgoing connections.STEP 08Creates the correspondanc…TRANSFORMCODE1 IN / 1 OUTForm to set the correponding field for each input field. integration node, form. 1 incoming and 1 outgoing connections.STEP 09Form to set the correpond…INTEGRATIONFORM1 IN / 1 OUTSet the values for each field1. transform node, code. 1 incoming and 1 outgoing connections.STEP 10Set the values for each f…TRANSFORMCODE1 IN / 1 OUTSplit all records to import. transform node, splitOut. 2 incoming and 1 outgoing connections.STEP 11Split all records to importTRANSFORMSPLITOUT2 IN / 1 OUTDefine properties. transform node, set. 1 incoming and 1 outgoing connections.STEP 12Define propertiesTRANSFORMSET1 IN / 1 OUTUploads to Hubspot. HubSpot node, httpRequest. 1 incoming and 1 outgoing connections.STEP 13Uploads to HubspotHUBSPOTHTTPREQUEST1 IN / 1 OUTForm response. integration node, form. 1 incoming and 0 outgoing connections.OUTCOMEForm responseINTEGRATIONFORM1 IN / 0 OUTStart here to update your field list. trigger node, manualTrigger. 0 incoming and 1 outgoing connections.STARTStart here to update your…TRIGGERMANUALTRIGGER0 IN / 1 OUTErase Google sheet. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 02Erase Google sheetGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTDefine array of objects. transform node, set. 1 incoming and 1 outgoing connections.STEP 03Define array of objectsTRANSFORMSET1 IN / 1 OUTSplit by object. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 04Split by objectTRANSFORMSPLITOUT1 IN / 1 OUTFetch properties from Hubspot. HubSpot node, httpRequest. 1 incoming and 1 outgoing connections.STEP 05Fetch properties from Hub…HUBSPOTHTTPREQUEST1 IN / 1 OUTDefine crm_type. transform node, code. 1 incoming and 1 outgoing connections.STEP 06Define crm_typeTRANSFORMCODE1 IN / 1 OUTSplit results. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 07Split resultsTRANSFORMSPLITOUT1 IN / 1 OUTRemove hidden and starting with hs_ props fields. decision node, filter. 1 incoming and 1 outgoing connections.STEP 08Remove hidden and startin…DECISIONFILTER1 IN / 1 OUTTransforms the results. transform node, code. 1 incoming and 1 outgoing connections.STEP 09Transforms the resultsTRANSFORMCODE1 IN / 1 OUTAppend to Google sheet. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.OUTCOMEAppend to Google sheetGOOGLE SHEETSGOOGLESHEETS1 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.26 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

File upload form

17 Execution Links

  1. Start

    File upload form

    Trigger

  2. Step 2

    Get the content of file

    Integration

    To get the first line of file

    Integration

  3. Step 3

    Set the real fields

    Transform

  4. Step 4

    Merge fields and data

    Decision

  5. Step 5

    Get the fields from the sheet

    Integration

  6. Step 6

    Check if all fields from input are defined

    Transform

  7. Step 7

    If all fields are defined

    Decision

  8. Step 8

    Set the values for each field

    Transform

    Creates the correspondance table

    Transform

  9. Step 9

    Form to set the correponding field for each input field

    Integration

  10. Step 10

    Set the values for each field1

    Transform

  11. Step 11

    Split all records to import

    Transform

  12. Step 12

    Define properties

    Transform

  13. Step 13

    Uploads to Hubspot

    Integration

  14. Outcome

    Form response

    Integration

02

Run Group

Start here to update your fiel…

9 Execution Links

  1. Start

    Start here to update your field list

    Trigger

  2. Step 2

    Erase Google sheet

    Integration

  3. Step 3

    Define array of objects

    Transform

  4. Step 4

    Split by object

    Transform

  5. Step 5

    Fetch properties from Hubspot

    Integration

  6. Step 6

    Define crm_type

    Transform

  7. Step 7

    Split results

    Transform

  8. Step 8

    Remove hidden and starting with hs_ props fields

    Decision

  9. Step 9

    Transforms the results

    Transform

  10. Outcome

    Append to Google sheet

    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