Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I was able to solve this using Http Client origin. I referred to Google Sheets API at https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchGet

https://sheets.googleapis.com/v4/spreadsheets/${SPREADSHEET_ID}/values:batchGet?ranges=${SHEETNAME}!${START_CELL}:${END_CELL}&key=${API_KEY}

API Key needs be created from Google Console and enabled for Google Sheets.