Turn NocoDB requests into a full SEO keyword plan with clear steps and data. It builds topics, pulls metrics, reviews competitors, and writes a content brief that is ready for action. Great for marketing teams that need fast, consistent plans at scale.

A row sent from NocoDB by webhook starts the run, sets status to started, and posts a Slack alert. OpenAI expands the primary topic into structured keyword sets with intent and related ideas. DataForSEO adds search volume, cost per click, and keyword difficulty for each main term, while split, aggregate, and merge nodes organize the data. Competitor URLs are checked two ways: ranked keywords per page from DataForSEO and a short AI review of strengths and gaps. All results are merged, and a final keyword strategy is drafted and saved back to NocoDB, followed by a done status and a Slack update.

You need access to NocoDB, OpenAI, DataForSEO, and Slack. Expect research time to drop from hours to minutes with consistent, structured results. This setup fits teams building content briefs, topic clusters, and refresh plans based on live metrics and competitor evidence.

• Webhook intake from NocoDB starts each run and maps key fields like topic, audience, language, location and competitor URLs.
• Slack notifications at start and finish to keep the team updated.
• OpenAI expands the topic into primary, long tail and question keywords using a structured schema.
• DataForSEO pulls search volume, cost per click and keyword difficulty for primary keywords.
• Split and aggregate nodes process each keyword and combine metrics for clean comparison.
• Competitor URLs are analyzed with DataForSEO ranked keywords per page.
• An AI agent reviews competitor content to summarize strengths and gaps.
• Merge nodes unify AI output and metric data into one dataset.
• Final keyword strategy is drafted by AI and saved back to NocoDB.
• Status updates in NocoDB and Slack confirm completion for the team.

• Reduce manual research from 3 hours to 10 minutes
• Automate about 80% of keyword research steps
• Improve data consistency by using one structured flow
• Connect NocoDB, OpenAI, DataForSEO and Slack in one place
• Handle many topics per day without extra staff
• Spot competitor keyword gaps faster with clear evidence

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with NocoDB, OpenAI, DataForSEO and Slack. See the Tools Required section above for links to create accounts with these services.
3. Open the NocoDB webhook trigger node. Copy the unique URL. In your NocoDB project, set a webhook to send a POST request to this URL when a row is created or updated for your SEO requests.
4. Double click the NocoDB nodes. In the credential dropdown, click Create new credential and follow the on screen instructions. Use your NocoDB base URL and API token from your NocoDB account.
5. Double click the OpenAI nodes. In the credential dropdown, click Create new credential and follow the on screen instructions. Create an API key in your OpenAI account and paste it into n8n.
6. Double click the DataForSEO nodes. In the credential dropdown, click Create new credential and follow the on screen instructions. Use your DataForSEO API access from their dashboard and confirm your plan allows keywords data and labs endpoints.
7. Double click the Slack nodes. In the credential dropdown, click Create new credential and follow the on screen instructions to connect your Slack workspace and select the target channel.
8. Open the Set relevant fields node. Map your NocoDB column names to primary topic, target audience, content type, language, location and competitor URLs exactly as used in your table.
9. Check the language and location inputs used by DataForSEO nodes. Make sure they match DataForSEO supported values to avoid empty results.
10. Open the Write Content Brief node and confirm the correct NocoDB base, table and column mappings for saving the final strategy and status fields.
11. Send a test row from NocoDB. In n8n, run the workflow and watch the execution. Verify Slack receives the start message, metrics are returned, and the final brief is written back with status done.
12. If DataForSEO returns 401 or empty data, recheck credentials and your language or location values. If Slack does not post, confirm the channel permission. If NocoDB fields are blank, verify column names and webhook event scope.