{"image_url":null,"type":"rich","width":"100%","author_url":"https://blog.hatena.ne.jp/wannabe-jellyfish/","provider_url":"https://hatena.blog","blog_url":"https://memory-lovers.blog/","categories":["GoogleSpreadSheet"],"url":"https://memory-lovers.blog/entry/2021/07/02/120744","version":"1.0","blog_title":"\u304f\u3089\u3052\u306b\u306a\u308a\u305f\u3044\u3002","height":"190","author_name":"wannabe-jellyfish","provider_name":"Hatena Blog","published":"2021-07-02 12:07:44","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmemory-lovers.blog%2Fentry%2F2021%2F07%2F02%2F120744\" title=\"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eURL\u304b\u3089spreadsheetId\u3068sheetId\u3092\u53d6\u5f97\u3059\u308b - \u304f\u3089\u3052\u306b\u306a\u308a\u305f\u3044\u3002\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"Google Sheets API\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u898b\u308b\u3068\u3001\u3053\u3093\u306a\u611f\u3058\u3089\u3057\u3044 https://docs.google.com/spreadsheets/d/<spreadsheetId>/edit#gid=<sheetId> \u4f7f\u3048\u308b\u6587\u5b57\u306f\u3001\u305d\u308c\u305e\u308c spreadsheetId ... \u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u3001\u6570\u5b57\u3001\u30cf\u30a4\u30d5\u30f3\u3001\u30a2\u30f3\u30c0\u30fc\u30b9\u30b3\u30a2 sheetId ... \u6570\u5b57 \u6b63\u898f\u8868\u73fe\u3067\u53d6\u5f97\u3059\u308b JavaScript\u306e\u6b63\u898f\u8868\u73fe\u3092\u4f7f\u3063\u3066\u53d6\u5f97\u3059\u308b\u3068\u3053\u3093\u306a\u611f\u3058 const pattern = /^https:\\/\\/docs.google.com\\/spreadsheets\\/d\\/([a-zA-Z0-9-_]+)\\\u2026","title":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eURL\u304b\u3089spreadsheetId\u3068sheetId\u3092\u53d6\u5f97\u3059\u308b"}