{"id":2887,"date":"2022-02-11T12:45:03","date_gmt":"2022-02-11T12:45:03","guid":{"rendered":"https:\/\/gatlabs.com\/knowledge\/?post_type=docs&#038;p=2887"},"modified":"2026-01-29T12:08:21","modified_gmt":"2026-01-29T12:08:21","password":"","slug":"user-defined-variables-within-collaborative-spreadsheet","status":"publish","type":"docs","link":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/","title":{"rendered":"User Defined Variables Within Collaborative Spreadsheet"},"content":{"rendered":"<h3>User-Defined Variables Within Collaborative Spreadsheet<\/h3>\n<p>&#8220;Apply custom filters&#8221; to query the metadata within GAT+ is a common task when auditing your Google Workspace domain.<\/p>\n<p>Many times, you will have to query an auditing section by using search operators and search operands to retrieve the metadata.<\/p>\n<p>To make your metadata query more flexible and collaborative, we have a feature that allows you to pull in custom variables from a Google Spreadsheet when defining your filter query.<\/p>\n<p>What are the benefits?<\/p>\n<ul>\n<li>You can share a spreadsheet with contributors who can fill it in<\/li>\n<li>The Spreadsheet can contain a list of variables, such as Emails, Phone Numbers, Serial Numbers, and anything else.<\/li>\n<\/ul>\n<p>The custom variables can be pulled in any auditing section of GAT+.<\/p>\n<h3>Spreadsheet settings<\/h3>\n<p>While signed in to your Google Workspace admin account, the first step is to <strong>create a Google Spreadsheet in your Google Drive.<\/strong><\/p>\n<ol>\n<li>Give your newly created Google Spreadsheet aname.\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-2888\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_21_58-Films-TV.png\" alt=\"\" width=\"1095\" height=\"487\" data-wp-editing=\"1\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_21_58-Films-TV.png 1095w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_21_58-Films-TV-300x133.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_21_58-Films-TV-1024x455.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_21_58-Films-TV-768x342.png 768w\" sizes=\"(max-width: 1095px) 100vw, 1095px\" \/><\/li>\n<li>Take a note of the File ID of your Spreadsheet.\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2889\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_39_33-Collaborative-Spreadsheet-with-User-Defined-Variables-Google-Sheets.png\" alt=\"\" width=\"838\" height=\"534\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_39_33-Collaborative-Spreadsheet-with-User-Defined-Variables-Google-Sheets.png 838w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_39_33-Collaborative-Spreadsheet-with-User-Defined-Variables-Google-Sheets-300x191.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_39_33-Collaborative-Spreadsheet-with-User-Defined-Variables-Google-Sheets-768x489.png 768w\" sizes=\"(max-width: 838px) 100vw, 838px\" \/><\/li>\n<li>Share your spreadsheet with our email address (<strong>gat-app-sa@generalaudittool.com<\/strong> as a <strong>Viewer or Editor<\/strong>.<\/li>\n<li>Share this spreadsheet with the rest of your collaborative team so they can begin to contribute.<\/li>\n<\/ol>\n<h3>GAT+ Settings<\/h3>\n<p>Now, within the GAT+ tool, navigate to <strong>Configuration &gt; General &gt; Settings\u00a0<\/strong><\/p>\n<p>In the <strong>Sheet ID with variables<\/strong> field, enter the <strong>URL of the Google spreadsheet<\/strong> we created above<\/p>\n<p>Click on the <strong>Save<\/strong> button<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2890\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_56_33-Films-TV.png\" alt=\"\" width=\"1472\" height=\"724\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_56_33-Films-TV.png 1472w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_56_33-Films-TV-300x148.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_56_33-Films-TV-1024x504.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_56_33-Films-TV-768x378.png 768w\" sizes=\"(max-width: 1472px) 100vw, 1472px\" \/><\/p>\n<p>Within the Google spreadsheet, you can now begin building your custom variables.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2895\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_35_20-Mail.png\" alt=\"\" width=\"1697\" height=\"390\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_35_20-Mail.png 1697w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_35_20-Mail-300x69.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_35_20-Mail-1024x235.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_35_20-Mail-768x176.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_35_20-Mail-1536x353.png 1536w\" sizes=\"(max-width: 1697px) 100vw, 1697px\" \/><\/p>\n<p>Note: Every time you make a change, please wait 2 \u2013 5 minutes before your changes are loaded into GAT+.<\/p>\n<h4>Custom Variable Update within Admin Log<\/h4>\n<p>Whenever you update the Google Spreadsheet containing your list of Custom Variables, wait a few minutes so that GAT+ can recognize the changes.<\/p>\n<p>You can see the log within the <strong>GAT+ &gt; Configuration &gt; Admin Log<\/strong> menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3144\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_03_08-Calculator.png\" alt=\"\" width=\"1920\" height=\"455\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_03_08-Calculator.png 1920w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_03_08-Calculator-300x71.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_03_08-Calculator-1024x243.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_03_08-Calculator-768x182.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_03_08-Calculator-1536x364.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\n<h3>Invoking Custom Variables within a Custom Filter<\/h3>\n<h5>Using a Custom Variable in Filtering Metadata<\/h5>\n<p>In any auditing section of GAT+, apply a custom filter. And invoke your custom variables from the Spreadsheet.<\/p>\n<p>Using the format <strong>%variable_name%<\/strong> make sure to <strong>use percentage symbols on either side.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2894\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_29_02-.png\" alt=\"\" width=\"1202\" height=\"945\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_29_02-.png 1202w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_29_02--300x236.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_29_02--1024x805.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_29_02--768x604.png 768w\" sizes=\"(max-width: 1202px) 100vw, 1202px\" \/><\/p>\n<h5>Using a Custom Variable in Removing Permission<\/h5>\n<p>You can invoke Custom Variables when using the Remove Permission menu.<\/p>\n<p>This is especially helpful if you have to manually enter many values, such as full email addresses, partial domain names, or Public or Public with link sharing permissions to remove them.<\/p>\n<p>Pulling information from a Google Spreadsheet is much easier to maintain and use.<\/p>\n<h3>How to Use<\/h3>\n<p>Within the Drive audit menu, in the Files tab, select files\/folders with the checkbox, then select the Files Operatio,n then Remove Permissions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3054\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-22-13_27_52-GAT-1.png\" alt=\"\" width=\"1201\" height=\"813\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-22-13_27_52-GAT-1.png 1201w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-22-13_27_52-GAT-1-300x203.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-22-13_27_52-GAT-1-1024x693.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-22-13_27_52-GAT-1-768x520.png 768w\" sizes=\"(max-width: 1201px) 100vw, 1201px\" \/><\/p>\n<p>The Remove Permission menu fields can handle variables that are comma-separated.<\/p>\n<p>Example: <strong>*@gmail.com, public with link, public,*@yahoo.com,*@ExternalDomain.com<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3145\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_08_53-Calculator.png\" alt=\"\" width=\"1304\" height=\"353\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_08_53-Calculator.png 1304w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_08_53-Calculator-300x81.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_08_53-Calculator-1024x277.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-03-08-10_08_53-Calculator-768x208.png 768w\" sizes=\"(max-width: 1304px) 100vw, 1304px\" \/><\/p>\n<h4>Format Within Spreadsheet<\/h4>\n<p>In the Google Spreadsheet, I had a variable list like:<\/p>\n<p><strong>EXT_EMAILS<\/strong><\/p>\n<p>user1@abc.com,user2@xyz.com, etc. Use a <strong>comma<\/strong> to separate each value. So to invoke this during a filter query, I must use the Search operator <strong>in (comma-separated values)<\/strong>.<\/p>\n<p>If you wish to use a Regex or a partial list of values, you must use the Search operator <strong>matches (partial string or regex)<\/strong>.<\/p>\n<p>Within the spreadsheets, these list values would be something like <strong>domain1.com|domain2.xyz|bob@companyz.com<\/strong>, etc., with each value separated with a vertical bar ( | ) in logical OR.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2896\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_40_51-Mail.png\" alt=\"\" width=\"1646\" height=\"355\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_40_51-Mail.png 1646w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_40_51-Mail-300x65.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_40_51-Mail-1024x221.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_40_51-Mail-768x166.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-12_40_51-Mail-1536x331.png 1536w\" sizes=\"(max-width: 1646px) 100vw, 1646px\" \/><\/p>\n<table dir=\"ltr\" style=\"height: 147px;\" border=\"1\" width=\"370\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"100\" \/>\n<col width=\"157\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Variable 1&quot;}\">Variable 1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;value1,value2,value3&quot;}\">value1,value2,value3<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Variable 2&quot;}\">Variable 2<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;value1|value2|value3&quot;}\">value1|value2|value3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h6>Valid Search Operators within GAT+ for Custom Variables<\/h6>\n<p>Since all of the values in the Google Spreadsheet are strings (any sequence of characters). There are only a few search operators within the custom filter menu that would be compatible.<\/p>\n<ul>\n<li>in (comma-separated values)<\/li>\n<li>not in (comma-separated values)<\/li>\n<li>matches (partial string or reg.ex.)<\/li>\n<li>doesn&#8217;t match (partial string or reg.ex.)<\/li>\n<\/ul>\n<p><strong>Note:<\/strong><\/p>\n<p>In the current version, you can only use <strong>string<\/strong> values within your variable lists.<\/p>\n<h3>FAQ<\/h3>\n<p data-path-to-node=\"3\"><strong>1. How long does it take for changes in my Google Spreadsheet to appear in GAT+?<\/strong><\/p>\n<p data-path-to-node=\"4\">A. After you update a variable or add a new value to your spreadsheet, there is a synchronization delay of <b data-path-to-node=\"4\" data-index-in-node=\"104\">2 to 5 minutes<\/b>. You can verify that the update was successful by checking the <b data-path-to-node=\"4\" data-index-in-node=\"182\">Admin Log<\/b> under the Configuration menu in GAT+.<\/p>\n<p data-path-to-node=\"5\"><strong>2. What is the correct syntax for using a variable in a filter?<\/strong><\/p>\n<p data-path-to-node=\"6\">A. To invoke a variable, you must wrap the variable name (as defined in your spreadsheet) with percentage symbols.<\/p>\n<ul>\n<li data-path-to-node=\"7,0,0\"><b data-path-to-node=\"7,0,0\" data-index-in-node=\"0\">Format:<\/b> <code data-path-to-node=\"7,0,0\" data-index-in-node=\"8\">%your_variable_name%<\/code><\/li>\n<li data-path-to-node=\"7,1,0\"><b data-path-to-node=\"7,1,0\" data-index-in-node=\"0\">Example:<\/b> If your variable is named <code data-path-to-node=\"7,1,0\" data-index-in-node=\"35\">EXT_EMAILS<\/code>, you would enter <code data-path-to-node=\"7,1,0\" data-index-in-node=\"63\">%EXT_EMAILS%<\/code> into the filter field.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>User-Defined Variables Within Collaborative Spreadsheet &#8220;Apply custom filters&#8221; to query the metadata within GAT+ is a common task when auditing your Google Workspace domain. Many times, you will have to query an auditing section by using search operators and search operands to retrieve the metadata. To make your metadata query more flexible and collaborative, we [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[21],"glossaries":[],"doc_tag":[24],"class_list":["post-2887","docs","type-docs","status-publish","hentry","doc_category-drive-management","doc_tag-gat"],"year_month":"2026-04","word_count":748,"total_views":"1257","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Enrique Gomez","author_nicename":"egomez","author_url":"https:\/\/gatlabs.com\/knowledge\/author\/egomez\/"},"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.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>User Defined Variables Within Collaborative Spreadsheet - GAT Knowledge Base<\/title>\n<meta name=\"description\" content=\"Apply custom filters to query the metadata within GAT+ is a common task when auditing your Google Workspace domain.\" \/>\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\/user-defined-variables-within-collaborative-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"User Defined Variables Within Collaborative Spreadsheet\" \/>\n<meta property=\"og:description\" content=\"Apply custom filters to query the metadata within GAT+ is a common task when auditing your Google Workspace domain.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"GAT Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-29T12:08:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_21_58-Films-TV.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1095\" \/>\n\t<meta property=\"og:image:height\" content=\"487\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"5 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\\\/user-defined-variables-within-collaborative-spreadsheet\\\/\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/user-defined-variables-within-collaborative-spreadsheet\\\/\",\"name\":\"User Defined Variables Within Collaborative Spreadsheet - GAT Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/user-defined-variables-within-collaborative-spreadsheet\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/user-defined-variables-within-collaborative-spreadsheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/2022-02-11-11_21_58-Films-TV.png\",\"datePublished\":\"2022-02-11T12:45:03+00:00\",\"dateModified\":\"2026-01-29T12:08:21+00:00\",\"description\":\"Apply custom filters to query the metadata within GAT+ is a common task when auditing your Google Workspace domain.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/user-defined-variables-within-collaborative-spreadsheet\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/user-defined-variables-within-collaborative-spreadsheet\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/user-defined-variables-within-collaborative-spreadsheet\\\/#primaryimage\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/2022-02-11-11_21_58-Films-TV.png\",\"contentUrl\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/2022-02-11-11_21_58-Films-TV.png\",\"width\":1095,\"height\":487},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/user-defined-variables-within-collaborative-spreadsheet\\\/#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\":\"User Defined Variables Within Collaborative Spreadsheet\"}]},{\"@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":"User Defined Variables Within Collaborative Spreadsheet - GAT Knowledge Base","description":"Apply custom filters to query the metadata within GAT+ is a common task when auditing your Google Workspace domain.","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\/user-defined-variables-within-collaborative-spreadsheet\/","og_locale":"en_GB","og_type":"article","og_title":"User Defined Variables Within Collaborative Spreadsheet","og_description":"Apply custom filters to query the metadata within GAT+ is a common task when auditing your Google Workspace domain.","og_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/","og_site_name":"GAT Knowledge Base","article_modified_time":"2026-01-29T12:08:21+00:00","og_image":[{"width":1095,"height":487,"url":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_21_58-Films-TV.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/","url":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/","name":"User Defined Variables Within Collaborative Spreadsheet - GAT Knowledge Base","isPartOf":{"@id":"https:\/\/gatlabs.com\/knowledge\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/#primaryimage"},"image":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_21_58-Films-TV.png","datePublished":"2022-02-11T12:45:03+00:00","dateModified":"2026-01-29T12:08:21+00:00","description":"Apply custom filters to query the metadata within GAT+ is a common task when auditing your Google Workspace domain.","breadcrumb":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/#primaryimage","url":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_21_58-Films-TV.png","contentUrl":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/02\/2022-02-11-11_21_58-Films-TV.png","width":1095,"height":487},{"@type":"BreadcrumbList","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/user-defined-variables-within-collaborative-spreadsheet\/#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":"User Defined Variables Within Collaborative Spreadsheet"}]},{"@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\/2887","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/comments?post=2887"}],"version-history":[{"count":18,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/2887\/revisions"}],"predecessor-version":[{"id":15755,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/2887\/revisions\/15755"}],"wp:attachment":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/media?parent=2887"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/doc_category?post=2887"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/glossaries?post=2887"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/doc_tag?post=2887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}