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)

1
{
2
"should_run": "Build Page",
3
"project_name": "Your Project Name",
4
"error_writer": "Errors"
5
"business_id": 555555,
6
"sites": [
7
{
8
"mapping": {
9
"base_directory": "Page Path",
10
"partner_site_id": "Landing Page ID"
11
},
12
"overrides": {
13
"published": true,
14
"formatted_domain": "landingpages.yourdomain.com",
15
"theme_id": 1234,
16
"noindex": true
17
},
18
"writers": {
19
"Preview URL": "preview_url",
20
"Published URL": "formatted_url"
21
}
22
}
23
]
24
}
Copied!
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
1
{
2
...
3
"sites": [
4
{
5
...
6
"filters": {
7
"custom_fields": ["Headline", "Subheadline", "Main Content"]
8
}
9
}
10
]
11
...
12
}
Copied!
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

1
{
2
"business_id": 555555,
3
...
4
}
Copied!

Multiple Businesses

1
{
2
"businesses": [
3
{
4
"mapping": {
5
"business_name": "Business Name",
6
"partner_business_id": "Landing Page ID"
7
}
8
}
9
]
10
...
11
}
Copied!
Last modified 3yr ago