am stuck with a problem, I want send email using amazon SES , suppose when I hit dynamicid.js file mail send method will work, can anyone tell me how can I implement send mail Functionality. If you have any question please free feel to ask.

getdatafromsheet() is the method where email body, status found

If any have any other method sending email via next js google sheet then let me know

SendMail.js

var AWS = require('aws-sdk');
   
 AWS.config.update({ region: process.env.AWS_REGION });
    
    export default function sendMail(Email) {
    
        var result;
        // Create sendEmail params 
        var params = {
            Destination: { /* required */
                CcAddresses: [
                    'harsalpatil512@gmail.com',
                    /* more items */
                ],
                ToAddresses: [
                    'harsalpatil512@gmail.com',
                    /* more items */
                ]
            },
            Message: { /* required */
                Body: { /* required */
                    Html: {
                        Charset: "UTF-8",
                        Data: "HTML_FORMAT_BODY"
                    },
                    Text: {
                        Charset: "UTF-8",
                        Data: "TEXT_FORMAT_BODY"
                    }
                },
                Subject: {
                    Charset: 'UTF-8',
                    Data: 'Test email'
                }
            },
            Source: 'skillup@eddytools.com', /* required */
            ReplyToAddresses: [
                'harsalpatil512@gmail.com',
                /* more items */
            ],
        };
    
        // Create the promise and SES service object
        var sendPromise = new AWS.SES({ apiVersion: '2010-12-01' }).sendEmail(params).promise();
    
        // Handle promise's fulfilled/rejected states
        sendPromise.then(
            function (data) {
                result = 'Success';
            }).catch(
                function (err) {
                   result = 'Failed';
                });
    }

DynamicId.js

import { getDataFromSheets } from "../../libs/sheets";
import sendMail from '../ses/sendmail';

export default function handler(req, res) {
  var data;
  getDataFromSheets()
    .then(sheet => {
      data = sheet.length
      for(var i = 0;i<data;i++){
        console.log(sheet[i+1].Email)
      }
    })
    .catch(err => console.log(err))

}