Retool as Your AI Email Approval Dashboard

"cm">// Retool REST API Query
"cm">// Resource: MultiMail (Base URL: https://api.multimail.dev)
"cm">// Method: GET
"cm">// Endpoint: /v1/pending
"cm">// Headers: Authorization: Bearer {{ retoolContext.environmentVariables.MULTIMAIL_API_KEY }}
"cm">// URL params:
"cm">//   limit: 50
"cm">//   mailbox: [email protected]

"cm">// Bind to a Table component:
"cm">// data source: {{ getPendingEmails.data.emails }}
"cm">// columns: id, to, subject, created_at, metadata.agent_id, body_preview

"cm">// Retool JavaScript Query — triggered by button onClick
const emailId = table1.selectedRow.data.id;
const decision = self.name === 'approveBtn' ? 'approve' : 'reject';
const reason = decision === 'reject' ? rejectReasonInput.value : undefined;

const response = await fetch(
  `https:"cm">//api.multimail.dev/v1/emails/${emailId}/decide`,
  {
    method: 'POST',
    headers: {
      'Authorization': `Bearer ${retoolContext.environmentVariables.MULTIMAIL_API_KEY}`,
      'Content-Type': 'application/json'
    },
    body: JSON.stringify({
      decision,
      reason,
      reviewer_id: current_user.email
    })
  }
);

if (!response.ok) {
  const err = await response.json();
  throw new Error(`decide_email failed: ${err.error}`);
}

"cm">// Refresh the queue table
await getPendingEmails.trigger();

"cm">// Retool REST API Query — triggered by table1.onRowClick
"cm">// Method: GET
"cm">// Endpoint: /v1/emails/{{ table1.selectedRow.data.id }}
"cm">// Headers: Authorization: Bearer {{ retoolContext.environmentVariables.MULTIMAIL_API_KEY }}

"cm">// In the Drawer component, bind:
"cm">// Text: emailSubject  → {{ getEmailDetail.data.subject }}
"cm">// Text: emailTo       → {{ getEmailDetail.data.to }}
"cm">// HTML: emailBody     → {{ getEmailDetail.data.body_html }}
"cm">// Text: agentId       → {{ getEmailDetail.data.metadata.agent_id }}
"cm">// Text: sentAt        → {{ getEmailDetail.data.created_at }}

"cm">// Retool Workflow — Start Trigger: every 5 minutes

"cm">// Step 1: Query MultiMail pending count
const resp = await fetch(
  'https://api.multimail.dev/v1/pending?limit=1',
  { headers: { 'Authorization': `Bearer ${workflow.environment.MULTIMAIL_API_KEY}` } }
);
const { total_pending } = await resp.json();

"cm">// Step 2: Branch — skip if queue is healthy
if (total_pending < 5) return { skipped: true, total_pending };

"cm">// Step 3: Notify via Retool Slack resource
await slackResource.postMessage({
  channel: '#ops-email-review',
  text: `*MultiMail approval queue*: ${total_pending} emails waiting.\n` +
        `<https:"cm">//acme.retool.com/apps/email-review|Open review app>`
});

"cm">// Retool JavaScript Query — triggered by form submit button
const payload = {
  from: '[email protected]',
  to: recipientInput.value,
  subject: subjectInput.value,
  body: bodyInput.value,
  tags: ['manual', 'ops-initiated']
};

const response = await fetch('https://api.multimail.dev/v1/emails/send', {
  method: 'POST',
  headers: {
    'Authorization': `Bearer ${retoolContext.environmentVariables.MULTIMAIL_API_KEY}`,
    'Content-Type': 'application/json'
  },
  body: JSON.stringify(payload)
});

const result = await response.json();

if (result.id) {
  utils.showNotification({
    title: 'Sent',
    description: `Message ID: ${result.id}`,
    notificationType: 'success'
  });
  form1.reset();
} else {
  utils.showNotification({
    title: 'Failed',
    description: result.error,
    notificationType: 'error'
  });
}