Step 2: Connect SerpAPI and Google Sheets

This workflow queries SerpAPI and appends results to Google Sheets. Connect both credentials before running.

1. Open SerpAPI Lookup and select the SerpAPI credential.
2. Credential Required: Connect your serpApi credentials.
3. Open Append to Sheet and select the Google Sheets credential.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 3: Set Up Keyword Processing

Next, format user keywords and build the page queue for SerpAPI queries.

1. Open Keyword Formatter and ensure the keywords value expression is set to {{ (() => { const keywords = $json["Keywords (comma separated)"] .split(',') .map(k => k.trim()) .filter(Boolean); return '("' + keywords.join('") ("') + '")'; })() }}.
2. Open Generate Page Queue and confirm the JavaScript Code uses the form values and computed keywords (as provided in the node).
3. Verify Generate Page Queue references Form Submit Trigger and Keyword Formatter for Pages to fetch, Keywords (comma separated), and submittedAt.

Step 4: Configure Search, Routing, and Result Parsing

This section runs SerpAPI queries, checks result count, and expands each organic result into individual items.

1. In Batch Iterator, keep default settings to process each page item from Generate Page Queue.
2. In SerpAPI Lookup, set q to =site:pl.linkedin.com/in/ {{$json.keywordsGrouped}} and Location to Warsaw,Masovian Voivodeship,Poland.
3. In SerpAPI Lookup, ensure Additional Fields → start is ={{$json.start}} so pagination works.
4. In Evaluate Result Count, keep the two rules: {{ parseInt($json.search_information.total_results) }} equals 0 for empty lists and {{ $json.search_information.total_results }} greater than 0 for non-empty lists.
5. In Expand Search Results, set Field To Split Out to organic_results.
6. In Extract Full Name, keep the JavaScript that splits the title field and stores it as fullName.

Step 5: Configure Output and Form Responses

Send results to Google Sheets and respond to the form submitter based on whether results were found.

1. In Append to Sheet, set Operation to append.
2. Set Document to the spreadsheet ID [YOUR_ID] and Sheet to gid=0 (Sheet1).
3. Map columns in Append to Sheet: Date → {{ $('Form Submit Trigger').item.json.submittedAt }}, Profile → {{ $json.link }}, Keywords → {{ $('Form Submit Trigger').item.json['Keywords (comma separated)'] }}, Full name → {{ $json.fullName }}.
4. In No Results Reply, confirm Completion Title is Response and Completion Message is No profiles found based on params..
5. In Return Form Response, set Completion Title to Response and Completion Message to Check linked file.

Step 6: Test and Activate Your Workflow

Run a manual test to verify the form flow, SerpAPI results, and Google Sheets output before enabling the workflow.

1. Click Execute Workflow and submit the form in Form Submit Trigger with sample keywords and pages.
2. Confirm that SerpAPI Lookup returns results and Append to Sheet writes rows to your spreadsheet.
3. If no results are found, verify that No Results Reply sends the completion message.
4. When everything looks correct, switch the workflow to Active for production use.