January 22, 2026

Bright Data to Google Sheets, hiring leads ready

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Copying LinkedIn job posts into a spreadsheet sounds simple. Then you do it for 30 minutes and realize half the fields are missing, descriptions are full of HTML, and you still can’t sort by anything useful.

Recruiters chasing fresh roles feel this pain fast. So do agency owners hunting “hiring signals” for outbound, and solo consultants building lists. This Bright Data Sheets automation takes raw job posts and turns them into clean, ready-to-use rows.

You’ll see how the workflow pulls jobs from LinkedIn via Bright Data, waits for the dataset snapshot, cleans the messy parts, and appends everything to Google Sheets so you can start outreach (or applying) immediately.

How This Automation Works

Here’s the complete workflow you’ll be setting up:

n8n Workflow Template: Bright Data to Google Sheets, hiring leads ready

Click to explore

flowchart LR

    subgraph sg0["On form submission - Discover Jobs Flow"]
        direction LR
        n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Snapshot Progress"]
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/form.svg' width='40' height='40' /></div><br/>On form submission - Discove.."]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>HTTP Request- Post API call .."]
        n3@{ icon: "mdi:cog", form: "rounded", label: "Wait - Polling Bright Data", pos: "b", h: 48 }
        n4@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If - Checking status of Snap..", pos: "b", h: 48 }
        n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>HTTP Request - Getting data .."]
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Code - Cleaning Up"]
        n7@{ icon: "mdi:database", form: "rounded", label: "Google Sheets - Adding All J..", pos: "b", h: 48 }
        n8@{ icon: "mdi:swap-vertical", form: "rounded", label: "Edit Fields", pos: "b", h: 48 }
        n8 --> n2
        n0 --> n4
        n6 --> n7
        n3 --> n0
        n1 --> n8
        n2 --> n3
        n5 --> n6
        n4 --> n3
        n4 --> n5
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n1 trigger
    class n4 decision
    class n7 database
    class n0,n2,n5 api
    class n6 code
    classDef customIcon fill:none,stroke:none
    class n0,n1,n2,n5,n6 customIcon

Why This Matters: Turning Hiring Posts Into Usable Leads

LinkedIn job posts are packed with signal, but they’re not packaged for action. You can’t easily filter by role, location, or “posted recently” without opening tabs, scrolling, and pasting chunks into a sheet that never stays clean. And the minute you try to scale it (multiple searches, multiple geos, or weekly refreshes), it turns into a recurring admin job. Worse, manual copy-paste introduces subtle errors: broken apply links, mismatched company names, and descriptions that come in as a wall of HTML you’ll never read again.

It adds up fast. Here’s where it breaks down in real life.

You waste about 5 minutes per job post just collecting the basics, and that’s before you clean anything.
Nested fields (like recruiter info or salary ranges) show up inconsistently, which makes your sheet impossible to filter.
Freshness is hard to maintain, so outreach goes out days late and feels generic.
One missed paste or formatting change can quietly ruin a whole campaign tab.

What You’ll Build: LinkedIn Job Posts Logged as Clean Sheet Rows

This workflow starts with a simple form in n8n where you enter what you want: location, keyword (like “CMO” or “Backend Developer”), and a country code. n8n sends that request to Bright Data’s Dataset API, which triggers a snapshot of matching LinkedIn job posts. Because Bright Data needs time to prepare the dataset, the automation waits and polls until the snapshot is ready. Once the data is available, it retrieves the full list, cleans and flattens the messy fields (including stripping HTML from descriptions), and formats everything into a consistent structure. Finally, it appends each job post as a new row in Google Sheets, so your list is immediately searchable, sortable, and ready for outreach or applications.

The workflow begins when you submit the intake form. Bright Data runs the snapshot in the background while n8n waits and checks progress. When it’s complete, n8n pulls the dataset, cleans it, and pushes neat rows into your Google Sheet tab.

What You’re Building

What Gets Automated

What You’ll Achieve

A form submission in n8n triggers a Bright Data dataset snapshot for LinkedIn job posts.
Polling checks snapshot status automatically until results are ready.
A cleaning step flattens nested fields like job poster and salary data.
Job descriptions are stripped of HTML and formatted for spreadsheet use.

