Help building an AI-powered cold calling notes workflow in n8n

Help me Build my Workflow
1

Hi n8n community!

I’m trying to build a workflow in n8n (local instance) that automates creating “cold calling notes” for prospects, and I could use some guidance or collaboration from someone experienced. Here’s what I want it to do:

Objective:

Given a list of prospect design companies , the workflow should automatically generate a structured note containing:

– Prospect Note –

Design Project:

  • A specific, completed interior design project from the company’s website or portfolio.

  • Example: "The Gilded Nest" — the actual name of a project they have done, not just a type of project.

Focus Area:

  • The main specialization of the prospect.

  • Examples: Residential, Commercial, Luxury Interior Design.

  • This should reflect what kind of projects they focus on, based on their website, portfolio, or LinkedIn.

Social Media Presence:

  • A summary of the prospect’s social media activity, ideally for Instagram, LinkedIn, or other relevant platforms.

  • Includes:

    • Activity Level: High / Medium / Low — based on number of posts, engagement, or general activity.

    • Followers: Number of followers (approximate is fine).

  • Example: "High activity" - 12,000 followers

The notes should be concise, standardized, and ready for cold calling outreach — really simple and easy to read.

EXAMPEL :

image
image395×358 9.02 KB

Desired Workflow Steps:

1. Input

  • List of prospect companies via Google Sheets.

  • Include fields such as: website link, Facebook link, LinkedIn link, business name, owner’s name, etc.

2. Search / Data Gathering

  • Ideally, search for information automatically using the website link (e.g., Redirecting... ).

  • I think there’s a node that can perform searches or fetch website data.

3. Summarization via AI (my biggest challenge)

  • Use OpenAI GPT (ideally GPT-5 mini or GPT-4) to filter and structure the information into the note format described above.

4. Output

  • Save the structured notes to Google Sheets, CSV, or Notion for easy access.

  • Notes should appear in a column to the right of the specific prospect.

Optional / Advanced:

  • Include a web scraping step to automatically check Instagram or LinkedIn for social media activity.

  • Rate social media activity as High / Medium / Low based on followers and post frequency.

What I’m Looking For:

  • Tips on prompting GPT to consistently return structured notes.

  • Advice on optionally integrating social media metrics.

  • Any workflow templates or examples that are similar.

Thanks so much in advance! I’d love to collaborate or see any examples of workflows like this.

2

Take a look at this Node which can help you with your LinkedIn profile extraction and doing outreach on LinkedIn: