Help with sending two scheduled emails from Google sheets using Mandrill (Zapier setup)

Hi, I’m new to Zapier, and learning. I am trying to setup a Zap to send two transactional emails using Mandrill (Mailchimp) based on a contact list from Google Sheets. I’ve set up the following steps so far:

1. Google Sheets Trigger – new row triggers the zap.
2. Formatter by Zapier (Text) – format the email content.
3. Formatter by Zapier (Date/Time) – convert the scheduled time into UTC format for Mandrill's send_at field.
4. Mailchimp Transactional – send the email via Mandrill.
   
   The co pilot mentioned Reshape API?

I’m facing a challenge:

• How do I send two emails at specific times to a list of contacts using Google Sheets, while ensuring they’re sent at the scheduled times?
   
• Should I manually trigger the emails or schedule them using send_at in Zapier?

Here’s what Mailchimp support said when I asked about scheduling emails with Mandrill:
 

"Hey,
I’d be happy to clarify.
Scheduling Emails in Mandrill
Mandrill doesn’t have a built-in scheduler like Mailchimp Marketing, but you can schedule emails using the send_at parameter in your API request. This allows you to specify a future date and time (in UTC) for your email to be sent. Here's an example of how you’d include it in your API call:
{
"key": "YOUR_API_KEY",
"message": {
"html": "<p>Hello, this is a scheduled email!</p>",
"subject": "Scheduled Email",
"from_email": "you@example.com",
"to": [
{
"email": "recipient@example.com",
"type": "to"
}
]
},
"send_at": "2025-02-20 12:00:00"
}
Make sure the time format follows YYYY-MM-DD HH:MM:SS in UTC.
Sending to Mailchimp Audience Contacts via Mandrill
Mandrill is designed for transactional emails, meaning it doesn’t pull directly from your Mailchimp audience. If you need to send emails to your Mailchimp audience using Mandrill, you’ll need to:
Export your audience from Mailchimp – You can do this under Audience > All contacts > Export Audience.
Use your system or a script to send through Mandrill – Since Mandrill is API-based, you’d need to build a process that imports your contacts and sends messages to them."

Any guidance on how to manage sending the two emails at different times would be greatly appreciated!

Thanks in advance!