Google Contacts and HTTP Request integration

Automatically sync newly registered Magento 2 customers to Google Contacts and Google Sheets every 24 hours — with full duplication control and seamless automation. This workflow is a plug-and-play customer contact automation system designed for Magento 2 store owners, marketers, and CRM teams. It fetches customer records registered within the last 24 hours (from 00:00:00 to 23:59:59), checks against an existing Google Sheet to avoid reprocessing, and syncs only the new ones into Google Contacts. This ensures your contact list is always fresh and up to date — without clutter or duplicates. ✅ What This Workflow Does: Automates Customer Syncing Every day, it fetches newly registered Magento 2 customers via API based on the exact date range (midnight to midnight). Deduplicates Using Google Sheets A master Google Sheet tracks already-synced emails. Before adding a customer, the workflow checks this list and skips if already present. Creates Google Contacts Automatically For each unique customer, it creates a new contact in your Google Contacts, saving fields like first name, last name, and email. Logs New Entries to Google Sheets In Google Sheets, it even records magento 2 customer group, created_at, website_id & store_id After syncing, it adds each new email to the tracking sheet, building a cumulative record of synced contacts. Fully Scheduled & Automated Can be scheduled with the Cron node to run daily (e.g., 12:05 AM) with no manual intervention required. 🔧 Modules Used: HTTP Request (Magento 2 API) Date & Time (for filtering registrations) Google Sheets (for reading/writing synced emails) Google Contacts (for contact creation) Set, IF, and Merge nodes (for control logic) Cron (for scheduling the automation) 💼 Use Cases: Keep your email marketing tools synced with Magento 2 customer data. Build a CRM-friendly contact base in Google Contacts without duplicates. Share customer data with sales or support teams through synced Google Sheets. Reduce manual work and human error in data transfer processes. 🔒 Credentials Required Magento 2 Bearer Auth: Set up as a credential in n8n using your Magento 2 API access token. Google API 📂 Category E-commerce → Magento 2 (Adobe Commerce) 💬 Need Help? 💡 Having trouble setting it up or want to customize this workflow further? Feel free to reach out — I’m happy to help with setup, customization, or Magento 2 API integration issues. Contact: Author 👤 Author Kanaka Kishore Kandregula Certified Magento 2 Developer https://gravatar.com/kmyprojects https://www.linkedin.com/in/kanakakishore

How it works: Schedule Trigger** on a daily basis (configured at 7.30 am) Connects Google Contacts** to get personal information from them Field Checker** on birthday date & firstnames. And see if there is any celebration for today Send a Telegram Notification** and display the message on a Google Home Speaker via Home Assistant if any celebration has matched Set up steps: Download* the workflow and import* it into your n8n instance Configure accounts** for Google Contacts, Telegram and Home Assistant And you will be good to go

Sync Notion Contacts to Google Contacts with Group Labels Overview Seamlessly transfer your Notion contacts to Google Contacts with organized group labels, simplifying your CRM management. This n8n workflow automates syncing contacts from a Notion database to Google Contacts, applying group labels based on Notion properties. It triggers on new or updated contacts, ensuring your Google Contacts are always organized without manual effort. ✨ Key Features 🔄 Automatic Sync: Updates Google Contacts when Notion entries are added or modified. 🏷️ Group Organization: Assigns labels to contacts based on Notion’s property_buy field. ✅ Duplicate Prevention: Marks synced contacts in Notion with a checkbox. 🛠️ Flexible Customization: Add fields like email in the “Map Notion Contact Fields” node. 📡 Community Nodes: Leverages Notion and Google Contacts nodes for integration. 📋 Prerequisites Required Credentials Notion API Token:** Set up OAuth2 in n8n. Get your token from Notion’s API settings. Google Contacts OAuth2:** Configure in n8n. See n8n’s Google Contacts guide. Notion Database:** Must include name, phone, labels (property_buy), and an “Added to Contacts” checkbox. Self-Hosted n8n:** Required for community nodes. 🔄 Workflow Process Trigger: Activates on new or updated Notion database entries. Fetch Data: Retrieves contact details (name, phone, labels) from Notion. Map Fields: Organizes data in the “Map Notion Contact Fields” node. Verify Groups: Checks for existing Google Contact groups; creates new ones if needed. Sync Contacts: Adds contacts to Google Contacts with labels. Update Notion: Marks contacts as synced. Result: Organized, labeled contacts in Google Contacts, updated automatically. 📊 Output Data Structure Name:** Contact’s first name from Notion. Phone:** Contact’s phone number. Group Labels:** Assigned from Notion’s property_buy field. Sync Status:** Notion checkbox updated to confirm sync. 💡 Pro Tips Real-Time Updates:** Set the Notion Trigger node to check every minute for faster syncing. Expand Fields:** Add email or other fields in the “Map Notion Contact Fields” node. Clean Labels:** Use consistent Notion labels for better Google Contacts organization. Test Small:** Start with a small dataset to verify setup. 🆘 Troubleshooting Authentication Issues:** Verify Notion and Google Contacts OAuth2 credentials. Sync Failures:** Ensure Notion database ID and field names match the workflow. Group Errors:** Check that property_buy labels are valid. 👨‍💻 Creator Information 👤 Created by: Dan Rahimi 🌐 Website: DanRahimi.com 📧 Email: [email protected] 📺 YouTube: @DanRahimi 👥 LinkedIn: Dan-Rahimi 🤝 Support & Contributions Enjoyed this workflow? Support my work or explore more: ☕ Buy Me a Coffee 📚 AI Automation Courses: Visit DanRahimi.com for more articles and tutorials about AI automation. Disclaimer: This workflow uses community nodes and requires a self-hosted n8n instance.

Sync your Google Contacts with your Notion database. You can filter contacts by label or sync all contacts. All contact information is kept in sync between Google and Notion. What happens if I delete a contact? It gets deleted on the other end. Google Contact deleted → Notion page deleted Notion page deleted → Google contact deleted But you can easily change this behavior by disabling the respective deletion nodes. Who is this template for? Service providers looking to keep track of client information Organized individuals who like to centralize their lives in Notion Automation nerds who enjoy creating interesting projects How it works First, you perform an initial import to bring your contacts from Google to Notion. After that, the workflow listens for changes in both Notion and Google and keeps everything in sync. How to set up Instructions are included within the workflow itself. Check out my other templates 👉 https://n8n.io/creators/solomon/