{"id":522,"date":"2022-01-09T15:46:36","date_gmt":"2022-01-09T15:46:36","guid":{"rendered":"https:\/\/gatlabs.com\/knowledge\/?p=522"},"modified":"2023-08-24T15:00:03","modified_gmt":"2023-08-24T14:00:03","password":"","slug":"manage-google-group-members-via-google-spreadsheets","status":"publish","type":"docs","link":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/","title":{"rendered":"Manage Google Group Members via Google Spreadsheets in GAT+"},"content":{"rendered":"\r\n\r\n\r\n<p>To manage\u00a0<a href=\"https:\/\/groups.google.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Group<\/a>\u00a0members via spreadsheets, we need an export to any group.<\/p>\r\n\r\n\r\n\r\n<p>This allows\u00a0<strong>managing group members<\/strong>\u00a0in<strong>\u00a0bulk\u00a0<\/strong>for multiple groups and multiple members<\/p>\r\n\r\n\r\n\r\n<p>Navigate to\u00a0<strong>Groups<\/strong>\u00a0<strong>&gt; Group members<\/strong><\/p>\r\n\r\n\r\n\r\n<p>To do so click on the\u00a0<strong>export<\/strong>\u00a0button and export it into a spreadsheet.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-style-twentytwentyone-border\"><img decoding=\"async\" class=\"wp-image-34628\" title=\"Manage Google Group Members via Google Spreadsheets 1\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.17-12_36_38.png\" alt=\"Manage Google Group Members via Google Spreadsheets 1\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">There are three options to manage groups via spreadsheet:<\/h3>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Edit existing groups<\/li>\r\n<li>Add members to existing groups<\/li>\r\n<li>Delete members from a group<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">Edit an existing group<\/h3>\r\n\r\n\r\n\r\n<p>Edit members of the\u00a0<strong>existing<\/strong>\u00a0group.<\/p>\r\n\r\n\r\n\r\n<p>Find the group you want to edit and export into a spreadsheet.<\/p>\r\n\r\n\r\n\r\n<p>Edit the green fields,\u00a0<strong>Owner<\/strong>\u00a0or\u00a0<strong>Manager<\/strong>\u00a0\u2013 change the values to\u00a0<strong>Yes<\/strong>\u00a0or\u00a0<strong>No<\/strong><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-style-twentytwentyone-border\"><img decoding=\"async\" class=\"wp-image-34334\" title=\"Manage Google Group Members via Google Spreadsheets 2\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-docs.google.com-2020.04.02-14_06_27.png\" alt=\"Manage Google Group Members via Google Spreadsheets 2\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Close the spreadsheet ( this will auto-save the changes)<\/p>\r\n\r\n\r\n\r\n<p>Click on<strong>\u00a0the Import<\/strong>\u00a0button and add the changes back<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-style-twentytwentyone-border\"><img decoding=\"async\" class=\"wp-image-34338\" title=\"Manage Google Group Members via Google Spreadsheets 3\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.02-14_13_03.png\" alt=\"Manage Google Group Members via Google Spreadsheets 3\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Click on the\u00a0<strong>checkmark<\/strong>\u00a0and view the changes<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-style-twentytwentyone-border\"><img decoding=\"async\" class=\"wp-image-34339\" title=\"Manage Google Group Members via Google Spreadsheets 4\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.02-14_14_16.png\" alt=\"Manage Google Group Members via Google Spreadsheets 4\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p><strong>Note<\/strong> Value equal<strong> Update<\/strong> &#8211; as we are updating the values for Manager and Owner.<\/p>\r\n\r\n\r\n\r\n<p>Click on\u00a0<strong>Accept\u00a0<\/strong>and the changes will be applied.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-style-twentytwentyone-border\"><img decoding=\"async\" class=\"wp-image-34341\" title=\"Manage Google Group Members via Google Spreadsheets 5\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.02-14_16_36.png\" alt=\"Manage Google Group Members via Google Spreadsheets 5\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p>The members will be updated accordingly<\/p>\r\n\r\n\r\n\r\n<p>They will be edited and updated as stated, either as\u00a0<strong>Manager<\/strong>\u00a0or\u00a0<strong>Owner\u00a0<\/strong><\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">Add a member to an existing group<\/h3>\r\n\r\n\r\n\r\n<p>Export\u00a0<strong>Group members\u00a0<\/strong>(any search)<\/p>\r\n\r\n\r\n\r\n<p>At the bottom of the sheet<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Group &#8211; Enter the name of the group<\/li>\r\n<li>Member &#8211; Add the email of members<\/li>\r\n<li>Owner &#8211; Manager &#8211; enter Yes or No &#8211; to select that permission the user to have as part of the group<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large is-style-twentytwentyone-border\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"499\" class=\"wp-image-526\" title=\"Manage Google Group Members via Google Spreadsheets 6\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2021-11-19-13_41_45-Window-1024x499.png\" alt=\"\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2021-11-19-13_41_45-Window-1024x499.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2021-11-19-13_41_45-Window-300x146.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2021-11-19-13_41_45-Window-768x374.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2021-11-19-13_41_45-Window.png 1140w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Close the spreadsheet ( this will auto-save the changes)<\/p>\r\n\r\n\r\n\r\n<p>Click on the\u00a0<strong>import<\/strong>\u00a0button again<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-style-twentytwentyone-border\"><img decoding=\"async\" class=\"wp-image-34350\" title=\"Manage Google Group Members via Google Spreadsheets 7\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.02-16_25_19.png\" alt=\"Manage Google Group Members via Google Spreadsheets 7\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p>View the changes that will occur.<\/p>\r\n\r\n\r\n\r\n<p><strong>Note<\/strong>: Type will be set to <strong>Create<\/strong> &#8211; as we are adding new members to the groups<\/p>\r\n\r\n\r\n\r\n<p>Click on\u00a0<strong>Accept\u00a0<\/strong>to import the changes<\/p>\r\n\r\n\r\n\r\n<p>When we search for the group we added additional members to, we can see the new members added accordingly.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-style-twentytwentyone-border\"><img decoding=\"async\" class=\"wp-image-34351\" title=\"Manage Google Group Members via Google Spreadsheets 8\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.02-16_31_40.png\" alt=\"Manage Google Group Members via Google Spreadsheets 8\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">Delete and remove a member of a group<\/h3>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Find the groups from where you want to remove members <strong>OR<\/strong><\/li>\r\n<li>Search for the member and choose from which group to remove them from<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Once you find the result\u00a0<strong>click<\/strong>\u00a0and\u00a0<strong>export<\/strong>\u00a0it into a spreadsheet.<\/p>\r\n\r\n\r\n\r\n<p>Find the user you want to remove from a group.<\/p>\r\n\r\n\r\n\r\n<p>SET <strong>deleted<\/strong> &#8211; to <strong>Yes<\/strong><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full is-style-twentytwentyone-border\"><img decoding=\"async\" width=\"946\" height=\"446\" class=\"wp-image-553\" title=\"Manage Google Group Members via Google Spreadsheets 9\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2021-11-19-14_59_46-Window.png\" alt=\"\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2021-11-19-14_59_46-Window.png 946w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2021-11-19-14_59_46-Window-300x141.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2021-11-19-14_59_46-Window-768x362.png 768w\" sizes=\"(max-width: 946px) 100vw, 946px\" \/>\r\n<figcaption><br \/><strong>Set &#8220;deleted&#8221; to yes<\/strong><\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Close the spreadsheet ( this will auto-save the changes)<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" class=\"wp-image-34355\" title=\"Manage Google Group Members via Google Spreadsheets 10\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.02-16_51_28.png\" alt=\"Manage Google Group Members via Google Spreadsheets 10\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Click on the\u00a0<strong>import<\/strong>\u00a0button again<\/p>\r\n\r\n\r\n\r\n<p>View the changes that will occur.<\/p>\r\n\r\n\r\n\r\n<p>Note: Type will be equal to DELETE as we remove members from the groups<\/p>\r\n\r\n\r\n\r\n<p>Click on\u00a0<strong>Accept\u00a0<\/strong>to import the changes<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">Result<\/h3>\r\n\r\n\r\n\r\n<p>As a result of all imports &#8211; Update\/Create\/Delete the members will be Updated Created (added) or Removed<\/p>\r\n\r\n\r\n\r\n<p>The changes can be seen in<strong>\u00a0Google Admin Console \u2013 Groups<\/strong><\/p>\r\n\r\n\r\n\r\n<p>The progress of those actions can also be checked:<\/p>\r\n\r\n\r\n\r\n<p><strong>GAT+<\/strong> <strong>&gt; Configuration &gt;<\/strong>\u00a0<strong>Admin log\u00a0<\/strong><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>To manage\u00a0Google Group\u00a0members via spreadsheets, we need an export to any group. This allows\u00a0managing group members\u00a0in\u00a0bulk\u00a0for multiple groups and multiple members Navigate to\u00a0Groups\u00a0&gt; Group members To do so click on the\u00a0export\u00a0button and export it into a spreadsheet. There are three options to manage groups via spreadsheet: Edit existing groups Add members to existing groups Delete [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[71],"glossaries":[],"doc_tag":[24],"class_list":["post-522","docs","type-docs","status-publish","hentry","doc_category-groups-auditing-management","doc_tag-gat"],"year_month":"2026-04","word_count":441,"total_views":"3347","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":"Groups Auditing &amp; Management","term_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips-category\/groups-auditing-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>Manage Google Group Members via Google Spreadsheets in GAT+ - GAT Knowledge Base<\/title>\n<meta name=\"description\" content=\"To manage\u00a0Google Group\u00a0members via spreadsheets, we need an export to any group.\" \/>\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\/manage-google-group-members-via-google-spreadsheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Manage Google Group Members via Google Spreadsheets in GAT+\" \/>\n<meta property=\"og:description\" content=\"To manage\u00a0Google Group\u00a0members via spreadsheets, we need an export to any group.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/\" \/>\n<meta property=\"og:site_name\" content=\"GAT Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-24T14:00:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.17-12_36_38.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=\"4 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\\\/manage-google-group-members-via-google-spreadsheets\\\/\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/manage-google-group-members-via-google-spreadsheets\\\/\",\"name\":\"Manage Google Group Members via Google Spreadsheets in GAT+ - GAT Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/manage-google-group-members-via-google-spreadsheets\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/manage-google-group-members-via-google-spreadsheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/gatlabs.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/screenshot-gs.generalaudittool.com-2020.04.17-12_36_38.png\",\"datePublished\":\"2022-01-09T15:46:36+00:00\",\"dateModified\":\"2023-08-24T14:00:03+00:00\",\"description\":\"To manage\u00a0Google Group\u00a0members via spreadsheets, we need an export to any group.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/manage-google-group-members-via-google-spreadsheets\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/manage-google-group-members-via-google-spreadsheets\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/manage-google-group-members-via-google-spreadsheets\\\/#primaryimage\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/screenshot-gs.generalaudittool.com-2020.04.17-12_36_38.png\",\"contentUrl\":\"https:\\\/\\\/gatlabs.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/screenshot-gs.generalaudittool.com-2020.04.17-12_36_38.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/manage-google-group-members-via-google-spreadsheets\\\/#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\":\"Manage Google Group Members via Google Spreadsheets in GAT+\"}]},{\"@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":"Manage Google Group Members via Google Spreadsheets in GAT+ - GAT Knowledge Base","description":"To manage\u00a0Google Group\u00a0members via spreadsheets, we need an export to any group.","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\/manage-google-group-members-via-google-spreadsheets\/","og_locale":"en_GB","og_type":"article","og_title":"Manage Google Group Members via Google Spreadsheets in GAT+","og_description":"To manage\u00a0Google Group\u00a0members via spreadsheets, we need an export to any group.","og_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/","og_site_name":"GAT Knowledge Base","article_modified_time":"2023-08-24T14:00:03+00:00","og_image":[{"url":"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.17-12_36_38.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/","url":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/","name":"Manage Google Group Members via Google Spreadsheets in GAT+ - GAT Knowledge Base","isPartOf":{"@id":"https:\/\/gatlabs.com\/knowledge\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/#primaryimage"},"image":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/#primaryimage"},"thumbnailUrl":"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.17-12_36_38.png","datePublished":"2022-01-09T15:46:36+00:00","dateModified":"2023-08-24T14:00:03+00:00","description":"To manage\u00a0Google Group\u00a0members via spreadsheets, we need an export to any group.","breadcrumb":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/#primaryimage","url":"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.17-12_36_38.png","contentUrl":"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/04\/screenshot-gs.generalaudittool.com-2020.04.17-12_36_38.png"},{"@type":"BreadcrumbList","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/manage-google-group-members-via-google-spreadsheets\/#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":"Manage Google Group Members via Google Spreadsheets in GAT+"}]},{"@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\/522","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=522"}],"version-history":[{"count":6,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/522\/revisions"}],"predecessor-version":[{"id":6722,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/522\/revisions\/6722"}],"wp:attachment":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/media?parent=522"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/doc_category?post=522"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/glossaries?post=522"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/doc_tag?post=522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}