Weekly new backlinks tracker in Slack and Sheets

By General Input

Every Monday morning, log new backlinks to your domain in a Google Sheet and post a Slack summary to your SEO channel.

Integrations

  • BuzzSumo
  • Google Sheets
  • Slack

Type

Deterministic Code

Categories

  • Marketing
  • Operations

Build me a deterministic code workflow that tracks new backlinks to my domain every week. Trigger: a cron schedule that runs every Monday at 6am in my local timezone.

Step 1: Call BuzzSumo's Search Backlinks operation for a configured root domain (make the domain a workflow input). Use the result set as this week's snapshot of backlinks pointing at the domain.

Step 2: Call Google Sheets Get Values on a configured spreadsheet ID and tab (also workflow inputs) to read the existing backlink log. The first column of the log holds source URLs that have already been recorded.

Step 3: Diff the BuzzSumo result set against the logged source URLs to identify backlinks discovered this week (URLs in the BuzzSumo response that are not already in the sheet). Deduplicate within the new set as well.

Step 4: Call Google Sheets Append Values to add one row per new backlink, with these columns in order: source URL, source domain, domain authority, anchor text snippet, evergreen score, discovered_at timestamp (ISO 8601, the time the workflow ran).

Step 5: Call Slack Send a Message to a configured channel (workflow input) with a single summary message. The message should include: the total count of new backlinks this week, a breakdown by domain authority bucket (high = 60+, medium = 30-59, low = under 30), and a link to the Google Sheet. If zero new backlinks were found, post a short message confirming the check ran with no new links.

This is a code workflow, not an agent: every step is a known operation with structured inputs and outputs, no reasoning or drafting is required. Keep the flow strictly deterministic.

Related prompts

Explore more prompts
Call overdue Xero customers with an AI collections agentLocal listing health board for every location you manageWin back LiveChat visitors whose chats went unansweredLet support send one-off Loops emails without an engineerStop cold emails to anyone with a live deal in PipedriveiMessage campaign console with pre-flight checks and delivery boardChat quality review board for LiveChat support leadsLinkedIn Ads budget pacing dashboard for every client accountFront desk appointment confirmation board for the next 3 daysGive your team Looker numbers without buying more seats