In the previous step, you learned how to quickly load data into Keboola using manual import. However, in real production projects, this is seldom used as most data is obtained automatically using data source connectors. In this part of the tutorial, you will use a Google Sheets data source connector to load data from an external spreadsheet.
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.
Navigate to Components section in Keboola and click the Add Component button:
Utilize the search box to locate the Google Sheets data source connector. Once found, click on it.
Click Connect To My Data. The ‘Use With Demo Data’ option will extract datasets prepared by Keboola for your experimentation outside of this tutorial, and it can be found across all commonly used connectors.
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.
Authorize the connector to access the spreadsheet by clicking the Sign in with Google button.
On the following screen, click Allow.
Now you want to select the Google Drive files to import.
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.
Use the search box to find your Level spreadsheet. Select it and click the Select button.
Select the sheet and click Save and Run Configuration. A job will be executed, and once completed, you will see a new table created.
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.
Feel free to reach out to our support team if there’s anything we can help with.