AutomationMart
Home/Browse/Research content keywords with SE Ranking and export to Google Sheets
n8n

Research content keywords with SE Ranking and export to Google Sheets

n8nn8n8 modulesv1.0
Google Sheets

Who is this for - Content creators looking for topic ideas - SEO specialists doing keyword research - Marketing teams planning content calendars What this workflow does Discover keyword opportunities from 4 different sources (longtail, questions, similar, related) and export analyzed results to Google Sheets. What you'll get - Longtail, question, similar, and related keyword variations - Opportunity scores based on volume, difficulty, and CPC - Search intent classification (informational, comme

At a glance

Research content keywords with SE Ranking and export to Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets
Modules
8
Price
Free
Version
v1.0
Research content keywords with SE Ranking and export to Google Sheets workflow diagram

About this workflow

Who is this for - Content creators looking for topic ideas - SEO specialists doing keyword research - Marketing teams planning content calendars What this workflow does Discover keyword opportunities from 4 different sources (longtail, questions, similar, related) and export analyzed results to Google Sheets. What you'll get - Longtail, question, similar, and related keyword variations - Opportunity scores based on volume, difficulty, and CPC - Search intent classification (informational, commercial, transactional, navigational) - Content type suggestions (how-to guide, listicle, comparison, etc.) - Trend analysis with historical search volume data - Estimated monthly traffic potential - Priority ranking (HIGH/MEDIUM/LOW) - SERP features analysis - All results automatically exported to Google Sheets How it works 1. Fetches 4 types of keywords from SE Ranking (longtail, questions, similar, related) 2. Merges and deduplicates all results 3. Analyzes each keyword with custom scoring algorithm 4. Calculates opportunity scores (volume 40%, difficulty 40%, CPC 20%) 5. Detects search intent and suggests content types 6. Exports enriched data to Google Sheets with 17 columns Requirements - SE Ranking account with API access (Get one here) - SE Ranking community node installed (Install from npm) - Google Sheets account Setup steps 1. Install the SE Ranking community node 2. Add your SE Ranking API credentials 3. Connect your Google Sheets account 4. Update the seed keyword in all 4 SE Ranking nodes (default: "digital marketing") 5. Select or create a Google Sheet for export Customization - Adjust volumeFrom and difficultyTo filters in SE Ranking nodes for different opportunity ranges - Change limit parameter to fetch more/fewer keywords per source (max 1000) - Modify opportunity score formula in the Code node (currently: volume 40%, difficulty 40%, CPC 20%) - Update content type detection patterns to match your industry - Change source parameter for different countries (us, uk, de, fr, etc.)

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Bulk generate images from Google Sheets with Leonardo.AI and store in Google Drive

Seamlessly automate the bulk creation of images using Leonardo.Ai based on prompts from a Google Sheets list. Once generated, the images are automatically saved to a specified Google Drive folder for easy access and organization.

Free

Get RSS feed updates in a single email summarizing all posts that contain a specific keyword

Make will watch RSS feeds you specify in a Google Sheets spreadsheet for new posts that contain a specific keyword. It will merge all these posts into a single email summary and send it to a specific email address. If you wish to use this template without further settings, you need to create a spreadsheet according to this example. In the RSS column, you specify the RSS feeds you want to watch and in the KEYWORD column the keyword to find.

Free

Create UseINBOX contacts from new Google Sheets spreadsheet rows

Make will watch for new rows in a specified Google Sheets spreadsheet at regular intervals and add contacts to a UseINBOX mailing list using information from the sheet. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1ESjUumFTkF2pgBLZp2RCm9mR6-WB8TAk1_hyO8bLAW8/edit?usp=sharing).

Free

Create Google Sheets for new Memberful orders completed

Every time a new order is completed in your Memberful, Make will automatically create a row with order information. Here's the [sheet](https://docs.google.com/spreadsheets/d/12olKfX3H3W-mTgUuHto8HykkryTvfU1WQduYPISaQfQ/edit?usp=sharing) used in this scenario.

Free

Track Amazon competitor with BrowserAct

This template automates Amazon product price monitoring using BrowserAct and Make. It extracts the latest product information (title, current price, original price, availability, rating, review count, and product URL) directly from Amazon pages, then updates Google Sheets and detects price changes. When a change occurs, the template automatically sends an email alert with the previous price, the new price, and the product link. This is designed for e-commerce sellers, dropshippers, analysts, an

Free

Create LionDesk contacts from Google Sheets rows

Every time a new row is added to a Google Sheet, Make will automatically validate the email address from the Google Sheet. If the status of the email is "valid", it will look that person up using Clearbit and create a contact in LionDesk. It will also update the Google Sheet with the data from Clearbit. This examples uses the sheet in [this link](https://docs.google.com/spreadsheets/d/1I_0ORbuaKUyehO5qj7l3iWRNYELfAuG5lQzLfyuSw9A/edit#gid=0).

Free

Create AI shorts with HeyGen, Creatomate, Replicate, Gemini and OpenAI

Shorts Creation v10 (Telegram Filming) — n8n Template Description --- How it works This workflow is a fully automated YouTube Shorts production pipeline. It takes the structured output from a video digestion workflow (transcript, key moments, metadata) and produces finished, rendered vertical shorts complete with AI-generated avatar narration, AI-generated B-roll video clips, dynamic multi-layout compositions, social media copy, and a lead magnet document — all uploaded to Google Dri

Free

Ai agent integration with eBay Buy Marketing API

Complete MCP server exposing 1 Buy Marketing API operations to AI agents. ⚡ Quick Setup Need help? Want access to more workflows and even live Q&A sessions with a top verified n8n creator.. All 100% free? Join the community 1. Import this workflow into your n8n instance 2. Credentials Add Buy Marketing API credentials 3. Activate the workflow to start your MCP server 4. Copy the webhook URL from the MCP trigger node 5. Connect AI agents using the MCP URL 🔧 How it Works This workflow converts the

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free