Turn a list of company domains in Google Sheets into useful profiles you can use for outreach. The flow looks up each domain, writes company details back to the same sheet, and marks the row as processed. It helps marketing and sales teams build lists faster with less manual work.

Here is how it runs. You start it manually. It reads all rows from a chosen Google Sheet, then filters to only the rows where the processed_at column is empty. A batch loop processes one row at a time to keep API calls under control. For each row, it sends the domain to an external data source through an HTTP request and returns details like company name and funding. Then it updates the same Google Sheet row with those fields and a data snapshot. The loop repeats until all pending rows are done.

You need a Google Sheets account and an API key for the data provider. Set up your sheet with columns for domain, processed_at, and any fields you want to fill like name, funds, and data. Expect faster list building, cleaner data, and fewer copy paste tasks. This setup is great for lead research, market mapping, and pre outreach prep for campaigns.

• Manual start for safe testing and on demand runs
• Reads all rows from a selected Google Sheets tab
• Filters to only rows with an empty processed_at column
• Processes one row at a time using a batch loop to control concurrency
• Looks up company details by domain via an HTTP request to the data API
• Updates the same row with name, funding, and a JSON snapshot of results
• Continues the loop until all pending rows are processed

• Reduce manual research from hours to minutes by auto looking up each domain
• Automate up to 90 percent of repetitive data entry for prospect lists
• Improve data quality by pulling consistent fields from one source
• Connect Google Sheets and an external data API with no coding
• Process large lists safely with single item batching to avoid rate limits

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and ProspectLens. See the Tools Required section above for links to create accounts with these services.
3. Prepare your Google Sheet. Add columns for domain and processed_at, plus any fields you plan to fill like name, funds, and data. Share the sheet with the Google account you will connect in n8n.
4. Open the Get all rows from Sheets node. In the Credential dropdown, pick your Google Sheets account or click Create new credential and follow the on screen steps to sign in. Select the correct Document and Sheet.
5. Open the Filter node. Set the condition so it only passes rows where processed_at is empty. This ensures only new rows are processed.
6. Open the Loop Over Items node. Confirm batch size is 1 to keep concurrency low and avoid API rate limits.
7. Open the ProspectLens API call node. Confirm the URL uses the domain field from the sheet. In the Credential dropdown, click Create new credential for HTTP Header Auth and follow the on screen steps to add your API key from the provider’s API page.
8. Open the Save company data into Sheets node. Select the same Google Sheets credential and your target document and sheet. Keep the operation as Update and map fields to your columns such as name, funds, data, and set processed_at to the current time if desired.
9. Click Execute Workflow. Watch the items flow through one by one. Confirm the sheet updates a single row with the returned data and a processed timestamp.
10. If you see 401 or 403 errors, check the API key and header settings. If you see rate limit errors, keep batch size at 1 or add a small wait between calls. If the sheet does not update, verify document permissions and that column names match.
11. After testing, duplicate the sheet for production lists and reuse the same nodes. Run on demand whenever you add new domains.