带有双引号的字符串中的Google表格REGEXEXTRACT数值

我在Google工作表单元格B1中有此字符串：

{
  "schedules":[],
  "name": "10000 Stitches",
  "report": { 
    "printtitle": false, 
    "margin":"normal", "notes":false,
    "format":"pdf",
    "horizontal_alignment":"CENTER",
    "vertical_alignment":"TOP",
    "scale":"2",
    "filesettings":"individual",
    "pagenum":false,
    "sheetnames":false,
    "fzc":false,
    "layout":"landscape",
    "sheets": [
      {
        "sheetid":"287088559",
        "active":true,
        "filename":"",
        "cellrange":null
      }
    ],
    "size":"letter",
    "globalfilename":"",
    "gridlines":false,
    "fzr":false
  },
  "active":false,
  "id":3,
  "email": { 
    "body":"<p>attached</p>",
    "text":"",
    "subject": "{%'10000 Stitches'!B1%} payout report for {%'10000 Stitches'!B2%}",
    "to":"{%'10000 Stitches'!B6%}",
    "cc":"",
    "bcc":"",
    "fromname":"EPM Operations",
    "savetodrive":true,
    "drivefolderid":"129szEEvSqGa5D8fi6BVyMEp0bvCmYvTk",
    "bodytype":"html"
  }
}

我正在尝试从中提取数值... "id":3,

我已经尝试过此正则表达式（除其他外）

=REGEXEXTRACT(B1,"id"":(.*)")`

但是继续出现错误：
Function REGEXEXTRACT parameter 2 value "id":(.*)" does not match text of Function REGEXEXTRACT parameter 1 value "".

我不确定数字数据的双引号，冒号，逗号或通配符语法是否正确。我研究了很多stackoverflow线程，但是正在转动我的轮子。任何帮助，将不胜感激。谢谢。