AI web researcher for sales n8n Workflow Template

n8n workflow template · 14 nodes · OpenAI

AI web researcher for sales is a free n8n workflow template that runs on a schedule and works with OpenAI, SerpApi and Google Sheets. It has 14 nodes, 6 of them AI nodes (OpenAI Chat Model, Call n8n Workflow Tool, SerpApi Tool and Structured Output Parser). The notes inside the workflow say: “This workflow allows you to do account research with the web using AI.” To run it, you add your own credentials for Google Sheets OAuth2, OpenAI API and Serp API.

Download JSON How to import into n8n

At a glance

Trigger
Schedule Trigger (Schedule Trigger)
Nodes
14
Apps
OpenAI, SerpApi and Google Sheets
AI nodes
6
Credentials
3 types
Category
Spreadsheets, databases and docs

Apps and integrations

  • OpenAI
  • SerpApi
  • Google Sheets

Node types used

  • Manual Trigger
  • Edit Fields (Set)
  • OpenAI Chat Model
  • Call n8n Workflow Tool
  • SerpApi Tool
  • Structured Output Parser
  • Loop Over Items
  • Google Sheets
  • Merge
  • Schedule Trigger
  • AI Agent

How it works

The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.

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

  • 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.

Run the workflow manually or activate it to run it every 2 hours

In this workflow, I use Google Sheets to store the results.

You can use my template to get started faster

  1. Click on this link to get the template
  2. Make a copy of the Sheets
  3. Add the URL to this node and the node "Google Sheets - Update Row with data"

Process rows 1 by 1

This module will allow us to process rows 1 by 1

Ask AI what are the information you are looking for about the company

Precise here the format in which you need the data to be

Setup notes

The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.

Get your free API key here

Instead of SERP API module, you can also use this custom module for ScrapingBee. It is more cost-efficient.

Get your free API key here

Nodes in this workflow

The 14 nodes in file order (sticky notes excluded). Branches and connections determine execution order in n8n:

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

Credentials you need

  • Google Sheets OAuth2 – used by Get rows to enrich and Google Sheets - Update Row with data
  • OpenAI API – used by OpenAI Chat Model
  • Serp API – used by SerpAPI - Search Google

Configure your own credentials after importing. Create each credential in n8n, then select it in the node.

How to import into n8n

  1. Download the JSON file with the button above.
  2. In n8n, open a new workflow, select the ... menu and choose Import from File. You can also paste the JSON straight into the editor canvas.
  3. Open each node that shows a warning and select or create its credential.
  4. Read the notes on the canvas, test the workflow with sample data, then activate it.

Do you need somewhere to run it? Read our guide to self-hosted n8n.

Need this customised?

We can adapt this workflow to your apps, data and process, then deploy and support it.

Contact Us