HubDB Use Cases

HubDB Application Ideas

By connecting spreadsheets to HubDB, you can dynamically display various data on your HubSpot site.

Here are specific use case examples.

Case 1: Access Rankings Display

Display popular product rankings on your blog based on pageview data from Google Analytics.

Data Flow

Benefits

• Rankings stay current even on older blog posts
• Automatically showcase "trending products"
• No daily manual updates needed

Spreadsheet Structure Example

Case 2: Store/Location Listings

Centrally manage multiple store or branch office information and display on your website.

Use Scenarios

• Link each store's blog to its dedicated HubDB table
• Show store-specific product rankings
• Dynamically display addresses and business hours

Multi-Table Management

GAS configuration example for separate tables per store:

const mappings = [
  { sheet: 'Downtown Store', tableId: '11111111' },
  { sheet: 'Midtown Store', tableId: '22222222' },
  { sheet: 'Uptown Store', tableId: '33333333' },
  { sheet: 'Suburb Store', tableId: '44444444' },
];

Benefits

• Store managers simply update their spreadsheet
• Centralized store information management
• Adding new stores just requires adding a table

Case 3: Category-Specific Rankings

Create rankings per product category and display on category blogs.

Configuration Example

Benefits

• Display optimal rankings on specialized blog posts
• Higher relevance between article content and rankings
• Expected improvement in conversion rates

Case 4: Campaign & Sale Information

Manage limited-time campaign information in spreadsheets and display site-wide.

Data Structure

Display Control with HubL

{% set campaigns = hubdb_table_rows(tableid) %}
{% set today = local_dt|datetimeformat('%Y-%m-%d') %}

{% for campaign in campaigns %}
  {% if campaign.is_active == 'true' %}
    {% if campaign.start_date <= today and today <= campaign.end_date %}
      <a href="{{ campaign.link_url }}">
        <img src="{{ campaign.banner_url }}" alt="{{ campaign.hs_name }}">
      </a>
    {% endif %}
  {% endif %}
{% endfor %}

Benefits

• Automatic campaign start/end control
• Banner updates complete in spreadsheet
• Past campaign data preserved as history

Case 5: Product Catalog Integration

Sync product master data from core systems to HubDB via spreadsheets and dynamically generate product information pages.

Data Flow

HubDB Dynamic Pages Feature

HubDB has a "Dynamic Pages" feature that auto-generates pages per row:

• hs_path column becomes the URL path
• Template displays HubDB data
• Adding products automatically creates pages

Available Data

Case 6: FAQ Database

Manage FAQs in spreadsheets and dynamically display on FAQ pages.

Benefits

• Customer support team directly edits FAQs
• Category-based filtering display
• Integration with search functionality

Data Structure Example

Operational Guidelines

Sync Frequency Design

Data Quality Management

• Set validation rules in spreadsheet
• Skip rows with empty required fields
• Validate image URL formats

Multi-User Operations

• Manage edit permissions
• Record update history
• Monitor sync execution logs

Summary

HubDB × Spreadsheet sync use cases:

• Access Rankings: Auto-display current popular products
• Store Listings: Centrally manage each location's info
• Category Rankings: Optimal rankings for specialized blogs
• Campaign Info: Date-controlled dynamic banners
• Product Master: Integration with core systems
• FAQ: Support team directly edits content

Use familiar spreadsheet tools as the starting point for dynamic HubSpot site content management.

Start with a small use case and gradually expand your applications.