Google Sheets
DLH.io documentation for 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
- Use only Google Sheet documents
Setup Instructions
Follow the setup steps guide for configuring your Google Sheets connection to enable data to flow into your destination via DLH.
Supported Features
Here are key features supported for this connector.
| Sync Feature | Supported | Details |
|---|---|---|
| Custom Data and Development | ✓ | Ability to enhance connector upon request |
| Historical Re-Load/Load | ✓ | |
| Incremental/Delta Load | ✓ | Gets most recent records and changes |
| Column Selection | ✓ | |
| Column Hashing | ✓ | |
| Re-Sync Table/Entity | ✓ | Select at the table level to reload data history (on next Sync Bridge run) |
| Custom Queries | Utilizing SQL Data Query Connector | |
| Custom Data | ||
| Captures Deleted Rows | ✓ | On all supported tables |
| API Sync Bridge Initiation | ✓ | |
| Priority Scheduling | ✓ | |
| Private VPC/Link | ☂ | |
| DLH Data Model Available | - |
If you have any questions about these supported features please reach out to our Customer Support team.
Details on Sync Processing
For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.
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 allow logic to be executed against a target connection based on a scheduled frequency or triggered event of new data on tables updated via DLH.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 DLH.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 DLH.io Support Portal.