Bing search rankings to Google Sheets with n8n

Method

1. Get an Apify token

   Sign in to Apify and copy a personal API token from Console: Settings, API and integrations. The workflow keeps it in an n8n credential, never in the file.

2. Import the workflow

   In n8n choose Workflows, Import from file, or paste the JSON onto an empty canvas.

   • Run by hand
   • Every day
   • Run Apify Actor
   • Keep main fields
   • Send to Google Sheets

   n8n workflowbing-search-rankings-to-sheets.n8n.json

   Copy Download Actor on Apify

   Show the file (176 lines)

   {
     "name": "Bing search rankings to Google Sheets",
     "nodes": [
       {
         "id": "66227772-4dfc-4440-af31-bc097f2085ef",
         "name": "Run by hand",
         "type": "n8n-nodes-base.manualTrigger",
         "typeVersion": 1,
         "position": [
           0,
           0
         ],
         "parameters": {}
       },
       {
         "id": "41978b22-7d9e-4752-a3a5-55ab201773b7",
         "name": "Every day",
         "type": "n8n-nodes-base.scheduleTrigger",
         "typeVersion": 1.2,
         "position": [
           0,
           200
         ],
         "parameters": {
           "rule": {
             "interval": [
               {
                 "triggerAtHour": 8
               }
             ]
           }
         },
         "notes": "Activate the workflow to run on this schedule."
       },
       {
         "id": "9f027696-3cc4-4fb7-ac49-7752cdebd6eb",
         "name": "Run Apify Actor",
         "type": "n8n-nodes-base.httpRequest",
         "typeVersion": 4.2,
         "position": [
           260,
           100
         ],
         "parameters": {
           "method": "POST",
           "url": "https://api.apify.com/v2/actors/nimbryxo-studio~bing-organic-search-results-scraper/run-sync-get-dataset-items",
           "authentication": "genericCredentialType",
           "genericAuthType": "httpHeaderAuth",
           "sendBody": true,
           "specifyBody": "json",
           "jsonBody": "{\n  \"mode\": \"webSearch\",\n  \"queries\": [\n    \"best coffee shops seattle\"\n  ],\n  \"maxResultsPerQuery\": 3,\n  \"market\": \"en-US\",\n  \"safeSearch\": \"moderate\",\n  \"dateRange\": \"anyTime\",\n  \"imageSize\": \"any\",\n  \"videoDuration\": \"any\",\n  \"newsSort\": \"relevance\"\n}",
           "options": {
             "timeout": 310000
           }
         },
         "notes": "Actor: nimbryxo-studio/bing-organic-search-results-scraper. Select a Header Auth credential: name Authorization, value Bearer + your Apify token. Edit the JSON body to change the input.",
         "notesInFlow": false
       },
       {
         "id": "434c28ba-797f-4222-a4f0-d02fde63af73",
         "name": "Keep main fields",
         "type": "n8n-nodes-base.code",
         "typeVersion": 2,
         "position": [
           500,
           100
         ],
         "parameters": {
           "jsCode": "// Keeps the Actor's main fields as flat, spreadsheet-safe values.\nconst columns = [\"position\",\"title\",\"views\",\"url\",\"displayUrl\",\"imageUrl\",\"thumbnailUrl\",\"searchUrl\",\"videoId\",\"query\",\"resultType\",\"page\",\"description\",\"snippet\",\"siteName\"];\n// A dotted name such as author.name reads the nested value.\nconst read = (obj, key) => (key in obj ? obj[key] : key.split('.').reduce((v, part) => (v && typeof v === 'object' ? v[part] : undefined), obj));\nreturn $input.all().map((item) => {\n  const row = {};\n  const present = columns.filter((key) => read(item.json, key) !== undefined);\n  // A record shaped differently from the published schema keeps its own fields rather than arriving blank.\n  for (const key of present.length >= 2 ? present : Object.keys(item.json)) {\n    const value = read(item.json, key);\n    row[key] = value === null || value === undefined ? '' : typeof value === 'object' ? JSON.stringify(value) : value;\n  }\n  // A tracker appends one row per record per run: the observation time tells the runs apart.\n  row.checkedAt = new Date().toISOString();\n  return { json: row };\n});"
         }
       },
       {
         "id": "8b02673a-a8fc-4cb6-a560-a94b39a552cf",
         "name": "Send to Google Sheets",
         "type": "n8n-nodes-base.googleSheets",
         "typeVersion": 4.5,
         "position": [
           740,
           100
         ],
         "parameters": {
           "operation": "append",
           "documentId": {
             "__rl": true,
             "value": "",
             "mode": "list",
             "cachedResultName": ""
           },
           "sheetName": {
             "__rl": true,
             "value": "Sheet1",
             "mode": "name"
           },
           "columns": {
             "mappingMode": "autoMapInputData",
             "value": {},
             "matchingColumns": [],
             "schema": []
           },
           "options": {}
         },
         "notes": "Pick your spreadsheet. The tab is set to Sheet1; change it if yours has another name. Add these headers in row 1: position, title, views, url, displayUrl, imageUrl, thumbnailUrl, searchUrl, videoId, query, resultType, page, description, snippet, siteName, checkedAt."
       },
       {
         "id": "5546475a-caa6-4e46-a29f-167341ac9a9b",
         "name": "Setup",
         "type": "n8n-nodes-base.stickyNote",
         "typeVersion": 1,
         "position": [
           0,
           -370
         ],
         "parameters": {
           "content": "## Bing Organic Search Results Scraper\n\nSource: [nimbryxo-studio/bing-organic-search-results-scraper](https://apify.com/nimbryxo-studio/bing-organic-search-results-scraper) on Apify.\n\n1. In **Run Apify Actor**, create a Header Auth credential: name `Authorization`, value `Bearer YOUR_APIFY_TOKEN` with your token.\n2. Open **Send to Google Sheets** and connect your Google Sheets account.\n3. Edit the JSON body of **Run Apify Actor** to change the input.\n\nGenerated by recipeforagents.com. Validated, not executed: runs are billed to your Apify account.",
           "height": 340,
           "width": 460,
           "color": 6
         }
       }
     ],
     "connections": {
       "Run by hand": {
         "main": [
           [
             {
               "node": "Run Apify Actor",
               "type": "main",
               "index": 0
             }
           ]
         ]
       },
       "Every day": {
         "main": [
           [
             {
               "node": "Run Apify Actor",
               "type": "main",
               "index": 0
             }
           ]
         ]
       },
       "Run Apify Actor": {
         "main": [
           [
             {
               "node": "Keep main fields",
               "type": "main",
               "index": 0
             }
           ]
         ]
       },
       "Keep main fields": {
         "main": [
           [
             {
               "node": "Send to Google Sheets",
               "type": "main",
               "index": 0
             }
           ]
         ]
       }
     },
     "pinData": {},
     "active": false,
     "settings": {
       "executionOrder": "v1"
     },
     "meta": {
       "templateCredsSetupCompleted": false
     },
     "tags": []
   }

   Validated, not executed: 11 of 11 checks pass

   • It has a nodes array and a connections object
   • Every node has a name, type, typeVersion, position and parameters
   • Node names are unique
   • Every node type is a known n8n core node (or the Apify node)
   • Every node uses a typeVersion that n8n ships
   • Every connection points at an existing node
   • At least one trigger starts the workflow
   • Every working node is reachable from a trigger
   • Apify calls use POST and a credential for the token
   • Actor input matches the Actor's published input schema
   • No token or credential value is embedded

