Four Tools, One Mess: Replacing Salesforce with Airtable CRM
Four tools, no single source of truth. See how Connex migrated a consulting firm from Salesforce and Pardot into a single Airtable CRM with Make automation.
Doubling trip frequency for boutique tour operator Project Por Amor
TABLE OF CONTENTS
The Client
Project Por Amor is a boutique tour guide focused on Cuba.
Due to embargos they can’t use standard tour guide apps.
The Challenge
- Running on spreadsheets.
- Lots of manual entry, copy and pasting. Mistakes are made, problems overlooked or not noticed.
- Manually recording payments in spreadsheets.
- 2 stages tour confirmation (minimum required).
- Follow ups with clients were all manual.
The Solution
- Airtable source of truth for payments and group management.
- Self-served client registration using Airtable and Fillout.
- Payment triggers automations to update records in Airtable.
- QuickBooks and Stripe integrations.
- Automations for minimum met, missing information and missing payments follow ups.
The Results
- Dramatically improved client experience. 20 hours on administrative tasks saved for each tour.
- Doubled tour capacity
Tech Used
Related Posts
How a Homeless Services Nonprofit Replaced a Broken Dashboard Stack with Real-Time Financial Reporting
How a ~60-person homeless services nonprofit replaced broken Klipfolio dashboards with real-time QuickBooks P&L reports in Looker Studio — built in 3 sessions.
How a ~65-Person Youth Soccer Nonprofit Automated 150+ Monthly Donations Across Three Systems — and Stopped Losing Records
How a ~65-person youth soccer nonprofit automated 150+ monthly donations across HubSpot, QGive, and QuickBooks — saving 8 hrs/week of manual entry.
