{"id":280907,"date":"2026-08-22T02:37:26","date_gmt":"2026-08-22T02:37:26","guid":{"rendered":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/"},"modified":"2026-08-22T02:37:26","modified_gmt":"2026-08-22T02:37:26","slug":"integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough","status":"publish","type":"post","link":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/","title":{"rendered":"Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough"},"content":{"rendered":"<div class=\"youtubomatic-video-container\"><iframe loading=\"lazy\" width=\"580\" height=\"380\" src=\"https:\/\/www.youtube.com\/embed\/l9PG-ZiAY3Y?autoplay=1&#038;controls=1&#038;hl=en\" frameborder=\"0\" allowfullscreen><\/iframe><\/div>\n<p>\ud83d\udc4b Hello Cloud Engineers, Data Analysts &#038; GCP Arcade Learners!<\/p>\n<p>Welcome back to Orbit of Ops! \ud83d\ude80<\/p>\n<p>In this video, we&#8217;ll walk through Integrate BigQuery Data and Google Workspace using Apps Script: Challenge Lab | ARC133 \u2014 an introductory Google Cloud Skills Boost Challenge Lab focused on connecting BigQuery with Google Sheets, Connected Sheets, Google Charts, and Apps Script.<\/p>\n<p>\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<br \/>\n\ud83d\udcda ABOUT THE LAB<br \/>\n\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<\/p>\n<p>ARC133 is a hands-on Challenge Lab where you apply skills from the Integrate BigQuery Data and Google Workspace using Apps Script learning path. The lab contains four checkpoints covering BigQuery queries, Google Sheets, Connected Sheets, charts, and Apps Script.<\/p>\n<p>\ud83c\udfaf WHAT YOU&#8217;LL LEARN<\/p>\n<p>\u2022 Query BigQuery data and send results to Google Sheets<br \/>\n\u2022 Work with BigQuery data through Connected Sheets<br \/>\n\u2022 Use formulas and calculations with Connected Sheets<br \/>\n\u2022 Create charts from connected BigQuery data<br \/>\n\u2022 Use Google Charts with Connected Sheets<br \/>\n\u2022 Use Apps Script to create and modify Google Sheets<br \/>\n\u2022 Connect Google Workspace productivity tools with cloud data<\/p>\n<p>\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<br \/>\n\ud83d\ude80\ud83d\ude80\ud83d\ude80 HORIZON STUDY NOTES &#038; COMMAND REFERENCE \ud83d\ude80\ud83d\ude80\ud83d\ude80<br \/>\n\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<\/p>\n<p>\ud83d\udccc Command Reference &#038; Step-by-Step Notes<\/p>\n<p>\ud83c\udf10 HORIZON APP<\/p>\n<p>\ud83d\udc49 <a href=\"https:\/\/horizon.orbitofops.com\/integrate-bigquery-data-and-google-workspace-using-apps-script?ref=youtube\" target=\"_blank\">https:\/\/horizon.orbitofops.com\/integrate-bigquery-data-and-google-workspace-using-apps-script?ref=youtube<\/a><\/p>\n<p>\u26a1 Horizon is the Orbit of Ops study companion for Google Cloud Skills Boost labs, providing command references, architectural concepts, AI learning tools, and productivity utilities.<\/p>\n<p>\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<br \/>\n\ud83d\udcd6 OFFICIAL RESOURCES<br \/>\n\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<\/p>\n<p>\ud83c\udf10 Official Lab<br \/>\n<a href=\"https:\/\/www.cloudskillsboost.google\/focuses\/67217\" target=\"_blank\">https:\/\/www.cloudskillsboost.google\/focuses\/67217<\/a><\/p>\n<p>\ud83c\udf10 Google Cloud Skills Boost<br \/>\n<a href=\"https:\/\/www.cloudskillsboost.google\/\" target=\"_blank\">https:\/\/www.cloudskillsboost.google\/<\/a><\/p>\n<p>\ud83d\udcd8 BigQuery Documentation<br \/>\n<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\" target=\"_blank\">https:\/\/cloud.google.com\/bigquery\/docs<\/a><\/p>\n<p>\ud83d\udcd8 BigQuery Data in Google Sheets \/ Connected Sheets<br \/>\n<a href=\"https:\/\/support.google.com\/docs\/answer\/9702507\" target=\"_blank\">https:\/\/support.google.com\/docs\/answer\/9702507<\/a><\/p>\n<p>\ud83d\udcd8 Analyze &#038; Refresh Connected Sheets<br \/>\n<a href=\"https:\/\/support.google.com\/docs\/answer\/9703214\" target=\"_blank\">https:\/\/support.google.com\/docs\/answer\/9703214<\/a><\/p>\n<p>\ud83d\udcd8 Apps Script Documentation<br \/>\n<a href=\"https:\/\/developers.google.com\/apps-script\" target=\"_blank\">https:\/\/developers.google.com\/apps-script<\/a><\/p>\n<p>\ud83d\udcd8 Apps Script \u2014 Connected Sheets<br \/>\n<a href=\"https:\/\/developers.google.com\/apps-script\/guides\/sheets\/connected-sheets\" target=\"_blank\">https:\/\/developers.google.com\/apps-script\/guides\/sheets\/connected-sheets<\/a><\/p>\n<p>\ud83d\udcd8 Apps Script \u2014 Google Sheets<br \/>\n<a href=\"https:\/\/developers.google.com\/apps-script\/guides\/sheets\" target=\"_blank\">https:\/\/developers.google.com\/apps-script\/guides\/sheets<\/a><\/p>\n<p>\ud83c\udfc5 Official Skill Badge<br \/>\n<a href=\"https:\/\/www.credly.com\/org\/google-cloud\/badge\/integrate-bigquery-data-and-google-workspace-using-\/\" target=\"_blank\">https:\/\/www.credly.com\/org\/google-cloud\/badge\/integrate-bigquery-data-and-google-workspace-using-\/<\/a><\/p>\n<p>\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<br \/>\n\ud83c\udf0c ORBIT OF OPS ECOSYSTEM<br \/>\n\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<\/p>\n<p>\ud83c\udf10 Main Hub<br \/>\n<a href=\"https:\/\/orbitofops.com\/\" target=\"_blank\">https:\/\/orbitofops.com\/<\/a><\/p>\n<p>\ud83d\udef0\ufe0f OrbitCalcy (GCP Arcade Points Auditor)<br \/>\n<a href=\"https:\/\/orbitcalcy.orbitofops.com\/\" target=\"_blank\">https:\/\/orbitcalcy.orbitofops.com\/<\/a><\/p>\n<p>\u270d\ufe0f OrbitScribe (Premium Online Notepad)<br \/>\n<a href=\"https:\/\/orbitscribe.orbitofops.com\/\" target=\"_blank\">https:\/\/orbitscribe.orbitofops.com\/<\/a><\/p>\n<p>\ud83c\udfa8 Prism Canvas (LinkedIn, GitHub &#038; X Banner Generator)<br \/>\n<a href=\"https:\/\/prismcanvas.orbitofops.com\/\" target=\"_blank\">https:\/\/prismcanvas.orbitofops.com\/<\/a><\/p>\n<p>\ud83e\udde9 QwikScore Pro \u2013 Cloud Skills Boost Extension (UI &#038; Dark Mode Enhancements)<br \/>\n<a href=\"https:\/\/chromewebstore.google.com\/detail\/qwikscore-pro-by-orbit-of\/pgajdjpjjamodhjmlmdemfdchjlmeibf\" target=\"_blank\">https:\/\/chromewebstore.google.com\/detail\/qwikscore-pro-by-orbit-of\/pgajdjpjjamodhjmlmdemfdchjlmeibf<\/a><\/p>\n<p>\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<br \/>\n\ud83d\udca1 LEARN \u2022 BUILD \u2022 EXPLORE<br \/>\n\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<\/p>\n<p>\ud83d\udca1 Learn Cloud \u2022 Explore AI \u2022 Build Projects \u2022 Boost Productivity<\/p>\n<p>\u2b50 Like \u2022 \ud83d\udd14 Subscribe \u2022 \ud83d\ude80 Share<\/p>\n<p>\ud83d\udc47 Let&#8217;s stay connected across the multiverse!<\/p>\n<p>\ud83d\udcf8 Instagram<br \/>\n<a href=\"https:\/\/www.instagram.com\/orbitofops\/\" target=\"_blank\">https:\/\/www.instagram.com\/orbitofops\/<\/a><\/p>\n<p>\ud83e\uddf5 Threads<br \/>\n<a href=\"https:\/\/www.threads.com\/@\" target=\"_blank\">https:\/\/www.threads.com\/@<\/a>orbitofops<\/p>\n<p>\ud83d\udcac WhatsApp Channel<br \/>\n<a href=\"https:\/\/whatsapp.com\/channel\/0029VbD1V4VEawdyyeaDHV1c\" target=\"_blank\">https:\/\/whatsapp.com\/channel\/0029VbD1V4VEawdyyeaDHV1c<\/a><\/p>\n<p>\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<br \/>\n\ud83d\udcda EDUCATIONAL BEST PRACTICES<br \/>\n\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<\/p>\n<p>\u2714\ufe0f Use only the temporary lab credentials provided by the platform.<br \/>\n\u2714\ufe0f Read through the official lab instructions to understand the workflow.<br \/>\n\u2714\ufe0f Use an Incognito\/private browser to avoid Google account conflicts.<br \/>\n\u2714\ufe0f Verify your BigQuery queries and Apps Script configurations match the lab requirements.<br \/>\n\u2714\ufe0f Complete all required checkpoints naturally to reinforce your learning.<\/p>\n<p>\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<br \/>\n\u26a0\ufe0f DISCLAIMER<br \/>\n\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501<\/p>\n<p>This video is for educational purposes only. Google Cloud, BigQuery, Google Workspace, Google Sheets, Apps Script, and related product names and trademarks belong to Google LLC. Orbit of Ops is an independent educational platform and is not affiliated with, sponsored by, or endorsed by Google LLC.<\/p>\n<p>If this walkthrough helped you, Like \ud83d\udc4d Subscribe \ud83d\udd14 and Share \ud83d\ude80!<\/p>\n<p>#GoogleCloud #BigQuery #AppsScript #GoogleWorkspace #GoogleSheets #ConnectedSheets #CloudSkillsBoost #GCPArcade #GoogleCloudArcade #ARC133 #BigQueryTutorial #GoogleCloudTutorial #LabWalkthrough #OrbitOfOps #Horizon<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud83d\udc4b Hello Cloud Engineers, Data Analysts &#038; GCP Arcade Learners! Welcome back to Orbit of Ops! \ud83d\ude80 In this video, we&#8217;ll walk through Integrate BigQuery Data and Google Workspace using Apps Script: Challenge Lab | ARC133 \u2014 an introductory Google Cloud Skills Boost Challenge Lab focused on connecting BigQuery with Google Sheets, Connected Sheets, Google Charts, and Apps Script. \u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501 \ud83d\udcda ABOUT THE LAB \u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501 ARC133 is a hands-on Challenge&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"","tve_custom_css":"","tve_user_custom_css":"","tve_globals":{},"tcb2_ready":0,"tcb_editor_enabled":0,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[1],"tags":[],"class_list":["post-280907","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough - UshopWell.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough - UshopWell.com\" \/>\n<meta property=\"og:description\" content=\"\ud83d\udc4b Hello Cloud Engineers, Data Analysts &#038; GCP Arcade Learners! Welcome back to Orbit of Ops! \ud83d\ude80 In this video, we&#8217;ll walk through Integrate BigQuery Data and Google Workspace using Apps Script: Challenge Lab | ARC133 \u2014 an introductory Google Cloud Skills Boost Challenge Lab focused on connecting BigQuery with Google Sheets, Connected Sheets, Google Charts, and Apps Script. \u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501 \ud83d\udcda ABOUT THE LAB \u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501 ARC133 is a hands-on Challenge...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/\" \/>\n<meta property=\"og:site_name\" content=\"UshopWell.com\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-22T02:37:26+00:00\" \/>\n<meta name=\"author\" content=\"UShopWell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"UShopWell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\\\/\"},\"author\":{\"name\":\"UShopWell\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\"},\"headline\":\"Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough\",\"datePublished\":\"2026-08-22T02:37:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\\\/\"},\"wordCount\":517,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\\\/\",\"name\":\"Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough - UshopWell.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\"},\"datePublished\":\"2026-08-22T02:37:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"name\":\"UshopWell.com\",\"description\":\"The Premiere Online Marketplace\",\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\",\"name\":\"UshopWell\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"contentUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"width\":365,\"height\":359,\"caption\":\"UshopWell\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\",\"name\":\"UShopWell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"caption\":\"UShopWell\"},\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/author\\\/kburnettu\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough - UshopWell.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/","og_locale":"en_US","og_type":"article","og_title":"Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough - UshopWell.com","og_description":"\ud83d\udc4b Hello Cloud Engineers, Data Analysts &#038; GCP Arcade Learners! Welcome back to Orbit of Ops! \ud83d\ude80 In this video, we&#8217;ll walk through Integrate BigQuery Data and Google Workspace using Apps Script: Challenge Lab | ARC133 \u2014 an introductory Google Cloud Skills Boost Challenge Lab focused on connecting BigQuery with Google Sheets, Connected Sheets, Google Charts, and Apps Script. \u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501 \ud83d\udcda ABOUT THE LAB \u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501 ARC133 is a hands-on Challenge...","og_url":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/","og_site_name":"UshopWell.com","article_published_time":"2026-08-22T02:37:26+00:00","author":"UShopWell","twitter_card":"summary_large_image","twitter_misc":{"Written by":"UShopWell","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/#article","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/"},"author":{"name":"UShopWell","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc"},"headline":"Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough","datePublished":"2026-08-22T02:37:26+00:00","mainEntityOfPage":{"@id":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/"},"wordCount":517,"commentCount":0,"publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/","url":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/","name":"Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough - UshopWell.com","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/#website"},"datePublished":"2026-08-22T02:37:26+00:00","breadcrumb":{"@id":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ushopwell.com\/ublog\/integrate-bigquery-data-and-google-workspace-using-apps-script-arc133-lab-walkthrough\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ushopwell.com\/ublog\/"},{"@type":"ListItem","position":2,"name":"Integrate BigQuery Data and Google Workspace using Apps Script | ARC133 | Lab Walkthrough"}]},{"@type":"WebSite","@id":"https:\/\/ushopwell.com\/ublog\/#website","url":"https:\/\/ushopwell.com\/ublog\/","name":"UshopWell.com","description":"The Premiere Online Marketplace","publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ushopwell.com\/ublog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ushopwell.com\/ublog\/#organization","name":"UshopWell","url":"https:\/\/ushopwell.com\/ublog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/","url":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","contentUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","width":365,"height":359,"caption":"UshopWell"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc","name":"UShopWell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","caption":"UShopWell"},"url":"https:\/\/ushopwell.com\/ublog\/author\/kburnettu\/"}]}},"_links":{"self":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/280907","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/comments?post=280907"}],"version-history":[{"count":0,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/280907\/revisions"}],"wp:attachment":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/media?parent=280907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/categories?post=280907"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/tags?post=280907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}