Fetch Ahrefs organic keywords when a table query result changes
Your saved query is already doing the filtering, deciding which sites matter right now. Notis picks up from there: when the query result changes, it pulls the relevant site's Ahrefs organic keywords, so your ranking view updates in step with the data you have already curated instead of lagging behind it.
Trigger
Table Query Result Changed
Triggers when the result set of a saved table query changes in Google Sheets. Detects rows added, removed, or updated in the query output. This trigger monitors the result of a SQL query against a Google Sheets table and fires when changes are detected.
Action
Retrieve organic keywords
Retrieves organic keywords data for a specified website using ahrefs' site explorer tool. this endpoint provides valuable insights into a website's seo performance by returning a list of keywords for which the site ranks in organic search results. it's particularly useful for analyzing a website's organic search visibility, identifying ranking opportunities, and comparing keyword performance against competitors. the data returned includes key metrics such as keyword position, search volume, and estimated traffic, allowing users to make informed decisions about their seo strategy. note that the results are based on ahrefs' database and may not reflect real-time search engine results.
Why this helps
Your query surfaces the sites that matter, but their organic keyword data stays frozen until you go pull it manually.
- Keeps organic keyword data in sync with your curated query results.
- Fires precisely when your filtered view changes, not on every edit.
- Removes the manual refresh between your data and Ahrefs rankings.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Ahrefs to Notis once via the portal.
- 2Create a New Automation in Automations named Organic keywords on query change.
- 3Describe it plainly: when my saved table query result changes, pull the site's Ahrefs organic keywords and report them.
- 4Choose the Table Query Result Changed trigger and pick your channel.
- 5Adjust the query so its result changes and confirm the keywords return.
Questions about this workflow
What counts as a query result change?
Rows being added, removed, or updated in the output of your saved SQL query against the sheet table.
Does it pull keywords for every row?
It acts on the site referenced by the changed result. Frame the prompt to target the domain in the affected rows.
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.