OpenAI and SendGrid integration

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 | Email | 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.

Qualify and Call Back Inbound Leads with OpenAI, Bland AI, Airtable & SendGrid This n8n template demonstrates how to capture inbound leads from a form, qualify them with OpenAI, and route the hottest ones to a Bland AI voice agent that calls them back, books a meeting on Google Calendar, and confirms by email, all without a human touching the lead. Use cases are many: instant follow-up on paid-ad leads, voice qualification for high-ticket consulting inquiries, or replacing the "first response" SDR seat entirely! Good to know Each Bland AI call is billed per minute. The default max_duration in this template is 5 minutes; see Bland AI pricing for the current rate. OpenAI calls for qualification cost fractions of a cent per lead, but volume adds up; set a budget alert on your OpenAI account if you're running paid traffic. You can also use Claude. Outbound calling is regulated. Make sure you have consent on your form and check the rules for your country (TCPA in the US, PECR in the UK, etc.) before going live. How it works We capture the lead via a webhook; your form, quiz, or landing page posts the payload (name, email, phone, company, plus any qualification fields you collect). A code node normalises the payload, an IF node rejects anything missing required fields, and the lead is written to Airtable so you have a single source of truth. OpenAI is then used to qualify the lead. We give it the cleaned payload and ask it to return one of three next actions: nurture_email, priority_email, or ai_call. Low-intent leads get a SendGrid nurture email. Medium-intent leads get a priority email. High-intent leads continue down to the voice path. For the voice path, we pull free slots from Google Calendar, format them into a natural-speech sentence ("I have Tuesday at 2 or Thursday at 10…"), and POST to Bland AI with the script, the lead's number, and a callback URL. Bland AI calls the lead, runs the script, and posts the outcome back to the second webhook in this same workflow. If a slot was booked, we create the Google Calendar event, update the Airtable record, and send a SendGrid confirmation. If the call failed (no answer, declined, error), we update Airtable and send a priority follow-up email so a human can step in. How to use The webhook trigger is set up for a typical form payload, but feel free to swap it for a Typeform/Tally trigger, a Calendly cancellation, or any inbound source. Tune the prompt inside the AI Lead Qualification node to match your ICP; the routing logic only cares that the model returns one of the three action strings. Edit the voice script inside the Trigger AI Phone Call body to match your company name, agent name, and offer before going live. The Bland AI webhook field inside the request body must point to the production URL of the Call Outcome Webhook node in this same workflow so Bland can post back. Requirements OpenAI account for lead qualification Bland AI account for the outbound voice agent Airtable base with a Leads table SendGrid account for emails Google Calendar for availability and event creation Customising this workflow AI voice follow-up works for plenty of inbound flows beyond sales calls. Try it for booking demos, recovering abandoned checkout carts with a quick "is everything okay?" call, or as a re-engagement layer on stale leads in your CRM.