Resend Email

[scottklein7]

Hello all!

I currently have some code that will check in on users who have not signed in, in over 7 days or have not signed at all, by sending an email with a link to our login page using resend. Ideally we would like that login link sign them in, magic link style, but not sure how to do that using the send email functionality portion of resend.

My code is below, let me know if there is a better approach!

import VercelInviteUserEmail from '@/components/email-template'
import { createClient } from '@supabase/supabase-js'
import { NextRequest, NextResponse } from 'next/server'
import * as React from 'react'
import { Resend } from 'resend'

const resend = new Resend('re_TxcSeenq_Bjwj8CBkkBb7cqbWqkj3tQ4z')

export async function GET(req: NextRequest) {
  const authToken = (req.headers.get('authorization') || '').split('Bearer ').at(1)

  // if not found OR the bearer token does NOT equal the CRON_SECRET
  if (!authToken || authToken != process.env.CRON_SECRET) {
    return NextResponse.json(
      { error: 'Unauthorized' },
      {
        status: 401
      }
    )
  }
  //here
  try {
    const supabase = createClient(
      process.env.NEXT_PUBLIC_SUPABASE_URL || '',
      process.env.SUPABASE_SERVICE_ROLE_KEY || ''
    )
    // Attempt to list users from Supabase
    const { data: usersData, error: usersError } = await supabase.auth.admin.listUsers()

    if (usersError) {
      throw new Error(`Supabase error: ${usersError.message}`)
    }

    const usersToNotify: string[] = [] // Initialize an empty array to hold user emails

    // Use forEach to iterate and conditionally push user emails to the array
    usersData.users.forEach((user) => {
      const lastSignInDate = user.last_sign_in_at ? new Date(user.last_sign_in_at) : null
      const currentDate = new Date()
      const oneWeekAgo = new Date(currentDate.getTime() - 7 * 24 * 60 * 60 * 1000)

      if (!lastSignInDate || lastSignInDate < oneWeekAgo) {
        if (user.email) {
          usersToNotify.push(user.email) // Push this user's email into the array
        }
      }
    })

    if (usersToNotify.length > 0) {
      const { data: emailData, error: emailError } = await resend.emails.send({
        from: '',
        to: [''],
        bcc: usersToNotify,
        subject: 'Sign In!',
        react: VercelInviteUserEmail() as React.ReactElement
      })

      if (emailError) {
        throw new Error(`Email sending error: ${emailError.message}`)
      }
    }

    return NextResponse.json({
      status: 200
    })
  } catch (error) {
    // Catch and return any error that occurs during the process
    return NextResponse.json({
      status: 400,
      message: `An error occurred: ${JSON.stringify(error)}`
    })
  }
}