Personalized pages
Create one noindex personalized page per worksheet row through an HTTP API column.
A personalized page is a private page on your own site, made for one prospect. Dreamstate researches the row and writes the insight; an HTTP API column sends the row to your page endpoint and stores the URL it returns, so a sequence can use it as {{page_url}}.
Endpoint contract
The column sends a POST with a JSON body holding row_id, tracking_id, prospect, insight, evidence and cta. Set both ids to {{row.id}}. Your endpoint responds with HTTP 200 within ten seconds: { "url": "https://pages.example.com/r/k7f3q2x9", "status": "ready" }. Map it with the response value [{ "key": "page_url", "path": "url" }].
The same row_id must always return the same URL, because requests are retried. Use a random slug, never a name or email, and mark every page noindex.
Visit tracking
Add the visit pixel to every page so a visit is credited to that prospect: <img src="https://p.trydreamstate.com/p/visit?k=YOUR_PIXEL_KEY&dst=ROW_ID" width="1" height="1" alt="">. A visit records a website visit for the person on that row, and a workflow with a website visit trigger can react to it.
Verify and check
Choose a signing account on the column, then verify X-Dreamstate-Signature against the raw request body before parsing JSON. Run one row as a dry run, then one live row. Open the URL and check that it shows that row's insight and evidence. Review ten rows before a wider run, and keep a holdout group without pages for comparison.