Automated SEO Keyword Tracking and Research via Semrush API in Google Sheets

🔎 Automated Keyword Research Workflow with Google sheet logging & Semrush API Description: Easily collect keywords and country input, run automated keyword research via the [Semrush Keyword Research](https://rapidapi.com/PrineshPatel/api/semrush-keyword-research-tool) API on RapidAPI, and store results in Google Sheets for seamless tracking and analysis.

---

⚙️ Node-by-Node Explanation

🟢 On form submission (formTrigger) - Collects keyword and country inputs from the user via a simple form to start the research process. - Triggers the workflow execution upon submission.

🌐 Keyword Research (httpRequest) - Sends a POST request with user inputs (keyword and country) to the [Semrush Keyword Research](https://rapidapi.com/PrineshPatel/api/semrush-keyword-research-tool). - Retrieves keyword suggestions, search volume, and related data for comprehensive keyword insights.

📄 Append Data to Google Sheet (googleSheets) - Automatically appends the keyword research results into a connected Google Sheets document. - Enables easy tracking, sharing, and further analysis of keyword data.

--- 📈 Example Spreadsheet Structure

| Keyword | Country | Search Volume | CPC | Competition | Keyword Difficulty | Related Keywords | Date of Research | |---------------|---------|---------------|------|-------------|--------------------|-------------------------------------|------------------| | keyword1 | US | 10,000 | $2.50| 0.75 | 45 | keyword2, keyword3 | 2025-09-09 | | example term | UK | 15,000 | $1.80| 0.60 | 38 | term1, example keyword | 2025-09-09 | 🌟 Benefits