A website content collection template that shows what’s missing
Website builds rarely stall on design; they stall waiting for copy and images. A website content collection template fixes that by asking for content one page at a time and tracking every page in a Google Sheets inventory with an owner, a due date and a status. This guide gives you the form questions, the sheet columns, copyable status formulas and a deadline plan for collecting website content from clients.
By Raj Kumar, Founder, Zunoform

What is a website content collection template?
It is a structured request for everything a website needs from the client, organized by page: the copy, images and files, who approves them and when they are due. The most practical version is a form with one submission per page, feeding a spreadsheet where the team tracks each page from “not started” to “ready to build”.
- One row per page in a content inventory, agreed before collection starts.
- A form that collects one page package per submission: copy link, assets, approver.
- A status column with fixed values, plus an owner and due date per page.
- Formulas that flag overdue pages and show overall progress.
Why collect website content page by page?
Asking a client to “send over the content” produces a folder of mixed drafts, a long email thread and no clear answer to the only question that matters: which pages can we build now? Collecting per page makes each package reviewable on its own. The services page can be ready while the about page is still waiting for photos, and everyone can see that.
It also separates two facts that are easy to confuse. Receiving content is not the same as the content being complete and approved. The form records what the client sent; the sheet records the team’s judgment on whether it is usable.
Content inventory columns for your Google Sheet
Create these on a Review tab before collection starts, with one row per page from the sitemap. The client never fills these in; the team does.
| Column | What it holds | Example |
|---|---|---|
| Page | Page name and planned URL, matching the sitemap | Services — /services |
| Content owner | The client-side person supplying this page | Priya (marketing lead) |
| Due date | When the page package is due | 2026-10-14 |
| Status | One value from a fixed dropdown | Waiting on client |
| Latest response ID | The form submission currently in use | Pulled by formula from Responses |
| Copy version | Which document version was reviewed | v3, 9 Oct |
| Missing item | What blocks the page, in one line | Team photos and captions |
| Last chased | Date of the last reminder | 2026-10-10 |
| Days overdue | Calculated, never typed | Formula |
What should the content collection form ask?
Our Website Content Collection template asks for one page per response. Its nine questions: page name and planned URL, what a visitor should learn or do on the page, a link to the copy document, copy approval status (Approved for build, Draft awaiting review, Changes requested), a link to images and assets, who confirms asset permissions and credits, what is missing and who will supply it by when, the content approver and next review date, and page-specific build notes.
Two design choices matter. Copy is collected as a link to a document, not pasted into a text box, because clients revise copy and a link lets you name the version you reviewed. And the “What is missing?” question carries the instruction “Write None if the page package is complete”, which asks clients to state gaps instead of leaving you to discover them.
Templates for website projects
Collect one page's copy, image links, approval state and content owner for a website build.
Define a website's goals, page scope, content ownership and launch requirements before design begins.
Anchor design feedback to a version, explain the requested change and identify the next reviewer.
Package final deliverables, transfer responsibilities, outstanding work and training needs into a client handoff record.
How do you collect website content from clients? Methods compared
Prices checked on 28 September 2026 on the vendor’s own page.
| Method | Cost | Status tracking | Main weakness |
|---|---|---|---|
| Email and attachments | Free | None; lives in inboxes | No single view of what is missing; versions get lost |
| Shared drive folder per page | Free with Google Drive or similar | Manual, by folder contents | Files arrive without context, approver or completeness |
| Shared spreadsheet the client edits | Free | Good if everyone keeps to it | Clients can overwrite formulas and paste long copy into cells |
| Form feeding Google Sheets | Free form plans exist; Zunoform Free includes Sheets | Team-owned Review tab with formulas | Reminders and chasing stay manual |
| Content Snare | From $35/month billed annually ($42 monthly), 20 active requests | Built in, with automatic reminders | A separate subscription for one job |
Sources: Content Snare pricing · Google Sheets: create a dropdown list
How do you connect the form to Google Sheets?
Zunoform’s Google Sheets connection is on the Free plan.
Save the form and authorize Sheets
Open the form’s Integrations tab and authorize Google Sheets. Zunoform creates a new spreadsheet named after the form with a Responses tab; there is no picker for an existing sheet.
Know the column layout
Each response becomes one row: Timestamp, Response ID, then one column per question in form order, then Location and User Agent. Multi-part answers such as contact details split into separate columns.
Add a Review tab
Build the inventory columns above on a second tab. Keep formulas and team notes out of Responses, which the integration manages and rewrites the header of when the form changes.
Test with a fictional page
Submit a test page package and match the row to the saved response by Response ID. Earlier responses are not backfilled, so connect before sending the form to the client.
Which status values should you track?
Use a dropdown so status stays countable: in Google Sheets, select the column and choose Insert, then Dropdown (or Data, then Data validation). Five values cover most projects: Not started, Waiting on client, In review, Changes requested, Ready to build. Resist adding more; a status nobody can define precisely is one nobody updates.
Only the team moves a page to Ready to build, and only after opening the linked copy and assets with the access the build team will use. A client choosing “Approved for build” in the form is an input to that decision, not the decision.
Copyable status formulas for the Review tab
Assumes Review columns: A Page, B Owner, C Due date, D Status, E Latest response ID, I Days overdue. Assumes Responses columns: B Response ID, C Page name and planned URL, F Copy approval status (the template’s order). Latest response for this page (row 2, searches bottom-up): =XLOOKUP(A2, Responses!C:C, Responses!B:B, "Not submitted", 0, -1) Client’s latest approval status for this page: =XLOOKUP(A2, Responses!C:C, Responses!F:F, "", 0, -1) Days overdue: =IF(AND(D2<>"Ready to build", C2<TODAY()), TODAY()-C2, "") Overall progress (format as %): =COUNTIF(D2:D, "Ready to build") / COUNTA(A2:A) Pages waiting on the client: =COUNTIF(D2:D, "Waiting on client") Conditional formatting, custom formula to highlight overdue rows (apply to A2:I): =AND($C2<TODAY(), $D2<>"Ready to build")
The XLOOKUP formulas need the page text in the form to match the Review tab exactly. Offer the page as a dropdown in the form if clients type it inconsistently.
How should clients send images and files?
Decide this before sending the form, because upload limits vary by plan. A Zunoform file upload question accepts up to 10 files per question, can be restricted to images, documents or video, and allows 10 MB per file on Free, 100 MB on Pro and 1 GB on Business. Uploaded files stay attached to the response in Zunoform; submit a test and check how the file answer appears in your sheet before relying on the sheet as your asset index.
For a page with a handful of images, direct upload is simplest. For photo shoots, brand kits and video, ask for a link to a shared folder instead, and ask who can confirm the rights and credits for each image. Large raw files rarely belong in a form, and a link keeps the client in control of the originals.
How do you set content deadlines clients actually meet?
Work backwards from launch and give each page its own due date instead of one deadline for everything. Illustration for a 10-page site launching on 1 December: build needs final content two weeks ahead, so the last pages are due 17 November. Stagger earlier dates by build order: the homepage and main service pages first, legal pages and blog posts last. Put the dates in the inventory, share them at kickoff and name the client-side owner for each page.
Chase by page, not by project. “The about page is waiting on team photos, due Friday” gets a faster answer than “we’re still waiting on content”. A weekly filtered view of rows with Days overdue greater than zero, sent to the client contact, keeps the list short and specific. If a page is still blocked a week before launch, agree a placeholder or move it to phase two rather than delaying everything.
Before you send the content form to a client
- The sitemap is agreed and every page has a row in the inventory.
- Each page has a named client-side owner and a due date.
- The Sheets connection is live and a test response has landed with its Response ID.
- Copy is requested as a document link with a version, not pasted text.
- Upload limits on your plan fit the files you expect, or you have asked for folder links.
- The form’s ending says submission starts a review; it does not publish anything.
- You know who on your team reviews each package and moves the status.
Where Zunoform fits (and where it doesn’t)
Zunoform gives you the collection form (the Website Content Collection template, document or single-page layout), native Google Sheets delivery and file uploads on the Free plan, with 500 responses a month, which is ample for per-page submissions. Pro adds 100 MB uploads and removes Zunoform branding from forms your clients see.
It does not chase clients for you, check that a copy document is complete or approved, or publish content to your CMS. If automatic reminders and per-item client portals are the main need, a dedicated tool such as Content Snare does that job, at a separate subscription. If your clients live in Google Drive already, a shared folder per page plus the Review tab above may be all you need.
Questions people ask
How do I collect website content from clients?
Agree the sitemap first, then request content page by page with a form that asks for a copy document link, asset links or uploads, missing items and an approver. Send responses to a spreadsheet where your team tracks each page’s owner, due date and status, and chase overdue pages individually rather than asking for “all the content”.
What should a website content checklist include?
For each page: final copy, headings and calls to action, images with rights and captions, any downloads or forms, SEO title and description if the client supplies them, and the person who approves the page. Site-wide, add the logo files, brand colors and fonts, legal pages, contact details and social links.
Is there a free website content collection template?
Yes. Zunoform’s Website Content Collection template is free to use on the Free plan and sends each submission to Google Sheets. It asks for one page per response. You can also build the inventory in a plain Google Sheet with the columns and formulas in this guide.
Should clients paste copy into the form or share a document?
Share a document. Copy goes through revisions, and a document link lets you record which version you reviewed. Pasted text in a form field loses formatting, cannot be commented on, and leaves you comparing several submissions to find the latest wording. Ask clients to name the version in the document or its title.
How large can uploaded files be?
In Zunoform, each file can be up to 10 MB on Free, 100 MB on Pro and 1 GB on Business, with up to 10 files per upload question. For large photo sets, video or brand packages, ask for a shared folder link instead of direct uploads.
Can Google Sheets track overdue content automatically?
Yes, with formulas and conditional formatting. A Days overdue column using TODAY() compared with the due date, and a custom-formula rule that highlights rows past due and not yet ready, show blockers at a glance. Sending reminders still needs a person or a separate automation tool.
What if a client submits the same page twice?
Treat the newer response as the current package and record its Response ID on the Review tab. A lookup that searches the Responses tab from the bottom, such as XLOOKUP with a search mode of -1, returns the latest submission for each page automatically, so counts are by page, not by response.
Raj Kumar · Founder, Zunoform
Raj Kumar is the founder of Zunoform, the form builder made by Symphonic Grow. He builds the product and writes these guides, checking every competitor price and feature claim against the vendor's own pages before publishing.
Raj Kumar on LinkedInKeep reading

Ready when you are
Better forms.
Better data.
Start with a conversation, a document or a single page.
Unlimited forms and 500 responses per month on Free.
No card required.
- No credit card
- Unlimited forms
- 500 responses / month