Send weekly personalized pet health tips with GPT-4o-mini, Gmail and Google Sheets

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

1. Loads pets data from Google Sheets 2. Filters pets who haven't received email in 7+ days 3. Calculates age from birthdate (formats as "2 years and 3 months") 4. AI generates tip - GPT-4o-mini creates climate-aware, veterinary-aligned advice based on pet type, age, and location 5. Sends email via Gmail or SendGrid 6. Updates timestamp in sheet to prevent duplicates 7. 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.