Connecting to Google Sheets

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
  2. create the Connector in Tulip with the following information:
    TLS: Yes

    method: GET
    endpoint: /v4/spreadsheets/{spreadsheet_id}/values/{column from}{row from}:{column to}{row to}?key={api key}

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:

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