{"id":22750,"date":"2022-05-03T08:31:31","date_gmt":"2022-05-03T08:31:31","guid":{"rendered":"https:\/\/refiner.io\/docs\/?post_type=knowledgebase&#038;p=22750"},"modified":"2025-02-21T22:34:00","modified_gmt":"2025-02-21T22:34:00","slug":"google-sheets-integration","status":"publish","type":"knowledgebase","link":"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/","title":{"rendered":"Google Sheets Integration"},"content":{"rendered":"\n\n\n<p>Data integrations with third party tools play a crucial role at Refiner. With our Google Sheets integration, you can push survey data from your Refiner account to a Google spreadsheet in real time.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create a Google Sheets integration<\/h2>\n\n\n\n<p>Refiner allows you to create multiple Google Sheets integrations, each with their own configuration. This allows you to send survey data to different sheets depending on the nature of the data.<\/p>\n\n\n\n<p>Start by navigating to the \u201cIntegrations &gt; Google Sheets\u201d within your Refiner dashboard and click on \u201cCreate integration\u201d. <\/p>\n\n\n\n<p>When prompted to name your Google Sheets integration. Choose a name that describes your integration accurately (e.g. &#8220;New NPS survey responses&#8221;).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Trigger event and data fields<\/h2>\n\n\n\n<p>You can choose between different trigger events.  for your Google Sheets integration:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Completed Survey<\/li>\n\n\n\n<li>Segment Match<\/li>\n\n\n\n<li>Tag Added<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"179\" src=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-1024x179.png\" alt=\"\" class=\"wp-image-22757\" srcset=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-1024x179.png 1024w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-800x140.png 800w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-768x134.png 768w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-1536x269.png 1536w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-2048x359.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>You can choose which data fields you want to sync to your Google Sheets file. You can choose to include user identifiers (Id, Email, Display Name), meta data (Survey Name, Response Date, Response Tags), actual survey response data, as well as other user traits.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"427\" src=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-21-at-23.33.22-1024x427.png\" alt=\"\" class=\"wp-image-26515\" srcset=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-21-at-23.33.22-1024x427.png 1024w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-21-at-23.33.22-800x334.png 800w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-21-at-23.33.22-768x321.png 768w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-21-at-23.33.22-1536x641.png 1536w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-21-at-23.33.22-2048x855.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Grant access to your Google account<\/h2>\n\n\n\n<p>Next, you&#8217;ll need to grant access to your Google account. To do so, click on &#8220;Sign in with Google&#8221; and follow the authorization flow of Google.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"131\" src=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.35.58-1024x131.png\" alt=\"\" class=\"wp-image-22756\" srcset=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.35.58-1024x131.png 1024w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.35.58-800x103.png 800w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.35.58-768x99.png 768w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.35.58.png 1324w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Find your Google Sheet ID<\/h2>\n\n\n\n<p>As a final step, you&#8217;ll need to provide the ID of the Google Sheet that should receive your Refiner data. You can find the ID of the Google Sheet in the URL when editing the sheet. Head over to the Google Sheet app and locate the ID in the URL as shown below. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"337\" src=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.39.10-1024x337.png\" alt=\"\" class=\"wp-image-22759\" srcset=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.39.10-1024x337.png 1024w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.39.10-800x263.png 800w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.39.10-768x253.png 768w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.39.10-1536x505.png 1536w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.39.10.png 1958w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">https:\/\/docs.google.com\/spreadsheets\/d\/&lt;SPREADSHEET_ID>\/edit#gid=0<\/pre>\n\n\n\n<p>Then, copy &amp; paste the ID in the input field in Refiner.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"70\" src=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.40.55-1024x70.png\" alt=\"\" class=\"wp-image-22760\" srcset=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.40.55-1024x70.png 1024w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.40.55-800x54.png 800w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.40.55-768x52.png 768w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.40.55-1536x104.png 1536w, https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.40.55-2048x139.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>","protected":false},"excerpt":{"rendered":"<p>Data integrations with third party tools play a crucial role at Refiner. With our Google Sheets integration, you can push survey data from your Refiner account to a Google spreadsheet in real time. Create a Google Sheets integration Refiner allows you to create multiple Google Sheets integrations, each with their own configuration. This allows you [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","template":"","knowledgebase_tag":[],"class_list":["post-22750","knowledgebase","type-knowledgebase","status-publish","hentry","knowledgebase_cat-integrations"],"acf":[],"featured_image_urls_v2":{"full":"","thumbnail":"","medium":"","medium_large":"","large":"","1536x1536":"","2048x2048":"","ab-block-post-grid-landscape":"","ab-block-post-grid-square":"","gb-block-post-grid-landscape":"","gb-block-post-grid-square":""},"post_excerpt_stackable_v2":"<p>Data integrations with third party tools play a crucial role at Refiner. With our Google Sheets integration, you can push survey data from your Refiner account to a Google spreadsheet in real time. Create a Google Sheets integration Refiner allows you to create multiple Google Sheets integrations, each with their own configuration. This allows you to send survey data to different sheets depending on the nature of the data. Start by navigating to the \u201cIntegrations &gt; Google Sheets\u201d within your Refiner dashboard and click on \u201cCreate integration\u201d. When prompted to name your Google Sheets integration. Choose a name that describes&hellip;<\/p>\n","category_list_v2":"","author_info_v2":{"name":"Moritz Dausinger","url":"https:\/\/refiner.io\/docs\/author\/user\/"},"comments_num_v2":"0 comments","yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Sheets Integration<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets Integration\" \/>\n<meta property=\"og:description\" content=\"Data integrations with third party tools play a crucial role at Refiner. With our Google Sheets integration, you can push survey data from your Refiner account to a Google spreadsheet in real time. Create a Google Sheets integration Refiner allows you to create multiple Google Sheets integrations, each with their own configuration. This allows you [...]Read More...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/\" \/>\n<meta property=\"og:site_name\" content=\"Refiner Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-21T22:34:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-1024x179.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. 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\":\"WebPage\",\"@id\":\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/\",\"url\":\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/\",\"name\":\"Google Sheets Integration\",\"isPartOf\":{\"@id\":\"https:\/\/refiner.io\/docs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-1024x179.png\",\"datePublished\":\"2022-05-03T08:31:31+00:00\",\"dateModified\":\"2025-02-21T22:34:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/#primaryimage\",\"url\":\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52.png\",\"contentUrl\":\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52.png\",\"width\":2090,\"height\":366},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/refiner.io\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Sheets Integration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/refiner.io\/docs\/#website\",\"url\":\"https:\/\/refiner.io\/docs\/\",\"name\":\"Refiner Documentation\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/refiner.io\/docs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/refiner.io\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/refiner.io\/docs\/#organization\",\"name\":\"Refiner Documentation\",\"url\":\"https:\/\/refiner.io\/docs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/refiner.io\/docs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/11\/cropped-Group-8.png\",\"contentUrl\":\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/11\/cropped-Group-8.png\",\"width\":400,\"height\":61,\"caption\":\"Refiner Documentation\"},\"image\":{\"@id\":\"https:\/\/refiner.io\/docs\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Sheets Integration","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:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/","og_locale":"en_US","og_type":"article","og_title":"Google Sheets Integration","og_description":"Data integrations with third party tools play a crucial role at Refiner. With our Google Sheets integration, you can push survey data from your Refiner account to a Google spreadsheet in real time. Create a Google Sheets integration Refiner allows you to create multiple Google Sheets integrations, each with their own configuration. This allows you [...]Read More...","og_url":"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/","og_site_name":"Refiner Documentation","article_modified_time":"2025-02-21T22:34:00+00:00","og_image":[{"url":"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-1024x179.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/","url":"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/","name":"Google Sheets Integration","isPartOf":{"@id":"https:\/\/refiner.io\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/#primaryimage"},"image":{"@id":"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-1024x179.png","datePublished":"2022-05-03T08:31:31+00:00","dateModified":"2025-02-21T22:34:00+00:00","breadcrumb":{"@id":"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/#primaryimage","url":"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52.png","contentUrl":"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52.png","width":2090,"height":366},{"@type":"BreadcrumbList","@id":"https:\/\/refiner.io\/docs\/kb\/integrations\/google-sheets-integration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/refiner.io\/docs\/"},{"@type":"ListItem","position":2,"name":"Google Sheets Integration"}]},{"@type":"WebSite","@id":"https:\/\/refiner.io\/docs\/#website","url":"https:\/\/refiner.io\/docs\/","name":"Refiner Documentation","description":"","publisher":{"@id":"https:\/\/refiner.io\/docs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/refiner.io\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/refiner.io\/docs\/#organization","name":"Refiner Documentation","url":"https:\/\/refiner.io\/docs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/refiner.io\/docs\/#\/schema\/logo\/image\/","url":"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/11\/cropped-Group-8.png","contentUrl":"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/11\/cropped-Group-8.png","width":400,"height":61,"caption":"Refiner Documentation"},"image":{"@id":"https:\/\/refiner.io\/docs\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/refiner.io\/docs\/wp-json\/wp\/v2\/knowledgebase\/22750","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/refiner.io\/docs\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/refiner.io\/docs\/wp-json\/wp\/v2\/types\/knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/refiner.io\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/refiner.io\/docs\/wp-json\/wp\/v2\/comments?post=22750"}],"version-history":[{"count":8,"href":"https:\/\/refiner.io\/docs\/wp-json\/wp\/v2\/knowledgebase\/22750\/revisions"}],"predecessor-version":[{"id":26516,"href":"https:\/\/refiner.io\/docs\/wp-json\/wp\/v2\/knowledgebase\/22750\/revisions\/26516"}],"wp:attachment":[{"href":"https:\/\/refiner.io\/docs\/wp-json\/wp\/v2\/media?parent=22750"}],"wp:term":[{"taxonomy":"knowledgebase_tag","embeddable":true,"href":"https:\/\/refiner.io\/docs\/wp-json\/wp\/v2\/knowledgebase_tag?post=22750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}