The Scenario
You are a technical SEO consultant. You ran an on-page crawl for a 500-page e-commerce site and the crawl task is complete in DataForSEO.
Now you need to extract all duplicate title tags and duplicate meta descriptions into a Google Sheet so you can prioritize fixes for the client. The report is due Monday morning.
It is Friday at 3 PM.
The bad version:
- You pull the raw crawl task results from DataForSEO via the API
- The response is a nested JSON with hundreds of pages and overlapping issue arrays
- You write a Python script to parse duplicate groups and flatten them into rows
- The script works, but it formats duplicate URLs as a semicolon-separated list in one cell
- The client cannot read that format and asks you to split it
- You spend Friday evening reformatting a spreadsheet you thought was done
- You email Monday's report at 11 PM Sunday.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your DataForSEO crawl task ID, fetches the duplicate tag findings, and writes them into a structured sheet — no JSON parsing, no Python script.
Open the SheetXAI sidebar and type:
Fetch duplicate title tags and duplicate meta descriptions from my DataForSEO on-page task ID and write each duplicate group — URLs sharing the same tag — into the DuplicateTagsAudit sheet.
SheetXAI calls the DataForSEO on-page summary endpoint with your task ID, extracts all duplicate groups, and writes them into DuplicateTagsAudit in a readable format. Each group is a separate row showing the shared tag text and the pages that share it.
What You Get
A DuplicateTagsAudit sheet with one row per duplicate group:
- Issue Type — duplicate_title or duplicate_description
- Shared Tag Text — the exact title or description that is duplicated
- Duplicate URLs — the pages sharing that tag, one per row or comma-separated
- Count — how many pages share this tag
Every duplicate group surfaced, ready to prioritize. Sort by count to fix the worst offenders first, or filter by issue type to tackle all duplicate titles before moving to descriptions.
What If the Data Is Not Quite Ready
Technical SEO audit sheets have edge cases and varying client requirements. SheetXAI handles them in one prompt.
When you want to exclude certain URL patterns from the duplicate analysis
The site has pagination URLs (/page/2, /page/3) that share titles intentionally and should not appear in the report.
Fetch duplicate title tags and meta descriptions from my DataForSEO crawl task. Exclude any URLs containing "/page/" from the duplicate groups. Write the remaining groups into the DuplicateTagsAudit sheet with columns for Issue Type, Shared Tag Text, and Duplicate URLs.
When you want to split duplicate URLs into separate rows for easier filtering
The client's team uses row-level filtering and cannot work with comma-separated URL lists.
Fetch duplicate title tag and meta description groups from my DataForSEO crawl task. Write one row per URL in each duplicate group, repeating the Issue Type and Shared Tag Text columns on each row. Write results into DuplicateTagsAudit.
When you need to prioritize by organic traffic impact
The client has a Traffic column in a separate sheet with page-level traffic data. You want to surface the duplicate groups that affect the highest-traffic pages first.
Fetch duplicate title and meta description groups from my DataForSEO crawl task. For each page in each duplicate group, look up its organic traffic from the Traffic tab in this sheet. Sort the results by the maximum traffic of any page in the group, highest first. Write results into DuplicateTagsAudit.
When you need the full audit export plus a written prioritization brief in one shot
The client does not read spreadsheets without context. You need the data and a written brief.
Fetch all duplicate title tags and duplicate meta descriptions from my DataForSEO crawl task. Write each duplicate group into the DuplicateTagsAudit sheet. Then create a Recommendations sheet and write a short paragraph identifying the top three duplicate groups to fix first, based on number of affected pages, and a one-sentence rationale for each.
The pattern: the data extraction and the written brief happen in one prompt — you send the client the full package, not a raw spreadsheet.
Try It
Get the 7-day free trial of SheetXAI and open any sheet where you want to capture on-page audit findings, then ask it to pull DataForSEO crawl results. The DataForSEO integration is included in every SheetXAI plan. For related workflows, see how to run a bulk on-page SEO audit into a sheet or the DataForSEO in Google Sheets overview.