Turn a simple sheet of company names into rich, useful data for sales. The setup looks up each company, checks its website, and writes clean answers back to your Google Sheet. Teams use it to speed up prospecting and prepare better outreach.

Under the hood, two triggers let you start by hand or run on a schedule. Rows are pulled from Google Sheets and handled one at a time. An AI agent powered by OpenAI gpt 4o searches the web with SerpAPI and reads website content through a helper workflow. A structured parser forces a clear format for fields like domain, LinkedIn URL, market type, pricing notes, API, free trial, and enterprise plan. The data is mapped to row fields and updated in place. You can switch search to a ScrapingBee tool if you want.

Connect Google Sheets, OpenAI, and SerpAPI credentials. Add the sheet URL and choose the right sheet tab. Set the output schema to match your columns. Expect big time savings. Many teams cut research from about 15 minutes per account to under 2 minutes. Great for SDRs, growth teams, and founders who need fast, repeatable company research.

• Manual and schedule triggers let you test on demand or run every few hours
• Google Sheets input node filters rows to enrich and returns them for processing
• Split in Batches processes one row at a time for stable runs
• AI agent uses OpenAI gpt 4o with low temperature for consistent answers
• SerpAPI tool searches Google to find domains, pages, and public info
• Sub workflow tool reads website content to extract pricing and product details
• Structured Output Parser forces a clean JSON with fields like domain and LinkedIn URL
• Merge and Set nodes map AI output to the right sheet columns and row number
• Google Sheets update writes results back to the same row
• Optional ScrapingBee search tool for cost efficient results

• Reduce manual research from 15 minutes to under 2 minutes per company
• Automate up to 80 percent of repetitive enrichment work
• Improve data quality by enforcing a clear field schema
• Handle large lists by processing rows one by one without overload
• Unify web search and website content in one Google Sheet
• Run on a schedule every few hours to keep data fresh

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, OpenAI, SerpAPI and ScrapingBee. See the Tools Required section above for links to create accounts with these services.
3. Prepare your Google Sheet: add columns for company input, domain, LinkedIn URL, market, cheapest plan, free trial, enterprise plan, API, case study link, and an enrichment_status field.
4. In n8n, open the Google Sheets nodes. In the credential dropdown, click Create new credential and follow the prompts to connect your Google account with OAuth2.
5. In the Get rows to enrich and Update Row nodes, paste your sheet document ID and select the correct sheet tab. Make sure the column names match your sheet.
6. Open the OpenAI Chat Model node. In the credential dropdown, click Create new credential and paste your OpenAI API key from your OpenAI account API page. Keep temperature near 0.3 for steady output.
7. Open the SerpAPI node. In the credential dropdown, click Create new credential and paste your SerpAPI key from the SerpAPI dashboard.
8. If you prefer ScrapingBee for search, enable the ScrapingBee tool node and add your API key the same way. Disable the SerpAPI tool to avoid duplicate calls.
9. Open the Structured Output Parser node and confirm the schema fields you want. Make sure each field has a matching column in your sheet.
10. Open the AI company researcher node and review the prompt so it asks for the exact fields in your schema. Keep instructions clear and short.
11. Check the Split in Batches node and set batch size to 1 to process rows safely. This prevents timeouts and keeps updates in order.
12. Run a manual test from the manual trigger. Confirm one row is updated with the right values. Fix any missing columns or mismatched field names.
13. Verify the Update Row node uses the row number field to write back to the correct row. Adjust the mapping if needed.
14. Turn on the Schedule Trigger and set it to run every 2 hours or your preferred interval. Watch the first scheduled run to confirm steady performance.
15. Troubleshooting: if you see empty fields, check the schema and prompt. If you get permission errors, reauthorize Google Sheets. If searches fail, confirm your SerpAPI or ScrapingBee key and usage limits.