Never Forget a Follow-Up Again: Turn Any Email into a Google Calendar Event
Never Forget a Follow-Up Again
How to Turn Any Sent Email into a Google Calendar Event Automatically.
Let’s be honest, the mental to-do list is endless. Whether you’re running a business, managing a household, or both, there are a million tiny tasks to keep track of. For me, one of the most important—and anxiety-inducing—tasks is managing my son’s repeat prescriptions.
I’d send the email request to the GP, and then the mental countdown would begin. Did they receive it? When will it be ready? When should I go to the pharmacy? Adding that worry to an already overflowing plate was stressful. I knew there had to be a better way.
The “Secret Weapon”: A Peek Behind the Curtain
The magic comes from Google Apps Script. It’s the engine that allows for truly custom workflows to be built directly within Google Workspace.
Privacy First
Critically, these scripts process data securely within Google’s ecosystem, making them inherently GDPR-friendly as they adhere to Google’s robust data protection standards.
How I Automate My Son’s Prescriptions:
1. It Watches “Sent”
The script keeps an eye out for any email I send to the GP with a specific subject line. It acts as my digital gatekeeper.
2. It Reads the Date
As soon as I hit “send,” the script wakes up, reads the current date and time, and gets to work instantly.
3. It Does the Maths
It automatically calculates a future date (e.g., 3 working days ahead), intelligently skipping weekends to find the right day.
4. It Creates the Event
Finally, it pops a detailed event into my Google Calendar, titled with the exact medication I need to collect. Job done.
“Before this, my mental to-do list was a disaster. I was constantly worried I’d forget to follow up… Now, sending an email instantly creates a calendar event. It’s given me back hours of time and a huge amount of peace of mind.”
From Prescriptions to Proposals
This automation was a game-changer for my personal peace of mind, but I quickly realised the exact same logic is a powerhouse for business. It can be customised for almost any workflow.
- Sales & Quoting: Automatically schedule a follow-up after sending a proposal.
- Client Onboarding: Email a welcome pack and trigger a series of check-in reminders.
- Project Management: Send a brief to a contractor and create a deadline reminder in your shared calendar.
- E-commerce: Log a customer query from an email into a spreadsheet and set a reminder to check for resolution.
- Personal Finance: Forward a bill and automatically create a payment reminder two days before the due date.
“This automation is a total game-changer for my business… It ensures every single client gets a consistent, professional follow-up without me ever having to remember to do it.”
Ready to Automate Your Peace of Mind?
Stop worrying about things slipping through the cracks.
Free up your mental energy to focus on what truly matters. Each automation I build is bespoke and tailored to your unique workflow.
Let’s build your system.