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