Make.com(Automat Expert): CRM & Membership Sync

Of course. Here is a compelling, professional project description optimized for a freelancer platform. --- **Project Title:** [login to view URL] (Integromat) Automation Expert – Build a Production-Ready CRM & Membership Sync **Description:** I am seeking an expert [login to view URL] (Integromat) automation specialist to architect and build a robust, production-ready system that synchronizes membership and customer data into Airtable as the central CRM. This is a concrete implementation project requiring expert-level skills in data flow design, identity resolution, and lifecycle management. The goal is to create a reliable "single source of truth" in Airtable by integrating Stripe (for payments), a newsletter platform (like Substack), and a membership site (e.g., Brilliant Directories or via API). You must build scalable, well-documented [login to view URL] scenarios with proper error handling—not just a proof of concept. **Core Responsibilities:** * Design and build [login to view URL] scenarios to ingest events from: * **Stripe:** Payments, subscription changes (upgrades/downgrades/cancellations), failed payments. * **Newsletter Platform:** Sync free/paid subscriber status changes. * **Membership Website:** Connect via its API or webhooks to sync member data. * Implement a reliable **identity resolution** system using email as the primary key, with intelligent "search vs. create" logic in Airtable to **prevent duplicate records**. * **Normalize data** from all sources into standardized fields in Airtable for membership tiers, statuses, and plan types. * Implement full **member lifecycle handling** (active, canceled, past-due, upgraded, etc.). * Configure **downstream actions** based on data changes, such as updating member tiers and sending system emails from a business domain. * Ensure **scalable design** with clean scenario structure, proper use of routers/filters, and basic logging/error notification. **Must-Have Expertise:** * Advanced, proven experience with **[login to view URL] (Integromat)**. * Deep understanding of **Stripe's subscription business logic** and webhooks. * Experience using **Airtable as an operational CRM/database** with complex automations. * Proficiency in working with **REST APIs and webhooks**. **Screening Question (Please answer in your proposal):** Briefly explain your approach to preventing duplicate user records when syncing from multiple sources (Stripe, membership site) into Airtable. Also, outline how you would programmatically handle a subscription upgrade versus a cancellation in the automation flow. **Project Structure:** This will begin with a **paid pilot project** to build the core synchronization system. Success here will lead to **ongoing, substantial work** on expansion, maintenance, and additional automation features. **I am looking for a true expert who can deliver a clean, reliable, and documented system. Please provide examples of similar [login to view URL] projects in your portfolio or proposal.**

Projekt-ID: 40072807