Google Sheets

Google Sheets is the online spreadsheet productivity application from Google and is part of the Google Business and Google Workspace offerings used by millions of users. This is often compared to Microsoft Excel as it offers similar and some might say more user friendly options as one of the first online spreadsheet applications in existence.

DLH.io provides this connector as a direct way to work with this spreadsheet data and the Google Sheets "files" mainly as a source to be synchronized or loaded into your cloud data warehouse destination of choice.

Pre-Requisities:

• Access to files in your Google Sheet file or files

Setup Instructions

DataLakeHouse.io securely connects to your Google Drive account that you have access to using the security of Google authentication. Using the form in the DataLakeHouse.io portal please complete the following basic steps.

1. Enter a Name or Alias for this connection, in the 'Name/Alias' field, that is unique from other connectors.
2. Enter in the 'Target Schema Prefix' field, a name that will be unique in your data cloud destination where you wish to land the data.
3. Provide the 'Sheet URL' field, the spreadsheet URL which you can find in the address bar of your browser.
4. Select Yes/No in the 'Sync All Sheets' field.
   • If you select Yes, then we will try to sync all sheets from the provided spreadsheet ignoring the hidden sheets.
   • If you select No, then we will just sync the sheet provided in the URL. So, please look at the spreadsheet URL which consists the gid parameter. ex. if the value is like gid=12345 then 12345 is the id of specific sheet and we will pull that specific sheet only.
5. Click the Authorize Your Account button which will transport you to the Google login, where you will login with your account credentials.   Once your credentials are accepted and you allow DataLakeHouse.io to access your data, you will be automatically redirected back to this DataLakeHouse.io portal and you should be able to see a successful connection.