Back to Workflows

Upload leads from a CSV file to Pipedrive CRM

Apps in this workflow

Pipedrive
Google Drive
Google Drive Trigger

Share

Details

Created 6 months ago by n8n-team
eye 43 views
Description

This workflow gets leads' contacts from a CSV file and adds it to the Pipedrive CRM by creating an organization and a person. The CSV file in this workflow serves as a universal connector allowing you to export contacts from any platform like LinkedIn, Facebook, etc.

Prerequisites

How it works

  1. The Google Drive Trigger node starts the workflow when a new CSV file is uploaded to a specific folder in Google Drive.
  2. Google Drive node downloads the CSV file.
  3. Spreadsheet File node reads data from the CSV file and sends the output to the Merge node. This Spreadsheet File's output becomes the input 1 for the Merge node.
  4. Meanwhile, the Pipedrive node gets the same list of contacts from the CSV file.
  5. IF node checks if Pipedrive has these contacts already created previously and sends the checked results to the Merge node. These results arrive at the Merge node as input 2.
  6. Merge node compares two inputs via email and removes the matches.
  7. Pipedrive node creates new contacts based on the data provided by the Merge node with necessary details such as organization and notes.

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon