[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","hamsaomar","name","followup_cron","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","36344b94-f299-11f0-aa30-42dde27851f2","main.ts","fileId","93a67c4a-f28d-11f0-9636-42dde27851f2","parentId","branchId","506f0d6e-f285-11f0-b33e-42dde27851f2","branchVersion",6,"latest",true,"createdAt",["D",1768540030171],5,"fileType","http","content","// Val.town Function: phoneagent_followup_cron\n// URL will be: https://hamsaomar-phoneagent_followup_cron.web.val.run\n//\n// Purpose: Cron job to send follow-up SMS/Email to leads who got signup link but haven't converted\n// Schedule: Run every hour via Val.town cron or external scheduler\n//\n// Follow-up sequence:\n// - +24h: First follow-up\n// - +72h: Second (final) follow-up\n\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\nimport { Resend } from \"https://esm.sh/resend@2\";\n\nconst SUPABASE_URL = \"https://dkdsoxnxdmsnnwdwnlmq.supabase.co\";\nconst SUPABASE_KEY = \"sb_secret_SdOIWO23hmXHYNsh7kbhEw_muZR3FWs\";\nconst RETELL_API_KEY = \"key_a77efed84db0861a2d47b3d0e841\";\nconst RESEND_API_KEY = \"YOUR_RESEND_API_KEY\"; // TODO: Replace with actual key\nconst OUTBOUND_PHONE = \"+16122300881\";\n\nconst SIGNUP_BASE_URL = \"https://phoneagent.ai/activate\";\n\nexport default async function (req: Request) {\n const supabase = createClient(SUPABASE_URL, SUPABASE_KEY);\n\n const now = new Date();\n const hours24Ago = new Date(now.getTime() - 24 * 60 * 60 * 1000);\n const hours72Ago = new Date(now.getTime() - 72 * 60 * 60 * 1000);\n\n let followUpsSent = 0;\n\n try {\n // ============ FOLLOW-UP 1 (+24h) ============\n // Leads who got signup link 24+ hours ago, no follow-up 1 yet, not converted\n const { data: followUp1Leads, error: fu1Error } = await supabase\n .from(\"leads\")\n .select(\"*\")\n .not(\"signup_link_sent_at\", \"is\", null)\n .is(\"follow_up_1_sent_at\", null)\n .is(\"converted_at\", null)\n .lt(\"signup_link_sent_at\", hours24Ago.toISOString())\n .limit(50); // Process in batches\n\n if (fu1Error) throw fu1Error;\n\n for (const lead of followUp1Leads || []) {\n const signupUrl = `${SIGNUP_BASE_URL}/${lead.id}`;\n\n // Send SMS\n const smsMessage =\n `Hey! Just checking in - your AI receptionist for ${lead.business_name} is still ready to go.\\n\\nActivate here: ${signupUrl}\\n\\nAny questions? Reply to this text.`;\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\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: `Quick follow-up - ${lead.business_name} receptionist`,\n html: `\n

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",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1768540030171],"children",[],[35],"506ed20e-f285-11f0-b33e-42dde27851f2",["D",1768531484246],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","019baa6a-f92f-753f-9af2-f006f98e68db","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019baa6a-f92f-753f-9af2-f76edf09d554","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_114":110},"org",{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zODVZMVA3d25jeDNBOU1RbFRwejB4T2pxRzAifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":148,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":149,"_95":150,"_97":151,"_99":53},[145],"files",[145],"counts",{"_135":77,"_136":137,"_138":77,"_31":139,"_140":141},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":134},[35],"pulls","branches",1,"forks",{"_142":77,"_144":77},"connections",{"_142":77,"_143":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":146,"_18":147},[],[35],["D",1768531484246],{"_11":12,"_114":110},{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_130":185,"_186":187,"_188":189,"_190":53,"_191":53,"_192":53,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":77,"_198":53,"_199":53,"_200":-5,"_201":53,"_202":53,"_203":53,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5a94df3abe1fc7a20cd77b19bfb04bf16e60a929","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Code