Google Apps Script读取Gmail正文报错TypeError: Cannot read property "1" from null

Let's break down this issue and fix it step by step—it's a common regex-related pitfall in Apps Script.

What's Causing the Error? #

The TypeError: Cannot read property "1" from null fires when you try to access the second capture group ([1]) of a regex match() result that returned null.

Your static HTML variable works because it contains content that perfectly matches your regex pattern. But when parsing real Gmail messages:

• The email body (HTML or plain text) might not include the pattern you're targeting
• The email's HTML structure could differ from your test content (extra tags, escaped characters, whitespace, etc.)
• Your execution log shows you successfully found a URL initially, so the error comes from a second regex match on line 51 that failed to find a match.

Step-by-Step Solutions #

1. Add Null Checks Before Accessing Capture Groups
   Every time you use match(), verify the result isn't null before pulling values from it. If line 51 looks like this:

   var targetValue = emailBody.match(/your-regex-pattern/)[1];
   

   Rewrite it to handle missing matches gracefully:

   var matchResult = emailBody.match(/your-regex-pattern/);
   if (matchResult) {
     var targetValue = matchResult[1];
     // Proceed with your logic
   } else {
     // Handle the no-match scenario
     SpreadsheetApp.getUi().alert("Could not find the expected pattern in the email.");
     Logger.log("No match found for regex pattern. Raw body: " + emailBody);
     return; // Exit early if needed
   }
   

2. Inspect the Actual Email Body
   Debug why your regex isn't matching by logging the raw email content:

   var emailBody = message.getBody();
   Logger.log("Raw email HTML body: " + emailBody);
   

   Check the execution logs to see the real content—you might spot extra HTML tags, encoded characters, or formatting that's breaking your regex. Adjust your pattern to account for these differences.

3. Try the Plain Text Email Body
   If HTML is too messy, switch to the plain text version of the email:

   var emailBody = message.getPlainBody();
   

   Plain text often has cleaner, more predictable content that's easier to match with regex.

Why Your Log Shows Success But Still Errors #

Your execution log confirms you found a URL and triggered an alert, but the error occurs afterward. This means line 51 runs a separate regex operation that didn't find a match. Applying the null check to that specific match() call will resolve the error.

内容的提问来源于stack exchange，提问作者John Mark