Welcome to Orange Slice

// Get prospect data from other columns in the current row
const name = ctx.thisRow.get("Name");
const company = ctx.thisRow.get("Company");
const title = ctx.thisRow.get("Title");

// Generate personalized outreach message
const outreach = await services.ai.generateText({
   prompt: `Write a personalized cold email to ${name}, ${title} at ${company}. 
   Keep it under 100 words and focus on how we help sales teams save time.`,
   model: "gpt-5-mini",
});

return outreach.text;

// Combine ctx (reading cells) with services (enrichment)
const name = ctx.thisRow.get("Name");
const company = ctx.thisRow.get("Company");

const linkedin = await services.person.linkedin.findUrl({
   name,
   company,
});

// Enrich the profile and store data
if (linkedin) {
   const profile = await services.person.linkedin.enrich({ url: linkedin });
   ctx.thisRow.set({
      "LinkedIn URL": linkedin,
      Title: profile.job_title,
      Location: profile.location_city,
   });
}

return linkedin;

// Receive form submissions or API webhooks
console.log(`Received ${webhook.method} request from ${webhook.ip}`);

// Automatically add webhook data to a sheet
webhook.addRootFieldsToSheet("Leads", true);

// Or process manually with custom logic
await ctx.sheet("Leads").addRow({
   email: webhook.body.email,
   name: webhook.body.name,
   source: webhook.query.source || "website",
   received_at: new Date(webhook.receivedAt).toISOString(),
});

return { success: true };

// Find a prospect's LinkedIn profile
const name = ctx.thisRow.get("Name");
const company = ctx.thisRow.get("Company");

const linkedin = await services.person.linkedin.findUrl({
   name,
   company,
});

ctx.thisRow.set({ "LinkedIn URL": linkedin });
return linkedin;