Agency workflow · Updated September 2026 · 9 min read

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

An open house model with some rooms filled with paper and blank prints, others still empty

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.

ColumnWhat it holdsExample
PagePage name and planned URL, matching the sitemapServices — /services
Content ownerThe client-side person supplying this pagePriya (marketing lead)
Due dateWhen the page package is due2026-10-14
StatusOne value from a fixed dropdownWaiting on client
Latest response IDThe form submission currently in usePulled by formula from Responses
Copy versionWhich document version was reviewedv3, 9 Oct
Missing itemWhat blocks the page, in one lineTeam photos and captions
Last chasedDate of the last reminder2026-10-10
Days overdueCalculated, never typedFormula

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

How do you collect website content from clients? Methods compared

Prices checked on 28 September 2026 on the vendor’s own page.

MethodCostStatus trackingMain weakness
Email and attachmentsFreeNone; lives in inboxesNo single view of what is missing; versions get lost
Shared drive folder per pageFree with Google Drive or similarManual, by folder contentsFiles arrive without context, approver or completeness
Shared spreadsheet the client editsFreeGood if everyone keeps to itClients can overwrite formulas and paste long copy into cells
Form feeding Google SheetsFree form plans exist; Zunoform Free includes SheetsTeam-owned Review tab with formulasReminders and chasing stay manual
Content SnareFrom $35/month billed annually ($42 monthly), 20 active requestsBuilt in, with automatic remindersA 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.

01

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.

02

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.

03

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.

04

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.

Source: Google Sheets: create a dropdown list

Source: Google Sheets: conditional formatting

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

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.

About the author

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 LinkedIn

Keep 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