The first battle was converting Microsoft Access into a file type macOS could open in order to convert it to CSV. Once converted, a series of PHP scripts cleaned and aggregated the data so that it could fit within Airtable’s record limit.
Leveraging Shopify, Google Sheets, Memberium, Gravity Forms, Airtable, Infusionsoft, and Zapier, we crafted a seven step automation workflow. The automations are tailored for purchases, submissions, and processing assessments.
With all the data in one place and automations feeding the system, we pushed the essential data through Zapier to Infusionsoft. The support team have access to assessment progress at a glance as well as students through Memberium.