Get spreadsheet
GET {{baseURL}}/1sBHRCV73VmPbu6q4SQf0k91y0c67n0I9NLjQk89BDaQ?baseURL=https://sheets.googleapis.com/v4/spreadsheets
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
baseURL | string |
RESPONSES
status: OK
{"spreadsheetId":"1sBHRCV73VmPbu6q4SQf0k91y0c67n0I9NLjQk89BDaQ","properties":{"title":"Test Spreadsheet","locale":"en_US","autoRecalc":"ON_CHANGE","timeZone":"Africa/Lagos","defaultFormat":{"backgroundColor":{"red":1,"green":1,"blue":1},"padding":{"top":2,"right":3,"bottom":2,"left":3},"verticalAlignment":"BOTTOM","wrapStrategy":"OVERFLOW_CELL","textFormat":{"foregroundColor":{},"fontFamily":"arial,sans,sans-serif","fontSize":10,"bold":false,"italic":false,"strikethrough":false,"underline":false,"foregroundColorStyle":{"rgbColor":{}}},"backgroundColorStyle":{"rgbColor":{"red":1,"green":1,"blue":1}}},"spreadsheetTheme":{"primaryFontFamily":"Arial","themeColors":[{"colorType":"TEXT","color":{"rgbColor":{}}},{"colorType":"BACKGROUND","color":{"rgbColor":{"red":1,"green":1,"blue":1}}},{"colorType":"ACCENT1","color":{"rgbColor":{"red":0.25882354,"green":0.52156866,"blue":0.95686275}}},{"colorType":"ACCENT2","color":{"rgbColor":{"red":0.91764706,"green":0.2627451,"blue":0.20784314}}},{"colorType":"ACCENT3","color":{"rgbColor":{"red":0.9843137,"green":0.7372549,"blue":0.015686275}}},{"colorType":"ACCENT4","color":{"rgbColor":{"red":0.20392157,"green":0.65882355,"blue":0.3254902}}},{"colorType":"ACCENT5","color":{"rgbColor":{"red":1,"green":0.42745098,"blue":0.003921569}}},{"colorType":"ACCENT6","color":{"rgbColor":{"red":0.27450982,"green":0.7411765,"blue":0.7764706}}},{"colorType":"LINK","color":{"rgbColor":{"red":0.06666667,"green":0.33333334,"blue":0.8}}}]}},"sheets":[{"properties":{"sheetId":0,"title":"Sheet1","index":0,"sheetType":"GRID","gridProperties":{"rowCount":1000,"columnCount":26}}}],"spreadsheetUrl":"https://docs.google.com/spreadsheets/d/1sBHRCV73VmPbu6q4SQf0k91y0c67n0I9NLjQk89BDaQ/edit?ouid=101433676333211534128"}