Daily Magento 2 customer sync to Google Contacts & Sheets without duplicates
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 Con
At a glance
Daily Magento 2 customer sync to Google Contacts & Sheets without duplicates is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects code, compareDatasets, googleContacts, googleSheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- code, compareDatasets, googleContacts, googleSheets, httpRequest, scheduleTrigger
- Modules
- 8
- Price
- Free
- Version
- v1.0

About this workflow
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: 1. Automates Customer Syncing 2. Every day, it fetches newly registered Magento 2 customers via API based on the exact date range (midnight to midnight). 3. Deduplicates Using Google Sheets 4. A master Google Sheet tracks already-synced emails. Before adding a customer, the workflow checks this list and skips if already present. 5. Creates Google Contacts Automatically 6. For each unique customer, it creates a new contact in your Google Contacts, saving fields like first name, last name, and email. 7. Logs New Entries to Google Sheets 8. In Google Sheets, it even records magento 2 customer group, createdat, websiteid & storeid 8. After syncing, it adds each new email to the tracking sheet, building a cumulative record of synced contacts. 9. Fully Scheduled & Automated 10. 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
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Transform old photos into animated videos with FLUX & Kling AI for social media
Scrape & import shoe products to Shopify with BrowserAct (with variants & images)
Automate Lightroom Cloud to Instagram
Automate multi-step onboarding with Google Sheets, Forms and Gmail notifications
Create viral ads with AI: NanoBanana & publish on socials via upload-post
Convert meeting recordings to notes & action items with AssemblyAI, GPT-4 & Sheets
⚡📽️ Ultimate AI-powered chatbot for YouTube summarization & analysis
AI blog generator for Shopify product listings: Using GPT-4o and Google Sheets
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you