What used to take about 2 hours of manual research becomes a repeatable 5-minute intake.
Your Google Sheet stays consistent across campaigns, even when LinkedIn fields vary.
Outreach lists become easier to prioritize by title, location, and recency.
You can reuse the same template per client, niche, or territory without rebuilding.
Job seekers get faster applications because links and recruiter details are already organized.

Expected Results

Say you pull 25 new LinkedIn job posts each morning to spot hiring signals for outbound. Manually, even 5 minutes per post is about 2 hours of tab-switching, copying, and cleanup. With this workflow, you spend about 5 minutes filling the form once, then wait a couple minutes for Bright Data to finish the snapshot while you do other work. Your sheet updates with 25 clean rows, ready to filter and message from.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Bright Data for LinkedIn Dataset API snapshots
Google Sheets to store and filter job rows
Bright Data API Key (get it from your Bright Data dashboard)

Skill level: Intermediate. You’ll connect accounts, paste an API key into headers, and adjust a couple of fields safely.

Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).

Step by Step

You submit a short intake form. The Form Trigger collects your keyword, location, and country code so you can run targeted searches without editing nodes every time.

The workflow maps your inputs into the Bright Data request. A Set step shapes the values into the exact request body Bright Data expects (including a time filter like “Past 24 hours” or “Last 7 days” for fresher results).

Bright Data runs a snapshot, and n8n waits and polls. First, an HTTP request triggers the dataset snapshot. Then a Wait step pauses briefly, followed by another HTTP request that checks snapshot progress. An If gate decides: loop again if it’s still processing, or continue once it’s complete.

Results are retrieved, cleaned, and appended to Google Sheets. A Code step flattens nested objects (job_poster, base_salary), strips HTML from job descriptions, and normalizes fields so every row matches your columns. The final Google Sheets node appends each job as a new row in your destination sheet.

You can easily modify the search filters to target different roles, countries, or recency windows based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Form Trigger

Set up the intake form that initiates the workflow and passes user inputs into the data collection pipeline.

Add the Form Intake Trigger node as your trigger.
Set Form Title to Linkedin High Intent Prospects And Job Post Hunt.
Define form fields for Job Location, Keyword, and Country (2 letters), matching the labels exactly.
Set Form Description to the provided multi-line guidance text so users understand optional filters.

Tip: Keep field labels identical to the JSON (Job Location, Keyword, Country (2 letters)) so later expressions resolve correctly.

Step 2: Connect Bright Data Snapshot Requests

Map the form inputs and send them to Bright Data, then wait and poll for snapshot completion.

In Map Input Fields, keep the node as the passthrough point (it can be used for future custom mapping).
Configure Trigger Bright Data Snapshot with URL https://api.brightdata.com/datasets/v3/trigger and Method POST.
Set JSON Body to the provided array and ensure the expressions resolve: {{ $json['Job Location'] }}, {{ $json.Keyword }}, {{ $json['Country (2 letters)'] }}.
In Trigger Bright Data Snapshot, update query parameters such as dataset_id, endpoint, and notify with your Bright Data values.
Set the Authorization header to Bearer [CONFIGURE_YOUR_API_KEY] in Trigger Bright Data Snapshot, Check Snapshot Progress, and Retrieve Snapshot Data.
Set Pause for Snapshot to wait in Minutes so the snapshot has time to generate.
Configure Check Snapshot Progress with URL =https://api.brightdata.com/datasets/v3/progress/{{ $('Trigger Bright Data Snapshot').item.json.snapshot_id }}.
In Snapshot Status Gate, set the condition to check {{ $json.status }} equals running. This loops back to Pause for Snapshot when still processing, or continues to Retrieve Snapshot Data when complete.

⚠️ Common Pitfall: If the Bright Data API key is missing or invalid in the Authorization header, the snapshot trigger and polling will fail silently.

Step 3: Set Up Data Processing

Clean and normalize the snapshot records before storing them.

