-png.png?width=1744&height=822&name=Screenshot%20(1229)-png.png)
Overview
DataBlend can collect data from a Google Sheet based on a Sheet ID and Range of cells. The range of cells can include a first row of column headers as a Boolean selection option.
Configuration
-
Add a new collector.
-
Complete the configuration fields and save the collector.
Field |
Required |
Comments |
---|---|---|
Type |
Required |
Google Sheets |
Name |
Required |
Free-text. |
Data Source |
Required |
Select from list of configured data sources. Data sources are configured separately. |
Schema |
Required |
Free-text. Used when writing queries against the collected data. If a schema with this name does not already exist, one will be created under the selected data source. |
Credential |
Required |
Select from the list of configured Google Sheets credentials. |
Sheet |
Required |
Name of the Spreadsheet in Google Sheets |
Range |
Required |
The range of cells within the Sheet to collect. (e.g. Sheet1!A1:C20 ; Sheet1!A:Z) |
First Row Column Names |
Optional |
Boolean selection to include column headers or not |
3. Use the Collect Now button to run the collection and initialize the schema.

Troubleshooting
Having trouble loading sheets or drive information within DataBlend? Try disconnecting and reconnecting the Credential. To learn more about the Google Sheets Credential, please visit Google Sheets Credentials