{"id":3456,"date":"2022-05-06T10:35:31","date_gmt":"2022-05-06T09:35:31","guid":{"rendered":"https:\/\/gatlabs.com\/knowledge\/?post_type=docs&#038;p=3456"},"modified":"2023-04-02T04:16:53","modified_gmt":"2023-04-02T03:16:53","password":"","slug":"export-a-tree-view-of-all-shared-drives-to-google-sheet","status":"publish","type":"docs","link":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/","title":{"rendered":"Export a tree view of all shared drives to Google sheet"},"content":{"rendered":"<h2>Google Drive Folder tree<\/h2>\n<p>GAT+ provides a detailed view of your domain&#8217;s Google Drive. A Google Workspace admin can use it to view the Folder tree of their entire domain.<\/p>\n<ul>\n<li><strong>My Drives<\/strong><\/li>\n<li><strong>Shared Drives<\/strong><\/li>\n<li><strong>External Folders\u00a0<\/strong><\/li>\n<\/ul>\n<p>Simply <strong>navigate<\/strong> <strong>down the tree<\/strong> and<strong> export<\/strong> individually for each\u00a0<span class=\"il\">Folder.<\/span><\/p>\n<p>Navigate to <strong>GAT+ &gt; Drive &gt; Folder Tree<\/strong><\/p>\n<p>From the menu on the left select <strong>Shared Drives<\/strong> &#8211; this will show all the <strong>Root Shared Drives<\/strong> of the domain in the Folder tree view.<\/p>\n<p>The Admin can see:<\/p>\n<ul>\n<li>Detailed view &#8211; metadata for the folder itself<\/li>\n<li>Files list &#8211; List of the files within<\/li>\n<\/ul>\n<h2>Export sheet<\/h2>\n<p>The Files list can be exported into Google Sheet (6)<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-3457\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window.png\" alt=\"\" width=\"1557\" height=\"902\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window.png 1557w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window-300x174.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window-1024x593.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window-768x445.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window-1536x890.png 1536w\" sizes=\"(max-width: 1557px) 100vw, 1557px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Shared Drive view<\/h2>\n<p>Additionally,\u00a0you can navigate to\u00a0<b>Drive &gt;\u00a0<span class=\"il\">Shared<\/span>\u00a0<span class=\"il\">Drives<\/span><\/b>\u00a0&#8211; where we show all the <strong>Root\u00a0<span class=\"il\">Shared<\/span>\u00a0<span class=\"il\">Drives<\/span><\/strong>.<\/p>\n<p>You\u00a0can click on this root\u00a0<span class=\"il\">Shared<\/span>\u00a0Drive and export (Show content\u00a0of this\u00a0<span class=\"il\">folder<\/span>\u00a0and its subfolders &#8211; then<b> Export<\/b>)<\/p>\n<p>Apply filter and find the Shared Drives you need.<\/p>\n<p>Click on the <strong>arrow beside the Title<\/strong> then <strong>Show the content of this folder and its subfolders<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3458\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_21_11-Window.png\" alt=\"\" width=\"1422\" height=\"575\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_21_11-Window.png 1422w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_21_11-Window-300x121.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_21_11-Window-1024x414.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_21_11-Window-768x311.png 768w\" sizes=\"(max-width: 1422px) 100vw, 1422px\" \/><\/p>\n<p>The result will show the content of the selected Shared Drive folder.<\/p>\n<p>This can be then <strong>exported<\/strong> into <strong>CSV<\/strong> or <strong>Google Sheet<\/strong> file<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3459\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-05-06-12_33_21-Window.png\" alt=\"\" width=\"1577\" height=\"559\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-05-06-12_33_21-Window.png 1577w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-05-06-12_33_21-Window-300x106.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-05-06-12_33_21-Window-1024x363.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-05-06-12_33_21-Window-768x272.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-05-06-12_33_21-Window-1536x544.png 1536w\" sizes=\"(max-width: 1577px) 100vw, 1577px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Drive Folder tree GAT+ provides a detailed view of your domain&#8217;s Google Drive. A Google Workspace admin can use it to view the Folder tree of their entire domain. My Drives Shared Drives External Folders\u00a0 Simply navigate down the tree and export individually for each\u00a0Folder. Navigate to GAT+ &gt; Drive &gt; Folder Tree From [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[21],"glossaries":[],"doc_tag":[24],"class_list":["post-3456","docs","type-docs","status-publish","hentry","doc_category-drive-management","doc_tag-gat"],"year_month":"2026-04","word_count":204,"total_views":"5459","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"stan","author_nicename":"stan","author_url":"https:\/\/gatlabs.com\/knowledge\/author\/stan\/"},"doc_category_info":[{"term_name":"Drive Audit &amp; Management","term_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips-category\/drive-management\/"}],"doc_tag_info":[{"term_name":"GAT+","term_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips-tag\/gat\/"}],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Export a tree view of all shared drives to Google sheet - GAT Knowledge Base<\/title>\n<meta name=\"description\" content=\"GAT+ allows a detailed view of the Google Drive of the domain. The admin can view the Folder tree of the entire domain and export tree view of all shared drives\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export a tree view of all shared drives to Google sheet\" \/>\n<meta property=\"og:description\" content=\"GAT+ allows a detailed view of the Google Drive of the domain. The admin can view the Folder tree of the entire domain and export tree view of all shared drives\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"GAT Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-02T03:16:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window.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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/export-a-tree-view-of-all-shared-drives-to-google-sheet\\\/\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/export-a-tree-view-of-all-shared-drives-to-google-sheet\\\/\",\"name\":\"Export a tree view of all shared drives to Google sheet - GAT Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/export-a-tree-view-of-all-shared-drives-to-google-sheet\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/export-a-tree-view-of-all-shared-drives-to-google-sheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/2022-03-28-11_17_16-Window.png\",\"datePublished\":\"2022-05-06T09:35:31+00:00\",\"dateModified\":\"2023-04-02T03:16:53+00:00\",\"description\":\"GAT+ allows a detailed view of the Google Drive of the domain. The admin can view the Folder tree of the entire domain and export tree view of all shared drives\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/export-a-tree-view-of-all-shared-drives-to-google-sheet\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/export-a-tree-view-of-all-shared-drives-to-google-sheet\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/export-a-tree-view-of-all-shared-drives-to-google-sheet\\\/#primaryimage\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/2022-03-28-11_17_16-Window.png\",\"contentUrl\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/2022-03-28-11_17_16-Window.png\",\"width\":1557,\"height\":902},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/export-a-tree-view-of-all-shared-drives-to-google-sheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tech Tips\",\"item\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Export a tree view of all shared drives to Google sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#website\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/\",\"name\":\"GAT Knowledge Base\",\"description\":\"Your source of all things GAT\",\"publisher\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#organization\",\"name\":\"GAT Labs Knowledge Base\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Group-1159.svg\",\"contentUrl\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Group-1159.svg\",\"width\":361,\"height\":97,\"caption\":\"GAT Labs Knowledge Base\"},\"image\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Export a tree view of all shared drives to Google sheet - GAT Knowledge Base","description":"GAT+ allows a detailed view of the Google Drive of the domain. The admin can view the Folder tree of the entire domain and export tree view of all shared drives","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:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/","og_locale":"en_GB","og_type":"article","og_title":"Export a tree view of all shared drives to Google sheet","og_description":"GAT+ allows a detailed view of the Google Drive of the domain. The admin can view the Folder tree of the entire domain and export tree view of all shared drives","og_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/","og_site_name":"GAT Knowledge Base","article_modified_time":"2023-04-02T03:16:53+00:00","og_image":[{"url":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/","url":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/","name":"Export a tree view of all shared drives to Google sheet - GAT Knowledge Base","isPartOf":{"@id":"https:\/\/gatlabs.com\/knowledge\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/#primaryimage"},"image":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window.png","datePublished":"2022-05-06T09:35:31+00:00","dateModified":"2023-04-02T03:16:53+00:00","description":"GAT+ allows a detailed view of the Google Drive of the domain. The admin can view the Folder tree of the entire domain and export tree view of all shared drives","breadcrumb":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/#primaryimage","url":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window.png","contentUrl":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/05\/2022-03-28-11_17_16-Window.png","width":1557,"height":902},{"@type":"BreadcrumbList","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/export-a-tree-view-of-all-shared-drives-to-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gatlabs.com\/knowledge\/"},{"@type":"ListItem","position":2,"name":"Tech Tips","item":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/"},{"@type":"ListItem","position":3,"name":"Export a tree view of all shared drives to Google sheet"}]},{"@type":"WebSite","@id":"https:\/\/gatlabs.com\/knowledge\/#website","url":"https:\/\/gatlabs.com\/knowledge\/","name":"GAT Knowledge Base","description":"Your source of all things GAT","publisher":{"@id":"https:\/\/gatlabs.com\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gatlabs.com\/knowledge\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/gatlabs.com\/knowledge\/#organization","name":"GAT Labs Knowledge Base","url":"https:\/\/gatlabs.com\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/gatlabs.com\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/Group-1159.svg","contentUrl":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/Group-1159.svg","width":361,"height":97,"caption":"GAT Labs Knowledge Base"},"image":{"@id":"https:\/\/gatlabs.com\/knowledge\/#\/schema\/logo\/image\/"}}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/3456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/comments?post=3456"}],"version-history":[{"count":7,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/3456\/revisions"}],"predecessor-version":[{"id":7126,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/3456\/revisions\/7126"}],"wp:attachment":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/media?parent=3456"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/doc_category?post=3456"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/glossaries?post=3456"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/doc_tag?post=3456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}