Finish/build Airtable + Zapier +Mailchimp+ Outlook automations for a class registration funnel

What you’ll build

Automatic email intake from Outlook:

Zapier watches our Outlook inbox, or a dedicated folder, for emails from our 15 to 30 college contacts. Filter by college email domain, plus an AI check that skips non-registration emails such as logistics questions.

No manual forwarding by staff.

Automatic reading of registrations:

Registrants pasted into the email body as a small table are extracted by an AI step.

Excel roster attachments are converted with Files by Zapier, with no OneDrive needed. An AI step standardizes column headers that differ between colleges.

Added to Airtable and coded correctly:

Loop through each registrant and find or create their record by email, so the same person on several rosters isn’t duplicated.

Tag each record with the correct college, class, cohort, and session dates by linking it to the matching class record.

Flag anything unclear for review and send an Outlook alert.

Added to Mailchimp for our ongoing newsletter:

Add or update each registrant in our Mailchimp audience, with tags for college, class, and cohort so we can segment later.

Respect consent: only registrants who opted in are subscribed, and existing unsubscribes are never overwritten.

Pre-class email automations:

A welcome email on registration with the Zoom link and class PDFs.

Reminders before each of the two Tuesday sessions.

A recap after session 1 with the recording link.

Roster check-in emails to the college contacts 10 days and 3 days before class.

All sent through Outlook, with “sent” tracking so nobody gets duplicates.

Coaching call sync from Calendly to Airtable:

Build personalized Calendly links for each registrant, prefilled with their name, email, and Airtable record ID, to use in the post-class email.

When someone books a coaching call, update their Airtable record with the call date and time, the assigned advisor, and the stage “Call booked.”

When someone cancels, clear the booking and reset their stage so the follow-up reminders start again.

Flag any booking that can’t be matched to a registrant for review.

Deliverables

Working automations, tested against the test cases in our build sheet

A short screen recording walking through each zap and automation

A live handoff session with our operations coordinator, who will maintain it

Requirements

Proven experience with multi-step Zapier builds using Microsoft Outlook, AI by Zapier, Files by Zapier, paths, and looping

Strong Airtable skills, including automations, linked records, and formulas

Experience with Mailchimp and Calendly integrations

Careful handling of personal contact information. We’re a regulated financial firm, and all work happens in our accounts, not yours.

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...

Other Jobs To Apply

Polaris Inc is hiring: Digital Animation Intern in Medina

Neurologist (Remote | $200/hr)

Radiographic Testing/Computed Radiography/Non-Destructive Testing Technician II

Inpatient Coding Specialist, (Remote), Day Shift, Medical Coding

reputed company Production Artist for Remote Hobby Lobby Careers - Graphic Design & Art Department

Regional Sales Operations Manager - EMEA (Remote)

Video Editor/Producer - Remote Entry Level

Senior Medical Records Collector (Remote) (,, United States)

Work from Home Opportunity for Moms

Remote Luxury Fashion Event Account Executive

Senior Director of Marketing (Remote)

Work From Home

Government Travel Advisor Specialists - Sabre Experts ------Remote - Now Hiring

Regional Sales Manager (Remote, Pol)

Client work Deployment Strategist Full‐time Remote (US) View role →

Overnight Remote Customer Support Associate – reputed company Night‑Shift Role with $25‑$35/hr Compensation, No Experience Required, Work‑From‑Home

Online Chat Representative (Remote)

Fractional Accounting Contract

Remote - Graphic Designer (If local to Dallas, Monthly in-office is required)

Technical Director - Remote Work

Healthcare Agent Licensed Trainee (WFH in the following states: AZ. KY. TX. And FL.)

Remote MEDICAL ASSISTANT (FT) REMOTE JOB/WORK FROM HOME - BILINGUAL HIGHLY DESIRED

Program Manager, Government

Remote Norwegian Customer Advisor - Junior

American Remote Jobs, American Express Data Analyst Jobs @ Joblagii ( Senior Analyst )

Remote Outbound Sales Specialist — Flexible Hours

Manager, Care Management – Aetna Better Health of Oklahoma – RN

Delta Airlines Remote Customer Support - Work From Your Own Home

US GAAP CA - FP&A & Financial Reporting (Remote)

Payroll and Benefits Accountant at Innovu: 100% Remote (Pittsburgh, PA)

Netflix Work From Home (Remote) (Software Engineer)

American Airlines Data Entry Clerk (Remote)

Remote Data Entry Specialist – High‑Pay, Flexible Hours, reputed company & Part‑Time Opportunities – Up to $2,500 Weekly Potential

Sales Representative at Sysco: 100% Remote (Lake Saint Louis, MO, O'Fallon, St Peter's, Wentzville)

Remote Full Stack Engineer - Podcast

Remote Salesforce Program Leader - End-to-End Delivery

Underwriting Consultant at Pacific Life: 100% Remote (AZ)

[Hiring] Telehealth RPM @Telenett

The Notary Nomad - Work From Home San Jose, CA

Mechanical Engineer - Fully Remote | Up to $110/hr

Remote Grant Writing Consultant for Municipal Public Works

Remote Part-Time Dental Health Expert

Copy Editor - Fully Remote | Up to $75/hr

Adjunct Faculty, Department of Management - Open Pool

Remote Biology Researcher (PhD) - City and County of San Francisco

Weekend Remote Aesthetic Telehealth NP

Part-Time Educator | Greenwich, CT

TurboTax Product Expert (Work From Home)

Manager, Care Management – Humana Care Support

Per Diem Inpatient RN — Top Pay + $7 Shift Differential