Skip to content
Edit this page

Google Sheets datasource

Google Sheets datasource allows fetching data from Google Sheets living in your Google Drive.

Working with Google Sheets

  1. Create a new Google Sheets connection as explained in the instructions.

  2. Once your connection is ready click on ADD QUERY in the Inspector on the right.

  3. Select Google Sheets datasource and click CREATE QUERY:

    Google Sheets type

  4. You can modify all the basic configuration settings as described in queries section.

  5. In addition you can configure following properties inline:

    Google Sheets configuration

    • Select spreadsheet - browse for a spreadsheet that you own or that is shared with you.

    • Select sheet - choose a spreadsheet's sheet from which you want to pull the data.

    • Range - select a range of cells from which the data should be pulled.

    • First row contains column headers - enable this setting if you would like to use names defined in a header row as the name for object keys in a response.

  6. Once finished with configuration click SAVE to commit your changes and return to the canvas.