This project automates birthday wishes by integrating Google Apps Script, Google Sheets, and ChatGPT API. It fetches contact details from the user's Google Contacts and sends personalized birthday greetings via email. 🎁 The wishes are randomized using ChatGPT, ensuring every wish feels unique and heartfelt.
Purpose: Automatically imports and updates the contact details into Google Sheets.
Features:
- Fetches data (name, email, birthdate) from the user's Google Contacts.
- Ensures only contacts with both email and birthdate are included.
- Sets missing birth years to
1900(if not provided) to focus on day and month. - Automates sheet updates daily between 11:00 PM and 12:00 AM using a time-driven trigger.
Purpose: Sends personalized birthday greetings via email on the recipient's special day. 🎈
Features:
- Automatically matches the current date with the contact's birthday.
- Uses the OpenAI GPT-3.5-turbo API to generate unique and personalized birthday messages.
- Sends emails with styled HTML content for a professional look.
- Operates seamlessly through a time-driven trigger daily between 12:00 AM and 1:00 AM.
- Option for static birthday wishes (commented-out code for fallback).
- The script fetches contacts from Google Contacts and stores them in Google Sheets.
- Contacts with missing data are skipped to maintain accuracy.
- At midnight, the script checks for birthdays matching the current date.
- If a match is found:
- An API-generated or static birthday wish is prepared.
- The email is sent with a personalized message.
- Everything runs automatically, making it hassle-free for users!
- Google Sheets Integration: Acts as a backend to store and manage contact data.
- OpenAI API: Ensures creative and unique birthday messages.
- Fully Automated Workflow: From fetching contacts to sending greetings.
- Time-Driven Triggers: Keeps the script running without manual intervention.
- Clone the repository:
git clone https://github.com/touhidulislam1999/Birthday-wish-Automation-using-Google-Apps-Script-and-Chatgpt.git