{"id":7470,"date":"2018-05-06T17:54:45","date_gmt":"2018-05-06T15:54:45","guid":{"rendered":"https:\/\/www.tomislavstankovic.com\/blog\/?p=7470"},"modified":"2018-05-06T17:54:45","modified_gmt":"2018-05-06T15:54:45","slug":"uvod-u-google-sheets-api","status":"publish","type":"post","link":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/","title":{"rendered":"Uvod u Google Sheets API"},"content":{"rendered":"<p>Nedavno mi je pala na pamet ideja kori\u0161tenja <em><a href=\"https:\/\/developers.google.com\/sheets\/\" rel=\"noopener\" target=\"_blank\">Google Sheetsa<\/a><\/em> kao baze podataka za nekakvu jednostavniju web ili mobilnu aplikaciju pa sam i\u0161ao malo istra\u017eiti koje sve mogu\u0107nosti <em><a href=\"https:\/\/developers.google.com\/sheets\/api\/guides\/concepts\" rel=\"noopener\" target=\"_blank\">Google Sheets API<\/a><\/em> ima i kako ih koristiti. U nastavku se mo\u017ee vidjeti nekoliko primjera na osnovu jednog dokumenta s dvije kartice podataka. <\/p>\n<h2>Google Developer konzola<\/h2>\n<p>Na URL-u <a href=\"https:\/\/console.developers.google.com\/\" rel=\"noopener\" target=\"_blank\">https:\/\/console.developers.google.com\/<\/a> kreiram novi projekt.<\/p>\n<p>Nakon toga klikom na \u2018<em>Enable Apis And Services<\/em>\u2018 kre\u0107em u odabir <em>Google Sheets API<\/em>-ja kako bi ga aktivirao.<\/p>\n<p><a href=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-1-min.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-1-min.png\" alt=\"Google Sheets API\" width=\"1033\" height=\"927\" class=\"aligncenter size-full wp-image-7477\" srcset=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-1-min.png 1033w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-1-min-300x269.png 300w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-1-min-768x689.png 768w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-1-min-1024x919.png 1024w\" sizes=\"auto, (max-width: 1033px) 100vw, 1033px\" \/><\/a><\/p>\n<p>Nakon aktivacije kreiram <em>API key<\/em> koji mi je potreban za slanje upita na <em>API<\/em>.<\/p>\n<p>Bez njega bi dobio <a href=\"https:\/\/stackoverflow.com\/questions\/44750946\/google-sheet-api-v4\" rel=\"noopener\" target=\"_blank\">poruku o gre\u0161ci<\/a>:<\/p>\n<pre class=\"lang:default decode:true \" >{\r\n  \"error\": {\r\n    \"code\": 403,\r\n    \"message\": \"The request is missing a valid API key.\",\r\n    \"status\": \"PERMISSION_DENIED\"\r\n  }\r\n}<\/pre>\n<p><a href=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-2-min.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-2-min.png\" alt=\"Google Sheets API\" width=\"827\" height=\"756\" class=\"aligncenter size-full wp-image-7479\" srcset=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-2-min.png 827w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-2-min-300x274.png 300w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-2-min-768x702.png 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/a><\/p>\n<h2>Kori\u0161tenje API-ja<\/h2>\n<p>Na sljede\u0107oj se slici mo\u017ee vidjeti koji su mi upiti dostupni<\/p>\n<p><a href=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-3-min.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-3-min.png\" alt=\"Google Sheets API\" width=\"1914\" height=\"1025\" class=\"aligncenter size-full wp-image-7488\" srcset=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-3-min.png 1914w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-3-min-300x161.png 300w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-3-min-768x411.png 768w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-3-min-1024x548.png 1024w\" sizes=\"auto, (max-width: 1914px) 100vw, 1914px\" \/><\/a><\/p>\n<h3>Prikaz podataka<\/h3>\n<p>Na sljede\u0107oj adresi <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1NVbthCyv4BuFbU3rv3ZBe0Pw6_4hHCgIdJfkKtvmD-M\/\" rel=\"noopener\" target=\"_blank\">https:\/\/docs.google.com\/spreadsheets\/d\/1NVbthCyv4BuFbU3rv3ZBe0Pw6_4hHCgIdJfkKtvmD-M\/<\/a> nalazi se moja prora\u010dunska tablica. Njezin <em>ID<\/em> je <span class=\"lang:default decode:true crayon-inline\">1NVbthCyv4BuFbU3rv3ZBe0Pw6_4hHCgIdJfkKtvmD-M<\/span>.<\/p>\n<p><a href=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-5.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-5.gif\" alt=\"Google Sheets API\" width=\"1136\" height=\"484\" class=\"aligncenter size-full wp-image-7494\" \/><\/a><\/p>\n<p>Ako, prema dokumentaciji na slici iznad, odem na <em>Services<\/em> > <em>Google Sheets API v4<\/em> > <em>sheets.spreadsheets.get<\/em> i unesem <em>ID<\/em> svoje prora\u010dunske tablice dobit \u0107u rezultat s hrpom, meni trenutno nepotrebnih, meta podatka. <\/p>\n<p><a href=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-4.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-4.gif\" alt=\"Google Sheets API\" width=\"1148\" height=\"599\" class=\"aligncenter size-full wp-image-7492\" \/><\/a><\/p>\n<p>S obzirom da se moja prora\u010dunska tablica sastoji od dva lista posebno \u0107u pozvati <em>API<\/em> za svaki list.<\/p>\n<p>Na URL-u <span class=\"lang:default decode:true  crayon-inline \" >https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/1NVbthCyv4BuFbU3rv3ZBe0Pw6_4hHCgIdJfkKtvmD-M\/values\/Zadaci?key={YOUR_API_KEY}<\/span> dohva\u0107am podatke iz lista &#8216;Zadaci&#8217;.<\/p>\n<p><a href=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-6.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-6.gif\" alt=\"Google Sheets API\" width=\"1156\" height=\"727\" class=\"aligncenter size-full wp-image-7500\" \/><\/a><\/p>\n<p>Dok na URL-u <span class=\"lang:default decode:true  crayon-inline \" >https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/1NVbthCyv4BuFbU3rv3ZBe0Pw6_4hHCgIdJfkKtvmD-M\/values\/Podaci?key={YOUR_API_KEY}<\/span> dohva\u0107am podatke iz lista &#8216;Podaci&#8217;.<\/p>\n<p><a href=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-7.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-7.gif\" alt=\"Google Sheets API\" width=\"1157\" height=\"726\" class=\"aligncenter size-full wp-image-7502\" \/><\/a><\/p>\n<h3>Dodavanje podataka<\/h3>\n<p>Na sljede\u0107oj adresi <a href=\"https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets.values\/append\" rel=\"noopener\" target=\"_blank\">https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets.values\/append<\/a> nalazi se dokumentacija vezana uz dodavanje sadr\u017eaja.<\/p>\n<p><a href=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-8.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-8.gif\" alt=\"Google Sheets API\" width=\"885\" height=\"1068\" class=\"aligncenter size-full wp-image-7507\" \/><\/a><\/p>\n<p>Ovo jo\u0161 moram testirati u <em><a href=\"https:\/\/www.getpostman.com\/\" rel=\"noopener\" target=\"_blank\">Postmanu<\/a><\/em>.<\/p>\n<h2>Zaklju\u010dak<\/h2>\n<p>Ovo je samo uvod u mogu\u0107nosti <em>Google Sheets API<\/em>-a. Za sada je ovo dovoljno \u010disto da se vidi kako stvar funkcionira, a dalje sve ovisi o specifi\u010dnim potrebama. Mo\u017eda na kraju zaklju\u010dim da ovo i nije najsretnije rje\u0161enje za kori\u0161tenje unutar web ili mobilne aplikacije. <\/p>\n<p><a href=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-9-min.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-9-min.jpg\" alt=\"Google Sheets API\" width=\"1100\" height=\"642\" class=\"aligncenter size-full wp-image-7509\" srcset=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-9-min.jpg 1100w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-9-min-300x175.jpg 300w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-9-min-768x448.jpg 768w, https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-9-min-1024x598.jpg 1024w\" sizes=\"auto, (max-width: 1100px) 100vw, 1100px\" \/><\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nedavno mi je pala na pamet ideja kori\u0161tenja Google Sheetsa kao baze podataka za nekakvu jednostavniju web ili mobilnu aplikaciju pa sam i\u0161ao malo istra\u017eiti koje sve mogu\u0107nosti Google Sheets API ima i kako ih koristiti. U nastavku se mo\u017ee vidjeti nekoliko primjera na osnovu jednog dokumenta s dvije kartice podataka. Google Developer konzola Na &hellip; <a href=\"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/\" class=\"more-link\">Nastavi \u010ditati <span class=\"screen-reader-text\">Uvod u Google Sheets API<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":7472,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[351],"tags":[376,507],"class_list":["post-7470","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-razvoj","tag-api","tag-google-sheets"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Uvod u Google Sheets API - Tomislav Stankovi\u0107<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/\" \/>\n<meta property=\"og:locale\" content=\"hr_HR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Uvod u Google Sheets API - Tomislav Stankovi\u0107\" \/>\n<meta property=\"og:description\" content=\"Nedavno mi je pala na pamet ideja kori\u0161tenja Google Sheetsa kao baze podataka za nekakvu jednostavniju web ili mobilnu aplikaciju pa sam i\u0161ao malo istra\u017eiti koje sve mogu\u0107nosti Google Sheets API ima i kako ih koristiti. U nastavku se mo\u017ee vidjeti nekoliko primjera na osnovu jednog dokumenta s dvije kartice podataka. Google Developer konzola Na &hellip; Nastavi \u010ditati Uvod u Google Sheets API\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/\" \/>\n<meta property=\"og:site_name\" content=\"Tomislav Stankovi\u0107\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-06T15:54:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-min.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"825\" \/>\n\t<meta property=\"og:image:height\" content=\"510\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Tomislav Stankovi\u0107\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisao\/la\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomislav Stankovi\u0107\" \/>\n\t<meta name=\"twitter:label2\" content=\"Procijenjeno vrijeme \u010ditanja\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/\"},\"author\":{\"name\":\"Tomislav Stankovi\u0107\",\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/#\\\/schema\\\/person\\\/0329c549c57700034ea77f5d3d78396d\"},\"headline\":\"Uvod u Google Sheets API\",\"datePublished\":\"2018-05-06T15:54:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/\"},\"wordCount\":354,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/#\\\/schema\\\/person\\\/0329c549c57700034ea77f5d3d78396d\"},\"image\":{\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Google-Sheets-API-min.jpg\",\"keywords\":[\"API\",\"Google Sheets\"],\"articleSection\":[\"Razvoj\"],\"inLanguage\":\"hr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/\",\"url\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/\",\"name\":\"Uvod u Google Sheets API - Tomislav Stankovi\u0107\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Google-Sheets-API-min.jpg\",\"datePublished\":\"2018-05-06T15:54:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/#breadcrumb\"},\"inLanguage\":\"hr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hr\",\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Google-Sheets-API-min.jpg\",\"contentUrl\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Google-Sheets-API-min.jpg\",\"width\":825,\"height\":510,\"caption\":\"Google Sheets API\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/uvod-u-google-sheets-api\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Po\u010detna stranica\",\"item\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uvod u Google Sheets API\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/\",\"name\":\"Tomislav Stankovi\u0107\",\"description\":\"Sam svoj bloger\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/#\\\/schema\\\/person\\\/0329c549c57700034ea77f5d3d78396d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/#\\\/schema\\\/person\\\/0329c549c57700034ea77f5d3d78396d\",\"name\":\"Tomislav Stankovi\u0107\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hr\",\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/cropped-TomislavStankovic.jpg\",\"url\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/cropped-TomislavStankovic.jpg\",\"contentUrl\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/cropped-TomislavStankovic.jpg\",\"width\":248,\"height\":165,\"caption\":\"Tomislav Stankovi\u0107\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/cropped-TomislavStankovic.jpg\"},\"description\":\"Bloger \u0161irokog raspona interesa od kojih dio voli objaviti na ovom blogu. U neslobodno vrijeme Angular developer mobilnih i web aplikacija.\",\"sameAs\":[\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/tomislavstankovic\\\/\"],\"url\":\"https:\\\/\\\/www.tomislavstankovic.com\\\/blog\\\/author\\\/tomislavstankovic\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Uvod u Google Sheets API - Tomislav Stankovi\u0107","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/","og_locale":"hr_HR","og_type":"article","og_title":"Uvod u Google Sheets API - Tomislav Stankovi\u0107","og_description":"Nedavno mi je pala na pamet ideja kori\u0161tenja Google Sheetsa kao baze podataka za nekakvu jednostavniju web ili mobilnu aplikaciju pa sam i\u0161ao malo istra\u017eiti koje sve mogu\u0107nosti Google Sheets API ima i kako ih koristiti. U nastavku se mo\u017ee vidjeti nekoliko primjera na osnovu jednog dokumenta s dvije kartice podataka. Google Developer konzola Na &hellip; Nastavi \u010ditati Uvod u Google Sheets API","og_url":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/","og_site_name":"Tomislav Stankovi\u0107","article_published_time":"2018-05-06T15:54:45+00:00","og_image":[{"width":825,"height":510,"url":"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-min.jpg","type":"image\/jpeg"}],"author":"Tomislav Stankovi\u0107","twitter_card":"summary_large_image","twitter_misc":{"Napisao\/la":"Tomislav Stankovi\u0107","Procijenjeno vrijeme \u010ditanja":"2 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/#article","isPartOf":{"@id":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/"},"author":{"name":"Tomislav Stankovi\u0107","@id":"https:\/\/www.tomislavstankovic.com\/blog\/#\/schema\/person\/0329c549c57700034ea77f5d3d78396d"},"headline":"Uvod u Google Sheets API","datePublished":"2018-05-06T15:54:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/"},"wordCount":354,"commentCount":0,"publisher":{"@id":"https:\/\/www.tomislavstankovic.com\/blog\/#\/schema\/person\/0329c549c57700034ea77f5d3d78396d"},"image":{"@id":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/#primaryimage"},"thumbnailUrl":"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-min.jpg","keywords":["API","Google Sheets"],"articleSection":["Razvoj"],"inLanguage":"hr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/","url":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/","name":"Uvod u Google Sheets API - Tomislav Stankovi\u0107","isPartOf":{"@id":"https:\/\/www.tomislavstankovic.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/#primaryimage"},"image":{"@id":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/#primaryimage"},"thumbnailUrl":"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-min.jpg","datePublished":"2018-05-06T15:54:45+00:00","breadcrumb":{"@id":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/#breadcrumb"},"inLanguage":"hr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/"]}]},{"@type":"ImageObject","inLanguage":"hr","@id":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/#primaryimage","url":"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-min.jpg","contentUrl":"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2018\/05\/Google-Sheets-API-min.jpg","width":825,"height":510,"caption":"Google Sheets API"},{"@type":"BreadcrumbList","@id":"https:\/\/www.tomislavstankovic.com\/blog\/uvod-u-google-sheets-api\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Po\u010detna stranica","item":"https:\/\/www.tomislavstankovic.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Uvod u Google Sheets API"}]},{"@type":"WebSite","@id":"https:\/\/www.tomislavstankovic.com\/blog\/#website","url":"https:\/\/www.tomislavstankovic.com\/blog\/","name":"Tomislav Stankovi\u0107","description":"Sam svoj bloger","publisher":{"@id":"https:\/\/www.tomislavstankovic.com\/blog\/#\/schema\/person\/0329c549c57700034ea77f5d3d78396d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tomislavstankovic.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hr"},{"@type":["Person","Organization"],"@id":"https:\/\/www.tomislavstankovic.com\/blog\/#\/schema\/person\/0329c549c57700034ea77f5d3d78396d","name":"Tomislav Stankovi\u0107","image":{"@type":"ImageObject","inLanguage":"hr","@id":"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2019\/10\/cropped-TomislavStankovic.jpg","url":"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2019\/10\/cropped-TomislavStankovic.jpg","contentUrl":"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2019\/10\/cropped-TomislavStankovic.jpg","width":248,"height":165,"caption":"Tomislav Stankovi\u0107"},"logo":{"@id":"https:\/\/www.tomislavstankovic.com\/blog\/wp-content\/uploads\/2019\/10\/cropped-TomislavStankovic.jpg"},"description":"Bloger \u0161irokog raspona interesa od kojih dio voli objaviti na ovom blogu. U neslobodno vrijeme Angular developer mobilnih i web aplikacija.","sameAs":["https:\/\/www.tomislavstankovic.com\/blog\/","https:\/\/www.linkedin.com\/in\/tomislavstankovic\/"],"url":"https:\/\/www.tomislavstankovic.com\/blog\/author\/tomislavstankovic\/"}]}},"_links":{"self":[{"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/posts\/7470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/comments?post=7470"}],"version-history":[{"count":33,"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/posts\/7470\/revisions"}],"predecessor-version":[{"id":7514,"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/posts\/7470\/revisions\/7514"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/media\/7472"}],"wp:attachment":[{"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/media?parent=7470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/categories?post=7470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tomislavstankovic.com\/blog\/wp-json\/wp\/v2\/tags?post=7470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}