Effortlessly Sync Your Contacts: Google Drive to Notion
detail.loadingPreview
Streamline your contact management by automatically syncing contacts from a Google Drive CSV file directly into your Notion database. Save time and ensure your contact information is always up-to-date.
About This Workflow
This n8n workflow revolutionizes contact management by bridging the gap between Google Drive and Notion. It automates the process of importing your contact lists from a CSV file stored in Google Drive into a structured Notion database. The workflow intelligently extracts key information like full name, email, phone number, and company from your CSV, transforming it into actionable data within Notion. Say goodbye to manual data entry and the risk of errors, and hello to a more organized and efficient way to manage your valuable connections.
Key Features
- Automated Data Import: Seamlessly pull contact data from Google Drive CSVs.
- Intelligent Data Mapping: Automatically identifies and maps essential contact fields (name, email, phone, company).
- Notion Database Integration: Creates new pages in your designated Notion contact database.
- Customizable Data Extraction: Easily adjust which fields are pulled and mapped.
- Manual Trigger: Start the sync process with a single click when you're ready.
How To Use
- Prepare Your CSV: Ensure your contact data is in a CSV file on Google Drive, with clear headers for "First Name", "Last Name", "Display Name", "E-mail Address", "Mobile Phone", "Home Phone", and "Company".
- Configure Google Drive Node: Connect your Google Drive account and specify the
fileIdof your CSV file. - Set Up Notion Node: Connect your Notion account and select your existing 'Contacts' database (or create a new one and update the
databaseId). Map the extracted fields to your Notion database properties. - Review Code Node: The 'Code' node is pre-configured to extract common contact fields. You can modify the
jsCodeto adjust how data is mapped if your CSV headers differ. - Execute Workflow: Click the 'Execute workflow' button on the manual trigger node to start the import process.
Apps Used
Workflow JSON
{
"id": "50416d3f-bbc1-497f-91a8-0dce0c4f4ab9",
"name": "Effortlessly Sync Your Contacts: Google Drive to Notion",
"nodes": 16,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 50416d3f-bbc1...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.