Configure Your Fields

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"
      }
    }
  ]
}
Option
​
Required
should_run
Name of the field within your sheet that denotes that the row should be processed.
Yes
project_name
Name of your project
Yes
error_writer
Field to write any processing or validation errors into
No
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"
      }
    }
  ]
  ...
}

Add Your Spreadsheet Fields

Integrations

Last modified 4yr ago

Option		Required
should_run	Name of the field within your sheet that denotes that the row should be processed.	Yes
project_name	Name of your project	Yes
error_writer	Field to write any processing or validation errors into	No