<div>
It is certainly doable in Excel as there is an ODBC driver for BigQuery. <br />
<a href="https://cloud.google.com/blog/big-data/2016/11/how-to-connect-bigquery-to-microsoft-excel-and-other-apps-with-our-new-odbc-driver" rel="ugc nofollow">https://cloud.google.com/blog/big-data/2016/11/how-to-connect-bigquery-to-microsoft-excel-and-other-apps-with-our-new-odbc-driver</a><br />
<br />
As for Google sheets - I have not tried it but here are some resources to get you started.<br />
Google BigQuery API in Apps Script - <a href="https://developers.google.com/apps-script/advanced/bigquery" rel="ugc">https://developers.google.com/apps-script/advanced/bigquery</a>&nbsp;<br />
Build charts in Google Sheets based on data from Google BigQuery - <a href="https://chrome.google.com/webstore/detail/owox-bi-bigquery-reports/fepofngogkjnejgcbdmmkddnpeojbbin" rel="ugc nofollow">https://chrome.google.com/webstore/detail/owox-bi-bigquery-reports/fepofngogkjnejgcbdmmkddnpeojbbin</a>
</div>


It is certainly doable in Excel as there is an ODBC driver for BigQuery.
https://cloud.google.com/blog/big-data/2016/11/how-to-connect-bigquery-to-microsoft-excel-and-other-apps-with-our-new-odbc-driver [https://cloud.google.com/blog/big-data/2016/11/how-to-connect-bigquery-to-microsoft-excel-and-other-apps-with-our-new-odbc-driver]

As for Google sheets - I have not tried it but here are some resources to get you started.
Google BigQuery API in Apps Script - https://developers.google.com/apps-script/advanced/bigquery [https://developers.google.com/apps-script/advanced/bigquery] 
Build charts in Google Sheets based on data from Google BigQuery - https://chrome.google.com/webstore/detail/owox-bi-bigquery-reports/fepofngogkjnejgcbdmmkddnpeojbbin [https://chrome.google.com/webstore/detail/owox-bi-bigquery-reports/fepofngogkjnejgcbdmmkddnpeojbbin]

<div>
<div class="content wysiwyg-content">
Can I have a working script I can use in Google Sheets to access BigQuery data? Thanks
</div>
</div>


Can I have a working script I can use in Google Sheets to access BigQuery data? Thanks

Accessing BigQuery with Google Spreadsheet

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.

Google

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.

Google Workspace

Cloud computing, also known as on-demand computing, is a kind of Internet-based computing where shared resources and information are provided to computers and other devices. It is a model for enabling ubiquitous, on-demand access to a shared pool of configurable computing resources. Cloud computing and storage solutions provide users and enterprises with various capabilities to store and process their data in third-party data centers, relying on sharing of resources to achieve coherence and economies of scale.

Cloud Computing

Cloud services are services made available to users via the Internet from a provider's servers. Cloud services are designed to provide easy, scalable access to applications, resources and services, and are fully managed by a cloud services provider. It is a model for enabling ubiquitous, on-demand access to a shared pool of configurable computing resources. Frequently offered cloud services are infrastructure-as-a-service (IaaS), desktops-as-a-service (DaaS), software-as-a-service (SaaS) and platform-as-a-service (PaaS). Examples of cloud services include online data storage and backup solutions, Web-based e-mail services, hosted office suites and document collaboration services, database processing, managed technical support services and more.