Shata Solutions
← Back to marketplace
Marketing Automation

Keyword Research

Refresh keyword opportunities weekly from competitor gaps and search trend shifts.

Automation overview

What this automation does

This automation starts when scheduled weekly — Wednesday 6 AM. It slack score, then results append to Airtable SEO queue with priority score, suggested content type, and Slack digest of top 10 new opportunities to content lead.

Trigger
Scheduled weekly — Wednesday 6 AM
Main actions
Slack score
Final outcome
Results append to Airtable SEO queue with priority score, suggested content type…
Execution time
30–90 seconds
Apps used
2 integrations
AI-powered
No
Difficulty
Intermediate
Intermediate
Workflow diagram

End-to-end scenario flow

Read-only visualization of how data moves from trigger to final result.

Trigger
Airtable
Scheduled run
Step 1
Slack
Score
Result
Slack
Workflow complete
Step-by-step

How each step runs

  1. 1
    AirtableTrigger
    Scheduled run

    Scheduled weekly — Wednesday 6 AM

  2. 2
    Slack
    Score

    Results append to Airtable SEO queue with priority score, suggested content type, and Slack digest of top 10 new opportunities to content lead.

  3. 3
    Slack
    Workflow complete

    Results append to Airtable SEO queue with priority score, suggested content type, and Slack digest of top 10 new opportunities to content lead.

Apps used

Connected applications

Airtable

Score

Slack

Score

Summary

Automation summary

Trigger
Scheduled weekly — Wednesday 6 AM
Inputs
Scheduled weekly — Wednesday 6 AM, Business Name, Notification Email, Timezone
Outputs
Results append to Airtable SEO queue with priority score, suggested content type, and Slack digest of top 10 new opportunities to content lead., Slack score
Business goal
Automate keyword research end-to-end with accurate app routing.
Execution frequency
Weekly
Estimated runtime
30–90 seconds
Error handling
Failed steps retry up to 3 times with exponential backoff; persistent failures notify your configured channel and log to the run history.
Dependencies
Airtable, Slack
Benefits

Why use this automation?

Save ~2 hours/week

Remove repetitive steps from Keyword Research so your team focuses on high-value work.

Reduce manual work

Connected apps sync data automatically instead of copy-paste between dashboards.

Prevent human errors

Standardized logic runs the same way every time, with retries on failure.

Requirements

What you need to get started

Required apps

  • Airtable
  • Slack

Required accounts

  • Active Airtable workspace with API access
  • Active Slack workspace with API access
  • Shata Automation workspace (free tier supported)

Required API keys

  • OAuth tokens for each connected integration

Permissions

  • Read access on trigger sources (forms, sheets, webhooks, or CRM objects)
  • Write access on destination apps (email, chat, CRM, or storage)

Estimated setup time

  • 1 hour including app authorization and test run
  • Difficulty: Intermediate

Automation runtime

Activate this template

PreviewSome steps run in preview until their integrations go live.

Connect required apps via OAuth or API keys. Credentials are encrypted server-side. Dev test runs mock external actions when connections are missing.

Draft
0%
Activation readiness

Est. setup time: ~5 min

Required connections

  • Airtable(required)
    PreviewAirtable: workflow actions run in preview
    ⚠ Missing
  • • Missing connection: Airtable
Manage all connections →View all installations →

Workflow summary

Trigger
Scheduled weekly — Wednesday 6 AM
Steps
3 nodes
Required apps
1
Optional apps
1

Trigger

Schedule trigger

Activate this workflow to provision the trigger endpoint.

Run history

No runs yet. Install the template and run a test, or activate to receive webhook/schedule runs.

FreeIntermediatePreview1 hour setup★3.96.6k installs · 39 reviews
Customize for My Business
Analytics

Template performance

25.8k
Views
6.6k
Installs
108
Favorites
3.9
Avg rating
25.7%
Conversion
1 min
Setup time
94%
Success rate
87
Trending score
Most used integrations
AirtableSlack

Weekly Ahrefs API pull of your domain plus 5 competitors identifies new keyword gaps, rising queries from Google Trends API, and declining keywords to deprioritize. Results append to Airtable SEO queue with priority score, suggested content type, and Slack digest of top 10 new opportunities to content lead.

Some steps run in preview until their integrations go live.

Required apps
AirtablePreview
Optional apps
SlackLive
All integrations
AirtableSlack
Workflow preview

How Keyword Research runs

1
Trigger
List competitor domains
2
Process
Rule engine
3
Action
airtable
4
Notify
Alert & log
AirtableSlack
Setup steps

Get started in 5 steps

  1. 1
    Connect SEO APIs

    Ahrefs, Google Trends, Airtable, Slack.

  2. 2
    List competitor domains

    Five competitor URLs in config; expand with caution for API quota.

  3. 3
    Define priority formula

    Volume × (1/difficulty) × business relevance weight from Airtable tags.

  4. 4
    Flag content types

    Blog vs. landing vs. glossary based on SERP feature analysis.

  5. 5
    Review first digest

    Content lead marks false positives; tune relevance weights.

Variables

Configurable settings

VariableTypeDefaultRequired
Business NametextYour BusinessYes
Notification Emailemail—Yes
Timezoneselect—Yes
Slack Channeltext#generalNo
FAQ

Frequently asked questions

Local keywords?

Country parameter on Ahrefs for EG, SA, UAE targeting.

Brand keywords excluded?

Filter out queries containing your brand name from gap list.

Auto-assign writers?

Optional Notion task create for top 3 priority keywords.

SEMrush instead?

Swap API connector; same Airtable output schema.

Get started

Customize Keyword Research for your business

Our team can adapt this template to your exact workflow, apps, and brand requirements.

Request custom automation →Talk to an expert