Your Pricing Report is Ready! 📊

\n \n

\n Great news! We've finished processing your transcript and your personalized pricing report is now available.\n

\n \n

What's in your report:

AI-powered analysis of your transcript
Key insights and recommendations
Professional summary of important points
Action items and next steps

\n \n

\n \n View Your Report\n \n

\n \n

\n This link will expire in 2 weeks for security purposes.\n

\n \n

\n If you have any questions, please don't hesitate to reach out to our team.\n

\n `;\n\n const textContent = `\nYour Pricing Report is Ready!\n\nGreat news! We've finished processing your transcript and your personalized pricing report is now available.\n\nWhat's in your report:\n• AI-powered analysis of your transcript\n• Key insights and recommendations \n• Professional summary of important points\n• Action items and next steps\n\nView your report here: ${reportUrl}\n\nThis link will expire in 2 weeks for security purposes.\n\nIf you have any questions, please don't hesitate to reach out to our team.\n `;\n\n const { data, error } = await resend.emails.send({\n from: \"Lightswitch \",\n to: [customerEmail],\n subject: \"Your Pricing Report is Ready! 📊\",\n html: htmlContent,\n text: textContent,\n });\n\n if (error) {\n console.error(\"Resend error:\", error);\n throw error;\n }\n\n console.log(\"Customer notification email sent successfully:\", data);\n return data;\n } catch (error) {\n console.error(\"Failed to send customer notification email:\", error);\n throw error;\n }\n}\nasync function saveFinalReport(summary: string, email: string, openaiThreadId: string) {\n try {\n const { data, error } = await supabase\n .from(\"final_reports\")\n .insert([\n {\n body: summary,\n email: email,\n openai_thread_id: openaiThreadId,\n },\n ])\n .select(); // Add select() to return the inserted record\n\n if (error) {\n console.error(\"Supabase error saving final report:\", error);\n throw error;\n }\n\n console.log(\"Summary saved to Supabase final_reports table:\", data);\n\n // Return the inserted record (data[0] contains the record with ID)\n return data[0];\n } catch (error) {\n console.error(\"Failed to save summary to final_reports:\", error);\n throw error;\n }\n}\n\n// Main endpoint for submitting transcripts\napp.post(\"/api/submit\", async (c) => {\n try {\n const body = await c.req.json();\n\n if (!body.text || typeof body.text !== \"string\") {\n return c.json({ error: \"Text field is required and must be a string\" }, 400);\n }\n\n if (!body.email || typeof body.email !== \"string\") {\n return c.json({ error: \"Email field is required and must be a string\" }, 400);\n }\n\n const timestamp = new Date().toISOString();\n const subject = `Text Submission - ${timestamp}`;\n\n // Email content\n const htmlContent = `\n

Text Submission

Submitted at: ${timestamp}

From: ${body.email}

Content:

${body.text}

Submitted via API

\n `;\n\n const textContent = `\nText Submission\n\nSubmitted at: ${timestamp}\nFrom: ${body.email}\n\nContent:\n${body.text}\n\n---\nSubmitted via API\n `;\n\n // Send email to all recipients\n const emailPromises = EMAIL_RECIPIENTS.map(recipient =>\n email({\n to: recipient,\n subject: subject,\n text: textContent,\n html: htmlContent,\n })\n );\n\n await Promise.all(emailPromises);\n\n // Save transcript to Supabase\n try {\n await saveTranscript(body.text, body.email, timestamp);\n } catch (supabaseError) {\n console.error(\"Failed to save to Supabase, but email was sent:\", supabaseError);\n // Continue execution - don't fail the request if Supabase fails\n }\n\n // Summarize transcript with OpenAI and save to final_reports\n try {\n console.log(\"Starting OpenAI summarization...\");\n const summaryResult = await summarizeTranscript(body.text);\n\n console.log(\"Saving summary to final_reports...\");\n const finalReport = await saveFinalReport(summaryResult.summary, body.email, summaryResult.completionId);\n\n console.log(\"Creating pricing wizard token...\");\n const tokenResult = await savePricingWizardToken(finalReport.id);\n\n console.log(\"Sending customer notification email...\");\n await sendCustomerNotification(body.email, tokenResult.token);\n\n console.log(\"Summary process completed successfully\");\n } catch (aiError) {\n console.error(\n \"Failed to summarize, save final report, or send customer notification, but email and transcript were saved:\",\n aiError,\n );\n // Continue execution - don't fail the request if AI processing fails\n }\n\n return c.json({\n success: true,\n message:\n `Message sent successfully to ${EMAIL_RECIPIENTS.length} recipients, saved to database, processed with AI summary, and customer notification sent`,\n recipients: EMAIL_RECIPIENTS,\n timestamp: timestamp,\n email: body.email,\n });\n } catch (error) {\n console.error(\"Error sending message:\", error);\n return c.json({ error: \"Failed to send message\" }, 500);\n }\n});\n\nexport default app.fetch;","deleted","label",[98],"permalink","https://www.val.town/x/sunnyatlightswitch/send-transcripts/code/main.tsx","extension","actionData","errors"]