Automated NASA Patent Lead Generation and Scoring with OpenAI, Google, and Notion

This n8n workflow automates the process of identifying, scoring, and managing potential leads from NASA patents. It fetches patent data, enriches it with company information using Google Search, scores the lead's relevance with OpenAI, and then stores the qualified leads in Notion.

What it does

This workflow performs the following key steps:

1. Triggers Manually: The workflow is initiated manually, typically to start a new lead generation cycle.
2. Fetches NASA Patent Data: It makes an HTTP request to a specified URL (likely a NASA patent API or data source) to retrieve patent information.
3. Processes Patent Data: It iterates through each retrieved patent item.
4. Enriches Data with Google Search: For each patent, it performs a Google search to find associated companies or relevant entities.
5. Scores Leads with OpenAI: It uses OpenAI to assess the relevance or potential of the identified leads based on the patent and company information.
6. Filters Leads: It applies conditional logic to determine if a lead meets specific criteria (e.g., a minimum score from OpenAI) to be considered qualified.
7. Formats Data for Notion: For qualified leads, it transforms and sets the necessary fields to match the structure of a Notion database.
8. Stores Qualified Leads in Notion: It creates new pages or items in a specified Notion database for each qualified lead, including all relevant details and the OpenAI score.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (cloud or self-hosted).
• NASA Patent Data Source: Access to a NASA patent API or a publicly available data endpoint that can be queried via HTTP.
• Google Search API Key: For the Google Search functionality (implied by the workflow's purpose, though not explicitly shown in the provided JSON for the HTTP Request node, it's a common pattern for enriching data).
• OpenAI API Key: For the lead scoring and analysis using OpenAI's models.
• Notion Account & Database: A Notion account with a pre-configured database where the leads will be stored. You will need the database ID and an integration token.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • HTTP Request Node (ID: 19): Update the URL and any necessary authentication details to fetch data from your chosen NASA patent source.
   • OpenAI Node (ID: 1250): Configure your OpenAI API key credential.
   • Notion Node (ID: 487): Configure your Notion API key (integration token) and specify the database ID where leads should be added.
3. Review and Adjust Nodes:
   • Code Node (ID: 834): Examine and modify the JavaScript code within this node if you need to adjust how the Google search query is constructed or how the OpenAI prompt is formatted.
   • If Node (ID: 20): Adjust the conditions in the "If" node to define what constitutes a "qualified" lead based on the OpenAI score or other data points.
   • Edit Fields (Set) Node (ID: 38): Ensure the fields being set match the properties of your Notion database.
4. Execute the Workflow: Click the "Execute workflow" button on the "Manual Trigger" node (ID: 838) to run the workflow.

This workflow provides a robust framework for automating lead generation from technical patent data, leveraging AI for intelligent scoring and Notion for organized management.