System Overview

The HL Dynamic Content System enables location-specific landing pages on GoHighLevel (GHL) by dynamically replacing content based on URL parameters and spreadsheet data.

Key Components

Data Flow

URL (?id=miami) → HL Engine → Google Sheets → Page Render

1. User visits landing page with ?id=location_id
2. Engine fetches spreadsheet data via CSV export
3. Engine finds matching row by ID
4. Engine replaces all .hl-* elements with data
5. Tracking tags (GTM/GA4/Hotjar) are injected

Architecture

┌─────────────────────────────────────────────────────────────┐
│                    GOOGLE SHEETS                             │
│  ┌─────────────────────────────────────────────────────┐    │
│  │  Data Sheet (e.g., UrgentCare)                      │    │
│  │  - Location data (clinic_name, address, phone...)   │    │
│  │  - Tracking IDs (gtmid, hotjar_id, ga4_id)         │    │
│  │  - Images (logo_url, picture, image_1...)          │    │
│  │  - Google Reviews (auto-populated)                  │    │
│  └─────────────────────────────────────────────────────┘    │
│                           │                                  │
│  ┌───────────────┐   ┌────┴────────────────────────────┐    │
│  │ Config Sheet  │   │ Google Apps Script              │    │
│  │ - Folder ID   │   │ - Image Sync from Drive         │    │
│  │ - Sheet names │   │ - Google Reviews Fetch          │    │
│  └───────────────┘   └─────────────────────────────────┘    │
└─────────────────────────────────────────────────────────────┘
                              │
                              │ CSV Export (auto)
                              ▼
┌─────────────────────────────────────────────────────────────┐
│                    GOHIGHLEVEL PAGE                          │
│  ┌─────────────────────────────────────────────────────┐    │
│  │  Header Code: HL Engine v31.0                       │    │
│  │  - Fetches spreadsheet via ?id= parameter           │    │
│  │  - Replaces .hl-* elements                          │    │
│  │  - Injects tracking scripts                         │    │
│  │  - Handles images, links, phones                    │    │
│  └─────────────────────────────────────────────────────┘    │
└─────────────────────────────────────────────────────────────┘
                              │
                              │ ?id=location_id
                              ▼
┌─────────────────────────────────────────────────────────────┐
│                    AD PLATFORMS                              │
│  Google Ads / Facebook Ads / etc.                           │
│  Each ad points to: page.com?id=location_id                 │
└─────────────────────────────────────────────────────────────┘

Setup & Configuration

Initial Setup Checklist

• Create Google Spreadsheet with required columns
• Add spreadsheet tools script to Apps Script
• Configure API key for Google Reviews
• Set up Google Drive folder for images
• Install HL Engine on GHL page
• Test with sample location

Google Spreadsheet Setup

1. Create new Google Spreadsheet
2. Name first sheet (tab) according to your project
3. Add all required columns (see Spreadsheet Structure)
4. Make spreadsheet publicly viewable: Share → Anyone with the link → Viewer

Google Apps Script Setup

1. Open spreadsheet
2. Extensions → Apps Script
3. Delete default code
4. Paste entire hl-spreadsheet-tools.gs content
5. Save (Ctrl+S)
6. Refresh spreadsheet
7. Run "Setup Config Sheet" from Admin Tools menu
8. Configure API key in script (line 24)

GHL Page Setup

1. Open page in GHL editor
2. Settings → Tracking Code
3. Paste entire hl-engine-v31.0.js in Header Code
4. Edit CONFIG section (lines 35-55):
   • sheetID: Your spreadsheet ID
   • sheetName: Your sheet/tab name
5. Save and publish

Spreadsheet Structure

Required Columns

Tracking Columns

Formula Columns

map_url (builds from address):

="https://www.google.com/maps/search/?api=1&query=" & ENCODEURL(E2 & " " & F2 & " " & G2 & " " & H2)

booking_phone (formats raw phone):

=REGEXREPLACE(TO_TEXT(J2), "(\d{3})(\d{3})(\d{4})", "($1) $2-$3")

Engine Configuration

CONFIG Object

