I think you could pull this off with Zapier, it’d just take several Zaps to get everything running.

Say you stuck with the Google Sheet as the primary way to manage the details. Then, you’d likely want to switch how you’re sending the emails. You could send them via Gmail in Zapier, though you’d have to add each new subscriber and that defeats the automation. Better would likely be to add the contacts to an email mailing list app (Mailchimp and Customer.io are two I’ve used a lot, others can work well here too), and then use the Zap to create + trigger sending emails to the whole list.

Then the setup would end up looking like:

• Add details about the event to Google Sheets
• That triggers Zapier to create a Zoom event, then to create a Google Calendar event that includes the Zoom link
• Then it (possibly after a delay) triggers your email list app to send email(s) to your followers about the event (that may take a tad more setup—if using Customer.io, say, you’d trigger an event that then you’d have a separate automation in Customer.io watching for that would send out the emails + calendar invites).
• Finally, you could have a second Zap watching for updates to Google Sheets that then would update the Google Calendar event (though there’s no default way to update the Zoom event) and send a followup email.

That’d get around HubSpot’s limitations, at any rate.

Looks like OnZoom would only work if you wanted to host paid calls, sell tickets, and run them through Zoom’s platform. If the team already has a way to sell tickets (or if you’re running free events), that likely wouldn’t be needed.

Coda could be used to make something that feels more like a unique app specifically for this team’s scheduling needs. What that’d likely look like is:

• You’d connect Zoom, Google Calendar, and Gmail to Coda.
• You’d have a table with “tasks” or “events”, and list the details. Then you’d have a button to create a Google Calendar and Zoom call, and link the task to each of those, with an automation to update the details if the initial task table is updated.
• Then you’d add an automation to send emails via Gmail … perhaps only when one specific column in the tasks table is updated, so you have a bit of a buffer to wait and make sure everything’s perfect before sending the updates.

It’d be a bit similar to the Zap workflow, but a bit more visual, with the benefit of having everything in one dashboard.

I did something like this for a business I ran. Parts of this process described below might help.

I used WooCommerce to sell access to psychologist-led interventions delivered on Zoom. Each course had multiple start dates.

The first zap ran on course creation and created a Zoom meeting, brought the meeting ID back and stored it in a Google Sheet. This info was also sent to the person running the course/programme.

When someone registered for the course, the zap found the corresponding zoom details and emailed them to the customer. I even connected it to Twilio to send an SMS with the details.

For some courses, we send another email requesting more info. For this, we had to do some "calculating" to do. We did this using a custom written 'Code by Zapier' zap.

The user info was also stored on HubspotCRM since we asked for different pieces of information during the programme. Having the data on Hubspot meant we could have everything for that customer in one place.

Coda employee here: This template within the Coda+Zoom template gets you to the stage of automatically creating Zoom links. Adding in the Calendar invite and 4 emails would just be additional buttons in each row (or automations) depending on when you want to create the invites/send the emails.