With BigQuery\u2019s data warehouse, businesses can centralize their information in one place. Moreover, they can access and analyze this data at any time.<\/p>\n
BigQuery can be easily integrated with Google Sheets<\/strong>. This enables organization members to collaborate on projects using a familiar tool while also accessing a live data stream from BigQuery.<\/p>\n First, we’ll explore BigQuery in more detail. Then we’ll go step by step through two ways to connect BigQuery to Google Sheets: Google’s Connected Sheets, and a scheduled transfer with Sheetgo, the AI-powered data automation platform.<\/p>\n [\/et_pb_text][et_pb_text module_id=”what” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n BigQuery<\/a> is one of Google\u2019s many products, it is a data warehouse storage system that enterprises can use to store all of their data.<\/p>\n Its huge processing power allows BigQuery to carry out rapid SQL queries whenever you need them. Furthermore, under Google\u2019s infrastructure, your data in BigQuery is constantly secure and accessible, perfect for project collaborations within organizations.<\/p>\n For a longer introduction, read What is BigQuery?<\/a><\/p>\n [\/et_pb_text][et_pb_text module_id=”why” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As part of Google\u2019s products, BigQuery can easily be integrated with Google Sheets<\/strong>. This has two main advantages:<\/p>\n To learn more about Google Sheet\u2019s analytical tools for data, read How to analyze BigQuery data within Google Sheets<\/a>.<\/p>\n Connecting BigQuery to Google Sheets lets you tap into huge amounts of data, and a Sheetgo automation ensures this data is always updated.<\/p>\n You want to import data on current Google search trends into a spreadsheet.<\/p>\n Connecting Google Sheets to a BigQuery database using Sheetgo would let you select updated trends data and analyze it in Google Sheets.<\/p>\n This powerful combination would help you identify the most popular trends or predict search trends to optimize your business\u2019 marketing.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_text][et_pb_text module_id=”how” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There are two ways to connect BigQuery to Google Sheets:<\/p>\n Watch the video below or continue reading to learn both approaches.<\/p>\n <\/p>\n [\/et_pb_text][et_pb_video src=”https:\/\/www.youtube.com\/watch?v=A8pV5_mU_UQ&pp=ygUpQ29ubmVjdCBHb29nbGUgU2hlZXRzIHRvIEJpZ3F1ZXJ5IHNoZWV0Z28%3D” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_video][et_pb_text module_id=”alternatively” _builder_version=”4.27.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This Google Sheets feature links a sheet to a BigQuery table and can refresh the data on a schedule. You need access to BigQuery and a Google Cloud project with billing set up.<\/p>\n To connect a BigQuery table from Google Sheets:<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 1.<\/strong> Go to Data > Data connectors > Connect to BigQuery.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/connect-bigquery-to-google-sheets-data-connectors.webp” alt=”Connect BigQuery to Google Sheets \u2014 Data menu open at Data connectors with Connect to BigQuery” title_text=”Data menu open at Data connectors with Connect to BigQuery” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> You will see a message like the one below. Click on “Get connected”.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/connect-bigquery-to-google-sheets-get-connected.webp” alt=”Connect BigQuery to Google Sheets \u2014 Connect and analyze big data in Sheets dialog with the Get connected button” title_text=”Connect and analyze big data in Sheets dialog with the Get connected button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> The next pop-up will ask you to choose a cloud project.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/connect-bigquery-to-google-sheets-cloud-project.webp” alt=”Connect BigQuery to Google Sheets \u2014 Add data connection dialog with My First Project as the cloud project” title_text=”Add data connection dialog with My First Project as the cloud project” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Next, you need to select a dataset in that project. In my example, I will choose a public dataset, “census_bureau_usa”.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/connect-bigquery-to-google-sheets-choose-dataset.webp” alt=”Connect BigQuery to Google Sheets \u2014 Choose a dataset list from bigquery-public-data with census_bureau_usa selected” title_text=”Choose a dataset list from bigquery-public-data with census_bureau_usa selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> Once you have selected your dataset, you can choose a table or view, then click on “Connect”.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/connect-bigquery-to-google-sheets-choose-table.webp” alt=”Connect BigQuery to Google Sheets \u2014 Choose a table or view with population_by_zip_2010 selected and the Connect button” title_text=”Choose a table or view with population_by_zip_2010 selected and the Connect button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 6.<\/strong> You will see a message once the connection is made.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/bigquery-to-google-sheets-census-data-connected.webp” alt=”BigQuery to Google Sheets \u2014 Success! Your data is connected for population_by_zip_2010, 1.6M rows and 6 columns” title_text=”Success! Your data is connected for population_by_zip_2010, 1.6M rows and 6 columns” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 7.<\/strong> That’s it. You can comfortably analyze your dataset from Sheets, even though it’s a large file since the data is not actually loaded into Sheets.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/bigquery-to-google-sheets-connected-sheet-preview.webp” alt=”BigQuery to Google Sheets \u2014 connected sheet preview of 1.6M rows with Refresh options, Schedule refresh and Extract” title_text=”Connected sheet preview of 1.6M rows with Refresh options, Schedule refresh and Extract” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The sheet shows a preview of 500 rows, but charts, pivot tables, and functions you build on it use the whole table. To update the data, click Refresh options. You can refresh now or set a schedule. Only people with BigQuery access can refresh. Others you share the file with can still view and analyze the data.<\/p>\n To work with the rows themselves, click Extract. An extract copies up to 50,000 rows into a regular sheet, or up to 500,000 rows as long as it stays under 5 million cells.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can also start from BigQuery. In the Google Cloud console, open BigQuery and go to the Explorer pane. Expand your project and open the dataset. Next to the table name, click View actions, then select Open in > Connected Sheets. A new spreadsheet opens with the table connected.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/bigquery-to-google-sheets-console-data-connected.webp” alt=”BigQuery to Google Sheets \u2014 Success! Your data is connected dialog over the connected sheets_table, 7 columns” title_text=”Success! Your data is connected dialog over the connected sheets_table, 7 columns” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”connecting” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Although the methods covered above are an effective way to connect your data, Sheetgo offers other features that provide more advantages.<\/p>\n These are just some benefits of using Sheetgo to connect BigQuery to Google Sheets:<\/p>\n <\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that we explored the benefits of using Sheetgo over Google\u2019s in-built function, let\u2019s look at the step-by-step instructions of how to connect BigQuery to Google Sheets automatically through Sheetgo.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Sign up for Sheetgo using your Google account.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Within Sheetgo, click N<\/strong>ew<\/b>, then select Blank workflow.<\/strong><\/p>\n Click Create an automation<\/strong>.<\/strong><\/p>\n <\/strong><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/04\/home_new-button_2024-08-09.webp” alt=”BigQuery to Google Sheets with Sheetgo \u2014 the New button in the Sheetgo workspace” title_text=”The New button in the Sheetgo workspace” align=”center” _builder_version=”4.27.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To choose your data source, scroll down to Databases<\/strong> and select BigQuery<\/b>.<\/p>\n Click Grant permission<\/b> so Sheetgo can connect to your BigQuery account.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/BQxGS-1-\u2013-2.jpg” alt=”BigQuery to Google Sheets with Sheetgo \u2014 Grant permission so Sheetgo can access your BigQuery account” title_text=”Grant permission so Sheetgo can access your BigQuery account” align=”center” _builder_version=”4.16″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Next, select your Bigquery Project<\/b>, Dataset name<\/b>, and Table<\/b> or<\/strong> View<\/b>. This will determine the data you are using.<\/p>\n Include a Query to pick the exact data you want to transfer.<\/p>\n Once you are happy with this, press Next step<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/BigQuery-to-Google-Sheets-2.png” alt=”BigQuery to Google Sheets with Sheetgo \u2014 Sheetgo-Demo project, Sales dataset, sales_representative table and query editor” title_text=”Sheetgo-Demo project, Sales dataset, sales_representative table and query editor” align=”center” _builder_version=”4.21.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n It\u2019s time to connect this dataset to Google Sheets. Select Google Sheets<\/b> as your destination.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/BigQuery-to-Google-Sheets-3.png” alt=”BigQuery to Google Sheets with Sheetgo \u2014 Select a destination screen with Google Sheets marked most popular” title_text=”Select a destination screen with Google Sheets marked most popular” align=”center” _builder_version=”4.21.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Name your new file.<\/p>\n When you\u2019re done configuring your automation, press Finish and save<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/BigQuery-to-Google-Sheets-4.png” alt=”BigQuery to Google Sheets with Sheetgo \u2014 new Google Sheets file settings and the Finish and save button” title_text=”New Google Sheets file settings and the Finish and save button” align=”center” _builder_version=”4.21.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n After saving your workflow, you can see a visual representation in the workflow view.<\/p>\n Under Triggers on the right sidebar, set up a schedule for your workflow to run on.<\/b><\/p>\n Sheetgo will automatically transfer data from BigQuery to Google Sheets at the frequency of your choice.<\/p>\n Your team then reads the results in Google Sheets instead of each person running the same query in BigQuery, which can help you cut BigQuery costs<\/a>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/04\/cut_bigquery_costs_1.webp” alt=”Automate BigQuery to Google Sheets \u2014 Sheetgo workflow from BigQuery to Google Sheets with a daily schedule trigger” title_text=”Sheetgo workflow from BigQuery to Google Sheets with a daily schedule trigger” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.27.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This guide moves data from BigQuery to Google Sheets. To send spreadsheet data the other way, BigQuery can read a Google Sheets file directly:<\/p>\n An external table leaves the data in Google Drive, so anyone who queries it needs access to the spreadsheet as well as to BigQuery. To copy sheet data into BigQuery tables on a schedule instead, see how to build BigQuery pipelines in spreadsheets<\/a> with Sheetgo, the AI-powered data automation platform, which can also append spreadsheet data to a BigQuery table.<\/p>\n [\/et_pb_text][et_pb_text module_id=”BigQuery” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, Sheetgo is a great option for businesses to connect BigQuery to Google Sheets<\/strong>.<\/p>\n It has numerous advantages over the native feature allowing you to build automations.<\/p>\n In fact, Sheetgo can transfer data from BigQuery data to Excel, CSV, or TSV files. Read more about How to connect BigQuery data to Excel automatically<\/a><\/p>\n [\/et_pb_text][et_pb_accordion _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_accordion_item title=”Is BigQuery free?” open=”on” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n BigQuery offers a free tier that includes 10 GB of storage and 1 TB of query processing<\/strong> per month, which is great for small projects. Beyond that, pricing is based on usage: you pay based on how much data you store and query.<\/p>\n [\/et_pb_accordion_item][et_pb_accordion_item title=”What is BigQuery used for?” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content” open=”off”]<\/p>\n BigQuery stores and analyzes large datasets on the cloud.<\/strong> It’s a scalable data warehouse that lets you run complex SQL queries, generate business insights, and manage structured data without any database infrastructure.<\/p>\n [\/et_pb_accordion_item][et_pb_accordion_item title=”Is BigQuery a relational database?” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content” open=”off”]<\/p>\n BigQuery is not a traditional relational database<\/strong>, but it uses a similar structure with tables, rows, and columns, and supports SQL queries. It\u2019s more accurately described as a serverless enterprise data warehouse.<\/p>\n [\/et_pb_accordion_item][\/et_pb_accordion][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Growing businesses usually turn to cloud-based storage solutions for their growing data needs. BigQuery is an increasingly popular option for data management. With BigQuery\u2019s data warehouse, businesses can centralize their information in one place. Moreover, they can access and analyze this data at any time. BigQuery can be easily integrated with Google Sheets. This enables […]<\/p>\n","protected":false},"author":40,"featured_media":42182,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"What is BigQuery?<\/h2>\n
Why connect Google Sheets to BigQuery?<\/h2>\n
\n
An example<\/h3>\n
How to connect BigQuery to Google Sheets<\/h2>\n
\n
Use Google’s connected sheets<\/h3>\n
Open a BigQuery table in Google Sheets from the BigQuery console<\/h3>\n
Connect BigQuery to Google Sheets automatically using Sheetgo<\/h3>\n
\n
Step 1: Sign up for Sheetgo<\/h4>\n
Step 2: Create workflow<\/h4>\n
Step 3: Select your source<\/h4>\n
Step 4: Find your BigQuery Project<\/h4>\n
Step 5: Select a destination<\/h4>\n
Step 6: Automate your workflow<\/h4>\n
Going the other way: Google Sheets to BigQuery<\/h2>\n
\n
Final thoughts<\/h2>\n
What is the BigQuery Data Connector for Google Sheets?<\/b><\/h5>\nBigQuery connectors allow users to integrate BigQuery with other platforms\u2014either data sources or analytics tools. Google recently launched a BigQuery connector for Google Sheets which allows greater accessibility to your data. Large datasets can be intimidating for non-experts within your organization, and not all users need access to your full range of data. For big data practitioners, it is better to free up smaller amounts of data and distribute it to the members of an organization who need it, rather than requiring those who are less tech-savvy to query the system themselves. Google Sheets is intuitive and familiar for any users who are used to working with spreadsheets. Learn more about the BiqQuery Data Connector in our <\/span>first post in this series.<\/span><\/a>\n
<\/h5>\n
Why is There No Automation Feature? <\/b>(Don't worry! We Fixed It!)<\/i><\/b><\/h5>\nThis Google Sheets feature is still relatively new. Just like with the <\/span>new Google Ads add-on, <\/span><\/a>automation is not a feature yet, and users will need to manually extract data from BigQuery everytime they need a refresh. This could get awfully tedious for users who need access to real-time data updates on a regular basis. <\/span>\n
<\/h5>\n
Use Our Google Apps Script<\/b><\/h5>\nHere at Sheetgo, we are all about automation and we love providing you with solutions\u2014so we created a tool to solve this problem! We made a script for you to install in your Google Sheets so that you can get data from BigQuery to Google Sheets <\/span>automatically<\/b>! Read on for a tutorial on how to quickly set up the script so you can get started on more important tasks!<\/span>\n
<\/h5>\n
Step 1: Make a Copy of the Script<\/b><\/h5>\nOpen the template by clicking <\/span>here<\/span><\/a>. Click <\/span>File \u2192 Make a Copy <\/b>to get your own copy of this script, it will automatically save to your Google Drive. <\/span>Be sure to make a copy of the template <\/span><\/i>rather than requesting editing access. <\/span>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/frame-generic-10-1024x640.webp\")
<\/h5>\nStep 2: Set up the Script<\/b><\/h5>\nY<\/span>our copy of the script will open automatically in a new tab. Click <\/span>Tools \u2192 Script Editor<\/b>. A new tab will open in your browser. You then need to complete two steps: enable the BigQuery API (<\/span>2.1<\/b>) and get the Project ID (<\/span>2.2<\/b>).<\/span>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/frame-generic-11-1024x571.webp\")
<\/h5>\n\n<\/span>Step 2.1: Enable the BigQuery API<\/b><\/h5>\nTo enable the Big Query API, select <\/span>Resources \u2192 Advanced Google Services.<\/b> A new window will pop up, make sure the Big Query API is turned <\/span>On<\/b>. <\/span>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/frame-generic-13-1024x687.webp\")
<\/h5>\nStep 2.2: Get the Project ID<\/b><\/h5>\nTo get the Project ID, follow these steps. The screenshots below show detailed steps.<\/span>\n
\n \t
<\/h5>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/frame-generic-14-1024x344.webp\")
\n\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/frame-generic-15-1024x554.webp\")
\n\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/frame-generic-16-1024x483.webp\")
\n\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/frame-generic-17-1024x368.webp\")
\n\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/frame-generic-19-1024x686.webp\")
\nStep 3: Run the Script<\/b><\/h5>\nGo back to your spreadsheet. <\/span>Click <\/span>Sheetgo \u2192 Run Query \u2192 Continue \u2192 Login<\/b>\n\nThat\u2019s it! The script has been created! Now you can automatically import data from BigQuery into your Google Sheets spreadsheets!<\/span>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/frame-generic-20-1024x503.webp\")
<\/h5>\n(I\u2019d kind of like to add a few more sentences as an outro.<\/span>","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-10168","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/10168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=10168"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/10168\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/42182"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=10168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=10168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=10168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}