const CONFIG = {
  sheetID: '1Yi-0B4lggjOz_vL0kSXv7-WFlwEddATSU_-B-5y2ffE',
  sheetName: 'UrgentCare',
  urlParam: 'id',
  retries: [0, 350, 900]
};

CSS Class Reference

Text Replacement

<div class="hl-clinic_name">Placeholder</div>

<!-- Inline Span (in rich text) -->
Visit us at <span class="hl-city_state">City, ST</span> today!

Images

Links & Phones

Google Apps Script Tools

Admin Menu

⚡ Admin Tools
├── 🖼️ Images
│   ├── Sync Drive Images (w/ Fallback)
│   └── Setup Config Sheet
├── ⭐ Reviews
│   ├── Fetch Google Reviews
│   └── Clear All Reviews
└── 📖 Help & Documentation

Image Sync

File Naming Convention:

• {id}_{column}.{ext} → Specific image
• 0_{column}.{ext} → Fallback image

Examples:

• miami_logo_url.png → Row where id="miami", column "logo_url"
• 0_picture.jpg → All empty "picture" cells

Troubleshooting

Console Warnings

Introduction

What is this system?

The HL Dynamic Content System allows you to manage multiple location-specific landing pages from a single Google Spreadsheet. Instead of creating separate pages for each location, you manage one page template and one spreadsheet with all location data.

Key Benefits

• Single Source of Truth: All location data in one spreadsheet
• Instant Updates: Change spreadsheet → Page updates automatically
• No Coding Required: Just edit cells in the spreadsheet
• Automatic Reviews: Google Reviews fetched automatically
• Image Management: Upload images to Drive, system syncs them

How It Works

You edit spreadsheet → System reads data → Landing page shows location info

When someone visits yourpage.com?id=miami, the system looks up "miami" in your spreadsheet, finds all the data for that location, and shows it on the page.

Daily Operations

Admin Tools Menu

After opening the spreadsheet, you'll see ⚡ Admin Tools in the menu bar:

⚡ Admin Tools
├── 🖼️ Images
│   ├── Sync Drive Images (w/ Fallback)
│   └── Setup Config Sheet
├── ⭐ Reviews
│   ├── Fetch Google Reviews
│   └── Clear All Reviews
└── 📖 Help & Documentation

Checking a Location

1. Find the location row by ID
2. Copy the ID value (e.g., "miami")
3. Open the landing page with ?id=miami at the end
4. Verify all information displays correctly

Adding New Locations

Step-by-Step Process

Step 1: Add Row to Spreadsheet

1. Go to the last row with data
2. Add a new row below
3. Fill in the id column first (e.g., "newcity")

Step 2: Fill Required Fields

Step 3: Test the Page

• Open landing page with ?id=newlocation
• Check all fields display correctly
• Test phone links (click to call)
• Test directions link
• Verify images load

Managing Images

Image Columns

Method 1: Direct Links

1. Upload image to Google Drive
2. Right-click → Share → Anyone with link
3. Copy link
4. Paste in spreadsheet column

Method 2: Image Sync (Recommended)

1. Upload image to the Drive folder
2. Name it: {id}_{column}.png (e.g., miami_logo_url.png)
3. Run Admin Tools → Images → Sync Drive Images

Google Reviews

Automatic Fetch

1. Go to Admin Tools → Reviews → Fetch Google Reviews
2. Wait for process to complete (may take several minutes)
3. Check the completion message for results

What Gets Fetched

• Only 4-5 star reviews
• Top 3 most recent reviews per location
• Review text and author name

When to Run

• After adding new locations
• Monthly refresh recommended
• After clearing reviews

Quality Assurance

Pre-Launch Checklist

• ID is unique (no duplicates)
• All required fields filled
• Phone number formats correctly
• Map link works
• Images load
• Reviews display (if available)
• Page title shows correctly
• Tracking IDs are correct

Testing a Page

1. Open: yourpage.com?id={location_id}
2. Check header/logo
3. Check all text content
4. Click phone number (should open dialer)
5. Click directions (should open Maps)
6. Check images loaded
7. Check page title in browser tab
8. Test on mobile device

FAQ

How long until changes appear?

Changes are instant. The page fetches fresh data on each load. You may need to clear browser cache or use incognito mode to see changes immediately.

