Forward Gmail emails to Quickbooks using a Google Script.

README.md

1. In Project Settings, enable Show appsscript.json manifest file in editor
2. Create a new project with the below Code.gs script on https://script.google.com
3. Modify the appsscript.json with the below script
4. In Triggers, setup a trigger to run your function every hour.

For a detailed approach, this code was inspired from this article: https://www.gozynta.com/blog/posts/quickbooks-online-gmail-receipt-forwarding/

appsscript.json

{
  "timeZone": "America/Toronto",
  "dependencies": {
    "enabledAdvancedServices": [
         {
            "userSymbol": "Gmail",
            "serviceId": "gmail",
            "version": "v1"
         }
      ]
  },
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8",
  "oauthScopes": [
      "https://www.googleapis.com/auth/userinfo.email",
      "https://www.googleapis.com/auth/gmail.modify",
      "https://mail.google.com/"
   ]
}

Code.gs

// create a script on https://script.google.com/

function processReceipts() {
  const userEmail = Session.getActiveUser().getEmail().toLowerCase();
  const newReceiptsLabel = GmailApp.getUserLabelByName('receipts-unprocessed');
  const processedReceiptsLabel = GmailApp.getUserLabelByName('receipts-processed');
  const destinationEmail = "[email protected]"

  console.log(`Running as ${userEmail}`);

  const threads = newReceiptsLabel.getThreads();

  console.log(`Number of threads to process: ${threads.length}`)

  for (const thread of threads) {
    for (const message of thread.getMessages()) {
      if (!message.getFrom().toLowerCase().includes('<' + userEmail + '>')) {
        console.log(`From: ${message.getFrom()} Subject: ${message.getSubject()} Date: ${message.getDate()}`);
        message.forward(destinationEmail, { from: userEmail });
        message.markRead();
      }
    }
    thread.addLabel(processedReceiptsLabel);
    thread.removeLabel(newReceiptsLabel);
  }
}