Run an Ahrefs batch analysis when competitor URLs hit your sheet
Comparing competitors one URL at a time is the kind of repetitive lookup that eats an afternoon. This automation lets you paste your list into a sheet and hands the whole batch to Ahrefs, so DR, traffic, and link metrics come back for every URL at once while you move on to the actual thinking.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Batch Url Analysis
Performs a batch analysis on multiple urls or domains using ahrefs' powerful seo metrics. this endpoint allows users to retrieve key seo data for up to 100 targets simultaneously, streamlining the process of analyzing multiple websites or pages. it's particularly useful for comparing competitors, analyzing site sections, or processing large sets of urls efficiently. the endpoint offers customization options for selecting specific metrics, filtering by country, and choosing the calculation mode for volume-based metrics. while it provides comprehensive data, users should be aware of the 100-target limit per request and ensure they have sufficient api quota for large-scale analyses.
Why this helps
Analyzing a competitor set means running the same Ahrefs lookup dozens of times, and the repetition drains focus before you get to the insights.
- One paste replaces dozens of one-off Ahrefs lookups.
- Gets comparable metrics for the whole competitor set in a single pass.
- Frees your attention for strategy instead of repetitive data pulls.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Ahrefs to Notis once from the portal.
- 2In Automations, create a New Automation called Batch competitor analysis.
- 3Write the plain-language prompt: when new URLs are added to my competitors sheet, run an Ahrefs batch analysis on them and send me the metrics.
- 4Choose the New Rows in Google Sheet trigger and pick your channel for results.
- 5Paste a few test URLs and confirm the batch metrics return together.
Questions about this workflow
Is there a limit to how many URLs I can add?
Ahrefs' batch analysis handles up to 100 targets per request, so keep pastes within that range for a single run.
Do the URLs need to be formatted a certain way?
Add them as normal URLs or domains in the rows. Notis reads the new entries and passes them to Ahrefs.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Ahrefs. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Ahrefs actions
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Backlinks stats retrieval
Retrieves comprehensive backlink statistics for a specified website or url using ahrefs' site explorer tool. this endpoint provides crucial data for seo analysis, including the total number of backlinks, referring domains, and potentially the domain rating (dr). it's essential for understanding a site's link profile, assessing its seo performance, and conducting competitive analysis. the tool is particularly useful when users need detailed insights into a website's backlink structure or when comparing the backlink profiles of multiple domains. note that the data returned is based on ahrefs' extensive web crawl and may not include very recent backlinks.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Batch Url Analysis
Performs a batch analysis on multiple urls or domains using ahrefs' powerful seo metrics. this endpoint allows users to retrieve key seo data for up to 100 targets simultaneously, streamlining the process of analyzing multiple websites or pages. it's particularly useful for comparing competitors, analyzing site sections, or processing large sets of urls efficiently. the endpoint offers customization options for selecting specific metrics, filtering by country, and choosing the calculation mode for volume-based metrics. while it provides comprehensive data, users should be aware of the 100-target limit per request and ensure they have sufficient api quota for large-scale analyses.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Domain rating for site explorer
Retrieves the domain rating (dr) for a specified domain. domain rating is an ahrefs metric that measures the strength and authority of a website's backlink profile on a logarithmic scale from 0 to 100. this endpoint should be used when you need to quickly assess the overall seo strength of a domain based on its backlink profile. it's particularly useful for competitive analysis, link building research, and evaluating potential partnership opportunities. the tool provides a single, easy-to-understand metric but does not offer detailed information about the backlinks themselves or other seo factors. for more comprehensive backlink analysis, consider using other ahrefs endpoints that provide more detailed backlink data.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Domain rating history
Retrieves the historical domain rating (dr) data for a specified domain over time. this endpoint is part of ahrefs' site explorer tool and provides insights into how a domain's authority has changed. it's useful for tracking the impact of seo efforts, analyzing competitors, or understanding long-term trends in domain strength. the tool returns a time series of domain rating values, allowing users to visualize changes in a domain's perceived authority according to ahrefs' metrics. it should be used when analyzing the historical performance of a domain in terms of its overall seo strength and backlink profile quality. note that this endpoint focuses solely on domain rating and does not provide other metrics like backlink counts or organic traffic data.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Explore keywords overview
Retrieves a comprehensive overview of keyword data from ahrefs' keywords explorer tool. this endpoint provides essential insights for seo professionals and content strategists, offering a summary of key metrics such as search volume, keyword difficulty, and potential traffic. it's ideal for users looking to get a quick snapshot of keyword performance and opportunities without diving into specific keyword details. the overview likely includes aggregate data and trends, helping users to make informed decisions about their keyword strategy. while it offers a broad perspective, it may not provide in-depth analysis of individual keywords. use this endpoint when you need a high-level view of your keyword landscape or to identify general trends in your niche.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Explore keyword volume by country
Retrieves the search volume data for specified keywords across different countries using ahrefs' keywords explorer tool. this endpoint allows users to obtain accurate search volume information, helping in keyword research and content strategy planning for specific geographic regions. it's particularly useful for seo professionals and content marketers looking to optimize their targeting for different markets. the endpoint provides monthly search volume data, which can be used to gauge the popularity and potential traffic of keywords in various countries. note that the data is based on ahrefs' extensive database and may not always exactly match real-time google search volumes.
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Explore linked domains of a site
Retrieves a list of external domains that the specified target website or url links to, using ahrefs' site explorer functionality. this endpoint is crucial for analyzing a website's external linking structure, which can provide insights into its content strategy, partnerships, and overall seo approach. it's particularly useful for competitive analysis, link building strategies, and identifying potential opportunities or risks in a website's outbound link profile. the endpoint returns detailed information about each linked domain, including the number of links pointing to it from the target site.
New Sheet Added in Google Spreadsheet
Polling trigger that detects when a new sheet is added to a Google Spreadsheet.
Explore matching terms for keywords
The keywords explorer matching terms endpoint retrieves a list of keyword phrases that match or contain the specified keyword from ahrefs' vast database. this tool is part of ahrefs' keyword explorer functionality and is designed to assist in comprehensive keyword research for seo purposes. it returns matching terms along with their relevant metrics such as search volume, keyword difficulty, and potential traffic. this endpoint is particularly useful when expanding a seed keyword list, finding long-tail variations, or discovering closely related search terms. the tool takes into account the specified country for localized results, allowing for targeted keyword strategies in different markets. it's important to note that while this tool provides valuable keyword suggestions, it should be used in conjunction with other ahrefs features for a complete seo strategy.
Connect any two apps with Notis in the middle.
Not just Google Sheets and Ahrefs. Any combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7 days free trial with 20$ free usage included.
No card. Works with personal or business Ahrefs.