Can I add custom columns?

Yes! Add any column to the spreadsheet. Then have the dev team add the matching .hl-{column} class to the GHL page.

What if I break something?

Spreadsheet changes can be undone: File → Version history → See version history, find a working version and restore.

Why isn't my image showing?

1. Is the file shared publicly?
2. Is the filename correct for sync?
3. Try a direct Drive link instead

Quick Start

The Core Concept

One landing page serves ALL locations. You just change the URL parameter.

Base URL:
https://yoursite.com/landing-page

Location-Specific URLs:
https://yoursite.com/landing-page?id=miami
https://yoursite.com/landing-page?id=dallas
https://yoursite.com/landing-page?id=sandiego

The ?id= parameter tells the page which location data to display.

What You Need

1. The base landing page URL
2. The list of location IDs (from spreadsheet)
3. Your campaign tracking parameters

Building Campaign URLs

Basic Formula

{base_url}?id={location_id}&{utm_parameters}

Example URLs

Google Ads:

https://yoursite.com/urgent-care?id=miami&utm_source=google&utm_medium=cpc&utm_campaign=urgent_care_miami

Facebook Ads:

https://yoursite.com/urgent-care?id=miami&utm_source=facebook&utm_medium=paid_social&utm_campaign=urgent_care_miami

Google Ads Setup

Campaign Structure

Campaign: Urgent Care - Miami
└── Ad Group: Urgent Care Near Me
    └── Ad: [Headlines + Descriptions]
        └── Final URL: https://site.com/page?id=miami

Setting Up Final URLs

Option 1: Per Ad Group (Recommended)

1. Create ad groups per location
2. Set Final URL at ad group level: https://yoursite.com/urgent-care?id=miami
3. UTM parameters added via tracking template

Tracking Template

Set at campaign or account level:

{lpurl}&utm_source=google&utm_medium=cpc&utm_campaign={_campaign}&utm_content={creative}

Facebook/Meta Ads Setup

Campaign Structure

Campaign: Urgent Care Awareness
└── Ad Set: Miami (Geo-targeted)
    └── Ad: [Creative + Copy]
        └── Website URL: https://site.com/page?id=miami

URL Parameters in Ads Manager

Website URL:

https://yoursite.com/urgent-care?id=miami

URL Parameters Field:

utm_source=facebook&utm_medium=paid_social&utm_campaign={{campaign.name}}

Dynamic Parameters

Tracking & Attribution

What's Automatically Tracked

The system injects these tracking scripts per location:

• Google Tag Manager (GTM)
• Google Analytics 4 (GA4)
• Hotjar

Set per location in spreadsheet columns.

UTM Parameters

Best Practices

Campaign Organization

Do:

• Create separate ad groups/ad sets per location
• Use consistent naming conventions
• Match geo-targeting to location data

Don't:

• Mix multiple locations in one ad group
• Use generic geo-targeting for location-specific ads
• Forget the ?id= parameter

Common Mistakes

Quick Reference

URL Formula

{base_url}?id={location_id}&utm_source={source}&utm_medium={medium}&utm_campaign={campaign}

Platform UTM Defaults

Testing Checklist

• URL includes ?id= parameter
• ID matches spreadsheet exactly (lowercase)
• Page shows correct location name
• Page shows correct phone number
• Phone link works (tap on mobile)
• Directions link opens Maps
• UTM parameters in URL
• GTM/GA4 tracking fires

Intellectual Property Rights

Copyright Notice

© 2025 Nick The Marketer. All Rights Reserved.

This software and accompanying documentation are protected by copyright law and international treaties. Unauthorized reproduction or distribution of this software, or any portion of it, may result in severe civil and criminal penalties, and will be prosecuted to the maximum extent possible under the law.

Trademark Notice

The following are trademarks or registered trademarks of Nick The Marketer:

• HL Dynamic Content System™
• Nick The Marketer®
• Associated logos and brand elements

Patent Pending

Certain aspects of the HL Dynamic Content System methodology and implementation may be subject to pending patent applications. The system incorporates proprietary algorithms and processes developed by Nick The Marketer.

Confidentiality Agreement

Confidential Information

All materials, including but not limited to:

