Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Lead Generation & Enrichment

Lead Generation & Enrichment

Research Target Accounts with OpenAI, SerpAPI and Google Sheets

When you run it or on a schedule, the workflow reads accounts from Google Sheets, searches Google via SerpAPI, and uses OpenAI to summarize each company's website findings.

Import it free Sign in to open it

What it does

## Read Me This workflow allows you to do account research with the web using AI. The advanced AI module has 2 capabilities: - Research Google using SerpAPI - Visit and get website content using a sub-workflow From an unstructured input like a domain or a company name. It will return the following properties: - domain - company Linkedin Url - cheapest plan - has free trial - has entreprise plan - has API - market (B2B or B2C) The strength of n8n here is that you can adapt this workflow to research whatever information you need. You just have to precise it in the prompt and to precise the output format in the "Strutured Output Parser" module. [Click here to find more detailed instructions with video guide.]({{ $env.WEBHOOK_URL }}

The steps

  1. When clicking "Test workflow"
  2. Input
  3. OpenAI Chat Model
  4. Get website content
  5. SerpAPI - Search Google
  6. Structured Output Parser
  7. Loop Over Items
  8. AI Researcher Output Data
  9. Google Sheets - Update Row with data
  10. Merge data
  11. Get rows to enrich
  12. Schedule Trigger
  13. AI company researcher
  14. Search Google with ScrapingBee

27 steps in total.

Similar automations

Lead Generation & EnrichmentResearch Target Accounts with OpenAI, SerpAPI and Google Sheets27 stepsLead Generation & EnrichmentResearch Sales Accounts with OpenAI and SerpAPI14 stepsLead Generation & EnrichmentResearch Sales Accounts on the Web with OpenAI14 stepsCRM & Sales PipelineCreate Salesforce Accounts from Excel 365 Data12 steps