Cannot read properties of undefined (reading 'result')

export const Route = createFileRoute("/success")({
  component: RouteComponent,
  validateSearch: z.object({
    sessionId: z.string(),
    editionId: z.string(),
  }),
  beforeLoad: async ({ search }) => {
    const { sessionId, editionId } = search;
    try {
      const stripe = new Stripe(env.STRIPE_SECRET_KEY, {
        apiVersion: "2025-02-24.acacia",
      });

      async function getSession() {
        const maxRetries = 5;
        const baseDelay = 500; //

        for (let attempt = 0; attempt < maxRetries; attempt++) {
          try {
            const session = await stripe.checkout.sessions.retrieve(sessionId);
            return session;
          } catch (error) {
            if (attempt === maxRetries - 1) throw error;

            // Exponential backoff: 1s, 2s, 4s
            const delay = baseDelay * Math.pow(2, attempt);
            await new Promise((resolve) => setTimeout(resolve, delay));
          }
        }
      }

      const session = await getSession();
      if (!session) {
        throw redirect({ href: env.ERROR_PAGE_URL });
      }
// continues below 

export const Route = createFileRoute("/success")({
  component: RouteComponent,
  validateSearch: z.object({
    sessionId: z.string(),
    editionId: z.string(),
  }),
  beforeLoad: async ({ search }) => {
    const { sessionId, editionId } = search;
    try {
      const stripe = new Stripe(env.STRIPE_SECRET_KEY, {
        apiVersion: "2025-02-24.acacia",
      });

      async function getSession() {
        const maxRetries = 5;
        const baseDelay = 500; //

        for (let attempt = 0; attempt < maxRetries; attempt++) {
          try {
            const session = await stripe.checkout.sessions.retrieve(sessionId);
            return session;
          } catch (error) {
            if (attempt === maxRetries - 1) throw error;

            // Exponential backoff: 1s, 2s, 4s
            const delay = baseDelay * Math.pow(2, attempt);
            await new Promise((resolve) => setTimeout(resolve, delay));
          }
        }
      }

      const session = await getSession();
      if (!session) {
        throw redirect({ href: env.ERROR_PAGE_URL });
      }
// continues below 

 const cols: Customer = {
        edition_id: editionId,
        email:
          session.customer_email ??
          session.customer_details?.email ??
          "No email",
        name: session.customer_details?.name ?? "No name",
        preinscription_amount: ((session.amount_total || 0) / 100).toFixed(2),
        status: session.payment_status ?? "unknown",
        last_update: new Date().toISOString(),
        stripe_payment_id:
          typeof session.payment_intent === "string"
            ? session.payment_intent
            : session.id,
        // preinscription_currency: session.currency || "EUR",
      };
      if (cols.status !== "paid") {
        console.log("Payment not successful");
        console.log(session);
        throw redirect({ href: env.ERROR_PAGE_URL });
      }

      await sendPreinscriptionEmail({
        name: session.customer_details?.name,
        email: cols.email,
        editionId,
        templateId: env.PREINSCRIPTION_EMAIL_TEMPLATE_ID,
      });

      console.log("SENT EMAIL");

      try {
        await updateCustomersList(cols);
      } catch (e) {
        console.error(e);
        throw redirect({ href: env.SUCCESS_PAGE_URL });
      }
    } catch (error) {
      console.error(error);
      throw redirect({ href: env.ERROR_PAGE_URL });
    }
    throw redirect({ href: env.SUCCESS_PAGE_URL });
  },
});

function RouteComponent() {
  return <div>Loading...</div>;
}

 const cols: Customer = {
        edition_id: editionId,
        email:
          session.customer_email ??
          session.customer_details?.email ??
          "No email",
        name: session.customer_details?.name ?? "No name",
        preinscription_amount: ((session.amount_total || 0) / 100).toFixed(2),
        status: session.payment_status ?? "unknown",
        last_update: new Date().toISOString(),
        stripe_payment_id:
          typeof session.payment_intent === "string"
            ? session.payment_intent
            : session.id,
        // preinscription_currency: session.currency || "EUR",
      };
      if (cols.status !== "paid") {
        console.log("Payment not successful");
        console.log(session);
        throw redirect({ href: env.ERROR_PAGE_URL });
      }

      await sendPreinscriptionEmail({
        name: session.customer_details?.name,
        email: cols.email,
        editionId,
        templateId: env.PREINSCRIPTION_EMAIL_TEMPLATE_ID,
      });

      console.log("SENT EMAIL");

      try {
        await updateCustomersList(cols);
      } catch (e) {
        console.error(e);
        throw redirect({ href: env.SUCCESS_PAGE_URL });
      }
    } catch (error) {
      console.error(error);
      throw redirect({ href: env.ERROR_PAGE_URL });
    }
    throw redirect({ href: env.SUCCESS_PAGE_URL });
  },
});

function RouteComponent() {
  return <div>Loading...</div>;
}

export async function getDoc(docId: string) {
  const serviceAccountAuth = new JWT({
    // env var values here are copied from service account credentials generated by google
    // see "Authentication" section in docs for more info
    email: env.GOOGLE_SERVICE_ACCOUNT_EMAIL,
    key: env.GOOGLE_PRIVATE_KEY,
    scopes: ["https://www.googleapis.com/auth/spreadsheets"],
  });

  const doc = new GoogleSpreadsheet(
    env.GOOGLE_SHEET_DOC_ID,
    serviceAccountAuth
  );

  await doc.loadInfo(); // loads document properties and worksheets
  return doc;
}

export async function updateCustomersList(cols: Customer) {
    const doc = await getDoc(env.GOOGLE_SHEET_DOC_ID);
      const sheet = doc.sheetsByTitle[env.CUSTOMER_LIST_GOOGLE_SHEET_PAGE];
      // await sheet.loadHeaderRow();
      await sheet.addRow(cols);
}

export async function getDoc(docId: string) {
  const serviceAccountAuth = new JWT({
    // env var values here are copied from service account credentials generated by google
    // see "Authentication" section in docs for more info
    email: env.GOOGLE_SERVICE_ACCOUNT_EMAIL,
    key: env.GOOGLE_PRIVATE_KEY,
    scopes: ["https://www.googleapis.com/auth/spreadsheets"],
  });

  const doc = new GoogleSpreadsheet(
    env.GOOGLE_SHEET_DOC_ID,
    serviceAccountAuth
  );

  await doc.loadInfo(); // loads document properties and worksheets
  return doc;
}

export async function updateCustomersList(cols: Customer) {
    const doc = await getDoc(env.GOOGLE_SHEET_DOC_ID);
      const sheet = doc.sheetsByTitle[env.CUSTOMER_LIST_GOOGLE_SHEET_PAGE];
      // await sheet.loadHeaderRow();
      await sheet.addRow(cols);
}