{"id":4753,"date":"2022-09-09T15:15:28","date_gmt":"2022-09-09T14:15:28","guid":{"rendered":"https:\/\/gatlabs.com\/knowledge\/?post_type=docs&#038;p=4753"},"modified":"2022-10-20T16:00:32","modified_gmt":"2022-10-20T15:00:32","password":"","slug":"import-users-email-addresses-in-gat-flow","status":"publish","type":"docs","link":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/","title":{"rendered":"Import users&#8217; email addresses in GAT Flow"},"content":{"rendered":"<p>In the GAT Flow, <a href=\"https:\/\/workspace.google.com\/\">Google Workspace<\/a> admins can simply import users&#8217; email addresses to create workflows. Which can then be used to take single or bulk actions to <strong>Onboard (create), Offboard (delete), or Modify (update) users in Google Workspace.<\/strong><\/p>\n<h2>Importing Emails<\/h2>\n<p>If you have a list of users&#8217; emails in a spreadsheet, that list can be imported directly with GAT Flow.<\/p>\n<p>To do this, create a workflow, and set it up as <strong>&#8216;Modify&#8217;<\/strong>.<\/p>\n<p>Give the workflow a name, and click <strong>&#8216;Next&#8217;<\/strong> to continue.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-4665 size-full\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/GAT-Flow-1.png\" alt=\"Creating a workflow in GAT Flow\" width=\"1335\" height=\"721\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/GAT-Flow-1.png 1335w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/GAT-Flow-1-300x162.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/GAT-Flow-1-1024x553.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/GAT-Flow-1-768x415.png 768w\" sizes=\"(max-width: 1335px) 100vw, 1335px\" \/><\/p>\n<p>In the top right-hand corner, you will see the option to <strong>&#8216;Import&#8217;<\/strong>.<\/p>\n<p>Click this button and a dialogue box will open.<\/p>\n<p>If you have a spreadsheet, you can search for it and import it to GAT Flow from the search box.<\/p>\n<p>If you don&#8217;t have a list of emails with just the spreadsheet, click the <strong>&#8216;Create template&#8217;<\/strong> option.<\/p>\n<p>A new template will be created with the title <strong>[WorkflowUser]<\/strong> and the current date.<\/p>\n<p>Click the &#8216;eye&#8217; icon to open this template and edit the spreadsheet.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-4754 size-full\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-01-20.14.04-1.png\" alt=\"Email import screen\" width=\"1436\" height=\"847\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-01-20.14.04-1.png 1436w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-01-20.14.04-1-300x177.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-01-20.14.04-1-1024x604.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-01-20.14.04-1-768x453.png 768w\" sizes=\"(max-width: 1436px) 100vw, 1436px\" \/><\/p>\n<p>On clicking the &#8216;eye&#8217; icon, the template will open in a new tab.<\/p>\n<p>You can paste the list of email addresses underneath the email heading.<\/p>\n<p>When you have finished, you can close the spreadsheet tab and click the &#8216;checkmark&#8217; icon in the GAT Flow tab.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-5204\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-28-19.34.18.png\" alt=\"\" width=\"1859\" height=\"556\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-28-19.34.18.png 1859w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-28-19.34.18-300x90.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-28-19.34.18-1024x306.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-28-19.34.18-768x230.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-28-19.34.18-1536x459.png 1536w\" sizes=\"(max-width: 1859px) 100vw, 1859px\" \/><\/p>\n<p>The list of email addresses will then get populated from the spreadsheet.<\/p>\n<p><strong>NOTE:<\/strong> The user&#8217;s from the email address must already be users created in your domain.<\/p>\n<p>If you want to import users&#8217; emails from a spreadsheet, you can check out this <a href=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-onboard-google-workspace-users-in-bulk\/\">article<\/a> for more info.<\/p>\n<h2>Related Posts<\/h2>\n<ul>\n<li><a href=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/creating-a-workflow\/\">GAT Flow: Creating a Workflow<\/a><\/li>\n<li><a href=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/conditional-workflows\/\">GAT Flow: Conditional Workflows for Google Workspace<\/a><\/li>\n<li><a href=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/events-workflows-with-conditions\/\">GAT Flow: Conditional Event Workflows for Google Workspace<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In the GAT Flow, Google Workspace admins can simply import users&#8217; email addresses to create workflows. Which can then be used to take single or bulk actions to Onboard (create), Offboard (delete), or Modify (update) users in Google Workspace. Importing Emails If you have a list of users&#8217; emails in a spreadsheet, that list can [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":5369,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[49],"glossaries":[],"doc_tag":[27],"class_list":["post-4753","docs","type-docs","status-publish","has-post-thumbnail","hentry","doc_category-on-boarding-off-boarding-modifying","doc_tag-gat-flow"],"year_month":"2026-04","word_count":280,"total_views":"911","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"jgrimes","author_nicename":"jgrimes","author_url":"https:\/\/gatlabs.com\/knowledge\/author\/jgrimes\/"},"doc_category_info":[{"term_name":"On-boarding, Off-boarding &amp; Modifying","term_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips-category\/users-management\/on-boarding-off-boarding-modifying\/"}],"doc_tag_info":[{"term_name":"GAT Flow","term_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips-tag\/gat-flow\/"}],"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>Import users&#039; email addresses in GAT Flow<\/title>\n<meta name=\"description\" content=\"With GAT Flow, admins can simply import users&#039; email addresses to create workflows to onboard, offboard or modify user accounts.\" \/>\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\/import-users-email-addresses-in-gat-flow\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import users&#039; email addresses in GAT Flow\" \/>\n<meta property=\"og:description\" content=\"With GAT Flow, admins can simply import users&#039; email addresses to create workflows to onboard, offboard or modify user accounts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/\" \/>\n<meta property=\"og:site_name\" content=\"GAT Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-20T15:00:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/GAT-Flow-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/import-users-email-addresses-in-gat-flow\\\/\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/import-users-email-addresses-in-gat-flow\\\/\",\"name\":\"Import users' email addresses in GAT Flow\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/import-users-email-addresses-in-gat-flow\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/import-users-email-addresses-in-gat-flow\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/GAT-Flow-1.jpg\",\"datePublished\":\"2022-09-09T14:15:28+00:00\",\"dateModified\":\"2022-10-20T15:00:32+00:00\",\"description\":\"With GAT Flow, admins can simply import users' email addresses to create workflows to onboard, offboard or modify user accounts.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/import-users-email-addresses-in-gat-flow\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/import-users-email-addresses-in-gat-flow\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/import-users-email-addresses-in-gat-flow\\\/#primaryimage\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/GAT-Flow-1.jpg\",\"contentUrl\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/GAT-Flow-1.jpg\",\"width\":1200,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/import-users-email-addresses-in-gat-flow\\\/#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\":\"Import users&#8217; email addresses in GAT Flow\"}]},{\"@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":"Import users' email addresses in GAT Flow","description":"With GAT Flow, admins can simply import users' email addresses to create workflows to onboard, offboard or modify user accounts.","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\/import-users-email-addresses-in-gat-flow\/","og_locale":"en_GB","og_type":"article","og_title":"Import users' email addresses in GAT Flow","og_description":"With GAT Flow, admins can simply import users' email addresses to create workflows to onboard, offboard or modify user accounts.","og_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/","og_site_name":"GAT Knowledge Base","article_modified_time":"2022-10-20T15:00:32+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/GAT-Flow-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/","url":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/","name":"Import users' email addresses in GAT Flow","isPartOf":{"@id":"https:\/\/gatlabs.com\/knowledge\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/#primaryimage"},"image":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/#primaryimage"},"thumbnailUrl":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/GAT-Flow-1.jpg","datePublished":"2022-09-09T14:15:28+00:00","dateModified":"2022-10-20T15:00:32+00:00","description":"With GAT Flow, admins can simply import users' email addresses to create workflows to onboard, offboard or modify user accounts.","breadcrumb":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/#primaryimage","url":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/GAT-Flow-1.jpg","contentUrl":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/09\/GAT-Flow-1.jpg","width":1200,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/import-users-email-addresses-in-gat-flow\/#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":"Import users&#8217; email addresses in GAT Flow"}]},{"@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\/4753","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/comments?post=4753"}],"version-history":[{"count":10,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/4753\/revisions"}],"predecessor-version":[{"id":5584,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/4753\/revisions\/5584"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/media\/5369"}],"wp:attachment":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/media?parent=4753"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/doc_category?post=4753"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/glossaries?post=4753"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/doc_tag?post=4753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}