Step 2: Connect Google Custom Search

The workflow queries Google Custom Search to find LinkedIn profile results.

1. Add the Google Search Request node and set URL to https://www.googleapis.com/customsearch/v1.
2. Enable Send Query and set Authentication to genericCredentialType with Generic Auth Type set to httpQueryAuth.
3. Set query parameter q to {{ $node['Initialize Search Inputs'].json.Position }} {{ $node['Initialize Search Inputs'].json.Industry }} site:linkedin.com/in.
4. Set query parameter start to {{ $runIndex == 0 ? $('Initialize Search Inputs').item.json.start_index : $('Normalize Search Output').item.json.nextPageStartIndex}}.
5. Set query parameter cx to your Custom Search Engine ID (replace [YOUR_ID]).
6. Credential Required: Connect your httpQueryAuth credentials in Google Search Request.

Step 3: Set Up Search Inputs and Pagination Controls

These nodes build the search parameters and control how many pages are fetched.

1. In ⚙️ Set Keyword Phrase, set keywords_string to Store Manager Retail London (or your own phrase).
2. In Define Search Options, set Position to {{ $json.keywords_string }} and Maxresults to 30.
3. In Initialize Search Inputs, set start_index to 1 and map fields like Position to {{ $json.Position }} and Region to {{ $json.Location }}.
4. Connect ⚙️ Set Keyword Phrase → Iterate Records → Define Search Options → Initialize Search Inputs to match the execution flow.

Step 4: Extract and Normalize Search Results

This section parses the Google response and standardizes fields before storing them.

1. In Extract Profile Entries, keep the JavaScript code as provided to loop through response items and output fields like title, link, and nextPageStartIndex.
2. In Normalize Search Output, map Title to {{ $json.title }}, URL to {{ $json.link }}, and nextPageStartIndex to {{ $json.nextPageStartIndex }}.
3. Ensure the flow continues Google Search Request → Extract Profile Entries → Normalize Search Output.

Step 5: Configure Airtable Upsert and Pagination Loop

Results are stored in Airtable and the workflow loops until the max result count is reached.

1. In Upsert into Airtable, set Operation to upsert.
2. Select your Airtable Base and Table (replace [YOUR_ID] values).
3. Map fields: Title → {{ $json.Title }}, Search → {{ $json.Search }}, Snippet → {{ $json.Snippet }}, Description → {{ $json.Description }}, linkedin_url → {{ $json.URL }}.
4. Credential Required: Connect your airtableTokenApi credentials in Upsert into Airtable.
5. Configure Pagination Decision with the rule {{ parseInt($('Normalize Search Output').item.json.nextPageStartIndex) }} lt {{ $node['Define Search Options'].json.Maxresults}} to continue searching.
6. Connect Normalize Search Output → Upsert into Airtable → Pagination Decision → Throttle Delay → Google Search Request for the loop.
7. In Throttle Delay, set Amount to 2 to reduce API rate limits.

Step 6: Test and Activate Your Workflow

Run a manual test to verify results are retrieved and upserted, then activate for ongoing use.

1. Click Execute Workflow on Manual Execution Start to run a test search.
2. Confirm Google Search Request returns results and Extract Profile Entries outputs multiple items.
3. Verify new or updated records appear in Airtable from Upsert into Airtable.
4. Activate the workflow using the Active toggle once tests are successful.