Import CSV Contacts from Google Drive to Notion Database

This workflow streamlines contact management by pulling a CSV file from Google Drive and transferring the data directly into a Notion database. It begins with a manual trigger, downloads the specified CSV file using the Google Drive node, and employs a custom Code node to parse and structure the data—extracting fields such as full name (derived from first/last or display name), email, phone, and company while handling missing values gracefully.

Following parsing, the workflow integrates with Notion to create new database entries for each contact, mapping the extracted fields to corresponding Notion properties. This ensures clean, organized data import without manual entry, supporting Notion's powerful database features like filtering, relations, and views.

Benefits include significant time savings for teams managing leads or customer lists, reduced errors from manual copying, and centralized storage in Notion for collaboration. Ideal use cases: importing contacts from exported apps (e.g., Gmail, HubSpot), syncing sales leads, or building a personal CRM in Notion. Setup requires Google Drive and Notion API credentials, plus a pre-configured Notion database.