Link prospecting workspace for competitor backlink gaps

Build me a link prospecting workspace my team works out of instead of keeping backlink opportunities in a spreadsheet. I want to enter my own domain plus two or three competitor domains, have the app pull everyone linking to those competitors from Ahrefs, and turn that into a prioritized outreach queue I can filter, assign, and work through.

Setup view. A simple screen where I enter my own site domain and add two or three competitor domains, then hit Refresh prospects. Save these settings in the app so I do not retype them every session, and show when the prospect list was last refreshed.

Building the prospect list. For each competitor domain, call Ahrefs List Referring Domains to get every domain linking to them, and Ahrefs List Backlinks to get the individual links, including the specific competitor page that earned each link and the anchor text. Drop any backlink where the is_spam field is true before it becomes a prospect. Then call Ahrefs List Referring Domains against my own domain and subtract every one of those domains from the results, so the queue only contains sites that link to a competitor but not yet to me. Collapse everything to one row per prospect domain, keeping the list of competitors it links to and the competitor pages it linked to.

Enrichment. For each surviving prospect domain, call Ahrefs Get Domain Rating for its Domain Rating and Ahrefs Rank, and Ahrefs Get Backlinks Stats for its live backlink and referring domain counts. Show these on the prospect row so I can judge quality at a glance.

Ahrefs specifics to respect. The select parameter is mandatory on list endpoints and drives unit cost, so request only the fields the app actually shows. The where parameter takes structured JSON rather than a string, for example filtering domain_rating with a gt comparison. The offset parameter is deprecated, so bound results with limit instead of trying to paginate. Cache the pulled data in the app so opening the queue does not re-fetch from Ahrefs on every page load, and only refresh when I ask.

The queue view. This is the main screen: a prioritized, sortable table of prospects. Let me filter by minimum Domain Rating, by how many of my competitors that domain links to, and by topic. Rank the default sort so that high Domain Rating combined with linking to multiple competitors floats to the top, since a site linking to two or three of my competitors is the most likely to link to me. Every row should show the prospect domain, its Domain Rating, its link counts, which competitors it links to, and which specific competitor page earned the link.

Prospect record. Each prospect holds a status I move through new, queued, contacted, replied, won, and dead, plus free-text notes and an owner. Persist all of this in the app so it survives refreshes and my whole team sees the same state. Changing status or owner should save immediately without a separate save button.

Draft outreach action. When I select a prospect and click Draft outreach, generate a personalized pitch that references the specific competitor page that site linked to, so the email has a real angle rather than being generic. Save it with Gmail Create a Draft and leave it unsent, always, so a human reviews and sends it. Show me the drafted copy in the app and link out to the draft in Gmail. Move the prospect to contacted only when I confirm, not automatically on draft creation.

Campaign tracker sync. A Log to sheet action appends the prospect row and its current status to our shared campaign tracker using Google Sheets Append Values. On app load, read the tracker back with Google Sheets Get Values and mark any prospect already present in the sheet as worked, so two people never chase the same domain. Let me pick which spreadsheet and tab to use and remember that choice.