Lead magnet idea brainstorming → physical production → lead DB (Google Sheets) integration all the way through. The deliverable is not a "lead magnet idea list" but a deployable physical product + a sheet where leads accumulate.
G1 — Brainstorming (back-and-forth questions, through conversation)
Don't ask everything at once — go in rounds: the answer determines the next question:
- Whose what pain? Target in 1 sentence + 1 problem they're currently searching for/worrying about.
- Business connection: What will this lead eventually buy? (The magnet must be the first step toward the main product — unrelated popular materials only collect junk leads.)
- 1 promise: Does "if you get this, you can ___ within 10 minutes" hold true?
- 2–3 format proposals (based on the criteria below) → user chooses.
Good magnet criteria: Consumable within 10 minutes · 1 immediately actionable result · naturally proves the need for the main product · a name whose value is clear from the title alone (includes specific numbers like "checklist of 12 items").
Format options: Checklist (fastest) / practical guide PDF / template·swipe file (something copy-pasteable) / mini diagnostic (score + prescription) / calculator·sheet.
G2 — Physical production
- Apply brand tokens (if DESIGN.md exists, use it as is; if not, use the brand-guide skill starting with the minimum tokens). Copy must pass the humanizer rules.
- PDF type: HTML → PDF (cover + body, 1 idea per page, last page = main product CTA + contact info). Template type: as a copyable Google Docs/Sheets link.
- Self QA: Follow it from the start to see whether the promised result actually comes out within 10 minutes. If it doesn't, reinforce the content — a thin magnet burns more trust than an email address.
- Don't put a version in the filename/title (
가이드_v3_최종.pdfforbidden).
G3 — Collection flow
- Landing (or a section on an existing page): headline = promise, form fields = email (+name) only — each added field lowers conversion. For an ad/PPC landing, remove navigation.
- Immediately after submission, automated delivery email (e-blast-newsletter): thanks + download link. A hard bounce on this email = fake email → mark/delete it immediately in the sheet (keep only real people).
- UTM tagging: also collect which channel brought the lead via a form hidden field.
G4 — Lead DB: Google Sheets integration
Sheet schema (row 1 fixed): timestamp | email | name | source(utm) | magnet | status(new/delivered/bounced) | notes
Integration methods (by situation):
- A. Google Forms (fastest, no-code): Forms → responses → Sheets auto-connected. Embed the form on the landing. Downside: design constraints.
- B. Custom form → Apps Script webhook (for a custom landing): in the sheet, Extensions →
Apps Script →
doPost(e)Deploying a script that appends (web app, access: all users) → the form POSTs to that URL. Script skeleton:
function doPost(e) {
const p = JSON.parse(e.postData.contents);
SpreadsheetApp.openById("SHEET_ID").getSheetByName("leads")
.appendRow([new Date(), p.email, p.name || "", p.utm_source || "",
p.magnet || "", "new", ""]);
return ContentService.createTextOutput("ok");
}
- C. Form service (Tally/Typeform, etc.): use the service's native Google Sheets integration.
- Either way, VERIFY: 1 test submission → confirm for yourself that a row is appended to the sheet and the delivery email arrives.
G5 — Follow-up
- After the delivery email, a sequence of 2–3 emails (value → case study → main product offer) — via e-blast-newsletter's broadcast/audience. If the list is large, upgrade to a CRM (crm-connect).
- Weekly check: number of sheet leads + conversions by channel (utm) — turn off channels that don't work and focus on the ones that do.