3. Add the Apify credential

   Open Run Apify Actor. Under Credential, create a Header Auth credential with the name Authorization and the value Bearer, a space and your token.

4. Set the input

   The request body holds the Actor input. It starts from the Actor's Store prefill; change mode, queries, maxResultsPerQuery to match your search.

   {
     "mode": "webSearch",
     "queries": [
       "best coffee shops seattle"
     ],
     "maxResultsPerQuery": 3,
     "market": "en-US",
     "safeSearch": "moderate",
     "dateRange": "anyTime",
     "imageSize": "any",
     "videoDuration": "any",
     "newsSort": "relevance"
   }

   Every input field is documented on the Bing Organic Search Results Scraper page.

5. Connect Google Sheets

   Open Send to Google Sheets, select your Google credential, then pick the spreadsheet from the list. The tab is set to Sheet1; change it if yours has another name. Put these headers in row 1 so the columns map automatically: position, title, views, url, displayUrl, imageUrl, thumbnailUrl, searchUrl, videoId, query, resultType, page, description, snippet, siteName, checkedAt.

6. Every run adds a dated row

   This is a tracker: each run appends one row per record with a checkedAt time, so you can chart how values change from day to day. Filter or pivot on checkedAt to compare runs.

7. Run once, then turn it on

   Click Execute workflow and check the first records in Google Sheets. When they look right, activate the workflow so the daily trigger runs it at 08:00 in your instance's timezone.

Where it breaks

• Rankings are a logged-out view from the chosen market and can differ from a signed-in browser.
• Image and video result fields stay blank for normal web results.
• Each keyword adds rows on every run, so a long keyword list grows the sheet quickly.
• The workflow uses Apify's synchronous endpoint, which waits up to 300 seconds. Bigger runs answer HTTP 408: lower the limit or switch to an asynchronous run.
• Each run is billed to your Apify account at the Store price ($0.99 per 1,000 results (pay per event)).

Bigger runs: the long-run workflow starts the run, waits for it and reads the dataset, so it never hits the 300-second limit.

If the workflow fails

Why does the workflow or script stop with HTTP 408?

The synchronous endpoint waits at most 300 seconds. After that it answers 408 while the run keeps going in Apify. Lower the result limit, or start the run asynchronously, wait for it to finish and then read its dataset.

Source: Apify API: run Actor synchronously and get dataset items

What do 400, 401, 402 and 403 from the Apify API mean?

Read error.type in the response body. 400 is invalid Actor input. 401 (user-or-token-not-found) means a token reached Apify but it is wrong or revoked. 402 with x402-payment-required means no token reached Apify at all: the n8n credential or the Authorization: Bearer header is missing, and Apify is offering its pay-per-run x402 route for agents instead; any other 402 is an exhausted usage limit on the account that pays for the run. 403 is a token without permission for that Actor or storage.

Source: Apify API: authentication; Apify documentation: agentic payments with x402; Apify API: run Actor synchronously and get dataset items

n8n says Install this node to use it after import. Why?

The workflow names a node or node version your instance does not have, usually a community node. The workflows here use only built-in nodes at versions n8n has shipped since 1.80, so they import on n8n Cloud and older self-hosted instances without community nodes.

Source: n8n issue: unrecognized node type after import

Why does the HTTP Request node time out before Apify answers?

Set the node's Timeout option to at least 300000 ms so n8n waits as long as Apify's synchronous endpoint. The workflows here already set 310000. A failure at exactly 30 seconds points to a proxy in front of n8n.

Source: n8n HTTP Request node documentation

Every fix in one place

Same data in an agent

Want Claude, Cursor or ChatGPT to call the Actor directly instead of on a schedule? The Bing Organic Search Results Scraper page has MCP configs for eight clients and a SKILL.md. The Bing MCP server bundles every Bing Actor in one URL.