Step 2: Connect Google Drive and Download the CSV

Pull the contact CSV from Google Drive and make it available as binary data for parsing.

1. Open Retrieve Drive File and set Operation to download.
2. Set File to the CSV you want to import (currently [YOUR_ID]).
3. In Options, set Binary Property Name to data.
4. Credential Required: Connect your googleDriveOAuth2Api credentials in Retrieve Drive File.
5. Connect Retrieve Drive File to Parse File Contents.

Step 3: Parse and Transform Contact Data

Parse the CSV file and standardize the fields needed for Notion.

1. Open Parse File Contents and keep the default settings (it will parse the binary data from the previous node).
2. Connect Parse File Contents to Transform Contact Data.
3. In Transform Contact Data, keep the JavaScript Code as provided to map: name, email, phone, and company.
4. Verify the logic uses fields like First Name, Last Name, Display Name, E-mail Address, Mobile Phone, Home Phone, and Company from the CSV.

Step 4: Configure Notion Output

Create a Notion database page for each contact.

1. Open Add Notion Record and set Resource to databasePage.
2. Select your target database in Database (currently [YOUR_ID] with name Contacts).
3. Set Title to ={{ $json.name }}.
4. Configure property mappings in Properties:
   • Email Address|email → ={{ $json.email ? $json.email : null}}
   • Phone Number|phone_number → ={{ $json.phone ? $json.phone : null}}
   • Company|rich_text → ={{ $json.company ? $json.company : "N/A" }} (with Rich Text set to ={{ false }})
5. Credential Required: Connect your notionApi credentials in Add Notion Record.
6. Connect Transform Contact Data to Add Notion Record.

Step 5: Test and Activate Your Workflow

Run the workflow end-to-end and confirm new entries appear in Notion.

1. Click Execute Workflow on Manual Run Trigger to test.
2. Confirm Retrieve Drive File downloads the CSV and Parse File Contents outputs parsed rows.
3. Check Transform Contact Data outputs name, email, phone, and company fields.
4. Verify new records appear in your Notion database from Add Notion Record.
5. When ready, toggle the workflow to Active for production use.