Skip to main content

Reading data

  1. Add a new HTTP request module from the Integrations menu

img/googlesheet5.png

  1. Open Settings by clicking on GET http://, then add URL to Google Sheets JSON as following

    [https://sheets.googleapis.com/v4/spreadsheets/](https://sheets.googleapis.com/v4/spreadsheets/)**document_id**/values/**tab_name**!**row_column**?alt=json&key=**api_key**

    document_id is id of your Google Sheets document
    tab_name is name of tab in document (usually Sheet1)
    row_column is column and row index, e.g. A1 - first column and first row
    api_key can be obtained from https://console.cloud.google.com/apis/credentials

    Full example: https://sheets.googleapis.com/v4/spreadsheets/1pa5pIeoPMY9Z3DjSTgmoo_Of-6kGNGYq_BqITwRyWkM/values/Sheet1!A8?alt=json&key=REDACTED

  2. Add Regular Expression match under Store response to variable. Use \[\s+\"(.*?)\" as Selector (it will match ["…. "] in response body) and assign variable that will hold result value.

  3. Save and test functionality from the shared widget.

img/googlesheet6.png

tip

HTTP requests are not executed in preview mode, only from the published widgets