Analyze Website Backlinks with Top Backlink Checker API and Google Sheets Logging

This n8n workflow provides a streamlined way to analyze website backlinks using a custom API and log the results into a Google Sheet. It's designed to be triggered manually via an n8n form, making it easy to initiate backlink checks for specific URLs and store the data for further analysis.

What it does

This workflow automates the following steps:

1. Triggers on Form Submission: A user submits a URL via an n8n form.
2. Makes an HTTP Request: It takes the submitted URL and constructs a request to a "Top Backlink Checker API" (or a similar custom API) to fetch backlink data.
3. Processes API Response: It then processes the JSON response from the API, extracting relevant backlink information.
4. Logs to Google Sheets: Finally, it appends the extracted backlink data as a new row in a specified Google Sheet, providing a persistent log of all analyses.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Account: A Google account with access to Google Sheets. You'll need to set up a Google Sheets credential in n8n.
• Top Backlink Checker API (or similar custom API): An API endpoint that can analyze a given URL and return backlink data. This workflow assumes such an API exists and is accessible via HTTP. You will need the API endpoint URL and any necessary authentication details (e.g., API key, headers).

Setup/Usage

1. Import the Workflow:

   • Copy the provided JSON code.
   • In your n8n instance, click on "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON". Paste the JSON code and click "Import".

2. Configure Credentials:

   • Google Sheets:
     • Click on the "Google Sheets" node.
     • Under "Credentials", click "Create New".
     • Choose "Google Sheets API" and follow the instructions to authenticate with your Google account. Ensure you grant the necessary permissions for n8n to write to your Google Sheets.
   • HTTP Request:
     • Click on the "HTTP Request" node.
     • Configure the "URL" field to point to your "Top Backlink Checker API" endpoint.
     • Set the "Method" (e.g., GET, POST) and add any required "Headers" (e.g., Authorization: Bearer YOUR_API_KEY) or "Query Parameters" as per your API's documentation. The workflow currently expects the URL to be passed in the url query parameter.

3. Configure Google Sheet:

   • In the "Google Sheets" node, specify the "Spreadsheet ID" and "Sheet Name" where you want to log the backlink data.
   • Ensure the sheet has appropriate headers matching the data you expect from the "Code" node (e.g., URL, Backlinks Count, Referring Domains).

4. Configure the Form Trigger:

   • Click on the "On form submission" node.
   • Customize the form fields if needed. By default, it expects a field named url.
   • Save the workflow.

5. Activate the Workflow:

   • Toggle the workflow "Active" switch in the top right corner of the n8n editor.

6. Use the Form:

   • Once active, you can access the form by clicking on the "On form submission" node and then clicking the "Open Form" button.
   • Enter the website URL you want to analyze and submit the form. The workflow will execute, fetch backlink data, and log it to your Google Sheet.