Skip to main content

Make Waves ’26 Step into AI’s glass box. Prague, 19–20 Oct.

Register now (opens in a new tab)
Make
Templates
Track Paid Ads with SE Ranking SEO Data API
App Families

Track Paid Ads with SE Ranking SEO Data API

Use template
Share

About template

Automates competitor intelligence for paid ads. It searches SE Ranking for domains advertising on a target keyword, logs their ad creatives to a Google Sheet, and sends a Slack notification upon completion.

Template Description

This template automates competitor ad monitoring. It retrieves a list of domains running paid ads for your specified keyword using the SE Ranking Data API, logs the ad creatives into a Google Sheet for historical analysis, and sends a completion alert to Slack.

Template configuration requires the following:

  1. SE Ranking SEO Data:

    • Establish your connection using your SE Ranking API Key.
      • Set the source parameter to the desired regional database using the alpha-2 country code (e.g., "us").
      • Enter the keyword you want to monitor.
      • (Optional) You can specify a date range using from and to parameters in "YYYY-MM" format to narrow down the search.

  2. Google Sheets:

    • Connect your Google Sheets account.
    • Select the destination spreadsheet and sheet.
    • Map the response data from SE Ranking to your sheet columns. Key available fields include domain, snippet_title, snippet_description, and snippet_display_url.

  3. Slack:

    • Authorize your Slack connection.
    • Choose the channel to receive the notification.
    • Customize the message content to summarize the operation.
Tools
SE Ranking
Flow Control

Similar templates

Find inspiration by the type of content that fits your goals.

See all templates
AI

Generate ChatGPT Completions from Google Sheets Rows

Effortlessly enhance your content creation process by integrating ChatGPT with Google Sheets. This powerful template allows you to automatically generate relevant completions, ranging from SEO keywords to custom responses, boosting productivity and content quality with ease. Learn more

Generate ChatGPT Completions from Google Sheets Rows
Use template
App Families

Add webhook data to a Google Sheet

Use this automation to instantly capture data from a webhook and automatically add it as a new row in a Google Sheet. This is ideal for real-time data logging, form submissions, or any event-driven updates that must be stored in a spreadsheet. Learn more about webhooks!

Add webhook data to a Google Sheet
Use template
App Families

Send a Gmail email from a new Google Sheets row

Effortlessly send Gmail messages when a new row is added to your Google Sheets. Just ensure your spreadsheet includes these columns: Email Address Subject Content

Send a Gmail email from a new Google Sheets row
Use template