Send weekly personalized pet health tips with GPT-4o-mini, Gmail and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 13 nodes and runs on a schedule (every week at 09:00). Along the way it connects OpenAI, Gmail, SendGrid and Google Sheets.
How it runs
Trigger: On a schedule (every week at 09:00).
- Load Pet Info (Google Sheets): uses Google Sheets
- Filter: Active + 7-Day Check (Code): runs custom JavaScript code
- Process Pets One-by-One (Loop Over Items (Split in Batches)): loops over the items in batches
- Calculate Pet Age (Code): runs custom JavaScript code
- Generate Personalized Tip (OpenAI): uses OpenAI
- Format Email Data (Code): runs custom JavaScript code
- Send via SendGrid (Disabled) (SendGrid): work with mail
- Send Health Tip using Gmail (Gmail): uses Gmail
- Update Last_Email_Sent Date (Google Sheets): append or update
- Log to Email_Log Sheet (Google Sheets): append or update
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- OpenAI
@n8n/n8n-nodes-langchain.openAi - No Operation, do nothing
n8n-nodes-base.noOp - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - SendGrid
n8n-nodes-base.sendGrid - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait
From the author
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…