# Weekly Kit newsletter draft from your content backlog

> Every Thursday morning, draft next week's Kit newsletter from your content backlog so all that is left is a quick review and send.

- Workflow type: agent
- Services: ConvertKit, Google Sheets
- Categories: Marketing, Personal Productivity
- Published: 2026-07-17

## What it does

- Every Thursday at 9am, reads your Content backlog tab in Google Sheets and picks the 3 to 5 highest-priority items still marked ready.
- Writes a short opener in your voice, then a one-sentence hook and link for each item, and closes with a clear call to action.
- Peeks at your recent Kit subject lines so the new draft matches your on-brand style.
- Saves the finished piece as a draft broadcast in Kit with a proposed subject line and preview text, and flips the picked backlog items to queued in the sheet.

## What you'll need

- A Kit (formerly ConvertKit) account you can connect.
- A Google account with access to the spreadsheet holding your content backlog.
- A backlog tab with columns for title, link, notes, priority, and status, where ready means the item is safe to feature.

## Prompt

Every Thursday at 9am, draft next week's Kit (ConvertKit) newsletter for me from my content backlog so I only have to review and send. Trigger: cron, weekly on Thursday at 9am in my local timezone.

Step 1: read the backlog. Use Google Sheets Get Values against the Content backlog tab. The columns are title, link, notes, priority, and status. Parse the rows and pick the 3 to 5 highest-priority items whose status is still exactly 'ready'. If fewer than 3 ready items exist, use whatever is available and note the shortfall in the run summary. Preserve each picked row's index so we can update it later.

Step 2: study my on-brand voice. Use ConvertKit List Broadcasts to fetch my most recent broadcasts (roughly the last 5 to 10). Skim their subject lines, preview text, and opening lines so the new draft matches the pattern I already use, including sentence casing, emoji habits, punchiness, and any recurring sign-off.

Step 3: write the newsletter. Produce a short opener in my voice (2 to 4 sentences, warm but concise). Then for each picked backlog item write a compact blurb: a bolded title that links to the item's link, and one sentence that hooks the reader on why it is worth clicking. Close with a single clear call to action (reply to the email, share the newsletter, or check out the featured item, whichever fits best given the mix). Also propose a subject line that matches the recent style and a preview text of roughly 90 to 120 characters.

Step 4: save the draft in Kit. Call ConvertKit Create Broadcast with the composed subject line, preview text, and HTML body. Save it as a draft only, never scheduled and never sent. Include the broadcast id and the Kit URL in the run summary so I can click straight through to review.

Step 5: mark the sheet. Call Google Sheets Batch Update Values to flip the status column for every picked row from 'ready' to 'queued', in a single batched request. Do this only after Create Broadcast succeeds so the sheet never gets ahead of the draft.

Non-negotiables: draft-only, never auto-send. If Create Broadcast fails, do not touch the sheet. Never feature the same item twice, and never feature items whose status is not exactly 'ready'. Report back which items were picked, the proposed subject line, and the Kit draft link.

## How to customize

- Change the day and time from Thursday at 9am to whenever fits your publishing cadence.
- Adjust how many items get pulled per issue, or which priority levels count as ready.
- Tweak the opener tone, sign-off, or the wording used for the call to action at the bottom.

## FAQ

### Will it actually send the newsletter to my subscribers?

No. The draft is saved inside Kit for you to review, edit, and hit send yourself. Nothing goes out to your list without your click.

### How does it know my writing style?

Before drafting, it looks at your recent broadcasts in Kit and mirrors the tone and subject-line pattern you already use.

### What happens if the backlog does not have enough ready items?

It uses whatever ready items are available and lets you know how many it found so you can add more before the next run.

### Do the items I feature get marked so I do not re-use them next week?

Yes. Once an item is picked, its status is flipped to queued in the sheet so the next run skips it.

### Can I use this if my backlog lives somewhere other than Google Sheets?

The starter version reads from Google Sheets. You can adapt it to pull from Airtable, Notion, or another tool during setup.

Use this prompt in General Input: https://www.generalinput.com/prompts/weekly-kit-newsletter-draft-from-your-content-backlog