Fetch an Ahrefs SERP overview when a target keyword hits your sheet
Before committing to a keyword, you want to know who already ranks and what searchers actually expect. Notis handles that read for you: each keyword you log for targeting triggers an Ahrefs SERP overview, so intent signals and the competitive picture are waiting before you invest time in content that might not have a real shot.
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
Get serp overview
Retrieves a comprehensive overview of search engine results pages (serp) data for specified keywords or queries. this endpoint provides valuable insights into search performance, including historical data, search intent analysis, and detailed metrics for each keyword. it's particularly useful for seo professionals and digital marketers looking to optimize their content strategy and improve their website's search engine visibility. the serp overview can help identify trends, analyze competition, and inform content creation efforts based on real search data. note that while this endpoint offers a wealth of information, it may not provide real-time data and should be used for strategic planning rather than immediate tactical decisions.
Why this helps
You commit to a keyword and only discover the SERP is stacked against you after the content is half written, because checking the SERP up front is a step you skip.
- Reveals the competitive picture before you invest in content.
- Surfaces search intent so your angle matches what searchers want.
- Keeps effort pointed at keywords you can realistically win.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Ahrefs to Notis once via the portal.
- 2In Automations, create a New Automation named SERP overview on target keyword.
- 3Write the plain-language prompt: when I add a target keyword, pull its Ahrefs SERP overview and report the intent and competition.
- 4Choose the New Rows in Google Sheet trigger and pick your channel.
- 5Add one keyword and confirm the SERP overview returns.
Questions about this workflow
Is the SERP data live?
It reflects Ahrefs' data and is meant for strategic planning rather than moment-to-moment SERP tracking.
Can I combine this with a keyword overview?
Yes. Many people run both so a new keyword returns metrics and SERP context together.
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.