Reads the landing pages you name and logs specific conversion fixes to a Google Sheet, one row per tip.
Uses
Google Sheets
OpenAI
Review landing pages with AI and log the fixes
Set pageUrls to blank.Set pageUrls to blank.Set offerAndAudience to blank.Set offerAndAudience to blank.Set reportSheetUrl to blank.Set reportSheetUrl to blank.Set reportTabName to Landing page reviews.Set reportTabName to Landing page reviews.Set pageCharacterLimit to 18000.Set pageCharacterLimit to 18000.Set tabIsNew to false.Set tabIsNew to false.
If a step below fails, save the error as createTabErrorIf a step below fails, save the error as createTabErrorTry
Google SheetsCreate the tab reportTabName in reportSheetUrl.Create the tab reportTabName in reportSheetUrl.
Change tabIsNew to true.Change tabIsNew to true.On error
Show in the output: The '@reportTabName' tab is already there, so this run adds to it. (createTabError.message).Show in the output: The '@reportTabName' tab is already there, so this run adds to it. (createTabError.message).
If tabIsNew is yesIf tabIsNew is yesYes
Google SheetsAdd a row to reportTabName in reportSheetUrl.Add a row to reportTabName in reportSheetUrl.No
No steps
Split pageUrls with "Split pageUrls with
replaced by , by , and save it as pageList.Set pagesReviewed to 0.Set pagesReviewed to 0.Set tipsWritten to 0.Set tipsWritten to 0.
For each pageEntry in pageList:For each pageEntry in pageList:Trim pageEntry and save it as pageUrl.Trim pageEntry and save it as pageUrl.If pageUrl is emptyIf pageUrl is emptyYes
Skip to the next item.Skip to the next item.No
No steps
Set pageText to blank.Set pageText to blank.Set pageReached to false.Set pageReached to false.If a step below fails, save the error as fetchErrorIf a step below fails, save the error as fetchErrorTry
Fetch pageUrl and save it as response.Fetch pageUrl and save it as response.Change pageReached to response.ok.Change pageReached to response.ok.Trim response.body and save it as pageText.Trim response.body and save it as pageText.On error
Show in the output: Could not open pageUrl - fetchError.message.Show in the output: Could not open pageUrl - fetchError.message.If pageReached isn't yes or pageText is emptyIf pageReached isn't yes or pageText is emptyYes
Show in the output: Skipped pageUrl because it did not return a readable page.Show in the output: Skipped pageUrl because it did not return a readable page.Skip to the next item.Skip to the next item.No
No steps
Shorten pageText to pageCharacterLimit characters (keeping words whole) and save it as pageExcerpt.Shorten pageText to pageCharacterLimit characters (keeping words whole) and save it as pageExcerpt.Set reviewPrompt to You are a conversion rate optimisation specialist reviewing one landing page. Give the specific, actionable notes you would give a client, not a score and not general advice that would fit any page.Set reviewPrompt to You are a conversion rate optimisation specialist reviewing one landing page. Give the specific, actionable notes you would give a client, not a score and not general advice that would fit any page.
What this page sells, who it is for, and what counts as a conversion:
offerAndAudience
Look for the things that actually lose conversions on this page:
- Call to action: is the main action obvious, above the fold, and worded as a benefit rather than 'Submit' or 'Learn more'?
- Messaging: within five seconds, does the page say what this is, who it is for, and why it beats the alternative?
- Layout: what gets between a visitor and the action - competing links, walls of text, the offer buried below three scrolls?
- Trust: is there proof a stranger would believe - named customers, numbers, guarantees, pricing that is actually shown?
- Forms: how many fields, and is every one of them worth the drop-off?
Reply with at most 8 findings, one per line, and nothing else. No numbering, no bullet characters, no introduction and no closing summary. Each line is exactly three parts separated by the pipe character:
Area | What is wrong | What to change
Area must be one of: Call to action, Messaging, Layout, Trust, Forms. Quote the page's own wording when you name a problem, and make the change concrete enough to hand straight to a designer. Leave out anything you cannot see evidence for in the page below.
Page address: pageUrl
Page source below as raw HTML. Read the visible copy and the form and link markup; ignore script blocks, style blocks and tracking tags.
pageExcerpt.Set findings to blank.Set findings to blank.If a step below fails, save the error as reviewErrorIf a step below fails, save the error as reviewErrorTry
OpenAIAsk OpenAI: reviewPrompt. Save it as review.Ask OpenAI: reviewPrompt. Save it as review.Trim review.response_text and save it as findings.Trim review.response_text and save it as findings.On error
Show in the output: Could not review pageUrl - reviewError.message.Show in the output: Could not review pageUrl - reviewError.message.If findings is emptyIf findings is emptyYes
Show in the output: No optimisation tips came back for pageUrl, so nothing was written for it.Show in the output: No optimisation tips came back for pageUrl, so nothing was written for it.Skip to the next item.Skip to the next item.No
No steps
Get today's date and save it as reviewedOn.Get today's date and save it as reviewedOn.Split findings by a new line and save it as findingLines.Split findings by a new line and save it as findingLines.Set rowsForThisPage to 0.Set rowsForThisPage to 0.For each findingLine in findingLines:For each findingLine in findingLines:Split findingLine by | and save it as parts.Split findingLine by | and save it as parts.If the length of parts is greater than or equal to 3If the length of parts is greater than or equal to 3Yes
Google SheetsAdd a row to reportTabName in reportSheetUrl.Add a row to reportTabName in reportSheetUrl.Add 1 to rowsForThisPage.Add 1 to rowsForThisPage.Add 1 to tipsWritten.Add 1 to tipsWritten.No
No steps
If rowsForThisPage is 0If rowsForThisPage is 0Yes
Google SheetsAdd a row to reportTabName in reportSheetUrl.Add a row to reportTabName in reportSheetUrl.Add 1 to tipsWritten.Add 1 to tipsWritten.No
No steps
Add 1 to pagesReviewed.Add 1 to pagesReviewed.Show in the output: Reviewed pagesReviewed as text landing page(s) and wrote tipsWritten as text tip(s) to the '@reportTabName' tab.Show in the output: Reviewed pagesReviewed as text landing page(s) and wrote tipsWritten as text tip(s) to the '@reportTabName' tab.