Google Apps Script Development
That Actually Works

function processInvoiceEmails() {
  const threads = GmailApp.search(
    'subject:invoice has:attachment'
  );

  threads.forEach(thread => {
    const messages = thread.getMessages();
    messages.forEach(msg => {
      if (!msg.isStarred()) {
        const attachments = msg.getAttachments();
        attachments.forEach(att => {
          if (att.getContentType() ===
              'application/pdf') {
            // Extract and log invoice data
            const data = extractInvoiceData(att);
            logToSheet(data);
            msg.star(); // Mark as processed
          }
        });
      }
    });
  });
}