DEV Community

Cover image for Birthday & Anniversary Wishes Automation AI Agent
Arti Gupta
Arti Gupta

Posted on

Birthday & Anniversary Wishes Automation AI Agent

#devchallenge #runnerhchallenge #ai

This is a submission for the Runner H "AI Agent Prompting" Challenge

What I Built

I built an AI Agent in Runner-H that automates the process of checking upcoming birthdays and anniversaries from a Google Sheet and then:

  1. Sends personalized Gmail email wishes
  2. Prevents duplicate emails by tracking the “Last Sent” date
  3. Logs all sent wishes into a “Log” sheet
  4. Can be extended to send WhatsApp messages and even upload WhatsApp status from a linked Google Photos image

Demo

Video Link: (https://youtu.be/Qy-toaKu5FM)

Runner H chat task Link: (https://runner.hcompany.ai/chat/c52cdbb4-f6a0-46db-bef0-3598f8e78e55/share)

Prompt:
Please use the following Google Sheet for birthday email automation:
🔗 Sheet URL: https://docs.google.com/spreadsheets/d/1t0DAtoThr6pi4UK3KrgKeW7LL0Y-pSyRT8brDywotqE/edit?usp=sharing

Sheet 1: "Birthday List"
Columns:

  • Name
  • Date (format: DD/MM/YYYY)
  • Email
  • Occasion
  • Last Sent

Sheet 2: "Log"
Columns:

  • Name
  • Email
  • Occasion
  • Message Sent
  • Date Sent

Task:

  1. Read the "Birthday List"
  2. For each row:
    • If today's DD/MM matches the "Date" column
    • And "Last Sent" is not today's full date → Send birthday email from artiguptag2@gmail.com → Update "Last Sent" with today's date → Log message in "Log" sheet

Use GmailApp.sendEmail() and format the message as HTML.

How I Used Runner H

I used Runner-H to:

  • Upload and work with a Birthday List Google Sheet file

  • Build a prompt that:

    1. Parses birthdays from the sheet
    2. Compares each row’s date with today’s date
    3. Sends an email using GmailApp.sendEmail() if not already sent today
    4. Updates the Last Sent column and appends a new entry to a Log tab

  • I enhanced the logic with:

    1. Date formatting and matching via Utilities.formatDate
    2. HTML emails with bold names, emojis and line breaks
    3. Logging each message with date and content for proof and audit
    4. Preparing optional columns for WhatsApp number and Photo URL for future expansion

Use Case & Impact

Who needs this?
Anyone who:

  1. Forgets birthdays or anniversaries
  2. Has to send repetitive greeting emails
  3. Wants to build a simple CRM-like birthday/anniversary assistant

Impact:

  1. Saves daily time
  2. Ensures no important dates are missed
  3. Keeps everything logged
  4. Can run automatically each day
  5. Extendable to WhatsApp wishes, status updates, Instagram/facebook story post.

Social Love

Will update with link after sharing on Twitter/LinkedIn/Instagram using #RunnerH

Solo submission by Arti Gupta

Top comments (0)