{"id":5770,"date":"2019-03-15T16:49:38","date_gmt":"2019-03-15T09:49:38","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/cap-nhat-du-lieu-bigquery-trong-sheets-nho-app-script-va-macros\/"},"modified":"2023-05-19T11:31:52","modified_gmt":"2023-05-19T04:31:52","slug":"cap-nhat-du-lieu-bigquery-trong-sheets-nho-app-script-va-macros","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/cap-nhat-du-lieu-bigquery-trong-sheets-nho-app-script-va-macros\/","title":{"rendered":"Update BigQuery data in Sheets with App Scripts and Macros"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cap-nhat-du-lieu-bigquery-trong-sheets-nho-app-script-va-macros\/#Co_gi_moi\" >What\u2019s new:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cap-nhat-du-lieu-bigquery-trong-sheets-nho-app-script-va-macros\/#Nhung_ai_chiu_anh_huong\" >Who\u2019s impacted<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cap-nhat-du-lieu-bigquery-trong-sheets-nho-app-script-va-macros\/#Tai_sao_ban_nen_su_dung_tinh_nang_nay\" >Why you\u2019d use it<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cap-nhat-du-lieu-bigquery-trong-sheets-nho-app-script-va-macros\/#Huong_dan_su_dung_tinh_nang\" >Instructions for using the feature<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cap-nhat-du-lieu-bigquery-trong-sheets-nho-app-script-va-macros\/#Cac_thong_tin_bo_sung\" >Additional details<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cap-nhat-du-lieu-bigquery-trong-sheets-nho-app-script-va-macros\/#Nhung_lien_ket_huu_ich\" >Useful links<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Co_gi_moi\"><\/span><b>What\u2019s new:<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Recently, Google launched the BigQuery data connector feature <a href=\"https:\/\/gcloudvn.com\/en\/bigquery\/\">BigQuery<\/a>. Now you can use tools like App Script and the Macro recorder in Sheets to schedule automatic updates to BigQuery data.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nhung_ai_chiu_anh_huong\"><\/span><b>Who\u2019s impacted<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">End users<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tai_sao_ban_nen_su_dung_tinh_nang_nay\"><\/span><b>Why you\u2019d use it<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Stay up to date with the latest and greatest in your business by automatically refreshing BigQuery data in Sheets.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">For example, you can set up the sales data to be updated automatically, so that every time you open the data sheet, you can always observe and analyze the latest data every day. You can also let the data automatically update to prepare you for important meetings\/presentations that happen weekly or monthly. Or you can set a schedule to update the data automatically every time you open the spreadsheet.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_su_dung_tinh_nang\"><\/span><b>Instructions for using the feature<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">With Admin: No need to do anything<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">End users: <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/9077536\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">Go here to learn how to schedule updates for data fetched from BigQuery.<\/span><\/a><\/li>\n<li><b>Shoot Macros to Refresh Your Data<\/b>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">On your computer, open a spreadsheet containing data connected to BigQuery in Google Sheets<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Record a macro from another tab, then from the tab you want to refresh<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">After starting macro recording, switch to the tab you want to refresh<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">At the bottom of the screen, click <\/span><b>Refresh<\/b><\/li>\n<\/ul>\n<\/li>\n<li><b><span style=\"font-weight: 400;\">Click<\/span> Save.<\/b><\/li>\n<li><b>Set a schedule for macros<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the upper part of the screen, select Tools &gt; Script Editor<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the upper part of the screen, choose Edit &gt; Current project&#039;s trigger.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the lower right, click <\/span><b>Add trigger<\/b><span style=\"font-weight: 400;\"> and choose the options you need.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Save<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_thong_tin_bo_sung\"><\/span><b>Additional details<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">To learn about key access permissions for BigQuery data connections<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">As always, you can use access management to control who can see, edit, or share your data.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nhung_lien_ket_huu_ich\"><\/span><strong>Useful links<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/support.google.com\/docs\/answer\/7665004\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">How to record\/save a macro<\/span><\/a><\/li>\n<\/ul>\n<p style=\"text-align: right;\"><strong>Updated: Gimasys<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Recently, Google released the BigQuery data connector feature. Now you can use tools like App Script and Macro recorder in Sheets.<\/p>","protected":false},"author":1,"featured_media":5771,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5770","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=5770"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5770\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/5771"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=5770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=5770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=5770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}