Load from Google Sheets

A side trip from Load Your Data: instead of uploading a file by hand, you will pull the data straight out of a spreadsheet with the Google Sheets data source connector.

Google Drive is commonly used for sharing small reference tables between different organizations. For our purposes, create a Google spreadsheet from the level.csv file. Imagine someone shared the level table with you through Google Drive.

Prepare

Go to Google Spreadsheets and start a new blank spreadsheet. Then go to File – Import and upload the level.csv file.

Configure Google Sheets Data Source Connector

1. Navigate to Components section in Keboola and click the Add Component button:

2. Utilize the search box to locate the Google Sheets data source connector. Once found, click on it.

3. Click Connect To My Data. The ‘Use With Demo Data’ option will extract datasets prepared by Keboola for your experimentation outside of this guide, and it can be found across all commonly used connectors.

4. Enter a name and description and click Create Configuration.

Each Keboola component (data source, data destination, or application) can support multiple configurations. This concept enables you to, for instance, extract data from multiple Google accounts.

5. Authorize the connector to access the spreadsheet by clicking the Sign in with Google button.

6. On the following screen, click Allow.

7. Now you want to select the Google Drive files to import.

8. In step 5, you authorized Keboola to use your account to access the Drive. In this step, you will be asked to grant access specifically to spreadsheets. Click ‘Select all’ and then proceed by clicking ‘Continue’ on the following screen.

9. Use the search box to find your Level spreadsheet. Select it and click the Select button.

10. Keboola has automatically detected all sheets from within your spreadsheet and will now allow you to select the one you want to load.
11. Select the sheet and click Save and Run Configuration. A job will be executed, and once completed, you will see a new table created.

12. The Google Sheets data source automatically generates an output bucket and table. Click on the name of the output table to check its contents, or navigate directly to the Storage section to explore the data.

Going further

Another side trip: load the same kind of data with the database data source connector.

Next: Transform your data →