All documentation: https://developers.google.com/sheets/api/samples
\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"10278160","collectionId":"5605b1f0-8507-4253-9c50-05181c967b38","publishedId":"UyrHftJV","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2022-05-04T00:19:24.000Z"},"item":[{"name":"Oauth Token - Example","id":"be313a22-c1b5-4aa9-9b15-e0323f6172c6","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"urlencoded","urlencoded":[{"key":"client_secret","value":"{{CLIENT_SECRET}}","description":"Created in Google Cloud Platform
\n","type":"text"},{"key":"grant_type","value":"refresh_token","description":"Fixed
\n","type":"text"},{"key":"refresh_token","value":"{{REFRESH_TOKEN}}","description":"Created in Google Oauth Playground
\n","type":"text"},{"key":"client_id","value":"{{CLIENT_ID}}","description":"Created in Google Cloud Platform
\n","type":"text"},{"key":"access_token","value":"{{ACCESS_TOKEN}}","description":"Created in Google Oauth Playground
\n","type":"text"},{"key":"project_id","value":"{{PROJECT_ID}}","description":"Name of the project
\n","type":"text"}]},"url":"https://oauth2.googleapis.com/token","description":"First step before using Get, Add or Update function.
\n","urlObject":{"protocol":"https","path":["token"],"host":["oauth2","googleapis","com"],"query":[{"disabled":true,"key":"valueInputOption","value":"USER_ENTERED"}],"variable":[]}},"response":[],"_postman_id":"be313a22-c1b5-4aa9-9b15-e0323f6172c6"},{"name":"Get Sheet - Example","id":"bbf66fd6-cedc-4159-8c9a-74f2878537af","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Authorization","value":"Bearer {{TOKEN}}","type":"text"}],"url":"https://sheets.googleapis.com/v4/spreadsheets/{{ID_SPREADSHEET}}/values/{{NAME_SHEET}}!{{RANGE}}?majorDimension=ROWS","description":"For more GET SHEETS examples: https://developers.google.com/sheets/api/samples/reading
\n","urlObject":{"protocol":"https","path":["v4","spreadsheets","{{ID_SPREADSHEET}}","values","{{NAME_SHEET}}!{{RANGE}}"],"host":["sheets","googleapis","com"],"query":[{"key":"majorDimension","value":"ROWS"}],"variable":[]}},"response":[],"_postman_id":"bbf66fd6-cedc-4159-8c9a-74f2878537af"},{"name":"Add Data Row - Example","id":"906b641a-5495-4d7f-8445-f0f5c29b9b5d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Authorization","value":"Bearer {{TOKEN}}","type":"text"}],"body":{"mode":"raw","raw":"{\n \"majorDimension\": \"ROWS\",\n \"values\": [\n [\"Dato 1\", \"Dato 2\", \"Dato 3\", \"Dato 4\"]\n ]\n}","options":{"raw":{"language":"json"}}},"url":"https://sheets.googleapis.com/v4/spreadsheets/{{ID_SPREADSHEET}}/values/{{NAME_SHEET}}!{{RANGE}}:append?valueInputOption=RAW","description":"For more writing examples: https://developers.google.com/sheets/api/samples/writing
\n","urlObject":{"protocol":"https","path":["v4","spreadsheets","{{ID_SPREADSHEET}}","values","{{NAME_SHEET}}!{{RANGE}}:append"],"host":["sheets","googleapis","com"],"query":[{"description":{"content":"The values the user has entered will not be parsed and will be stored as-is.
\n","type":"text/plain"},"key":"valueInputOption","value":"RAW"},{"disabled":true,"description":{"content":"The values will be parsed as if the user typed them into the UI. Numbers will stay as numbers, but strings may be converted to numbers, dates, etc. following the same rules that are applied when entering text into a cell via the Google Sheets UI.
\n","type":"text/plain"},"key":"valueInputOption","value":"USER_ENTERED"}],"variable":[]}},"response":[],"_postman_id":"906b641a-5495-4d7f-8445-f0f5c29b9b5d"},{"name":"Update Sheet for Range - Example","id":"be85421b-1c19-438f-9dba-f94a2c1c2e9f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Authorization","value":"Bearer {{TOKEN}}","type":"text"}],"body":{"mode":"raw","raw":"{\n \"majorDimension\": \"ROWS\",\n \"values\": [\n [\"Dato 1\", \"Dato 2\", \"Dato 3\", \"Dato 4\"]\n ]\n}","options":{"raw":{"language":"json"}}},"url":"https://sheets.googleapis.com/v4/spreadsheets/{{ID_SPREADSHEET}}/values/{{NAME_SHEET}}!{{RANGE}}?valueInputOption=RAW","description":"For more writing examples: https://developers.google.com/sheets/api/samples/writing
\n","urlObject":{"protocol":"https","path":["v4","spreadsheets","{{ID_SPREADSHEET}}","values","{{NAME_SHEET}}!{{RANGE}}"],"host":["sheets","googleapis","com"],"query":[{"description":{"content":"The values the user has entered will not be parsed and will be stored as-is.
\n","type":"text/plain"},"key":"valueInputOption","value":"RAW"},{"disabled":true,"description":{"content":"The values will be parsed as if the user typed them into the UI. Numbers will stay as numbers, but strings may be converted to numbers, dates, etc. following the same rules that are applied when entering text into a cell via the Google Sheets UI.
\n","type":"text/plain"},"key":"valueInputOption","value":"USER_ENTERED"}],"variable":[]}},"response":[],"_postman_id":"be85421b-1c19-438f-9dba-f94a2c1c2e9f"}]}