SEOの自動化テンプレート

Every 15 minutes, takes the leads ActiveCampaign has touched most recently, turns each website into a bare domain, looks the company up in the Google Business listings database, and writes the name, description, categories, address, rating and price level back onto the ActiveCampaign record.

Every 15 minutes, takes the leads ActiveCampaign has touched most recently, turns each website into a bare domain, estimates how much organic search traffic that domain gets, and writes the numbers back onto the ActiveCampaign record.

Pulls the live backlinks pointing at a domain every 15 minutes and appends them to a Google Sheet, one row per link, with the source page, anchor text, follow status, ranks and first/last seen dates.

Tracks which websites Google's AI Mode cites when it answers a question. Every 7 days it queries the AI Mode SERP for a keyword, flattens the references of every answer block, de-duplicates them by URL and appends them to a Google Sheet.

Tracks which websites Google's AI Overview cites for a keyword. Every 7 days it pulls the Google SERP with the AI Overview block loaded, collects every source the answer references, de-duplicates them by URL and appends them to a Google Sheet.

Each week, finds the keywords where your domains are newly cited inside Google's AI Overview, saves the full picture to Google Sheets, and emails the new placements.

Every morning, pulls the newest reviews for your app from both Google Play and the App Store, keeps only the ones written since the last run, and posts a digest per store to Slack.

Every morning, pulls the newest reviews for your app from both Google Play and the App Store, keeps only the ones written since the last run, and opens one ClickUp task per store holding the digest.

Pulls every backlink pointing at a URL on your domain that now returns an error, logs them to a dated Google Sheet, and opens one Asana task pointing at that sheet.

Reads a column of domains from a Google Sheet and pulls the full backlink profile for all of them in one DataForSEO call - rank, spam score, broken links, referring domains, IPs, subnets and the TLD, type, attribute, platform, location and country breakdowns.

Reads a column of target domains from a Google Sheet, scores all of them in one DataForSEO Bulk Ranks call, and writes each rank back next to its domain with the date it was measured.

Reads a column of domains from a Google Sheet, scores all of them in one DataForSEO Bulk Spam Score call, and writes each 0-100 score back next to its domain with the date it was measured.

Reads a column of domains from a Google Sheet and pulls the live backlink count for all of them in one DataForSEO call, stamping each count with the date it was measured.

Reads a column of domains from a Google Sheet and pulls the live referring-domain counts for all of them in one DataForSEO call, writing the follow and nofollow breakdown back next to each domain.

Pulls every keyword your site ranks for, pulls every keyword a competitor ranks for, and writes the difference - the keywords they own and you do not - into a Notion database with search volume, their position, their URL and the keyword competition score.

Each week, finds the keywords where your domains now hold Google's featured snippet and emails the new ones with position, search volume and the ranking URL.

Every 15 minutes, takes the leads GoHighLevel has touched most recently, turns each website into a bare domain, looks the company up in the Google Business listings database, and writes the name, description, categories, address, rating and price level back onto the GoHighLevel record.

Every 15 minutes, takes the leads GoHighLevel has touched most recently, turns each website into a bare domain, estimates how much organic search traffic that domain gets, and writes the numbers back onto the GoHighLevel record.

Reads a column of keywords from a Google Sheet and fills in the Google Ads planner numbers for all of them in one call: monthly search volume, competition and cost per click.

Each week, finds the keywords above your search-volume bar that your domains have started ranking for and turns them into an Asana task, so the opportunity lands in someone's queue instead of a spreadsheet nobody opens.

Every 15 minutes, takes the leads HubSpot has touched most recently, turns each website into a bare domain, looks the company up in the Google Business listings database, and writes the name, description, categories, address, rating and price level back onto the HubSpot record.

Every 15 minutes, takes the leads HubSpot has touched most recently, turns each website into a bare domain, estimates how much organic search traffic that domain gets, and writes the numbers back onto the HubSpot record.

Every two weeks, takes a list of URLs from an input sheet and, for each one, pulls the full set of keywords that URL ranks for into its own tab of an output spreadsheet - keyword, position, volume, difficulty, CPC, competition, intent, SERP feature type and estimated traffic.

Every two weeks, checks where each tracked URL ranks for its keyword and appends a dated row carrying the new position, the delta and a status - up, down, same, new or lost.

For each seed domain in an input sheet, pulls every keyword the domain is relevant for, scores all of them for ranking difficulty in one bulk call, and writes the combined picture - volume, trend, difficulty, intent and average backlinks - to an opportunities sheet.

