Collectors
      Back to home
      1. Knowledge Base
      2. Connect & Transform
      3. Collectors

      Google Sheets Collectors

      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

      1. Add a new collector.

        image-20210714-141413

         

      2. 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.

      image-20200819-213214

      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