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

This workflow automates the process of scanning business cards received via Telegram and instantly saving the extracted contact information into Google Contacts. It combines OCR technology, AI-powered data extraction, and workflow automation to eliminate manual contact entry and reduce errors. The workflow validates authorized users, processes business card images, extracts structured information such as names, company details, phone numbers, email addresses, and addresses, and automatically creates a new contact in Google Contacts. Finally, it sends a confirmation message back to the user via Telegram. Key Benefits ✅ Fully Automated Contact Management The workflow removes the need for manual typing of business card information by automatically converting images into structured contact data and saving them directly into Google Contacts. ✅ Faster Lead Collection Users can instantly save new contacts during meetings, conferences, networking events, or sales activities simply by sending a photo of a business card to Telegram. ✅ AI-Powered Data Extraction Using Mistral OCR and OpenAI models, the workflow accurately extracts and structures contact information even from complex or differently formatted business cards. ✅ Improved Data Accuracy The workflow minimizes human errors typically caused by manual data entry, ensuring standardized and reliable contact information. ✅ Secure User Validation Only authorized Telegram users can trigger the workflow, adding an additional layer of security and preventing unauthorized usage. ✅ Seamless Integration The automation integrates multiple services: Telegram for image submission and notifications Mistral OCR for text recognition OpenAI for intelligent information extraction Google Contacts for automatic contact creation ✅ Real-Time Feedback After processing the business card, the workflow sends an automatic success or error notification directly to the user on Telegram. ✅ Scalable and Customizable The workflow can easily be extended with additional features such as: CRM integration Contact enrichment Duplicate detection Multi-language business card support Lead scoring and tagging Business Value This workflow is ideal for: Sales teams Business networking Event management Entrepreneurs Recruitment agencies CRM data collection It significantly increases operational efficiency, accelerates lead management, and creates a smoother digital workflow for handling professional contacts. How it works Telegram trigger – The workflow starts when a message is sent to the Telegram bot. Authorization check – A Code node verifies if the message comes from an authorized Telegram user ID. Message validation – The workflow checks that: The message contains a photo. The caption starts with /business. Image retrieval – The bot fetches the highest‑quality photo from the message. OCR extraction – The image is sent to Mistral OCR (via HTTP Request) to extract text from the business card. Information extraction – The extracted text is passed to an Information Extractor (powered by an OpenAI chat model) which parses the card and returns structured fields: company_name, first_name, last_name, role, phone, email, website, street_address, city, region, country_code, postal_code. Create Google Contact – A Google Contacts node creates a new contact using the extracted data (addresses, company, emails, phone). Success check – An IF node checks if the contact was created successfully (by verifying resourceName exists). Telegram reply – The bot sends a confirmation message (“Contact successfully added”) or an error message to the user. Set up steps Telegram bot Create a Telegram bot via @BotFather. Add the bot’s API token as a credential in n8n (name: Telegram account Fastewb). User authorization Find your Telegram user ID (e.g., by using @userinfobot). In the Code node, replace XXX with your numeric user ID. Mistral OCR Get an API key from Mistral AI.# Create an HTTP Bearer Auth credential in n8n named Mistral OCR with that key. The node uses https://api.mistral.ai/v1/ocr with a base64‑encoded image. OpenAI chat model Obtain an OpenAI API key. Create an OpenAi API credential in n8n (name: OpenAi account (Eure)). The workflow uses gpt-5.4-mini – ensure this model is available or change it to gpt-4o-mini / gpt-3.5-turbo. Google Contacts Set up Google OAuth2 credentials in n8n with access to Google Contacts API. The node will create contacts under the authenticated Google account. Activate the workflow Save the workflow. Set the Telegram Trigger to Active. In Telegram, send a photo with the caption /business to the bot to test. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

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/