Extraction de références à partir des aperçus Google AI via DataForSEO

Name: Extraction de références à partir des aperçus Google AI via DataForSEO
Rating: 4.5 (10 reviews)
Author: DataForSEO

Intermédiaire

Ceci est unMarket Research, Multimodal AIworkflow d'automatisation du domainecontenant 9 nœuds.Utilise principalement des nœuds comme SplitOut, GoogleSheets, ScheduleTrigger, DataForSeoSerpApi. Extraire les sources de référence de l'Aperçu Google AI vers Google Sheets avec DataForSEO

Prérequis

•Informations d'identification Google Sheets API

Nœuds utilisés (9)

Catégorie

Étude de marché

IA Multimodale

Aperçu du workflow

Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement

Exécuter tous les 7 jours

Diviser (éléments)

Diviser (références)

Obtenir les données SERP de l'aperçu IA Google

Enregistrer les références dans votre feuille Google

React Flow

Exporter le workflow

Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow

{
  "id": "nBY4tiJSO0zKOUT4",
  "meta": {
    "instanceId": "4a76003a62faba42ea6eec7846a579c09ab33f6cef8e27dd3411ceec56e4d925",
    "templateCredsSetupCompleted": true
  },
  "name": "Pull references from Google's AI Overview with DataForSEO",
  "tags": [],
  "nodes": [
    {
      "id": "65a02469-2bf3-47f4-8c9c-593ca436ccc0",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -100,
        -100
      ],
      "parameters": {
        "color": 7,
        "height": 80,
        "content": "The flow will run every 7 days. Adjust the schedule if needed."
      },
      "typeVersion": 1
    },
    {
      "id": "68389fbb-5a4b-4ac7-bf3d-e6a3f91b8d88",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        -120
      ],
      "parameters": {
        "color": 7,
        "height": 100,
        "content": "Specify the necessary **Keyword**, **Location**, and **Language** you want to get data for."
      },
      "typeVersion": 1
    },
    {
      "id": "01aa19ef-4fc3-4d6d-997e-ee7a62ec3f55",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        -120
      ],
      "parameters": {
        "color": 7,
        "height": 100,
        "content": "Select the necessary Google Sheet that contains the **Source**, **Domain**, **URL**, **Title**, and **Text** columns."
      },
      "typeVersion": 1
    },
    {
      "id": "2e0fb6c2-eb8e-41a3-963a-f2c638a6c282",
      "name": "Exécuter tous les 7 jours",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "daysInterval": 7
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "e1491bb5-d8d2-4000-8100-b2b9cc8114ee",
      "name": "Diviser (éléments)",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        440,
        0
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "tasks[0].result[0].items"
      },
      "typeVersion": 1
    },
    {
      "id": "4655bb43-6a14-4a38-9f54-2a9bd50dd0ce",
      "name": "Diviser (références)",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        660,
        0
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "references"
      },
      "typeVersion": 1
    },
    {
      "id": "25116900-69eb-4efa-b15c-490809b84118",
      "name": "Note adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -460,
        -160
      ],
      "parameters": {
        "width": 340,
        "height": 340,
        "content": "This n8n template automatically collects all source references from Google’s AI Overview for any keyword you choose using DataForSEO and Google Sheets. \n\nWhat it does:\n\n* Uses DataForSEO API to fetch AI Overview results.\n* Extracts the source title, URL, and domain.\n* Stores the data in Google Sheets.\n\nYou can use this data to track your website’s presence in AI-generated snippets.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "d552d5b3-9297-48c6-ae9b-0bf19cac25c1",
      "name": "Obtenir les données SERP de l'aperçu IA Google",
      "type": "n8n-nodes-dataforseo.dataForSeoSerpApi",
      "position": [
        220,
        0
      ],
      "parameters": {
        "keyword": "why sky is blue",
        "operation": "get-live-google-organic-serp-advanced",
        "language_name": "english",
        "location_name": "united states",
        "max_crawl_pages": {},
        "browser_screen_width": {},
        "browser_screen_height": {},
        "load_async_ai_overview": true,
        "people_also_ask_click_depth": {},
        "browser_screen_resolution_ratio": {}
      },
      "credentials": {
        "dataForSeoApi": {
          "id": "aIZVcfarv3t96Jhx",
          "name": "DataForSEO account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "4280384e-1ccb-4afd-807e-31cf05a36b3b",
      "name": "Enregistrer les références dans votre feuille Google",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        880,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "URL": "={{ $json.url }}",
            "Text": "={{ $json.text }}",
            "Title": "={{ $json.title }}",
            "Domain": "={{ $json.domain }}",
            "Source": "={{ $json.source }}"
          },
          "schema": [
            {
              "id": "Source",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Source",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Domain",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Domain",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Text",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Text",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XCjkjyVxrtpTUQenHeR3B07xfEZ489mhuVidjhGOO7I/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1XCjkjyVxrtpTUQenHeR3B07xfEZ489mhuVidjhGOO7I",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XCjkjyVxrtpTUQenHeR3B07xfEZ489mhuVidjhGOO7I/edit?usp=drivesdk",
          "cachedResultName": "Scraping references"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "vEZOgsi2aDspPSBz",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "c7c14e05-61cb-48b0-9091-b25406dc2b91",
  "connections": {
    "2e0fb6c2-eb8e-41a3-963a-f2c638a6c282": {
      "main": [
        [
          {
            "node": "d552d5b3-9297-48c6-ae9b-0bf19cac25c1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e1491bb5-d8d2-4000-8100-b2b9cc8114ee": {
      "main": [
        [
          {
            "node": "4655bb43-6a14-4a38-9f54-2a9bd50dd0ce",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4655bb43-6a14-4a38-9f54-2a9bd50dd0ce": {
      "main": [
        [
          {
            "node": "4280384e-1ccb-4afd-807e-31cf05a36b3b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d552d5b3-9297-48c6-ae9b-0bf19cac25c1": {
      "main": [
        [
          {
            "node": "e1491bb5-d8d2-4000-8100-b2b9cc8114ee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Intermédiaire - Étude de marché, IA Multimodale

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.