The mapping and configuration of your Google Sheet is setup via a JSON config file. This JSON content can be added to your Worksheet as a new sheet labeled "Config".

Our system will then pull in this configuration when processing your sheet.

Example Configuration (Basic)

{
  "should_run": "Build Page",
  "project_name": "Your Project Name",
  "error_writer": "Errors"
  "business_id": 555555,
  "sites": [
    {
      "mapping": {
        "base_directory": "Page Path",
        "partner_site_id": "Landing Page ID"
      },
      "overrides": {
        "published": true,
        "formatted_domain": "landingpages.yourdomain.com",
        "theme_id": 1234,
        "noindex": true
      },
      "writers": {
        "Preview URL": "preview_url",
        "Published URL": "formatted_url"
      }
    }
  ]
}

Custom Fields

You can easily map custom fields on your sheet with your project, using the "custom_fields" filter.

This filter just contains a list of the field names on your sheet you would like to map

{
  ...
  "sites": [
    {
      ...
      "filters": {
        "custom_fields": ["Headline", "Subheadline", "Main Content"]
      }
    }
  ]
  ...
}

These fields get automatically processed and are also turned into macros prefixed with "custom_", lowercased, and spaces are turned into underscores.

• "Headline" => "${custom_headline}"

• "Subheadline" => "${custom_subheadline}"

• "Main Content" => "${custom_main_content}"

Business Configuration

Each row within the Sheet can either publish all Landing Pages under one existing Business, or a Business can be created for each row in the sheet.

One Existing Business

{
  "business_id": 555555,
  ...
}

Multiple Businesses

{
  "businesses": [
    {
      "mapping": {
        "business_name": "Business Name",
        "partner_business_id": "Landing Page ID"
      }
    }
  ]
  ...
}