{"id":7349,"date":"2026-03-04T11:50:28","date_gmt":"2026-03-04T08:50:28","guid":{"rendered":"https:\/\/help.bothelp.io\/?p=7349"},"modified":"2026-03-27T21:31:34","modified_gmt":"2026-03-27T18:31:34","slug":"upravlenie-google-tabliczej","status":"publish","type":"post","link":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/","title":{"rendered":"Google Sheets Management"},"content":{"rendered":"<p data-start=\"155\" data-end=\"320\"><strong>The Google Sheets<\/strong> function allows you to create a new record in a selected spreadsheet. The function is triggered by a specific event in a subscriber conversation:<\/p>\n<ul data-start=\"322\" data-end=\"459\">\n<li data-start=\"322\" data-end=\"435\">\n<p data-start=\"324\" data-end=\"435\">The subscriber confirmed their interest in booking an online consultation \/ trial lesson \/ in-person meeting.<\/p>\n<\/li>\n<li data-start=\"436\" data-end=\"459\">\n<p data-start=\"438\" data-end=\"459\">Or any other event.<\/p>\n<\/li>\n<\/ul>\n<h2>Google Sheets Setup<\/h2>\n<p data-start=\"491\" data-end=\"521\"><strong>Preparing the Spreadsheet<\/strong><\/p>\n<ul data-start=\"523\" data-end=\"1238\">\n<li data-start=\"523\" data-end=\"550\">\n<p data-start=\"526\" data-end=\"550\">Create a Google Sheet.<\/p>\n<\/li>\n<li data-start=\"551\" data-end=\"621\">\n<p data-start=\"554\" data-end=\"621\">If needed, you can create multiple sheets within one spreadsheet.<\/p>\n<ul>\n<li data-start=\"625\" data-end=\"814\"><strong>Important<\/strong>: after connecting the integration and configuring the function, do <strong data-start=\"702\" data-end=\"709\">not<\/strong> change the sheet names. If you change a sheet name, update the function\u2019s action settings accordingly.<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"815\" data-end=\"967\">\n<p data-start=\"818\" data-end=\"967\">Make sure the first row of the sheet contains column headers where data will be recorded. These headers are required for mapping data from BotHelp.<\/p>\n<\/li>\n<li data-start=\"968\" data-end=\"1057\">\n<p data-start=\"971\" data-end=\"1057\">There are no strict requirements for column names \u2014 you can name them as you prefer.<\/p>\n<\/li>\n<li data-start=\"1058\" data-end=\"1238\">\n<p data-start=\"1061\" data-end=\"1238\">There should be no empty columns between your columns. If there are columns without headers, BotHelp will only recognize columns up to the first empty column without a header.<\/p>\n<\/li>\n<li data-start=\"1267\" data-end=\"1315\">\n<p data-start=\"1269\" data-end=\"1315\">Ensure you are the owner of the spreadsheet.<\/p>\n<\/li>\n<li data-start=\"1316\" data-end=\"1392\">\n<p data-start=\"1318\" data-end=\"1392\">In sharing settings, select <strong data-start=\"1346\" data-end=\"1372\">\u201cAnyone with the link\u201d<\/strong> and <strong data-start=\"1377\" data-end=\"1389\">\u201cEditor\u201d<\/strong>.<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"1399\" data-end=\"1447\"><strong>Important:<\/strong> Google Sheets Field Requirements.<\/p>\n<ul data-start=\"1449\" data-end=\"2182\">\n<li data-start=\"1449\" data-end=\"1562\">\n<p data-start=\"1451\" data-end=\"1562\">Column names in Google Sheets can be up to 255 characters \u2014 the same limit applies to field names in BotHelp.<\/p>\n<\/li>\n<li data-start=\"1563\" data-end=\"1630\">\n<p data-start=\"1565\" data-end=\"1630\">Cell values in Google Sheets should not exceed 1000 characters.<\/p>\n<\/li>\n<li data-start=\"1631\" data-end=\"1970\">\n<p data-start=\"1633\" data-end=\"1769\">Do <strong data-start=\"1636\" data-end=\"1643\">not<\/strong> leave empty rows between records \u2014 otherwise, new data will be inserted into empty rows instead of at the end of the table.<\/p>\n<ul data-start=\"1772\" data-end=\"1970\">\n<li data-start=\"1772\" data-end=\"1970\">\n<p data-start=\"1774\" data-end=\"1970\">If you need to visually separate the table into groups, fill at least one cell in that row with any symbol or text. The filled cell must be within the area where automatic data recording occurs.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"1971\" data-end=\"2182\">\n<p data-start=\"1973\" data-end=\"2182\">If you need to reference cells on other sheets, it\u2019s recommended to use the <code data-start=\"2049\" data-end=\"2059\">INDIRECT<\/code> function instead of direct references like <code data-start=\"2103\" data-end=\"2117\">='Sheet1'!A2<\/code>. This ensures correct and stable data transfer between sheets.<\/p>\n<\/li>\n<\/ul>\n<h2>Connecting the Function<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-7419\" src=\"https:\/\/help.bothelp.io\/wp-content\/uploads\/2026\/03\/snimok-ekrana-2026-03-05-v-15.32.12-1024x388.png\" alt=\"\" width=\"1024\" height=\"388\" srcset=\"https:\/\/help.bothelp.io\/wp-content\/uploads\/2026\/03\/snimok-ekrana-2026-03-05-v-15.32.12-1024x388.png 1024w, https:\/\/help.bothelp.io\/wp-content\/uploads\/2026\/03\/snimok-ekrana-2026-03-05-v-15.32.12-300x114.png 300w, https:\/\/help.bothelp.io\/wp-content\/uploads\/2026\/03\/snimok-ekrana-2026-03-05-v-15.32.12-768x291.png 768w, https:\/\/help.bothelp.io\/wp-content\/uploads\/2026\/03\/snimok-ekrana-2026-03-05-v-15.32.12-1536x581.png 1536w, https:\/\/help.bothelp.io\/wp-content\/uploads\/2026\/03\/snimok-ekrana-2026-03-05-v-15.32.12-2048x775.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li data-start=\"2218\" data-end=\"2330\">\n<p data-start=\"2221\" data-end=\"2330\">In the first step of AI-agent setup, go to the <strong data-start=\"2268\" data-end=\"2281\">Functions<\/strong> section and select the <strong data-start=\"2305\" data-end=\"2322\">Google Sheets<\/strong> card.<\/p>\n<\/li>\n<li data-start=\"2331\" data-end=\"2515\">\n<p data-start=\"2334\" data-end=\"2374\">Connect the Google Sheets integration:<\/p>\n<ul data-start=\"2378\" data-end=\"2515\">\n<li data-start=\"2378\" data-end=\"2412\">\n<p data-start=\"2380\" data-end=\"2412\">Click <strong data-start=\"2386\" data-end=\"2409\">Connect Integration<\/strong>.<\/p>\n<\/li>\n<li data-start=\"2416\" data-end=\"2453\">\n<p data-start=\"2418\" data-end=\"2453\">A Google Sheets window will open.<\/p>\n<\/li>\n<li data-start=\"2457\" data-end=\"2515\">\n<p data-start=\"2459\" data-end=\"2515\">Select the desired Google account and click <strong data-start=\"2503\" data-end=\"2512\">Allow<\/strong>.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"2516\" data-end=\"2929\">\n<p data-start=\"2519\" data-end=\"2555\">Configure the function parameters:<\/p>\n<ul data-start=\"2559\" data-end=\"2929\">\n<li data-start=\"2559\" data-end=\"2715\">\n<p data-start=\"2561\" data-end=\"2715\"><strong data-start=\"2561\" data-end=\"2579\">Event trigger:<\/strong> Specify the trigger, e.g., \u201csubscriber confirmed booking an online consultation,\u201d or any other event relevant to your business logic.<\/p>\n<\/li>\n<li data-start=\"2719\" data-end=\"2783\">\n<p data-start=\"2721\" data-end=\"2783\"><strong data-start=\"2721\" data-end=\"2737\">Spreadsheet:<\/strong> Enter the direct link to your Google Sheet.<\/p>\n<\/li>\n<li data-start=\"2787\" data-end=\"2833\">\n<p data-start=\"2789\" data-end=\"2833\"><strong data-start=\"2789\" data-end=\"2799\">Sheet:<\/strong> Select the sheet from the list.<\/p>\n<\/li>\n<li data-start=\"2839\" data-end=\"2929\"><strong data-start=\"2839\" data-end=\"2857\">Field mapping:<\/strong> Map the subscriber card fields you want to transfer to Google Sheets.<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"2839\" data-end=\"2929\">Save the function.<\/li>\n<\/ul>\n<div>Congratulations! The function is successfully configured. Make sure to <strong data-start=\"3031\" data-end=\"3052\">test the function<\/strong> before deploying it to all subscribers.<\/div>\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><\/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=\"7349\">\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>The Google Sheets function allows you to create a new record in a selected spreadsheet. The function is triggered by a specific event in a subscriber conversation: The subscriber confirmed their interest in booking an online consultation \/ trial lesson \/ in-person meeting. Or any other event. Google Sheets Setup Preparing the Spreadsheet Create a [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_helpful_status":1,"footnotes":""},"categories":[95],"tags":[],"class_list":["post-7349","post","type-post","status-publish","format-standard","hentry","category-ai-agent-functions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Google Sheets Management<\/title>\n<meta name=\"description\" content=\"The Google Sheets function allows you to create a new record in a selected spreadsheet. The function is triggered by a specific event in a subscriber conversation: The subscriber confirmed their interest in booking an online consultation \/ trial lesson \/ in-person meeting. Or any other event. Google Sheets Setup Preparing the Spreadsheet Create a&hellip;\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets Management\" \/>\n<meta property=\"og:description\" content=\"The Google Sheets function allows you to create a new record in a selected spreadsheet. The function is triggered by a specific event in a subscriber conversation: The subscriber confirmed their interest in booking an online consultation \/ trial lesson \/ in-person meeting. Or any other event. Google Sheets Setup Preparing the Spreadsheet Create a&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/\" \/>\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=\"2026-03-04T08:50:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-27T18:31:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/files.carrotquest.app\/knowledge-bases-images\/articles\/49290\/49290-1681811053269-jmsz7r4j.png\" \/>\n<meta name=\"author\" content=\"\u042d\u043b\u043b\u0430 \u0424\u0435\u0434\u043e\u0440\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=\"\u042d\u043b\u043b\u0430 \u0424\u0435\u0434\u043e\u0440\u043e\u0432\u0430\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/\"},\"author\":{\"name\":\"\u042d\u043b\u043b\u0430 \u0424\u0435\u0434\u043e\u0440\u043e\u0432\u0430\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/#\\\/schema\\\/person\\\/b93a6a7803b1e2ea3edeb59d9247e5d5\"},\"headline\":\"Google Sheets Management\",\"datePublished\":\"2026-03-04T08:50:28+00:00\",\"dateModified\":\"2026-03-27T18:31:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/\"},\"wordCount\":553,\"image\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/files.carrotquest.app\\\/knowledge-bases-images\\\/articles\\\/49290\\\/49290-1681811053269-jmsz7r4j.png\",\"articleSection\":[\"AI-Agent Functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/\",\"url\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/\",\"name\":\"\u0423\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 Google \u0422\u0430\u0431\u043b\u0438\u0446\u0435\u0439 - \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\\\/upravlenie-google-tabliczej\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/files.carrotquest.app\\\/knowledge-bases-images\\\/articles\\\/49290\\\/49290-1681811053269-jmsz7r4j.png\",\"datePublished\":\"2026-03-04T08:50:28+00:00\",\"dateModified\":\"2026-03-27T18:31:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/#\\\/schema\\\/person\\\/b93a6a7803b1e2ea3edeb59d9247e5d5\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/#primaryimage\",\"url\":\"https:\\\/\\\/files.carrotquest.app\\\/knowledge-bases-images\\\/articles\\\/49290\\\/49290-1681811053269-jmsz7r4j.png\",\"contentUrl\":\"https:\\\/\\\/files.carrotquest.app\\\/knowledge-bases-images\\\/articles\\\/49290\\\/49290-1681811053269-jmsz7r4j.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/upravlenie-google-tabliczej\\\/#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\":\"Google Sheets Management\"}]},{\"@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\\\/b93a6a7803b1e2ea3edeb59d9247e5d5\",\"name\":\"\u042d\u043b\u043b\u0430 \u0424\u0435\u0434\u043e\u0440\u043e\u0432\u0430\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5ffa840d7a9636e0d0c9498016590515f725cd29c1d0f6a5997f7e68c182f211?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5ffa840d7a9636e0d0c9498016590515f725cd29c1d0f6a5997f7e68c182f211?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5ffa840d7a9636e0d0c9498016590515f725cd29c1d0f6a5997f7e68c182f211?s=96&d=mm&r=g\",\"caption\":\"\u042d\u043b\u043b\u0430 \u0424\u0435\u0434\u043e\u0440\u043e\u0432\u0430\"},\"url\":\"https:\\\/\\\/help.bothelp.io\\\/en\\\/author\\\/e-fedorova\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Sheets Management","description":"The Google Sheets function allows you to create a new record in a selected spreadsheet. The function is triggered by a specific event in a subscriber conversation: The subscriber confirmed their interest in booking an online consultation \/ trial lesson \/ in-person meeting. Or any other event. Google Sheets Setup Preparing the Spreadsheet Create a&hellip;","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":"The Google Sheets function allows you to create a new record in a selected spreadsheet. The function is triggered by a specific event in a subscriber conversation: The subscriber confirmed their interest in booking an online consultation \/ trial lesson \/ in-person meeting. Or any other event. Google Sheets Setup Preparing the Spreadsheet Create a&hellip;","og_locale":"en_US","og_type":"article","og_title":"Google Sheets Management","og_description":"The Google Sheets function allows you to create a new record in a selected spreadsheet. The function is triggered by a specific event in a subscriber conversation: The subscriber confirmed their interest in booking an online consultation \/ trial lesson \/ in-person meeting. Or any other event. Google Sheets Setup Preparing the Spreadsheet Create a&hellip;","og_url":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/","og_site_name":"\u0411\u0430\u0437\u0430 \u0437\u043d\u0430\u043d\u0438\u0439 BotHelp","article_publisher":"https:\/\/www.facebook.com\/bothelpru","article_published_time":"2026-03-04T08:50:28+00:00","article_modified_time":"2026-03-27T18:31:34+00:00","og_image":[{"url":"https:\/\/files.carrotquest.app\/knowledge-bases-images\/articles\/49290\/49290-1681811053269-jmsz7r4j.png","type":"","width":"","height":""}],"author":"\u042d\u043b\u043b\u0430 \u0424\u0435\u0434\u043e\u0440\u043e\u0432\u0430","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u042d\u043b\u043b\u0430 \u0424\u0435\u0434\u043e\u0440\u043e\u0432\u0430","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/#article","isPartOf":{"@id":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/"},"author":{"name":"\u042d\u043b\u043b\u0430 \u0424\u0435\u0434\u043e\u0440\u043e\u0432\u0430","@id":"https:\/\/help.bothelp.io\/#\/schema\/person\/b93a6a7803b1e2ea3edeb59d9247e5d5"},"headline":"Google Sheets Management","datePublished":"2026-03-04T08:50:28+00:00","dateModified":"2026-03-27T18:31:34+00:00","mainEntityOfPage":{"@id":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/"},"wordCount":553,"image":{"@id":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/#primaryimage"},"thumbnailUrl":"https:\/\/files.carrotquest.app\/knowledge-bases-images\/articles\/49290\/49290-1681811053269-jmsz7r4j.png","articleSection":["AI-Agent Functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/","url":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/","name":"\u0423\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 Google \u0422\u0430\u0431\u043b\u0438\u0446\u0435\u0439 - \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\/upravlenie-google-tabliczej\/#primaryimage"},"image":{"@id":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/#primaryimage"},"thumbnailUrl":"https:\/\/files.carrotquest.app\/knowledge-bases-images\/articles\/49290\/49290-1681811053269-jmsz7r4j.png","datePublished":"2026-03-04T08:50:28+00:00","dateModified":"2026-03-27T18:31:34+00:00","author":{"@id":"https:\/\/help.bothelp.io\/#\/schema\/person\/b93a6a7803b1e2ea3edeb59d9247e5d5"},"breadcrumb":{"@id":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/#primaryimage","url":"https:\/\/files.carrotquest.app\/knowledge-bases-images\/articles\/49290\/49290-1681811053269-jmsz7r4j.png","contentUrl":"https:\/\/files.carrotquest.app\/knowledge-bases-images\/articles\/49290\/49290-1681811053269-jmsz7r4j.png"},{"@type":"BreadcrumbList","@id":"https:\/\/help.bothelp.io\/en\/upravlenie-google-tabliczej\/#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":"Google Sheets Management"}]},{"@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\/b93a6a7803b1e2ea3edeb59d9247e5d5","name":"\u042d\u043b\u043b\u0430 \u0424\u0435\u0434\u043e\u0440\u043e\u0432\u0430","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/5ffa840d7a9636e0d0c9498016590515f725cd29c1d0f6a5997f7e68c182f211?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5ffa840d7a9636e0d0c9498016590515f725cd29c1d0f6a5997f7e68c182f211?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5ffa840d7a9636e0d0c9498016590515f725cd29c1d0f6a5997f7e68c182f211?s=96&d=mm&r=g","caption":"\u042d\u043b\u043b\u0430 \u0424\u0435\u0434\u043e\u0440\u043e\u0432\u0430"},"url":"https:\/\/help.bothelp.io\/en\/author\/e-fedorova\/"}]}},"_links":{"self":[{"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/posts\/7349","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/comments?post=7349"}],"version-history":[{"count":13,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/posts\/7349\/revisions"}],"predecessor-version":[{"id":7795,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/posts\/7349\/revisions\/7795"}],"wp:attachment":[{"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/media?parent=7349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/categories?post=7349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.bothelp.io\/en\/wp-json\/wp\/v2\/tags?post=7349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}