{"id":27815,"date":"2019-09-13T07:33:57","date_gmt":"2019-09-13T06:33:57","guid":{"rendered":"https:\/\/www.okappy.com\/?post_type=avada_portfolio&#038;p=27815"},"modified":"2019-09-13T07:33:57","modified_gmt":"2019-09-13T06:33:57","slug":"dynamically-linking-data-between-okappy-and-google-sheets","status":"publish","type":"avada_portfolio","link":"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-and-google-sheets\/","title":{"rendered":"Dynamically linking data between Okappy and Google Sheets"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;margin-bottom: 0px;margin-top: 0px;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"margin-top:0px;margin-bottom:20px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-1 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"margin-top:0px;margin-bottom:31px;\"><h1 class=\"title-heading-left\" style=\"margin:0;\">Dynamically linking data between Okappy and Google Sheets<\/h1><\/div><div class=\"fusion-text fusion-text-1\" style=\"transform:translate3d(0,0,0);\"><p>Certain version of Google Sheets can now integrate with Okappy and pull in your information periodically into an Excel sheet where you can then manipulate the data and generate management information.<\/p>\n<p>Read on to find out how to connect Google Sheets with Okappy.<\/p>\n<\/div><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-2 fusion-sep-none fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-bottom:31px;\"><h3 class=\"title-heading-left\" style=\"margin:0;\">1) Generate your report data formula within Okappy<\/h3><\/div><div class=\"fusion-text fusion-text-2\" style=\"transform:translate3d(0,0,0);\"><p>From within Okappy, generate your <strong>Google Sheets URL<\/strong> by<\/p>\n<ul>\n<li>Clicking <strong>Reports<\/strong><\/li>\n<li>Selecting the relevant report<\/li>\n<li>Choose your options and click <strong>Generate Report<\/strong><\/li>\n<li>Once the report has been created, click the <strong>Google Sheets Icon<\/strong> ( <img class=\"lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/google-sheets-icon-16x16.png\" alt=\"Google Sheets Icon\" \/>\u00a0)<\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27817\" title=\"Okappy Export Data Google Sheets\" src=\"https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets-1024x707.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets-1024x707.png\" alt=\"Okappy Export Data Google Sheets\" width=\"1024\" height=\"707\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27707%27%20viewBox%3D%270%200%201024%20707%27%3E%3Crect%20width%3D%271024%27%20height%3D%273707%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets-200x138.png 200w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets-300x207.png 300w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets-400x276.png 400w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets-600x414.png 600w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets-768x530.png 768w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets-800x552.png 800w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets-1024x707.png 1024w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets-1200x828.png 1200w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Google-Sheets.png 1265w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>Click the <strong>Copy formula<\/strong> button<\/li>\n<li>The formula will be copied<\/li>\n<\/ul>\n<\/div><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-3 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"margin-top:0px;margin-bottom:31px;\"><h1 class=\"title-heading-left\" style=\"margin:0;\">2) Link Your Google Sheets spreadsheet to Okappy<\/h1><\/div><div class=\"fusion-text fusion-text-3\" style=\"transform:translate3d(0,0,0);\"><p>From within Google Sheets,<\/p>\n<ul>\n<li>Select a cell<\/li>\n<li>Press <strong>CTRL V<\/strong> (CMD V) to paste the formula into the cell<\/li>\n<li>The data will be loaded into Google Sheets<\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27818\" title=\"Okappy Google Sheets Paste Formula\" src=\"https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula-1024x707.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula-1024x707.png\" alt=\"Okappy Google Sheets Paste Formula\" width=\"1024\" height=\"707\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27707%27%20viewBox%3D%270%200%201024%20707%27%3E%3Crect%20width%3D%271024%27%20height%3D%273707%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula-200x138.png 200w, https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula-300x207.png 300w, https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula-400x276.png 400w, https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula-600x414.png 600w, https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula-768x530.png 768w, https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula-800x552.png 800w, https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula-1024x707.png 1024w, https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula-1200x828.png 1200w, https:\/\/okappyimages.okappy.com\/Okappy-Google-Sheets-Paste-Formula.png 1265w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<\/div><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-4 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"margin-top:0px;margin-bottom:31px;\"><h1 class=\"title-heading-left\" style=\"margin:0;\">3) Keeping data current<\/h1><\/div><div class=\"fusion-text fusion-text-4\" style=\"transform:translate3d(0,0,0);\"><ul>\n<li>If you want to show data added up to the current date, edit the formula you posted above by replacing the date in the <strong>toDate<\/strong> parameter with <strong><em>&amp;text(TODAY(),&#8221;dd-mm-yyyy hh:MM&#8221;)&amp;<\/em><\/strong><\/li>\n<li>Google will update the data when you open the sheet and periodically thereafter<\/li>\n<li>It&#8217;s not current possibly to change the frequency that Google Sheets updates the data<\/li>\n<\/ul>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Find out how to dynamically pull information from Okappy into Google Sheets and generate management information<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"spay_email":""},"portfolio_category":[],"portfolio_skills":[],"portfolio_tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v16.6.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Dynamically linking data between Okappy and Google Sheets - Okappy<\/title>\n<meta name=\"description\" content=\"Find out how to dynamically pull information from Okappy into Google Sheets where you can manipulate the data and generate management information.\" \/>\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.okappy.com\/support-article\/dynamically-linking-data-between-okappy-and-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dynamically linking data between Okappy and Google Sheets - Okappy\" \/>\n<meta property=\"og:description\" content=\"Find out how to dynamically pull information from Okappy into Google Sheets where you can manipulate the data and generate management information.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-and-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Okappy\" \/>\n<meta property=\"og:image\" content=\"https:\/\/okappyimages.okappy.com\/google-sheets-icon-16x16.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.okappy.com\/#organization\",\"name\":\"Okappy Limited\",\"url\":\"https:\/\/www.okappy.com\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.okappy.com\/#logo\",\"inLanguage\":\"en-GB\",\"url\":\"https:\/\/okappyimages.okappy.com\/images\/20171223135158\/okappy-logo%402x-e1547078327884.png\",\"contentUrl\":\"https:\/\/okappyimages.okappy.com\/images\/20171223135158\/okappy-logo%402x-e1547078327884.png\",\"width\":452,\"height\":210,\"caption\":\"Okappy Limited\"},\"image\":{\"@id\":\"https:\/\/www.okappy.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.okappy.com\/#website\",\"url\":\"https:\/\/www.okappy.com\/\",\"name\":\"Okappy\",\"description\":\"Rethinking workforce management\",\"publisher\":{\"@id\":\"https:\/\/www.okappy.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.okappy.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-and-google-sheets\/#primaryimage\",\"inLanguage\":\"en-GB\",\"url\":\"https:\/\/okappyimages.okappy.com\/google-sheets-icon-16x16.png\",\"contentUrl\":\"https:\/\/okappyimages.okappy.com\/google-sheets-icon-16x16.png\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-and-google-sheets\/#webpage\",\"url\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-and-google-sheets\/\",\"name\":\"Dynamically linking data between Okappy and Google Sheets - Okappy\",\"isPartOf\":{\"@id\":\"https:\/\/www.okappy.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-and-google-sheets\/#primaryimage\"},\"datePublished\":\"2019-09-13T06:33:57+00:00\",\"dateModified\":\"2019-09-13T06:33:57+00:00\",\"description\":\"Find out how to dynamically pull information from Okappy into Google Sheets where you can manipulate the data and generate management information.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-and-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-and-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-and-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.okappy.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Portfolio\",\"item\":\"https:\/\/www.okappy.com\/support-article\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Dynamically linking data between Okappy and Google Sheets\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/avada_portfolio\/27815"}],"collection":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/avada_portfolio"}],"about":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/types\/avada_portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/comments?post=27815"}],"version-history":[{"count":0,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/avada_portfolio\/27815\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/media?parent=27815"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/portfolio_category?post=27815"},{"taxonomy":"portfolio_skills","embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/portfolio_skills?post=27815"},{"taxonomy":"portfolio_tags","embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/portfolio_tags?post=27815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}