Automatic backlink data export from Semrush to Google Sheets via RapidAPI

🔗 Automated Semrush Backlink Checker with n8n and Google Sheets

📘 Description

This n8n workflow automates backlink data extraction using the [Semrush Backlink Checker API](https://rapidapi.com/PrineshPatel/api/semrush-backlink-checker) available on RapidAPI. By submitting a website via a simple form, the workflow fetches both backlink overview metrics and detailed backlink entries, saving the results directly into a connected Google Sheet. This is an ideal solution for SEO professionals who want fast, automated insights without logging into multiple tools.

---

🧩 Node-by-Node Explanation

- On form submission – Starts the workflow when a user submits a website URL through a web form. - HTTP Request – Sends the URL to the [Semrush Backlink Checker API](https://rapidapi.com/PrineshPatel/api/semrush-backlink-checker) using a POST request with headers and form data. - Reformat 1 – Extracts high-level backlink overview data like total backlinks and referring domains. - Reformat 2 – Extracts individual backlink records such as source URLs, anchors, and metrics. - Backlink overview – Appends overview metrics into the "backlink overflow" tab of a Google Sheet. - Backlinks – Appends detailed backlink data into the main "backlinks" tab of the same Google Sheet.

---

✅ Benefits of This Workflow