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 use only google sheet documents do not confuse this with xls/x files that you may be merely viewing through the goole sheets interface 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 enter a name or alias for this connection, in the ' name/alias ' field, that is unique from other connectors 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 provide the ' sheet url ' field, the spreadsheet url which you can find in the address bar of your browser 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 similar to a single sheet, please copy the url and ensure it has a #gid=xxx at the end of the url 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 for example, https //docs google com/spreadsheets/d/13xxp3b35fx0d77jbs60jlc2mmm2zjwk6cslda8u7o9i/edit#gid=109876 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 known issues / gotchas one common mistake using this connector is that a user will have opened an xls/x file via google sheets but this is not a google sheet document and cannot be used for this connector you will receive a 400 error in the logs and monitoring section if this happens in this case you have a few choices conver the xls/x file to a google sheet use the google drive connector instead and point to the folder where the xlsx/xls file resides use the flat file connector and manually upload your xls/x file (this would require you to re upload the file every time it changes in this option) control each column data type sql transformations docid 5zjgrvbhtywqw8 olioh0 allow logic to be executed against a target connection based on a scheduled frequency or triggered event of new data on tables updated via datalakehouse io (dlh io) this especially helps when you want to control the data type set in your target connection since all columns are set as varchar(16777216) issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com