The latest articles on Forem by Arti Gupta (@arti_gupta). https://forem.com/arti_gupta https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3326053%2F629c82d5-f8c6-4a72-a2eb-d1c2456c6254.png https://forem.com/arti_gupta en Arti Gupta Sun, 06 Jul 2025 11:37:28 +0000 https://forem.com/arti_gupta/birthday-anniversary-wishes-automation-ai-agent-55le https://forem.com/arti_gupta/birthday-anniversary-wishes-automation-ai-agent-55le <p><em>This is a submission for the <a href="https://dev.to/challenges/runnerh">Runner H "AI Agent Prompting" Challenge</a></em></p> <h2> What I Built </h2> <p>I built an AI Agent in Runner-H that automates the process of checking upcoming birthdays and anniversaries from a Google Sheet and then:</p> <ol> <li>Sends personalized Gmail email wishes</li> <li>Prevents duplicate emails by tracking the “Last Sent” date</li> <li>Logs all sent wishes into a “Log” sheet</li> <li>Can be extended to send WhatsApp messages and even upload WhatsApp status from a linked Google Photos image</li> </ol> <h2> Demo </h2> <p>Video Link: (<a href="https://youtu.be/Qy-toaKu5FM" rel="noopener noreferrer">https://youtu.be/Qy-toaKu5FM</a>)</p> <p>Runner H chat task Link: (<a href="https://runner.hcompany.ai/chat/c52cdbb4-f6a0-46db-bef0-3598f8e78e55/share" rel="noopener noreferrer">https://runner.hcompany.ai/chat/c52cdbb4-f6a0-46db-bef0-3598f8e78e55/share</a>)</p> <p>Prompt: <br> Please use the following Google Sheet for birthday email automation:<br> 🔗 Sheet URL: <a href="https://docs.google.com/spreadsheets/d/1t0DAtoThr6pi4UK3KrgKeW7LL0Y-pSyRT8brDywotqE/edit?usp=sharing" rel="noopener noreferrer">https://docs.google.com/spreadsheets/d/1t0DAtoThr6pi4UK3KrgKeW7LL0Y-pSyRT8brDywotqE/edit?usp=sharing</a></p> <p>Sheet 1: "Birthday List"<br> Columns:</p> <ul> <li>Name</li> <li>Date (format: DD/MM/YYYY)</li> <li>Email</li> <li>Occasion</li> <li>Last Sent</li> </ul> <p>Sheet 2: "Log"<br> Columns:</p> <ul> <li>Name</li> <li>Email</li> <li>Occasion</li> <li>Message Sent</li> <li>Date Sent</li> </ul> <p>Task:</p> <ol> <li>Read the "Birthday List"</li> <li>For each row: <ul> <li>If today's DD/MM matches the "Date" column</li> <li>And "Last Sent" is not today's full date → Send birthday email from <a href="mailto:artiguptag2@gmail.com">artiguptag2@gmail.com</a> → Update "Last Sent" with today's date → Log message in "Log" sheet</li> </ul> </li> </ol> <p>Use GmailApp.sendEmail() and format the message as HTML.</p> <h2> How I Used Runner H </h2> <p>I used Runner-H to:</p> <ul> <li>Upload and work with a Birthday List Google Sheet file </li> <li> <p>Build a prompt that:</p> <ol> <li>Parses birthdays from the sheet</li> <li>Compares each row’s date with today’s date</li> <li>Sends an email using GmailApp.sendEmail() if not already sent today</li> <li>Updates the Last Sent column and appends a new entry to a Log tab</li> </ol> </li> <li> <p>I enhanced the logic with:</p> <ol> <li>Date formatting and matching via Utilities.formatDate</li> <li>HTML emails with bold names, emojis and line breaks </li> <li>Logging each message with date and content for proof and audit</li> <li>Preparing optional columns for WhatsApp number and Photo URL for future expansion</li> </ol> </li> </ul> <h2> Use Case &amp; Impact </h2> <p>Who needs this?<br> Anyone who:</p> <ol> <li>Forgets birthdays or anniversaries</li> <li>Has to send repetitive greeting emails</li> <li>Wants to build a simple CRM-like birthday/anniversary assistant</li> </ol> <p>Impact:</p> <ol> <li>Saves daily time</li> <li>Ensures no important dates are missed</li> <li>Keeps everything logged</li> <li>Can run automatically each day</li> <li>Extendable to WhatsApp wishes, status updates, Instagram/facebook story post.</li> </ol> <h3> Social Love </h3> <p>Will update with link after sharing on Twitter/LinkedIn/Instagram using #RunnerH</p> <p>Solo submission by Arti Gupta</p> devchallenge runnerhchallenge ai