Configure Retrieve Snapshot Data with URL =https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }} and add the format query parameter as json.
In Cleanse Job Records, keep the JavaScript that flattens job_poster and base_salary, and strips HTML from job_description_formatted.
Verify the node connection: Retrieve Snapshot Data → Cleanse Job Records → Append to Job Sheet.

Step 4: Configure the Output Destination

Append the cleansed job records into Google Sheets.

Open Append to Job Sheet and set Operation to append.
Choose your Google Sheet using Document ID [YOUR_ID] and select Sheet Name input (gid=0).
Ensure column mapping includes country_code set to {{ $json.country_code }} and allow extra fields with Handling Extra Data set to insertInNewColumn.
Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 5: Test and Activate Your Workflow

Run a full test to verify the form, Bright Data loop, and Google Sheets append behavior.

Click Execute Workflow and submit a sample form entry via Form Intake Trigger.
Confirm that Trigger Bright Data Snapshot returns a snapshot_id and that Check Snapshot Progress eventually transitions through Snapshot Status Gate to Retrieve Snapshot Data.
Verify new rows appear in your Google Sheet after Append to Job Sheet runs.
Once the test is successful, switch the workflow to Active to use it in production.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

Bright Data credentials can expire or lack dataset permissions. If calls fail, check your Bright Data dashboard for API key status and that “Dataset API” access is enabled.
If you’re using Wait nodes or external rendering, processing times vary. Bright Data snapshots often take 1–3 minutes, so bump the wait duration if your “check status” step hits before the snapshot is ready.
Google Sheets OAuth can silently lose access after password changes or security updates. If rows stop appending, reconnect Google Sheets in n8n credentials and confirm the spreadsheet ID and tab name match.

Quick Answers

What’s the setup time for this Bright Data Sheets automation?

About 30 minutes if your Bright Data and Google Sheets access is ready.

Is coding required for this job lead logging automation?

No. You’ll connect credentials and adjust a few fields in the form. The included Code step is already written for you.

Is n8n free to use for this Bright Data Sheets workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Bright Data dataset usage costs based on how often you run snapshots.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I modify this Bright Data Sheets workflow for different use cases?

Yes, and you probably should. You can change the form inputs (keyword, location, country code) without touching the logic, and you can tweak the HTTP Request body to add filters like job_type, remote, company, or a tighter time_range like “Past 24 hours”. If you want different columns in Google Sheets, adjust the “Cleanse Job Records” code to map and flatten extra fields. Many teams also add a simple scoring rule in the Code step so the best-fit roles rise to the top.

Why is my Bright Data connection failing in this workflow?

Usually it’s an API key issue. Confirm the header is exactly Authorization: Bearer YOUR_BRIGHTDATA_API_KEY and that the key has Dataset API access enabled. If you’re polling too aggressively, you can also hit rate limits, so increase the Wait time and try again.

What volume can this Bright Data Sheets workflow process?

Plenty for normal lead gen runs, like a few dozen to a few hundred job posts per pull.

Is this Bright Data Sheets automation better than using Zapier or Make?

Often, yes. Bright Data snapshots require waiting, polling, and conditional looping, and n8n handles that kind of control flow cleanly without turning your automation into a spaghetti mess. Self-hosting is also a big deal if you want unlimited runs without paying per task. Zapier or Make can still work if you keep it basic, but you may hit limits once you add retries, formatting, and “wait until ready” logic. If you want a second opinion on the simplest setup for your exact use case, Talk to an automation expert.

