I then used a Google Drive "Upload" module to save a copy of the pdf and a "Delete" module to remove the google slide file.
Finally, I updated the Airtable record, checking the "Certificate Sent?" box and attached the Google Drive link of the certificate for future reference.
Weekly Challenge!!!!
CHALLENGE:
Automate sending certificates to students using https://t.co/ueVKQkeJj8.
Goal:
Build a workflow that takes student name and automatically generates and emails personalized certificates.
MY SOLUTION👇👇
I designed a certificate template with dynamic tags using google slides.
Then I passed their details to a Google Slides module to generate a personalized certificate for each student which is then converted to pdf and sent to each student
Part of an automation group where we do weekly challenges...this week is a project using airtable.
The week is almost ending and I am just starting mine.
Fingers crossed🤞
I hope I'll be able to complete it by tomorrow
CHALLANGE:
A growing agency needs an Airtable expert to build a centralized system for managing multiple clients. The system must organize content, assign team tasks, track progress, and automate approval notifications to streamline their social media workflow.
MY SOLUTION: 👇
I decided to take planning and tracking my finances in 2026 seriously.
Built a notion template for this... very sleek and easy to use on the phone.
You do not need to click through multiple pages to update your finances, everything is on the first page.
I loveee it!!
My AI Receptionist for BioSmile Clinic is completed ✅
When a client calls in to book an appointment, the agent checks if the date is available, books the appointment and then sends out a confirmation email to client once successfully logged on the calendar.
Breakdown below ↓
@JeanA1423031 Hi jean, sorry for the late response.
For my knowledge base, I used google docs to put it together. I broke down information about how that specific company operates and also sourced for information pertaining to dental clinic practices as a whole....took me about a week
book appointment tool which books the appointment and send a confirmation email to client.
↓
If proposed time is not free, agent suggest other available times within the same day and if the whole day is occupied, agent asks client to choose another day preferably the next day
Client calls and gives proposed date for appointment, check availability tool is triggered
↓
If date is Sunday, agent tells client Sunday is closed else it checks the calendar to see if time is free
↓
If time is free, agent tells client time is free then triggers 👇
@elewachii I'm trying to get my head around something similar but the logic is not "logic'ing". Would you be showing a visual explanation anytime soon?