📱 Send weekly personalized pet health tips with GPT-4o-mini, Gmail and Google Sheets
⚡ 203 views · 📱 Social Media & Email Marketing
Description
Send personalized pet care tips from Google Sheets with AI
Automate weekly pet wellness emails with AI-generated, location and age-specific advice.
Who’s it for
Pet care businesses, veterinary clinics, pet subscription services, and animal shelters sending regular wellness content to pet owners.
How it works
- Loads pets data from Google Sheets
- Filters pets who haven’t received email in 7+ days
- Calculates age from birthdate (formats as “2 years and 3 months”)
- AI generates tip - GPT-4o-mini creates climate-aware, veterinary-aligned advice based on pet type, age, and location
- Sends email via Gmail or SendGrid
- Updates timestamp in sheet to prevent duplicates
- Logs activity to tracking sheet
Requirements
APIs:
- Google Sheets, Airtable, Typeform or similar
- OpenAI (GPT-4o-mini)
- Gmail OAuth2 OR SendGrid, you can use Brevo, Mailchimp or any other.
Google Sheet Structure:
Sheet 1: Pets
| Owner_Name | Pet_Name | Pet_Type | Date_of_Birth | Country (ISO) | Status | Last_Email_Sent |
|---|
Sheet 2: Email_Log
| Timestamp | Parent_Email | Pet_Name | Tip_Category | Status |
|---|
How to set up
- Create Google Sheet with structure above, add 2-3 test pets.
- Import workflow and add credentials.
- Update nodes:
- “Load Pet Info”: Set your Sheet ID
- “Update Last_Email_Sent Date”: Set Sheet ID
- “Log to Email_Log Sheet”: Set Sheet ID
- Test manually with 1 active pet
- Enable schedule (default: Mondays 9am)
How to customize
Switch email provider:
- Enable “Send via SendGrid” node
- Disable “Send Health Tip using Gmail” node
- Update template ID
Modify AI prompt:
- Edit “Generate Personalized Tip” node
- Adjust temperature
- Add/remove categories
Use cases beyond pets
Same workflow works for:
- Plant care (growth stage tips)
- Baby milestones (age-based parenting advice)
- Fitness coaching (experience level workouts)
- Language learning (study streak motivation)
Just update sheet columns and AI prompt.
Notes
- Choose only one mailing service.
- Country codes use ISO format (US, UK, AU, CA, etc.)
- AI considers location for seasonal advice.
đź”— Nodes Used
Google Sheets, Gmail, SendGrid, Schedule Trigger, OpenAI
đź“Ą Import
Download workflow.json and import into n8n:
Workflow menu → Import from File