EP02 uses the selected pages from the EP01 site tree, scrapes competitor page HTML into title, meta, headings, and content snapshots, then combines that evidence with your positioning input to create a section plan for each page.
The EP01 tree tells which website pages should be planned. EP02 turns selected tree rows into page-structure briefs.
The script creates EP02 tabs, captures positioning, scrapes competitor content, and generates a page-by-page section plan.
Run EP01 and review the site tree. The pages marked Include or Review become the target pages EP02 can structure.
Import target pages from EP01, then add primary keyword, audience, offer, positioning angle, conversion goal, and must-have notes.
Build the competitor URL list and scrape each selected page into title, meta description, H1, H2/H3/H4 headings, and visible content snapshots.
Run the AI action. The output is not body copy. It is the section plan inside each selected page, with SEO fields and heading levels.
.xlsx mode.Extensions > Apps Script.Run for the function named setupEP02.SEO/GEO Series > EP02: Import Target Pages from EP01 Tree.EP02 TARGET PAGES.SEO/GEO Series > EP02: Build Competitor Content List.SEO/GEO Series > EP02: Scrape Competitor Content.SEO/GEO Series > EP02: Set AI API Key.SEO/GEO Series > EP02: Generate Page Structure with AI.EP02 TARGET PAGES
EP02 COMPETITOR CONTENT
EP02 PAGE STRUCTURE
EP02 AI LOG
Loading EP02 Apps Script...The import action reads the EP01 site tree and imports pages marked Include or Review. You can uncheck any page that should not be structured yet.
Add the page keyword, target audience, offer, positioning angle, conversion goal, required points, and exclusions before generating the final structure.
The build action matches each selected target page to competitor URLs from EP01, using the page type, recommended path, and URL evidence.
Uncheck pages you are not ready to plan. EP02 works best when the selected targets have clear positioning and enough competitor evidence.
The AI output is intentionally limited to structure: page goal, SEO fields, section order, H1, H2, H3, optional H4 rows, and section-purpose notes. It does not write page body copy.
The AI uses repeated competitor patterns across headings and page content snapshots, but the final structure is shaped by the positioning inputs you add.
The title tag and meta description are generated from competitor evidence and positioning context, then reviewed for brand voice, keyword relevance, and search intent.
The final tab becomes the brief for writing or designing each selected page. Writers get the required sections before they start drafting paragraphs.
EP01 answered which pages the website may need. EP02 answers how a selected page should be structured before anyone writes the page.
The process starts with target pages selected from the EP01 site tree. Instead of guessing the outline, the sheet collects competitor pages that match each target page.
The scrape fetches the raw HTML, then stores the useful evidence: title tag, meta description, H1, H2, H3, H4, and a visible body-content snapshot. AI compresses those patterns into a clean section plan for the new page.
The goal is not to copy competitor wording. The goal is to understand which sections each selected page needs, combine that with the business positioning, and create a better structure for the website being built.
Instagram embed will be added here once the reel URL is shared.
EP01 competitor list, EP01 site-structure matrix, and EP01 site tree should already exist in the same copied Google Sheet.
Choose the target page from the EP01 tree, such as homepage, service page, location page, or case-study page. EP02 works best when a focused set of pages is reviewed at a time.
Scrape the selected competitor pages. Titles, meta descriptions, headings, and body-content snapshots reveal what topics the page covers and in what order they appear.
Create the section order for each selected page, plus title tag, meta description, H1, H2, and H3 ideas. Keep it as a structure, not finished copy.
Edit the generated structure for the actual brand, service, location, offer, and conversion goal. Then hand it to the writer or designer.
If a competitor blocks Apps Script requests, open the page manually and paste the visible headings or important page content into the EP02 COMPETITOR CONTENT row.
Some pages skip H1, use decorative headings, repeat navigation text, or hide content behind JavaScript. Clean obvious noise before using AI output for a real page brief.
AI can find section patterns, but it does not know the exact business, offer, compliance needs, or conversion goal unless you review and edit the final structure.
Use competitor headings as evidence, not as text to copy. The final structure should be original and better matched to the page being built.