Step 2: Connect Google Sheets and Set Source Inputs

Define the source spreadsheet and ensure all Google Sheets nodes can access it.

1. Open Assign Sheet Source and set google_sheet_url to your spreadsheet URL (replace xxxxxxxxxxxx with the actual link).
2. In Assign Sheet Source, set google_sheet_name to companies (or change to your sheet tab name).
3. Open Fetch Source Records and confirm Sheet Name uses {{ $json.google_sheet_name }} and Document ID uses {{ $json.google_sheet_url }}.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials in Fetch Source Records.
5. Open Generate Output Sheet and set Operation to create and Title to =company-urls-{{new Date().format('dd/mm-HH:mm')}}.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Generate Output Sheet.

Assign Sheet Source outputs to both Generate Output Sheet and Fetch Source Records in parallel, so both the output sheet and source records are prepared at the same time.

Step 3: Set Up the Payload and Branch Synchronization

The workflow merges the sheet creation and data fetch paths, then prepares a query list for Apify.

1. Ensure Synchronize Branches is connected to both Generate Output Sheet and Fetch Source Records.
2. Open Prepare Apify Payload and keep the JavaScript code that builds queries from Fetch Source Records:

let listOfCompanies = ''
for (const item of $('Fetch Source Records').all()) {
listOfCompanies += `\n${item.json.name}`
}

return {
json: {
queries : listOfCompanies
}
}

Step 4: Configure Apify Execution and Results Retrieval

Apify runs the LinkedIn company URL lookup and returns dataset results for storage.

1. Open Launch Apify Actor and confirm Actor Source is store with actor ID 9X6Pju8NeHNTvzRxF.
2. Set Custom Body to {{ $json }} in Launch Apify Actor to pass the queries.
3. Credential Required: Connect your apifyApi credentials in Launch Apify Actor.
4. Open Retrieve Apify Results and set Resource to Datasets and Dataset ID to {{ $json.defaultDatasetId }}.
5. Credential Required: Connect your apifyApi credentials in Retrieve Apify Results.

Step 5: Configure Output Writing to Google Sheets

Results are appended to the newly created output sheet in your Google Sheets file.

1. Open Append Results to Sheet and set Operation to append.
2. Set Sheet Name (by ID) to {{ $('Generate Output Sheet').first().json.sheetId }}.
3. Set Document ID to {{ $('Assign Sheet Source').first().json.google_sheet_url }}.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Results to Sheet.

Step 6: Test and Activate Your Workflow

Run a manual test to confirm the data flows from Google Sheets to Apify and back to the output sheet.

1. Click Execute Workflow on Manual Start Trigger to run the workflow.
2. Verify Generate Output Sheet creates a new tab with a name like company-urls-{{new Date().format('dd/mm-HH:mm')}}.
3. Check that Append Results to Sheet writes Apify results into the new output sheet.
4. Once confirmed, toggle the workflow to Active for production use.