Automate Pipedrive Organization Notes with GPT-4 & ScrapingBee

What this workflow does

This workflow automatically adds detailed notes about new organizations in Pipedrive. It solves the problem of manually researching company websites. The result is quicker data entry and better information in the CRM, plus real-time Slack alerts for the sales team.

When a new organization is created, it scrapes the website URL you have saved. Then it sends the website content to GPT-4o to make a summary with company info. It adds this summary as a note in Pipedrive. Finally, it sends a message with the summary to Slack in a readable format.

Who should use this workflow

This workflow is useful for sales teams or CRM managers who want to save time researching new organizations. It helps keep Pipedrive updated with richer, consistent company data without manual effort.

It’s meant for users who already use Pipedrive and get many new organizations weekly. It benefits those who want faster follow-ups and better team collaboration via Slack notifications.

Tools and services used

• Pipedrive: Manages organizations and stores custom website URLs.
• ScrapingBee API: Gets the HTML content of organization homepages.
• OpenAI GPT-4o: Creates HTML summaries of website content.
• Slack: Sends markdown-formatted notifications to a sales channel.
• n8n: Runs the workflow and connects all nodes together.

Inputs and processing steps

Inputs

• New organization created event in Pipedrive.
• Organization website URL saved in a custom Pipedrive field.

Processing steps

• Trigger: The Pipedrive Trigger node fires when a new organization is created.
• Scrape website: HTTP Request node calls ScrapingBee API with the website URL to retrieve homepage HTML.
• Summarize content: OpenAI node sends HTML to GPT-4o with a system prompt to create a company summary as HTML.
• Create note: Pipedrive node adds a note linked to the organization, containing GPT-4o’s HTML summary.
• Convert HTML to Markdown: HTML To Markdown node changes the note content from HTML to Markdown format.
• Format Markdown for Slack: Code node runs JavaScript to replace markdown headings with bold text, lists with arrow points, and tables with bullet lists suited for Slack.
• Send Slack message: Slack node posts the formatted summary and organization name to a specified Slack channel.

Output

• A new HTML-formatted note linked to the organization in Pipedrive.
• Slack channel message with a Slack-markdown formatted company summary.

Beginner step-by-step: How to run this in n8n

Import the workflow

1. Download the workflow file using the Download button on this page.
2. Inside your n8n editor, click to import and select “Import from File”.

Add required credentials

3. Add your Pipedrive API key with access to organization data.
4. Add your ScrapingBee API key in the HTTP Request node.
5. Add your OpenAI API key with GPT-4o model access in the OpenAI node.
6. Add your Slack OAuth2 credentials and select the Slack channel for notifications.

Update configuration

7. Confirm the website field ID in Pipedrive matches the expression in the HTTP Request node. For example:

   {{$json.current.<custom_website_field_id>}}

8. Check the system prompt text in the OpenAI node matches the prompt below:

You're an assistant that summarizes website content for CRM entries. The user will provide HTML content from a company's website. Your task is to analyze the HTML content and create a concise summary that includes:
1. A brief description of the company's services or products.
2. Any information about the company's target market or customer base.
3. Key points about the company's unique selling propositions or competitive advantages.
4. Based on the provided information, suggest potential competitors if you know any.

Format your response as HTML.

Test and activate

9. Run the workflow once with a test organization that has a website URL.
10. Check Pipedrive for the new note and Slack for the notification.
11. When satisfied, activate the workflow with the toggle switch.

If using your own server, make sure it is accessible from the internet so Pipedrive can send webhook calls. Check self-host n8n for help with hosting.

Customization options

• You can change the AI model in the OpenAI node to GPT-3.5 to save costs but expect shorter summaries.
• You can swap the ScrapingBee service with another scraping API if preferred.
• Editing the system prompt in the OpenAI node can add more company details like location or executive names.
• The Slack message format can be changed by updating the JavaScript in the Code node.
• This workflow can be adapted for other Pipedrive objects like Deals or Contacts by changing triggers and note links.

Common edge cases and troubleshooting

• 401 Unauthorized error on Pipedrive Trigger node: Recheck and re-add Pipedrive API credentials. Old or wrong keys block webhook access.
• OpenAI node gives no or invalid answer: Review system prompt and scraped HTML input. Confirm OpenAI API key and GPT-4o access are correct.
• No Slack messages sent: Confirm Slack node OAuth2 setup and target Slack channel are correct in settings.

Summary and outcomes

✓ Saves about 20 minutes of manual research per new Pipedrive organization.
✓ Automatically creates rich, consistent notes with company descriptions.
✓ Sends clear Slack messages to keep sales teams updated.
✓ Improves CRM data quality and speeds up sales follow-up.
✓ Works with minimal setup and can be extended to other CRM objects.