{"id":393,"date":"2024-09-21T17:57:04","date_gmt":"2024-09-21T14:57:04","guid":{"rendered":"https:\/\/help.testbh.ru\/?p=393"},"modified":"2025-09-25T13:06:03","modified_gmt":"2025-09-25T10:06:03","slug":"integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros","status":"publish","type":"post","link":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/","title":{"rendered":"Integration with Google Sheets via \"External Query\""},"content":{"rendered":"<p>A general description of the &#8220;External Query&#8221; action and other instructions on how to configure and use it can be <a href=\"\/dejstvie-vneshnij-zapros\/\">found here<\/a>.<\/p>\n<h4>General description<\/h4>\n<p>This integration will allow you to <strong>read<\/strong> data from the specified Google Sheet through the &#8220;External Query&#8221; action in order to later enter it in the person&#8217;s custom fields.<br \/>\nYou will not be able to <strong>enter<\/strong> data to a Google Sheet using the &#8220;External Query&#8221; action.<\/p>\n<p>To integrate, you will first have to set up a Google Account and the Google Sheet itself. Step-by-step instructions are below.<\/p>\n<h4>Google Settings<\/h4>\n<p><strong>Google Sheet Settings:<\/strong><\/p>\n<ul>\n<li>Create a Google Sheet which you will then read the data from.<\/li>\n<li>In the access settings of the spreadsheet, specify the access type &#8220;Anyone with the link&#8221; and the role &#8220;Editor&#8221;.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670563560521-se4lm0id.png\" \/><\/p>\n<ul>\n<li>To set up an &#8220;External Query&#8221;, copy the spreadsheet ID from the link of the spreadsheet page. An ID is a long combination of letters, numbers, and symbols. You will easily find it in the link of the page with the spreadsheet. For an example, see the screenshot below.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670563684236-azhhjws6.png\" \/><br \/>\n<strong>How to set up a Google Account and get an API key:<\/strong><\/p>\n<p>1. Log in to<a href=\"https:\/\/console.cloud.google.com\/\"> console.cloud.google.com<\/a> with the account that contains the required Google Sheet.<\/p>\n<p>2. Create a new project:<\/p>\n<ul>\n<li>Click the <strong>Select Project<\/strong> button in the upper-left corner.<\/li>\n<li>In the window that pops up, click the <strong>New Project<\/strong> button in the upper-right corner.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670567125762-h3nj0e9y.png\" \/><\/p>\n<ul>\n<li>In the tab that opens, enter the project name and click <strong>CREATE<\/strong>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670567173274-loo5m8t3.png\" \/><\/p>\n<ul>\n<li>After that, you will be redirected to the previous page, and the project will be created in a few seconds.<\/li>\n<li>Click the <strong>Select Project<\/strong> button in the upper-left corner again and select the newly created project. Now you are working on this project.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670567283472-94wmkgad.png\" \/> 3. Activate the API and get the API key:<\/p>\n<ul>\n<li>You have to activate API methods that will allow you to read data from the spreadsheet. To do this, open the left navigation dashboard and go to the &#8220;APIs &amp; Services&#8221; section.<\/li>\n<li>On the page that opens, click the <strong>+ ENABLE APIS AND SERVICES<\/strong> button at the top of the screen.<\/li>\n<li>In the &#8220;API Library&#8221; page that opens, scroll down to the &#8220;Google Workspace&#8221; section, find and click the &#8220;Google Sheets API&#8221; icon.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670567635994-a4ixg9ov.png\" \/><\/p>\n<ul>\n<li>Next, click the <strong>ENABLE<\/strong> button. After a few seconds, this API will be activated, and you will be redirected to the next page.<\/li>\n<\/ul>\n<ul>\n<li>On the page that opens, click <strong>CREATE<\/strong> <strong>CREDENTIALS<\/strong> in the upper-right corner.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670567784876-jj7gihir.png\" \/><\/p>\n<ul>\n<li>In the window that opens, select the &#8220;User data&#8221; property and click <strong>NEXT<\/strong>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670567847098-xf9ruiu2.png\" \/><\/p>\n<ul>\n<li>In the next section, fill in the fields: the name of your application and two fields with your email. Click <strong>SAVE AND CONTINUE<\/strong>.<\/li>\n<li>Do not fill in the &#8220;Scopes (optional)&#8221; section, click <strong>SAVE AND CONTINUE<\/strong>.<\/li>\n<li>In the &#8220;OAuth Client ID&#8221; section, in the &#8220;Application Type&#8221; field, specify the value &#8220;Web Application&#8221; and enter a name. Click the <strong>CREATE<\/strong> button.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670568075539-91kptuzp.png\" \/><\/p>\n<ul>\n<li>After a few seconds, the &#8220;Your Credentials&#8221; section will load, and then click <strong>DONE<\/strong>. You will be redirected to the previous page.<\/li>\n<li>On the page that opens, go to the &#8220;Credentials&#8221; page in the left navigation dashboard.<\/li>\n<li>Click + <strong>CREATE CREDENTIALS<\/strong> and select &#8220;API key&#8221;.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670568576125-3qbc5z3q.png\" \/><\/p>\n<ul>\n<li>An API key will be generated in a few seconds. Copy it, you will have to use it when setting up the &#8220;External Query&#8221;.\n<ul>\n<li>This API key will not disappear, you can copy it later in the same section.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670568686719-s90otg13.png\" \/><\/p>\n<h4>Flow settings in BotHelp<\/h4>\n<p>1. How to set up a simple flow chain to send a query and display the received data in a custom field:<\/p>\n<ul>\n<li>Create a flow chain of three consecutive blocks:\n<ul>\n<li>&#8220;Message 1&#8221; -&gt; &#8220;Action 1&#8221; -&gt; &#8220;Message 2&#8221;.<\/li>\n<li>In the &#8220;Message 1&#8221; block, we will just add a text greeting.<\/li>\n<li>In the &#8220;Action 1&#8221; block, we will set up an &#8220;External query&#8221;.<\/li>\n<li>In the &#8220;Message 2&#8221; block, we use a macro to output a custom field which the data read from the Google Sheet will be recorded in.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670570552794-3riya6bd.png\" \/><\/p>\n<p>2. Setting up &#8220;External Query&#8221;:<\/p>\n<ul>\n<li>In the &#8220;Action&#8221; block, select &#8220;External Query&#8221; from the list of actions and open the window to configure the &#8220;External Query&#8221; by clicking on the &#8220;pencil&#8221;.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670570995014-fjppbbuv.png\" \/><\/p>\n<ul>\n<li>Specify the GET query type.<\/li>\n<li>In the &#8220;URL&#8221; field, insert the link:<\/li>\n<\/ul>\n<p>https:\/\/sheets.googleapis.com\/v4\/spreadsheets \/<strong>{%google table id%}<\/strong>\/values\/<strong>{%address of a cell or range in the table %}<\/strong>?key=<strong>{%API key%}<\/strong><\/p>\n<ul>\n<li>Insert your data into the link:\n<ul>\n<li>the ID of the Google Sheet which you want to read the data from instead of {%Google table id%}<\/li>\n<li>the address of the cell or range (e.g., A1 or DJ22), where you want to read the values from instead of {%the address of the cell or range in the table %}<\/li>\n<li>The API key obtained in your Google Account settings, instead of {%API key%}<\/li>\n<\/ul>\n<\/li>\n<li>The final link should look like this:\n<ul>\n<li>https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/1<strong>OttAA3aWMJe-KrvhLZsm3UD6u0tIvaC8<\/strong>\/values\/<strong>A1<\/strong>?key=<strong>AIz3X-zW-6H_oQdPY-XuzF_Kh4<\/strong><\/li>\n<li>This link will return the value of cell A1.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670571558341-pkewc2j7.png\" \/><\/p>\n<ul>\n<li>Go to the &#8220;Response&#8221; section to test the query and get a test response. In the test response, you will be able to see the structure of the response body, which you will need to configure the matching of responses (save settings to custom fields).<\/li>\n<li>Click <strong>Send Query<\/strong>. The received response will be displayed on the right side. Open the &#8220;Response body&#8221; section.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670571705164-tqju8qf7.png\" \/><\/p>\n<ul>\n<li>Received response body:<\/li>\n<\/ul>\n<pre>{\r\n   \"range\": \"'\u041b\u0438\u0441\u04421'!A1\",\r\n   \"majorDimension\": \"ROWS\",\r\n   \"values\":\r\n     [\r\n       [\r\n         \"raz\"\r\n       ]\r\n     ]\r\n}<\/pre>\n<ul>\n<li>The value that is entered in the spreadsheet is in the &#8220;Values&#8221; field. The value itself is &#8220;raz&#8221;.<\/li>\n<li>Go to the &#8220;Matching responses&#8221; tab to configure the logic of entering the received data in a custom field.<\/li>\n<li>In the &#8220;JSON Path&#8221; field, enter <strong>$.values.0.0<\/strong>\n<ul>\n<li>The value &#8220;JSON Path&#8221; will be returned from the response body by the &#8220;raz&#8221; value.<\/li>\n<li>Detailed instructions on the JSON Path are here: <a href=\"\/kak-napisat-json-path\/\">link<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li>In the &#8220;Custom Field&#8221; field, select the field where you want to save the received value.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670575755543-yyj2utmw.png\" \/><\/p>\n<ul>\n<li>Done. This completes the settings for the &#8220;External Query&#8221;.<\/li>\n<li>Click <strong>Save<\/strong> in the settings window of the &#8220;External Query&#8221;, be sure to click <strong>Save and Close<\/strong> in the settings window of the &#8220;Action&#8221; block.<\/li>\n<\/ul>\n<p>Now you can test the flow. Two messages will be sent from it: a greeting and one containing the value from cell \u04101 received from the Google Sheet. <img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670575719110-u1ilsgdf.png\" \/> The full instructions for the &#8220;External Query&#8221; action are here: <a href=\"\/dejstvie-vneshnij-zapros\/\">link<\/a>.<\/p>\n<h4>Frequently asked questions<\/h4>\n<p><em>1. Is it possible to use variables when forming a link?<\/em>&nbsp;<em><img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1671268190878-rsal6g86.png\" \/><\/em> <em>Answer<\/em>: Yes, it is. In an external query, the URL field supports macros. For example, you can request a certain number from a person and enter this value in their field. Then, in the query link, you can generate the address of the cell which you want to read the value from using a macro for the person field. When sending a query, the macro will automatically be replaced with the specific value that the person previously entered. <img decoding=\"async\" class=\"fr-fic fr-dib\" src=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1672317375209-w21epmch.png\" \/> <em>2. If, depending on the conditions that are formed in the flow chain, a query has to be made for the values of certain cells, how can the cell address be generated inside the flow?<\/em><\/p>\n<p><em>Answer<\/em>: You can insert an address for cell R3C2, where R3 is the third row (row 3), C2 is the second column (column 2). In the person&#8217;s &#8220;number&#8221; field, enter the desired value before the desired flow step.<\/p>\n<hr \/>\n<p>If you haven&#8217;t found the answer to your question, contact us in the chat in your profile or email <a href=\"mailto:hello@bothelp.io\">hello@bothelp.io<\/a>\ud83d\ude03<\/p>\n<p>Get 14 days of full functionality of BotHelp, a platform for creating broadcasting, autofunnels, and chatbots.<\/p>\n<p><strong><a href=\"https:\/\/bothelp.io\/ru?utm_source=bz&amp;utm_medium=footer&amp;utm_campaign=15655\">Get 14 days for free<\/a><\/strong><\/p>\n\r\n\t\t\t<div id=\"daexthefu-container\"\r\n\t\t\t\tclass=\"daexthefu-container daexthefu-layout-side-by-side daexthefu-alignment-left\"\r\n\t\t\t\tdata-post-id=\"393\">\r\n\r\n\t\t\t\t<div class=\"daexthefu-feedback\">\r\n\t\t\t\t\t<div class=\"daexthefu-text\">\r\n\t\t\t\t\t\t<h3 class=\"daexthefu-title\">\u0411\u044b\u043b\u0430 \u043b\u0438 \u0441\u0442\u0430\u0442\u044c\u044f \u043f\u043e\u043b\u0435\u0437\u043d\u0430?<\/h3>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<div class=\"daexthefu-buttons-container\">\r\n\t\t\t\t\t\t<div class=\"daexthefu-buttons\">\r\n\t\t\t\t\t\t\t\r\n\t\t\t<div class=\"daexthefu-yes daexthefu-button daexthefu-button-type-icon\" data-value=\"1\">\r\n\t\t\t\t\r\n                <svg>\r\n                    <defs>\r\n                        <style>.thumb-up-cls-1{fill:#c9c9c9;}.thumb-up-cls-2{fill:#e1e1e1;}.thumb-up-cls-3{fill:#676767;}<\/style>\r\n                    <\/defs>\r\n                    <g id=\"thumb_up\">\r\n                        <path class=\"thumb-up-cls-2 daexthefu-icon-circle\" d=\"m24,3c11.58,0,21,9.42,21,21s-9.42,21-21,21S3,35.58,3,24,12.42,3,24,3m0-1C11.85,2,2,11.85,2,24s9.85,22,22,22,22-9.85,22-22S36.15,2,24,2h0Z\" \/>\r\n                        <g>\r\n                            <rect class=\"thumb-up-cls-3 daexthefu-icon-secondary-color\" x=\"10\" y=\"20\" width=\"6\" height=\"15\" rx=\"1.5\" ry=\"1.5\" \/>\r\n                            <path class=\"thumb-up-cls-1 daexthefu-icon-primary-color\" d=\"m30.57,9.06l-.49-.1c-.81-.17-1.61.35-1.78,1.16l-5.3,11.74c-.17.81,3.16,1.61,3.97,1.78l1.96.41c.81.17,1.61-.35,1.78-1.16l2.18-10.27c.34-1.61-.7-3.21-2.31-3.56Z\" \/>\r\n                            <path class=\"thumb-up-cls-1 daexthefu-icon-primary-color\" d=\"m38.17,20h-18.67c-.83,0-1.5.67-1.5,1.5v12c0,.83.67,1.5,1.5,1.5h16.27c.71,0,1.33-.5,1.47-1.21l2.4-12c.19-.93-.53-1.8-1.47-1.8Z\" \/>\r\n                        <\/g>\r\n                    <\/g>\r\n                <\/svg>\t\t\t<\/div>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t<div class=\"daexthefu-no daexthefu-button daexthefu-button-type-icon\" data-value=\"0\">\r\n\t\t\t\t\r\n                <svg>\r\n                    <defs>\r\n                        <style>.thumb-down-cls-1{fill:#c9c9c9;}.thumb-down-cls-2{fill:#e1e1e1;}.thumb-down-cls-3{fill:#676767;}<\/style>\r\n                    <\/defs>\r\n                    <g id=\"thumb_down\">\r\n                        <path class=\"thumb-down-cls-2 daexthefu-icon-circle\" d=\"m24,3c11.58,0,21,9.42,21,21s-9.42,21-21,21S3,35.58,3,24,12.42,3,24,3m0-1C11.85,2,2,11.85,2,24s9.85,22,22,22,22-9.85,22-22S36.15,2,24,2h0Z\" \/>\r\n                        <g>\r\n                            <rect class=\"thumb-down-cls-3 daexthefu-icon-secondary-color\" x=\"10\" y=\"13\" width=\"6\" height=\"15\" rx=\"1.5\" ry=\"1.5\" \/>\r\n                            <path class=\"thumb-down-cls-1 daexthefu-icon-primary-color\" d=\"m30.57,38.94l-.49.1c-.81.17-1.61-.35-1.78-1.16l-5.3-11.74c-.17-.81,3.16-1.61,3.97-1.78l1.96-.41c.81-.17,1.61.35,1.78,1.16l2.18,10.27c.34,1.61-.7,3.21-2.31,3.56Z\" \/>\r\n                            <path class=\"thumb-down-cls-1 daexthefu-icon-primary-color\" d=\"m38.17,28h-18.67c-.83,0-1.5-.67-1.5-1.5v-12c0-.83.67-1.5,1.5-1.5h16.27c.71,0,1.33.5,1.47,1.21l2.4,12c.19.93-.53,1.8-1.47,1.8Z\" \/>\r\n                        <\/g>\r\n                    <\/g>\r\n                <\/svg>\t\t\t<\/div>\r\n\r\n\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\r\n\t\t\t\t<div class=\"daexthefu-comment\">\r\n\t\t\t\t\t<div class=\"daexthefu-comment-top-container\">\r\n\t\t\t\t\t\t<label id=\"daexthefu-comment-label\" class=\"daexthefu-comment-label\"><\/label>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"daexthefu-comment-character-counter-container\">\r\n\t\t\t\t\t\t\t\t<div id=\"daexthefu-comment-character-counter-number\"\r\n\t\t\t\t\t\t\t\t\tclass=\"daexthefu-comment-character-counter-number\"><\/div>\r\n\t\t\t\t\t\t\t\t<div class=\"daexthefu-comment-character-counter-text\"><\/div>\r\n\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<textarea id=\"daexthefu-comment-textarea\" class=\"daexthefu-comment-textarea\"\r\n\t\t\t\t\t\t\t\tplaceholder=\"\u0412\u0432\u0435\u0434\u0438\u0442\u0435 \u0432\u0430\u0448\u0435 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435\"\r\n\t\t\t\t\t\t\t\tmaxlength=\"\r\n\t\t\t\t\t\t\t\t400\t\t\t\t\t\t\t\t\t\"><\/textarea>\r\n\t\t\t\t\t<div class=\"daexthefu-comment-buttons-container\">\r\n\t\t\t\t\t\t<button class=\"daexthefu-comment-submit daexthefu-button\">\u041e\u0442\u043f\u0440\u0430\u0432\u0438\u0442\u044c<\/button>\r\n\t\t\t\t\t\t<button class=\"daexthefu-comment-cancel daexthefu-button\">\u041e\u0442\u043c\u0435\u043d\u0438\u0442\u044c<\/button>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\r\n\t\t\t\t<div class=\"daexthefu-successful-submission-text\">\u0421\u043f\u0430\u0441\u0438\u0431\u043e \u0437\u0430 \u043e\u0431\u0440\u0430\u0442\u043d\u0443\u044e \u0441\u0432\u044f\u0437\u044c!<\/div>\r\n\r\n\t\t\t<\/div>\r\n\r\n\t\t\t","protected":false},"excerpt":{"rendered":"<p>How to use the External Query action to read data from a Google spreadsheet and write it to the subscriber&#8217;s user fields<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_helpful_status":1,"footnotes":""},"categories":[22],"tags":[],"class_list":["post-393","post","type-post","status-publish","format-standard","hentry","category-api-i-vneshnij-zapros"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Integration with Google Sheets via &quot;External Query&quot;<\/title>\n<meta name=\"description\" content=\"How to use the External Query action to read data from a Google spreadsheet and write it to the subscriber&#039;s user fields\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/How%20to%20use%20the%20External%20Query%20action%20to%20read%20data%20from%20a%20Google%20spreadsheet%20and%20write%20it%20to%20the%20subscriber's%20user%20fields\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integration with Google Sheets via &quot;External Query&quot;\" \/>\n<meta property=\"og:description\" content=\"How to use the External Query action to read data from a Google spreadsheet and write it to the subscriber&#039;s user fields\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0411\u0430\u0437\u0430 \u0437\u043d\u0430\u043d\u0438\u0439 BotHelp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/bothelpru\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-21T14:57:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-25T10:06:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670563560521-se4lm0id.png\" \/>\n<meta name=\"author\" content=\"\u0422\u0430\u0442\u044c\u044f\u043d\u0430 \u041a\u0430\u0440\u043f\u0438\u043a\u043e\u0432\u0430\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u0422\u0430\u0442\u044c\u044f\u043d\u0430 \u041a\u0430\u0440\u043f\u0438\u043a\u043e\u0432\u0430\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/\"},\"author\":{\"name\":\"\u0422\u0430\u0442\u044c\u044f\u043d\u0430 \u041a\u0430\u0440\u043f\u0438\u043a\u043e\u0432\u0430\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/#\\\/schema\\\/person\\\/3725f2e711da03f7380efe93da1a53ca\"},\"headline\":\"Integration with Google Sheets via \\\"External Query\\\"\",\"datePublished\":\"2024-09-21T14:57:04+00:00\",\"dateModified\":\"2025-09-25T10:06:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/\"},\"wordCount\":942,\"image\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/files.carrotquest.io\\\/knowledge-bases-images\\\/articles\\\/49290\\\/49290-1670563560521-se4lm0id.png\",\"articleSection\":[\"API and external request\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/\",\"url\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/\",\"name\":\"\u0418\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u044f \u0441 Google \u0422\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0447\u0435\u0440\u0435\u0437 \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 | \u0411\u0430\u0437\u0430 \u0437\u043d\u0430\u043d\u0438\u0439 BotHelp\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/files.carrotquest.io\\\/knowledge-bases-images\\\/articles\\\/49290\\\/49290-1670563560521-se4lm0id.png\",\"datePublished\":\"2024-09-21T14:57:04+00:00\",\"dateModified\":\"2025-09-25T10:06:03+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/#\\\/schema\\\/person\\\/3725f2e711da03f7380efe93da1a53ca\"},\"description\":\"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u044e BotHelp \u0441 Google \u0422\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0447\u0435\u0440\u0435\u0437 \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u0437\u0430\u043f\u0440\u043e\u0441. \u0420\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0437\u0430\u0446\u0438\u0438 \u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/#primaryimage\",\"url\":\"https:\\\/\\\/files.carrotquest.io\\\/knowledge-bases-images\\\/articles\\\/49290\\\/49290-1670563560521-se4lm0id.png\",\"contentUrl\":\"https:\\\/\\\/files.carrotquest.io\\\/knowledge-bases-images\\\/articles\\\/49290\\\/49290-1670563560521-se4lm0id.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"How to Work with BotHelp Service: Setting Up Your Account for Your Business Goals\",\"item\":\"https:\\\/\\\/help.bothelp.io\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Integration with Google Sheets via \\\"External Query\\\"\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/\",\"name\":\"\u0411\u0430\u0437\u0430 \u0437\u043d\u0430\u043d\u0438\u0439 BotHelp\",\"description\":\"\u0417\u0434\u0435\u0441\u044c \u0432\u044b \u043d\u0430\u0439\u0434\u0435\u0442\u0435 \u043e\u0442\u0432\u0435\u0442\u044b \u043d\u0430 \u0432\u0441\u0435 \u0432\u043e\u043f\u0440\u043e\u0441\u044b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/#\\\/schema\\\/person\\\/3725f2e711da03f7380efe93da1a53ca\",\"name\":\"\u0422\u0430\u0442\u044c\u044f\u043d\u0430 \u041a\u0430\u0440\u043f\u0438\u043a\u043e\u0432\u0430\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc2c651ad25d8a5ed31aeb69271b32a21caab387207adf0043a317f97bedafbd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc2c651ad25d8a5ed31aeb69271b32a21caab387207adf0043a317f97bedafbd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc2c651ad25d8a5ed31aeb69271b32a21caab387207adf0043a317f97bedafbd?s=96&d=mm&r=g\",\"caption\":\"\u0422\u0430\u0442\u044c\u044f\u043d\u0430 \u041a\u0430\u0440\u043f\u0438\u043a\u043e\u0432\u0430\"},\"url\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/author\\\/t-karpikova\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Integration with Google Sheets via \"External Query\"","description":"How to use the External Query action to read data from a Google spreadsheet and write it to the subscriber's user fields","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":"How to use the External Query action to read data from a Google spreadsheet and write it to the subscriber's user fields","og_locale":"en_US","og_type":"article","og_title":"Integration with Google Sheets via \"External Query\"","og_description":"How to use the External Query action to read data from a Google spreadsheet and write it to the subscriber's user fields","og_url":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/","og_site_name":"\u0411\u0430\u0437\u0430 \u0437\u043d\u0430\u043d\u0438\u0439 BotHelp","article_publisher":"https:\/\/www.facebook.com\/bothelpru","article_published_time":"2024-09-21T14:57:04+00:00","article_modified_time":"2025-09-25T10:06:03+00:00","og_image":[{"url":"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670563560521-se4lm0id.png","type":"","width":"","height":""}],"author":"\u0422\u0430\u0442\u044c\u044f\u043d\u0430 \u041a\u0430\u0440\u043f\u0438\u043a\u043e\u0432\u0430","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u0422\u0430\u0442\u044c\u044f\u043d\u0430 \u041a\u0430\u0440\u043f\u0438\u043a\u043e\u0432\u0430","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/#article","isPartOf":{"@id":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/"},"author":{"name":"\u0422\u0430\u0442\u044c\u044f\u043d\u0430 \u041a\u0430\u0440\u043f\u0438\u043a\u043e\u0432\u0430","@id":"https:\/\/help.bothelp.io\/#\/schema\/person\/3725f2e711da03f7380efe93da1a53ca"},"headline":"Integration with Google Sheets via \"External Query\"","datePublished":"2024-09-21T14:57:04+00:00","dateModified":"2025-09-25T10:06:03+00:00","mainEntityOfPage":{"@id":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/"},"wordCount":942,"image":{"@id":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/#primaryimage"},"thumbnailUrl":"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670563560521-se4lm0id.png","articleSection":["API and external request"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/","url":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/","name":"\u0418\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u044f \u0441 Google \u0422\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0447\u0435\u0440\u0435\u0437 \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 | \u0411\u0430\u0437\u0430 \u0437\u043d\u0430\u043d\u0438\u0439 BotHelp","isPartOf":{"@id":"https:\/\/help.bothelp.io\/#website"},"primaryImageOfPage":{"@id":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/#primaryimage"},"image":{"@id":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/#primaryimage"},"thumbnailUrl":"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670563560521-se4lm0id.png","datePublished":"2024-09-21T14:57:04+00:00","dateModified":"2025-09-25T10:06:03+00:00","author":{"@id":"https:\/\/help.bothelp.io\/#\/schema\/person\/3725f2e711da03f7380efe93da1a53ca"},"description":"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u044e BotHelp \u0441 Google \u0422\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0447\u0435\u0440\u0435\u0437 \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u0437\u0430\u043f\u0440\u043e\u0441. \u0420\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0437\u0430\u0446\u0438\u0438 \u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438.","breadcrumb":{"@id":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/#primaryimage","url":"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670563560521-se4lm0id.png","contentUrl":"https:\/\/files.carrotquest.io\/knowledge-bases-images\/articles\/49290\/49290-1670563560521-se4lm0id.png"},{"@type":"BreadcrumbList","@id":"https:\/\/help.bothelp.io\/en\/integracziya-s-gugl-tabliczami-cherez-vneshnij-zapros\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"How to Work with BotHelp Service: Setting Up Your Account for Your Business Goals","item":"https:\/\/help.bothelp.io\/"},{"@type":"ListItem","position":2,"name":"Integration with Google Sheets via \"External Query\""}]},{"@type":"WebSite","@id":"https:\/\/help.bothelp.io\/en\/#website","url":"https:\/\/help.bothelp.io\/en\/","name":"\u0411\u0430\u0437\u0430 \u0437\u043d\u0430\u043d\u0438\u0439 BotHelp","description":"\u0417\u0434\u0435\u0441\u044c \u0432\u044b \u043d\u0430\u0439\u0434\u0435\u0442\u0435 \u043e\u0442\u0432\u0435\u0442\u044b \u043d\u0430 \u0432\u0441\u0435 \u0432\u043e\u043f\u0440\u043e\u0441\u044b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/help.bothelp.io\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/help.bothelp.io\/#\/schema\/person\/3725f2e711da03f7380efe93da1a53ca","name":"\u0422\u0430\u0442\u044c\u044f\u043d\u0430 \u041a\u0430\u0440\u043f\u0438\u043a\u043e\u0432\u0430","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/fc2c651ad25d8a5ed31aeb69271b32a21caab387207adf0043a317f97bedafbd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fc2c651ad25d8a5ed31aeb69271b32a21caab387207adf0043a317f97bedafbd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fc2c651ad25d8a5ed31aeb69271b32a21caab387207adf0043a317f97bedafbd?s=96&d=mm&r=g","caption":"\u0422\u0430\u0442\u044c\u044f\u043d\u0430 \u041a\u0430\u0440\u043f\u0438\u043a\u043e\u0432\u0430"},"url":"https:\/\/help.bothelp.io\/en\/author\/t-karpikova\/"}]}},"_links":{"self":[{"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/posts\/393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/comments?post=393"}],"version-history":[{"count":15,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/posts\/393\/revisions"}],"predecessor-version":[{"id":5569,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/posts\/393\/revisions\/5569"}],"wp:attachment":[{"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/media?parent=393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/categories?post=393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/tags?post=393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}