One sheet per client. Re-run it every month.
URLs in column A, one formula for titles, descriptions and headings, and free rank tracking next to it.
fx=PAGEDATA(A2, A3, A4, A5, A6)
| URL | Formula | |
|---|---|---|
| 2 | clientsite.co.uk/ | =PAGEDATA(A2, A3, A4, A5, A6) |
| 3 | clientsite.co.uk/services | |
| 4 | clientsite.co.uk/about | |
| 5 | clientsite.co.uk/blog/local-seo | |
| 6 | clientsite.co.uk/contact |
| title | description | h1 |
|---|---|---|
| Client Site | Web Design Leeds | Award-winning web design and SEO in Leeds. | Web design that ranks |
| Services | Client Site | What we do | |
| About | Client Site | Meet the team behind Client Site. | About us |
| Local SEO in 2026: a practical guide | How small businesses win local search. | Local SEO in 2026 |
| Contact | Client Site | Get in touch |
Example output for illustration, not a live result.
50 pages. About 2 hours by hand, or one formula dragged down.
How PAGEDATA() works.
Where it runs
This writes beside the formula. PAGEDATA fetches the page directly and spills the results under the cell, usually within a few seconds. No new tab, no background job.
Where the data comes from
Fetches each page's live HTML directly and parses out the title, description and headings. A page that needs JavaScript to render is detected and re-fetched through a browser automatically, no extra setup.
Costs 50 integration credits for 50 pages: 1 per page, from the published rate. See every source's rate
Two ways to do it.
Formula
Every formula works on Free.
1. Paste the formula
Put the client's URLs in column A and paste =PAGEDATA(A2, A3, A4, A5, A6) into B1. Add every URL you want checked as another argument.
2. Read the table
PAGEDATA spills a header row and one row per URL beneath the cell: title, description and headings. Leave the cells below and to the right empty.
3. Re-run it next month
Open the same sheet, press Enter on the formula cell, and compare the new rows against last month.
Chat
Chat Agent is on Solo, Team and Business plans.
1. Type the job
“Audit every URL in column A and flag titles over 60 characters or missing descriptions”
2. The agent writes the sheet
Checked 50 pages: 7 titles too long, 12 descriptions missing. Flags are in column E.
Month four.
Same sheet, next month. Re-run the column and diff.
| url | description | Run |
|---|---|---|
| clientsite.co.uk/services | Web design, branding and SEO packages for small businesses. | Updated |
| clientsite.co.uk/contact | Get in touch with the Client Site team in Leeds. | Updated |
What re-running the same formula next month adds or changes. Example output for illustration, not a live result.
Turn on Keep Formula in the sidebar and the column stays live for the rows you add next week.
Formulas for this job.
=PAGEDATA(A2, A3, A4)Bulk-extract metadata (title, description, headings) from a range of URLs
=BULKSERP("best coffee shops in NYC")Search results in horizontal format, ideal for many keywords at once, free on every plan
=GETMETATITLE("https://example.com")Get the meta title of any page
=GETHEADINGS("https://example.com")Get all headings (H1–H6) of any page
=AITEXT("Write a product description for: " & A1)Generate AI text from any prompt, supports every model and optional real-time web search
Not sure it fits your job? Ask.
Describe the task in plain English. In about ten seconds you get a straight answer, yes, partially or not a fit, plus the exact formulas or Chat Agent prompt to run. No signup, no card.
Already sure?
Installs from the Google Workspace Marketplace in under a minute. Every formula works on the free allowance.
Install free for Google Sheets