Hey,

\n \n

Just wanted to follow up - your AI receptionist for ${lead.business_name} \n is still ready and waiting.

\n \n

If you had any questions after the demo, just reply to this email.

\n \n

Or if you're ready to go:

\n \n

\n \n Activate Now →\n \n

\n \n

– PhoneAgent

\n `,\n });\n } catch (e) {\n console.error(`Email failed for ${lead.id}:`, e);\n }\n }\n\n // Mark follow-up 1 as sent\n await supabase\n .from(\"leads\")\n .update({ follow_up_1_sent_at: now.toISOString() })\n .eq(\"id\", lead.id);\n\n followUpsSent++;\n }\n\n // ============ FOLLOW-UP 2 (+72h) ============\n // Leads who got follow-up 1 48+ hours ago (72h total), no follow-up 2 yet, not converted\n const { data: followUp2Leads, error: fu2Error } = await supabase\n .from(\"leads\")\n .select(\"*\")\n .not(\"follow_up_1_sent_at\", \"is\", null)\n .is(\"follow_up_2_sent_at\", null)\n .is(\"converted_at\", null)\n .lt(\"signup_link_sent_at\", hours72Ago.toISOString())\n .limit(50);\n\n if (fu2Error) throw fu2Error;\n\n for (const lead of followUp2Leads || []) {\n const signupUrl = `${SIGNUP_BASE_URL}/${lead.id}`;\n\n // Send SMS - final message\n const smsMessage =\n `Last call! Your custom AI receptionist for ${lead.business_name} is ready.\\n\\n${signupUrl}\\n\\nAfter this, we'll assume you're not interested. No hard feelings!`;\n\n try {\n await fetch(\"https://api.retellai.com/v2/send-sms\", {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${RETELL_API_KEY}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n from_number: OUTBOUND_PHONE,\n to_number: lead.phone,\n message: smsMessage,\n }),\n });\n } catch (e) {\n console.error(`SMS failed for ${lead.id}:`, e);\n }\n\n // Send Email - final\n if (lead.email && RESEND_API_KEY !== \"YOUR_RESEND_API_KEY\") {\n try {\n const resend = new Resend(RESEND_API_KEY);\n await resend.emails.send({\n from: \"PhoneAgent \",\n to: lead.email,\n subject: `Last chance - ${lead.business_name} AI receptionist`,\n html: `\n

Hey,

\n \n

This is our last follow-up about the AI receptionist for ${lead.business_name}.

\n \n

If it's not for you, no worries at all. But if you're still interested:

\n \n

\n \n Activate Your Receptionist →\n \n

\n \n

After this, we won't bug you again. Thanks for checking it out!

\n \n

– PhoneAgent

\n `,\n });\n } catch (e) {\n console.error(`Email failed for ${lead.id}:`, e);\n }\n }\n\n // Mark follow-up 2 as sent\n await supabase\n .from(\"leads\")\n .update({ follow_up_2_sent_at: now.toISOString() })\n .eq(\"id\", lead.id);\n\n followUpsSent++;\n }\n\n console.log(`Follow-up cron complete: ${followUpsSent} follow-ups sent`);\n\n return Response.json({\n success: true,\n followUpsSent,\n followUp1Count: followUp1Leads?.length || 0,\n followUp2Count: followUp2Leads?.length || 0,\n });\n } catch (err: any) {\n console.error(\"Follow-up cron error:\", err);\n return Response.json({ success: false, error: err.message }, {\n status: 500,\n });\n }\n}","deleted","label",[99],"permalink","https://www.val.town/x/hamsaomar/followup_cron/code/main.ts","extension","actionData","errors"]