Every 15 minutes, takes the leads monday has touched most recently, turns each website into a bare domain, looks the company up in the Google Business listings database, and writes the name, description, categories, address, rating and price level back onto the monday record.

Every 15 minutes, takes the leads monday has touched most recently, turns each website into a bare domain, estimates how much organic search traffic that domain gets, and writes the numbers back onto the monday record.

Each week, finds the keywords where your domains are now cited inside Google's AI Overview and emails the new ones.

Each week, finds the keywords where your domains now hold Google's featured snippet - position zero, above the first organic result - and emails the ones that are new since last week.

Each week, finds the keywords above your search-volume bar that your domains have started ranking for, opens one Asana task holding the list, and posts a summary to Slack.

Each week, pulls every keyword your target domains rank for, compares it against last week's snapshot, and posts whatever is new to Slack.

Each week, finds the keywords where your domains have broken into Google's first page, writes them to an Airtable base, and posts a summary to Slack.

Every 15 minutes, takes the leads Pipedrive has touched most recently, turns each website into a bare domain, looks the company up in the Google Business listings database, and writes the name, description, categories, address, rating and price level back onto the Pipedrive record.

Every 15 minutes, takes the leads Pipedrive has touched most recently, turns each website into a bare domain, estimates how much organic search traffic that domain gets, and writes the numbers back onto the Pipedrive record.

Runs a ranked keyword gap analysis between your domain and a competitor's, and logs every keyword they rank for and you do not into a Notion database.

Watches an Airtable table for target domains that have not been looked up yet, pulls the keywords each one ranks for, writes them into a second table, and ticks the source record off so it is never processed twice.

Every 15 minutes, takes the leads Salesforce has touched most recently, turns each website into a bare domain, looks the company up in the Google Business listings database, and writes the name, description, categories, address, rating and price level back onto the Salesforce record.

Every 15 minutes, takes the leads Salesforce has touched most recently, turns each website into a bare domain, estimates how much organic search traffic that domain gets, and writes the numbers back onto the Salesforce record.

Watches, in near real time, which sites Google's AI Mode pulls from when it answers questions about your brand. Polls the AI Mode SERP every 15 minutes and appends every cited source to a Google Sheet.

Polls the Google SERP for a keyword every 15 minutes with the AI Overview block loaded and appends every source the overview cites to a Google Sheet.

Watches an Airtable table for keyword/domain pairs that have not been checked yet, looks up where the domain ranks for that keyword on Google, and writes the position back onto the record.

Every morning, checks where each tracked URL ranks for its keyword, compares against the position recorded on the last run, and posts to Slack only when a keyword has moved down.

Each week, finds the keywords where your domains have broken into Google's first page, logs them to Airtable, and alerts Slack.

Every day, pulls the keywords each target domain currently holds a top-10 position for, compares against yesterday's snapshot, and emails a digest of everything that slipped.

Every day, pulls the keywords each target domain currently holds a top-10 position for, compares against yesterday's snapshot, and emails a digest of everything that slipped.

Pages through every backlink pointing at your domain with a spam score above the threshold, writes the source URLs into a Google-compliant disavow.txt, uploads it to Google Drive and emails you the link.

Every evening, searches the web for pages that mentioned your brand in the last 24 hours, classifies each mention as positive, negative or neutral, writes them into a dated Google Doc, and posts a Slack summary with the sentiment split and a link to the doc.

Reads a column of domains from a Google Sheet and pulls, in one DataForSEO call, how many backlinks each of them gained and lost, stamped with the date.

Reads a column of domains from a Google Sheet and pulls, in one DataForSEO call, how many referring domains each of them gained and lost - counted both per domain and per main domain - stamped with the date.

Once a week, fetches every keyword your domains rank for on Google, saves the current picture to Google Sheets, and sends a Slack summary of what is newly ranking.

Every week, pulls every backlink first seen in the last seven days whose spam score is above the threshold, drops them into a fresh Google Sheet named after the domain and the date, and emails you the link.

Every 15 minutes, takes the leads Zoho CRM has touched most recently, turns each website into a bare domain, looks the company up in the Google Business listings database, and writes the name, description, categories, address, rating and price level back onto the Zoho CRM record.

Every 15 minutes, takes the leads Zoho CRM has touched most recently, turns each website into a bare domain, estimates how much organic search traffic that domain gets, and writes the numbers back onto the Zoho CRM record.