{"id":12678,"date":"2025-01-15T12:34:46","date_gmt":"2025-01-15T12:34:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/google-sheets-cong-thuc-tra-cuu-phien-am-ipa-tieng-anh\/"},"modified":"2025-01-15T12:34:46","modified_gmt":"2025-01-15T12:34:46","slug":"google-sheets-cong-thuc-tra-cuu-phien-am-ipa-tieng-anh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/google-sheets-cong-thuc-tra-cuu-phien-am-ipa-tieng-anh\/","title":{"rendered":"Google Sheets, c\u00f4ng th\u1ee9c tra c\u1ee9u phi\u00ean \u00e2m IPA ti\u1ebfng Anh"},"content":{"rendered":"
\n

Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Thanh v\u00e0 trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh s\u1ebd chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n m\u1ed9t c\u00e1ch c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong Google Sheets \u0111\u1ec3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng tra c\u1ee9u phi\u00ean \u00e2m IPA c\u1ee7a m\u1ed9t t\u1eeb ti\u1ebfng Anh.<\/p>\n

Ng\u00e0y x\u01b0a khi h\u1ecdc ti\u1ebfng Anh th\u00ec m\u00ecnh kh\u00e1 l\u00e0 l\u01b0\u1eddi trong vi\u1ec7c tra phi\u00ean \u00e2m c\u1ee7a m\u1ed9t t\u1eeb, b\u1edfi v\u00ec m\u00ecnh th\u00edch nghe tr\u1ef1c ti\u1ebfp v\u00e0 b\u1eaft ch\u01b0\u1edbc l\u1ea1i h\u01a1n. Tuy nhi\u00ean vi\u1ec7c h\u1ecdc b\u1eb1ng c\u00e1ch tra phi\u00ean \u00e2m IPA, m\u00ecnh ngh\u0129 s\u1ebd h\u1ec7 th\u1ed1ng v\u00e0 ph\u00f9 h\u1ee3p h\u01a1n v\u1edbi nhi\u1ec1u b\u1ea1n.<\/p>\n

\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 ngh\u0129 t\u1edbi 2 c\u00e1ch:<\/p>\n

    \n
  1. S\u1eed d\u1ee5ng Google Apps Script \u0111\u1ec3 c\u00f3 th\u1ec3 truy v\u1ea5n t\u1edbi m\u1ed9t API mi\u1ec5n ph\u00ed cho ch\u00fang ta k\u1ebft qu\u1ea3 phi\u00ean \u00e2m IPA<\/li>\n
  2. Ch\u1ec9 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong Google Sheets, tuy nhi\u00ean v\u1eabn c\u1ea7n truy v\u1ea5n t\u1edbi API mi\u1ec5n ph\u00ed.<\/li>\n<\/ol>\n

    Nh\u01b0 v\u1eady th\u00ec \u0111\u1ed1i v\u1edbi c\u1ea3 2 c\u00e1ch tr\u00ean, ch\u00fang ta \u0111\u1ec1u c\u1ea7n c\u00f3 1 API free. Sau khi t\u00ecm ki\u1ebfm th\u00ec m\u00ecnh may m\u1eafn ki\u1ebfm \u0111\u01b0\u1ee3c m\u1ed9t API s\u1eed d\u1ee5ng GET Method ch\u1ee9 kh\u00f4ng ph\u1ea3i POST Method \u2013 ngh\u0129a l\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 ki\u1ec3m tra API n\u00e0y tr\u1ef1c ti\u1ebfp b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng URL v\u00e0 d\u00e1n v\u00e0o tr\u00ecnh duy\u1ec7t ch\u1ee9 kh\u00f4ng c\u1ea7n t\u1edbi c\u00f4ng c\u1ee5 \u0111\u1ec3 g\u1eedi truy v\u1ea5n nh\u01b0 Postman.<\/p>\n

    https:\/\/api.dictionaryapi.dev\/api\/v2\/entries\/en\/hello<\/strong>\n\n<\/code><\/pre>\n
    \u1ede trong URL tr\u00ean, ch\u1eef \u201chello\u201d \u1edf cu\u1ed1i l\u00e0 ch\u1eef m\u00ecnh \u0111\u00e3 \u0111\u1ecbnh d\u1ea1ng m\u00e0u \u0111\u1eadm l\u00ean, ngh\u0129a l\u00e0 n\u1ebfu ch\u00fang ta mu\u1ed1n k\u1ebft qu\u1ea3 phi\u00ean \u00e2m IPA c\u1ee7a ch\u1eef n\u00e0o th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 thay v\u00e0o v\u1ecb tr\u00ed n\u00e0y. \u0110\u00e2y l\u00e0 k\u1ebft qu\u1ea3 khi b\u1ea1n d\u00e1n URL tr\u00ean v\u00e0o trong tr\u00ecnh duy\u1ec7t: <\/p>\n
    <\/figure>\n
    Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 c\u00f3 API v\u00e0 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c. K\u1ebft qu\u1ea3 ch\u00fang ta nh\u1eadn \u0111\u01b0\u1ee3c \u1edf \u0111\u00e2y l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u Text, JSON.<\/p>\n
    \u1ede \u0111\u00e2y, ch\u00fang ta t\u1eadp trung v\u00e0o vi\u1ec7c ch\u1ec9 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 tra c\u1ee9u IPA. Khi n\u00f3i t\u1edbi t\u01b0\u01a1ng t\u00e1c v\u1edbi \u201cth\u1ebf gi\u1edbi b\u00ean ngo\u00e0i\u201d c\u1ee7a Sheets, ch\u00fang ta c\u00f3 th\u1ec3 s\u1ebd ngh\u0129 t\u1edbi h\u00e0m IMPORTXML, IMPORTDATA. B\u1edfi v\u00ec IMPORTXML kh\u00f4ng l\u00e0m vi\u1ec7c tr\u1ef1c ti\u1ebfp \u0111\u01b0\u1ee3c v\u1edbi JSON, v\u1eady n\u00ean ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng IMPORTDATA<\/p>\n
    =IMPORTDATA(\"https:\/\/api.dictionaryapi.dev\/api\/v2\/entries\/en\/hello\")<\/code><\/pre>\n
    <\/figure>\n
    L\u1ea7n \u0111\u1ea7u ti\u00ean nh\u1eadp 1 c\u00f4ng th\u1ee9c Google Sheets c\u00f3 kh\u1ea3 n\u0103ng trao \u0111\u1ed5i d\u1eef li\u1ec7u v\u1edbi th\u1ebf gi\u1edbi b\u00ean ngo\u00e0i, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o nh\u01b0 tr\u00ean c\u1ee7a Google, v\u00e0 ch\u00fang ta s\u1ebd b\u1ea5m Allow access \u0111\u1ec3 cho ph\u00e9p \u0111i\u1ec1u n\u00e0y. Tuy nhi\u00ean \u1edf \u0111\u00e2y, ch\u00fang ta g\u1eb7p ph\u1ea3i v\u1ea5n \u0111\u1ec1 ti\u1ebfp theo, k\u1ebft qu\u1ea3 b\u1ecb d\u00e0n ra nhi\u1ec1u c\u1ed9t nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi: <\/p>\n
    \n
    \n
    \n
    \n<\/a>\n<\/div>\n<\/div>\n
    <\/figure>\n
    Nh\u01b0 v\u1eady ch\u00fang ta s\u1ebd c\u1ea7n ph\u1ea3i n\u1ed1i c\u00e1c k\u1ebft qu\u1ea3 n\u00e0y v\u00e0o v\u1edbi nhau b\u1eb1ng h\u00e0m JOIN:<\/p>\n
    =JOIN(\"\",IMPORTDATA(\"https:\/\/api.dictionaryapi.dev\/api\/v2\/entries\/en\/hello\"))<\/code><\/pre>\n
    <\/figure>\n
     Sau \u0111\u00f3 ta c\u1ea7n t\u00ecm c\u00e1ch \u0111\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c ph\u1ea7n gi\u00e1 tr\u1ecb c\u1ee7a key \u201ctext\u201d trong \u0111o\u1ea1n JSON n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m REGEXEXTRACT nh\u01b0 \u0111\u00e3 h\u01b0\u1edbng d\u1eabn trong kho\u00e1 h\u1ecdc Google Sheets n\u00e2ng cao c\u1ee7a Thanh<\/a>:<\/p>\n
    <\/figure>\n
    =REGEXEXTRACT(JOIN(\"\",IMPORTDATA(\"https:\/\/api.dictionaryapi.dev\/api\/v2\/entries\/en\/hello\")), \"\"\"text\"\":\"\"([^\"\"]+)\"\"\")<\/code><\/pre>\n
    <\/figure>\n
    V\u00e0 t\u1ea5t nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 thay t\u1eeb hello b\u1eb1ng nh\u1eefng t\u1eeb kh\u00e1c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu:<\/p>\n
    <\/figure>\n
    Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng v\u00e0 xin h\u1eb9n g\u1eb7p l\u1ea1i trong kho\u00e1 h\u1ecdc. [\u0110\u00e2y l\u00e0 file k\u00e8m theo<\/a>]<\/p>\n<\/div>\n
    \n
    Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n
    T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n
    H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n
    HKD H\u1ecdc Excel Online
    S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n
    \n
    \u00a9  document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
    \n
    \n
    \n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12679,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12678","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=12678"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12678\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12679"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}