Once this is in place, your “lead list” stops being a manual chore and becomes a repeatable system you can run whenever you need fresh hiring signals. Set it up, run it, move on.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"name": "Automated Job Data Capture Flow",
"versionId": null,
"meta": {
"instanceId": "8eef2e0ca43ba0306305d17a63ca7502d5dc950da2c1e7083b5ffd33e56490a6"
},
"nodes": [
{
"id": "flowpast-topbar-3580",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
120,
110
],
"parameters": {
"color": 7,
"width": 1260,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "1d7a7bb0-1531-4516-9373-5e85a090b143",
"name": "Form Intake Trigger",
"type": "n8n-nodes-base.formTrigger",
"position": [
120,
210
],
"webhookId": "8d0269c7-d1fc-45a1-a411-19634a1e0b82",
"parameters": {
"options": [],
"formTitle": "Linkedin High Intent Prospects And Job Post Hunt",
"formFields": {
"values": [
{
"fieldLabel": "Job Location",
"placeholder": "example: new york",
"requiredField": true
},
{
"fieldLabel": "Keyword",
"placeholder": "example: CMO, AI architect",
"requiredField": true
},
{
"fieldLabel": "Country (2 letters)",
"placeholder": "example: US,UK,IL",
"requiredField": true
}
]
},
"formDescription": "This form lets you customize your job search / prospecting by choosing:\n\nLocation (city or region)\n\nJob title or keywords\n\nCountry code\n\nFilters like posting date, job type, experience level, and remote options\n\nYou can also optionally narrow results by company name.\n\n\ud83e\udde0 Tip: Leave fields blank if you want broader results."
},
"typeVersion": 2.2
},
{
"id": "cccb03cb-0432-43ff-9c3a-233de510a775",
"name": "Map Input Fields",
"type": "n8n-nodes-base.set",
"position": [
350,
250
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "12067869-0249-4cd2-b9e2-8e4055a0d917",
"name": "",
"type": "string",
"value": ""
}
]
}
},
"typeVersion": 3.4
},
{
"id": "aea569df-eedd-441f-aba5-c3c26a50fa87",
"name": "Trigger Bright Data Snapshot",
"type": "n8n-nodes-base.httpRequest",
"position": [
610,
215
],
"parameters": {
"url": "https://api.brightdata.com/datasets/v3/trigger",
"method": "POST",
"options": [],
"jsonBody": "=[\n  {\n    \"location\": \"{{ $json['Job Location'] }}\",\n    \"keyword\": \"{{ $json.Keyword }}\",\n    \"country\": \"{{ $json['Country (2 letters)'] }}\",\n    \"time_range\": \"Past 24 hours\",\n    \"job_type\": \"Part-time\",\n    \"experience_level\": \"\",\n    \"remote\": \"\",\n    \"company\": \"\"\n  }\n] ",
"sendBody": true,
"sendQuery": true,
"sendHeaders": true,
"specifyBody": "json",
"queryParameters": {
"parameters": [
{
"name": "dataset_id",
"value": "[YOUR_ID]"
},
{
"name": "endpoint",
"value": "https://[YOUR_ID]"
},
{
"name": "notify",
"value": "https://[YOUR_ID]"
},
{
"name": "format",
"value": "json"
},
{
"name": "uncompressed_webhook",
"value": "true"
},
{
"name": "type",
"value": "discover_new"
},
{
"name": "discover_by",
"value": "=keyword"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer [CONFIGURE_YOUR_API_KEY]"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "8837f055-7243-44b6-87a2-e679d75839d0",
"name": "Pause for Snapshot",
"type": "n8n-nodes-base.wait",
"position": [
820,
260
],
"webhookId": "8005a2b3-2195-479e-badb-d90e4240e699",
"parameters": {
"unit": "minutes"
},
"executeOnce": false,
"typeVersion": 1.1
},
{
"id": "33cb416e-a7ff-4b55-9701-9b9e95d76f12",
"name": "Check Snapshot Progress",
"type": "n8n-nodes-base.httpRequest",
"position": [
1040,
230
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/progress/{{ $('Trigger Bright Data Snapshot').item.json.snapshot_id }}",
"options": [],
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer [CONFIGURE_YOUR_API_KEY]"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "1f0ebefa-42a1-450c-b30a-64edabdaedaf",
"name": "Snapshot Status Gate",
"type": "n8n-nodes-base.if",
"position": [
1280,
250
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7932282b-71bb-4bbb-ab73-4978e554de7e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "running"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "e17b4da0-3f9c-45d5-acdf-ab634acfef97",
"name": "Retrieve Snapshot Data",
"type": "n8n-nodes-base.httpRequest",
"position": [
1030,
500
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }}",
"options": [],
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "format",
"value": "json"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer [CONFIGURE_YOUR_API_KEY]"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "b5bd6a55-f80d-46f9-a59a-beff28de9da7",
"name": "Cleanse Job Records",
"type": "n8n-nodes-base.code",
"position": [
800,
520
],
"parameters": {
"jsCode": "// Helper function to strip HTML tags\nfunction stripHtml(html) {\n  return html\n    .replace(/<[^>]+>/g, '')    // remove all HTML tags\n    .replace(/ /g, ' ')     // decode HTML entities\n    .replace(/&[a-z]+;/g, '')    // remove other HTML entities\n    .replace(/\\s+/g, ' ')        // normalize whitespace\n    .trim();\n}\n\nreturn items.map(item => {\n  const data = item.json;\n\n  // Flatten job_poster\n  if (data.job_poster) {\n    data.job_poster_name = data.job_poster.name || '';\n    data.job_poster_title = data.job_poster.title || '';\n    data.job_poster_url = data.job_poster.url || '';\n    delete data.job_poster;\n  }\n\n  // Flatten base_salary\n  if (data.base_salary) {\n    data.salary_min = data.base_salary.min_amount || '';\n    data.salary_max = data.base_salary.max_amount || '';\n    data.salary_currency = data.base_salary.currency || '';\n    data.salary_period = data.base_salary.payment_period || '';\n    delete data.base_salary;\n  }\n\n  // Clean up job description HTML\n  if (data.job_description_formatted) {\n    data.job_description_plain = stripHtml(data.job_description_formatted);\n  }\n\n  return { json: data };\n});\n"
},
"typeVersion": 2
},
{
"id": "70f4a4a0-b9ce-4b7a-b232-86014a7f8a3f",
"name": "Append to Job Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
570,
560
],
"parameters": {
"columns": {
"value": {
"country_code": "={{ $json.country_code }}"
},
"schema": [
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_posting_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_posting_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_description_plain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_description_plain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_poster_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_poster_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_poster_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_poster_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_poster_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_poster_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "salary_min",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "salary_min",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "salary_max",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "salary_max",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "salary_currency",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "salary_currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "salary_period",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "salary_period",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "application_availability",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "application_availability",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_posted_date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_posted_date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_logo",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_logo",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country_code",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "country_code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "timestamp",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_posted_time",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_posted_time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_num_applicants",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_num_applicants",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "discovery_input",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "discovery_input",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "apply_link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apply_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "title_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_description_formatted",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_description_formatted",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "input",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "input",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_seniority_level",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_seniority_level",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_function",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_function",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_employment_type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_employment_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_industries",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_industries",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_base_pay_range",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "job_base_pay_range",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"handlingExtraData": "insertInNewColumn"
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "input"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.3,
"alwaysOutputData": true
}
],
"pinData": [],
"connections": {
"Map Input Fields": {
"main": [
[
{
"node": "Trigger Bright Data Snapshot",
"type": "main",
"index": 0
}
]
]
},
"Check Snapshot Progress": {
"main": [
[
{
"node": "Snapshot Status Gate",
"type": "main",
"index": 0
}
]
]
},
"Cleanse Job Records": {
"main": [
[
{
"node": "Append to Job Sheet",
"type": "main",
"index": 0
}
]
]
},
"Pause for Snapshot": {
"main": [
[
{
"node": "Check Snapshot Progress",
"type": "main",
"index": 0
}
]
]
},
"Form Intake Trigger": {
"main": [
[
{
"node": "Map Input Fields",
"type": "main",
"index": 0
}
]
]
},
"Trigger Bright Data Snapshot": {
"main": [
[
{
"node": "Pause for Snapshot",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Snapshot Data": {
"main": [
[
{
"node": "Cleanse Job Records",
"type": "main",
"index": 0
}
]
]
},
"Snapshot Status Gate": {
"main": [
[
{
"node": "Pause for Snapshot",
"type": "main",
"index": 0
}
],
[
{
"node": "Retrieve Snapshot Data",
"type": "main",
"index": 0
}
]
]
}
}
}