Follow me on LinkedIn - AI, GA4, BigQuery

Follow the steps below to connect and transfer data from Google Sheets to BigQuery:

Step-1: Navigate to your BigQuery account: https://console.cloud.google.com/bigquery

Step-2: Click on the drop-down menu at the top:

Click on the drop down menu at the top

Step-3: Click on the ‘New Project’ button:

New Project bigquery

Step-4: Name the project ‘Google Sheets’, rename the project id (by clicking on the ‘edit’ button) to something easily recognizable and then click on the ‘create’ button:

New Project bigquery 2

Step-5: Click on the ‘SELECT PROJECT’ link on the top right-hand side of your screen:

SELECT PROJECT

Step-6: Click on your project ID:

Click on your project ID

Step-7: Click on the ‘CREATE DATASET’ button on the top right-hand side of your screen: