Connecting to Google Sheets

Show and Tell
1

hello all,

getting data into Tulip from Google Sheets can be very useful as to enhance the functionality of apps. this can be achieved quickly by using the Google Sheets API.

here’s a quick guide:

  1. ensure sharing is enabled on your Google Sheet
    Screen Shot 9
    Screen Shot 93104×1928 360 KB
  2. create the Connector in Tulip with the following information:
    host: sheets.googleapis.com
    TLS: Yes
    Screen Shot 12
    Screen Shot 123104×1928 315 KB

    method: GET
    endpoint: /v4/spreadsheets/{spreadsheet_id}/values/{column from}{row from}:{column to}{row to}?key={api key}
    Screen Shot 11
    Screen Shot 113104×1928 388 KB

once the outputs are selected, the function can be Run from apps as to get data into your Tulip apps!!

navigate to Google console to create API credentials: https://console.developers.google.com/apis.

hope this helps, let me know if you have any questions.

gio