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,
});

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,
});

return linkedin;