Automate SEO Analysis for Multiple Domains with Google Sheets

This n8n workflow provides a framework for automating SEO analysis across multiple domains. It's designed to read a list of domains from a Google Sheet, process them, and potentially integrate with other tools (like Ahrefs, implied by the directory name, though not explicitly in the JSON) for detailed analysis. The workflow uses a manual trigger, allowing you to initiate the analysis on demand.

What it does

1. Triggers Manually: The workflow starts when you manually click 'Execute workflow' in n8n.
2. Reads Domains from Google Sheets: It connects to a specified Google Sheet to retrieve a list of domains or other data points that need analysis.
3. Loops Over Items: The workflow is designed to process each item (e.g., each domain) from the Google Sheet individually or in batches, allowing for scalable analysis.
4. Executes Custom Code (Placeholder): A Code node is included, which can be customized to perform specific actions for each domain. This is where you would integrate with external APIs (like Ahrefs) or perform custom data manipulation.

Prerequisites/Requirements

• n8n Instance: A running instance of n8n.
• Google Account: A Google account with access to Google Sheets.
• Google Sheets Credential: An n8n credential configured for Google Sheets.
• Custom Code Logic (Optional but Recommended): You will need to write JavaScript code within the Code node to define the specific SEO analysis steps you want to perform for each domain. This might involve API calls to SEO tools like Ahrefs, data parsing, or other operations.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, click "New" to create a new workflow.
   • Go to the "Workflows" menu, select "Import from JSON", and paste the workflow JSON.
2. Configure Google Sheets Node:
   • Click on the "Google Sheets" node.
   • Select or create a Google Sheets credential.
   • Specify the Spreadsheet ID and Sheet Name where your domain list is located.
   • Ensure the operation is set to "Read" and configure any other options (e.g., range) as needed to fetch your domain data.
3. Customize the Code Node:
   • Click on the "Code" node.
   • Replace the placeholder JavaScript code with your custom logic. This is where you'd typically:
     • Access the domain name from the incoming item (e.g., item.json.domain).
     • Make API calls to SEO tools (e.g., Ahrefs, SEMrush) using the httpRequest helper.
     • Process the API responses.
     • Format the output data.
   • Example (conceptual, requires actual API integration and error handling):

     for (const item of items) {
       const domain = item.json.domain; // Assuming your Google Sheet has a 'domain' column
       // Make an API call to Ahrefs
       // const ahrefsResponse = await n8n.helpers.httpRequest({
       //   method: 'GET',
       //   url: `https://api.ahrefs.com/v3/site-explorer/overview?target=${domain}&output=json`,
       //   headers: {
       //     'Authorization': 'Bearer YOUR_AHREFS_API_KEY',
       //   },
       // });
       // item.json.ahrefsData = ahrefsResponse.json; // Add Ahrefs data to the item
       item.json.processedDomain = `Processed: ${domain}`; // Placeholder for actual processing
     }
     return items;
     

4. Configure Loop Over Items:
   • The "Loop Over Items" node is pre-configured to handle batches. You can adjust the "Batch Size" if needed based on API rate limits or performance considerations.
5. Add Output Nodes (Optional):
   • After the "Code" node, you might want to add additional nodes to:
     • Write the processed data back to another Google Sheet.
     • Send notifications (e.g., Slack, Email) with analysis summaries.
     • Store data in a database.
6. Execute the Workflow:
   • Click the "Execute Workflow" button in the n8n editor to run the workflow manually.
   • Review the output in the n8n interface to ensure it's functioning as expected.