• Source code (JavaScript, Google Apps Script)
• System architecture and design documents
• Technical documentation and guides
• Implementation methodologies
• Business processes and workflows
• Client data and configurations

are considered Confidential Information and must be treated as such.

Obligations

By accessing this documentation, you agree to:

1. Non-Disclosure: Not disclose any Confidential Information to third parties without prior written consent from Nick The Marketer.
2. Limited Use: Use Confidential Information solely for authorized business purposes related to your engagement with Nick The Marketer.
3. Protection: Take reasonable measures to protect Confidential Information from unauthorized access, use, or disclosure.
4. Return/Destruction: Upon request or termination of your engagement, promptly return or destroy all Confidential Information in your possession.

Survival

Confidentiality obligations survive indefinitely and remain in effect even after termination of any business relationship.

License Terms

Grant of License

Subject to your compliance with these terms, Nick The Marketer grants you a limited, non-exclusive, non-transferable, revocable license to:

• Access and use the HL Dynamic Content System for authorized business operations
• View this documentation for reference purposes
• Implement the system on approved client projects as specified in your service agreement

License Restrictions

This license does NOT include the right to:

• Modify, adapt, or create derivative works based on the software
• Reverse engineer, decompile, or disassemble the software
• Remove or alter any proprietary notices or labels
• Sublicense, sell, resell, transfer, or assign the software
• Use the software to provide services to third parties without authorization
• Copy or reproduce the software except as expressly permitted

Termination

This license terminates automatically if you breach any of these terms. Upon termination, you must cease all use of the software and destroy all copies in your possession.

Use Restrictions

Prohibited Uses

You may NOT use the HL Dynamic Content System to:

• Violate any applicable laws, regulations, or third-party rights
• Distribute malware, spam, or other harmful content
• Engage in fraudulent, deceptive, or misleading practices
• Infringe upon intellectual property rights of others
• Compete with Nick The Marketer's business offerings
• Train artificial intelligence or machine learning models
• Benchmark or performance test without written consent

Compliance

You are responsible for ensuring that your use of the system complies with:

• All applicable federal, state, and local laws
• Advertising platform terms of service (Google, Facebook, etc.)
• Privacy regulations (GDPR, CCPA, etc.)
• Industry-specific regulations applicable to your business

Audit Rights

Nick The Marketer reserves the right to audit your use of the system to ensure compliance with these terms. You agree to cooperate fully with any such audit upon reasonable notice.

Limitation of Liability

Disclaimer of Warranties

THE HL DYNAMIC CONTENT SYSTEM IS PROVIDED "AS IS" AND "AS AVAILABLE" WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON-INFRINGEMENT.

Limitation of Liability

TO THE MAXIMUM EXTENT PERMITTED BY LAW, IN NO EVENT SHALL NICK THE MARKETER BE LIABLE FOR ANY INDIRECT, INCIDENTAL, SPECIAL, CONSEQUENTIAL, OR PUNITIVE DAMAGES, INCLUDING WITHOUT LIMITATION, LOSS OF PROFITS, DATA, USE, GOODWILL, OR OTHER INTANGIBLE LOSSES, RESULTING FROM:

• Your access to or use of or inability to access or use the system
• Any conduct or content of any third party
• Any content obtained from the system
• Unauthorized access, use, or alteration of your transmissions or content

Indemnification

You agree to indemnify, defend, and hold harmless Nick The Marketer and its officers, directors, employees, agents, and affiliates from and against any claims, liabilities, damages, losses, and expenses arising out of or in any way connected with your use of the system or violation of these terms.

Contact Information

Governing Law

These terms shall be governed by and construed in accordance with the laws of the State of Alabama, without regard to its conflict of law provisions. Any disputes arising under these terms shall be subject to the exclusive jurisdiction of the state and federal courts located in Jefferson County, Alabama.

Entire Agreement

These terms, together with any applicable service agreements, constitute the entire agreement between you and Nick The Marketer regarding the use of the HL Dynamic Content System and supersede all prior agreements and understandings.

Modifications

Nick The Marketer reserves the right to modify these terms at any time. Continued use of the system after any modifications constitutes acceptance of the updated terms.

Last Updated: December 2025
Document Version: 1.0