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 interior 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 :
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 / Lowbased 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.
