Generate ready-to-paste eNews HTML from NCH worksheet Google Docs. No coding required.
You will need:
.zip file will be saved to your Downloads folder..zip → Extract All… → click Extract..zip file. A folder will appear beside it..html file — this is the file the builder needs..html file into the drop-google-doc-html-here folder inside the builder folder.index.html. It will open in your default web browser..html file from Step 1 onto the drop zone labeled “KMHF Worksheet HTML”.
The builder will process the worksheet and take you to the review screen.
The builder reads NCH eNews worksheets with the following structure. Each worksheet produces one email.
The builder extracts these from the worksheet tables:
The builder detects section types from the article headings in the worksheet:
Full-width hero image followed by a dark blue (#224B9F) band with sub-text, heading, body copy, and an optional inverted button.
280×280 image on the left, heading + text + optional button on the right.
Two side-by-side columns (260×172 images), each with a heading, text, and button or hyperlink. Always paired.
Pink (#e64461) callout block with Lato/Open Sans heading, body, and a black button. Renders only when the worksheet contains content for this section. Default link target is onoursleeves.org.
Social-share row (Facebook, Twitter, Email, LinkedIn). Renders only when the worksheet provides explicit URLs for it.
A list of events with dates and linked descriptions.
If an article section has no heading and no content, it is automatically skipped. You don’t need to delete empty sections from the worksheet.
If a section has no “Button Text & Link” row filled in, the section will render without a button.
The review screen shows:
Click the Preview button in the top-right corner of the toolbar. A live preview panel will open showing the email with the full stationery wrapper — header, body content, footer, and social links.
At the bottom of the screen you will find two action buttons:
Click New Build in the bottom-right corner to clear everything and return to the upload screen. You can then drop in a new worksheet and start fresh.
| Problem | Solution |
|---|---|
| “No article sections found” error | Make sure the worksheet has h3 headings like “Article/story #1 (banner/full width section)”. The builder looks for these headings to identify each section. |
| Some sections are missing from the output | Empty sections are automatically skipped. If a section has content but is missing, check that it has both a Heading and Message Content filled in. |
| Preview panel looks blank | Make sure you scroll down inside the preview. The email may be below the visible area. |
| The drop zone does not accept the file | Confirm the file has an .html or .htm extension. If you downloaded the Google Doc as a .zip, make sure you extracted/unzipped it first. |
| Date bar shows incorrect date | The builder reads the “Send Date and Time” field from the worksheet. Make sure it’s formatted as “M/DD/YY at noon” or similar with a recognizable date. |
| Button URLs look wrong | The builder strips Google redirect wrappers from URLs. If a URL still looks wrong, you can edit it directly in the HTML editor. |