Moving NZ Airports from Spreadsheets to Zoho CRM
RESOURCES / CASE STUDIES
Moving NZ Airports from Spreadsheets to Zoho CRM
Introduction
Hatchit helped NZ Airports bring airport, membership, sponsor and contact information from spreadsheets into Zoho CRM. The project connected website forms, introduced a newsletter subscriber approval process and automated new member emails.
Industry: Aviation membership association
Software: Zoho CRM · Zoho Forms
Hatchit’s work: Process review, data migration, CRM configuration, website forms and workflow automation
About NZ Airports
NZ Airports is a not-for-profit industry association representing New Zealand’s airports and related businesses.
Its team had used spreadsheets for years to manage airports, corporate members, sponsors, contacts and other related organisations. These spreadsheets supported processes including sponsor tracking, membership applications and newsletter sign-ups.
The Challenges
The team needed one central place to manage its information. It wanted to clearly separate airports, corporate members, sponsors and other organisations while linking contacts to the correct records.
Information held across multiple spreadsheets required manual updates and offered limited opportunities for automation.
NZ Airports also needed better ways to track sponsor opportunities, manage website enquiries, approve newsletter subscribers and segment contacts according to their areas of interest.
The Solution
Hatchit configured Zoho CRM around the association’s relationships and processes, bringing its spreadsheet data into a structured, central system.
Custom modules separated different types of organisations, with contacts linked to the relevant records. The Deals pipeline provided a visual process for managing sponsor opportunities.
Zoho Forms connected membership applications and newsletter sign-ups from the website to CRM. Subscriber approval controls, automated new member emails and interest fields supported the team’s membership and communication processes.
How Hatchit Implemented It
Hatchit reviewed the existing spreadsheets and met with the team to understand how its processes worked before importing the data into Zoho CRM.
Custom modules were created for airports, members, sponsors and other organisations. Contacts were linked to the correct airport, member or related organisation.
Sponsor opportunities were managed through the Deals pipeline, allowing the team to move each opportunity through its stages.
Hatchit added Zoho Forms to the website for membership applications and newsletter sign-ups. Submissions flow directly into CRM, where the team can review, approve and convert them into contacts where needed. A custom button was created for approving newsletter subscribers.
Workflows were configured to send automated new member emails. Checkbox fields capture areas of interest and map them back to CRM, enabling the team to search and segment contacts for targeted emails, webinars and events.
The Results
NZ Airports now has a more organised and connected CRM system in place of multiple spreadsheets.
- Centralised information: Airports, members, sponsors, contacts, applications and newsletter subscribers can be managed in one place.
- Clearer contact relationships: Contacts are linked to the relevant airport, member or related organisation.
- Visible sponsor opportunities: The Deals pipeline provides a clear way to track sponsorship opportunities through each stage.
- Connected website submissions: Membership applications and newsletter sign-ups flow directly into CRM for review and processing.
- Automated new member emails: Workflows handle this part of the member journey.
- More targeted communications: Captured interests help the team search and segment contacts for relevant emails, webinars and events.
The system is easier to manage and search, with scope to add event and attendee tracking as it grows.
Could Your Membership Processes Work Better?
If your team relies on spreadsheets to manage members, sponsors and communications, talk to Hatchit about your current processes and what you would like to improve.