ALL CASE STUDIES
    DUBROVNIK CHARTER · DUBROVNIK, CROATIA

    Yacht-charter offers and contracts generated straight from the booking database

    For a Dubrovnik yacht-charter agency, I connected Airtable to Google Docs through Make. Offers and contracts are built from a booking record in one step; later each affiliate partner got its own price list automatically.

    INDUSTRY
    Yacht charter
    YEARS
    2022–24
    MY ROLE
    Automation builder
    STATUS
    Finished May 2024
    ~4 months
    to build the offer and contract automation
    1 step
    from an Airtable booking record to a finished offer document
    0 manual copies
    of prices and terms for each new affiliate partner
    ~16 months later
    the client came back for a second round of automation
    We run our charter bookings in Airtable, and every offer and contract used to be put together by hand. Mark connected Airtable to Google Docs with Make, so an offer is created straight from the booking record. When we started working with affiliate partners, we came back to him. Now each partner gets its own copy of our prices and terms automatically, ready to adjust. He fixed edge cases quickly and kept the scenarios efficient.
    Pjero KusijanovićPjero KusijanovićOwner & CEO, Dubrovnik Charter
    THE PRODUCT

    Click through it

    app.dubrovnik-charter.com
    Loading…
    THE PROBLEM

    What wasn't working

    ABOUT DUBROVNIK CHARTER

    Dubrovnik Charter is a boutique yacht-charter agency in Dubrovnik offering day yachts, crewed weekly charters and curated routes along the Croatian coast and to Montenegro. It is run by founder Pjero Kusijanović, a Dubrovnik-born former skipper, with a small sales and content team.

    Each charter enquiry needs a tailored offer and then a contract, with yacht, dates, prices and terms. The data already lived in Airtable, but every document was assembled by hand in Google Docs: slow and error-prone in high season.

    As the agency added affiliate partners, each one needed its own editable copy of the web price list and terms, linked back to the originals. Copying them by hand didn't scale, and the automation had to stay light on Make operations.

    WHAT I BUILT

    The system, part by part

    Offer generator

    An Airtable record goes through Make into a Google Docs template and comes out as a ready offer.

    Contract generator

    The same pattern for charter contracts.

    Rich-text formatting

    Bold, bullets and links carried from Airtable into the generated document, with clean link text.

    Affiliate price and terms cloning

    A new partner gets duplicated price and terms records, linked to the partner and back to the originals.

    Safe trigger and incremental sync

    A 'Copy' field starts the run instead of a button, and only new or changed records are processed to save operations.

    RESULTS

    What changed

    • The offer automation stayed in use: in 2024 the client still ran 'the Create offer scenario you created with Google Docs'
    • The client came back about 16 months later for more automation
    • Affiliate cloning tested by the client: 'it works well'; after fixes, 'Thank you for correcting the errors'
    TIMELINE

    Built fast, then looked after

    1. Jun 2022KickoffAirtable → Google Docs automation starts
    2. Sep 2022Offers and contracts automatedPhase 1 complete
    3. Feb 2024Client returnsAffiliate price and terms cloning built and tested ('it works well')
    4. May 2024FinishEdge-case fixes and rich-text formatting; last call 2024-04-03
    NEXT STEP

    Have a process like this? Show it to me on a call.

    30 minutes, a screen share, and a scope with a fixed price the next day.

    Book a call
    NEXT CASE · PODIOM HEALTHAn anonymous anamnesis app for therapists, first build in 8 days