{"id":719,"date":"2026-04-30T14:06:05","date_gmt":"2026-04-30T11:06:05","guid":{"rendered":"https:\/\/dariiaklimuk.wordpress.com\/?page_id=719"},"modified":"2026-04-30T14:06:05","modified_gmt":"2026-04-30T11:06:05","slug":"google-forms-apps-script-too","status":"publish","type":"page","link":"https:\/\/dariiaklimuk.eu\/wp\/google-forms-apps-script-too\/","title":{"rendered":"Google Forms + Apps Script t\u00f6\u00f6"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Selles t\u00f6\u00f6s l\u00f5in Google Forms k\u00fcsitluse ja kasutasin Apps Scripti, et saata automaatne t\u00e4nukiri vastajale.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Sammud:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>L\u00f5in Google Forms k\u00fcsitluse\n<ul class=\"wp-block-list\">\n<li>Lisatud v\u00e4ljad: nimi, e-post, vanus, s\u00fcnnip\u00e4ev<\/li>\n\n\n\n<li>Kasutasin erinevaid k\u00fcsimuse t\u00fc\u00fcpe (valik, kuup\u00e4ev, checkbox)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"962\" height=\"305\" src=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/099b9378-4498-4567-b90b-e663b550d878.png?w=962\" alt=\"\" class=\"wp-image-722\" srcset=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/099b9378-4498-4567-b90b-e663b550d878.png 962w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/099b9378-4498-4567-b90b-e663b550d878-300x95.png 300w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/099b9378-4498-4567-b90b-e663b550d878-768x243.png 768w\" sizes=\"(max-width: 962px) 100vw, 962px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"780\" height=\"585\" src=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/7582aada-56cd-4247-a1e2-53909f8c6f7c.png?w=780\" alt=\"\" class=\"wp-image-723\" srcset=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/7582aada-56cd-4247-a1e2-53909f8c6f7c.png 780w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/7582aada-56cd-4247-a1e2-53909f8c6f7c-300x225.png 300w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/7582aada-56cd-4247-a1e2-53909f8c6f7c-768x576.png 768w\" sizes=\"(max-width: 780px) 100vw, 780px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"694\" src=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/f3f56dce-ab21-4ce4-bdbe-177f05c6bf43.png?w=786\" alt=\"\" class=\"wp-image-724\" srcset=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/f3f56dce-ab21-4ce4-bdbe-177f05c6bf43.png 786w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/f3f56dce-ab21-4ce4-bdbe-177f05c6bf43-300x265.png 300w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/f3f56dce-ab21-4ce4-bdbe-177f05c6bf43-768x678.png 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00dchendasin vormi Google Sheets tabeliga<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"319\" height=\"48\" src=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/image-3.png?w=319\" alt=\"\" class=\"wp-image-726\" srcset=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/image-3.png 319w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/image-3-300x45.png 300w\" sizes=\"(max-width: 319px) 100vw, 319px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"777\" height=\"390\" src=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/image-4.png?w=777\" alt=\"\" class=\"wp-image-727\" style=\"aspect-ratio:1.9923679453705563;width:378px;height:auto\" srcset=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/image-4.png 777w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/image-4-300x151.png 300w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/image-4-768x385.png 768w\" sizes=\"(max-width: 777px) 100vw, 777px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Avatud Google Sheets \u2192 Laiendused \u2192 Apps Script<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kirjutasin skripti, mis:\n<ul class=\"wp-block-list\">\n<li>loeb vastused tabelist<\/li>\n\n\n\n<li>v\u00f5tab nime ja e-posti<\/li>\n\n\n\n<li>lisab ka teised vastused<\/li>\n\n\n\n<li>saadab automaatselt t\u00e4nukirja<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"815\" height=\"425\" src=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/207169d4-f3fd-44d3-ba9d-2f691e0f154b.png?w=815\" alt=\"\" class=\"wp-image-729\" srcset=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/207169d4-f3fd-44d3-ba9d-2f691e0f154b.png 815w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/207169d4-f3fd-44d3-ba9d-2f691e0f154b-300x156.png 300w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/207169d4-f3fd-44d3-ba9d-2f691e0f154b-768x400.png 768w\" sizes=\"(max-width: 815px) 100vw, 815px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lisasin triggeri:\n<ul class=\"wp-block-list\">\n<li>Event: On form submit<\/li>\n\n\n\n<li>Function: saadaTanuKiri<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"184\" height=\"184\" src=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/image-5-edited-1.png\" alt=\"\" class=\"wp-image-734\" srcset=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/image-5-edited-1.png 184w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/image-5-edited-1-150x150.png 150w\" sizes=\"(max-width: 184px) 100vw, 184px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"664\" src=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/00712a04-0ab2-4fb8-9dc6-818e2555f2e3.png?w=700\" alt=\"\" class=\"wp-image-735\" style=\"aspect-ratio:1.0542256701825234;width:399px;height:auto\" srcset=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/00712a04-0ab2-4fb8-9dc6-818e2555f2e3.png 700w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/00712a04-0ab2-4fb8-9dc6-818e2555f2e3-300x285.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Testisin s\u00fcsteemi:\n<ul class=\"wp-block-list\">\n<li>t\u00e4itsin vormi<\/li>\n\n\n\n<li>kontrollisin e-posti<\/li>\n\n\n\n<li>sain automaatse t\u00e4nukirja<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Kasutatud AI prompt:<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Kasutasin AI abi j\u00e4rgmise promptiga:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Koosta Google Apps Script funktsioon, mis saadab automaatselt t\u00e4nukirja ja lisab sinna ka k\u00f5ik kasutaja vastused.<\/p>\n<\/blockquote>\n\n\n\n<h4 class=\"wp-block-heading\">Tulemus:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>vastused salvestatakse tabelisse<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1386\" height=\"185\" src=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/8ea3557c-99a3-4c41-916e-30bd875f3fa0.png?w=1024\" alt=\"\" class=\"wp-image-738\" srcset=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/8ea3557c-99a3-4c41-916e-30bd875f3fa0.png 1386w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/8ea3557c-99a3-4c41-916e-30bd875f3fa0-300x40.png 300w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/8ea3557c-99a3-4c41-916e-30bd875f3fa0-1024x137.png 1024w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/8ea3557c-99a3-4c41-916e-30bd875f3fa0-768x103.png 768w\" sizes=\"(max-width: 1386px) 100vw, 1386px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>kasutaja saab automaatse t\u00e4nukirja koos oma vastustega<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"291\" src=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/5c7845d2-186a-467c-9fe3-54eec7af6ed5.png?w=597\" alt=\"\" class=\"wp-image-740\" style=\"width:488px;height:auto\" srcset=\"https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/5c7845d2-186a-467c-9fe3-54eec7af6ed5.png 597w, https:\/\/dariiaklimuk.eu\/wp\/wp-content\/uploads\/2026\/04\/5c7845d2-186a-467c-9fe3-54eec7af6ed5-300x146.png 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Link k\u00fcsitlusele:<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/forms.gle\/HFiDDFxB51mNf73P6\">https:\/\/forms.gle\/HFiDDFxB51mNf73P6<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Selles t\u00f6\u00f6s l\u00f5in Google Forms k\u00fcsitluse ja kasutasin Apps Scripti, et saata automaatne t\u00e4nukiri vastajale. Sammud: Kasutatud AI prompt: Kasutasin AI abi j\u00e4rgmise promptiga: Koosta Google Apps Script funktsioon, mis saadab automaatselt t\u00e4nukirja ja lisab sinna ka k\u00f5ik kasutaja vastused. Tulemus: Link k\u00fcsitlusele: https:\/\/forms.gle\/HFiDDFxB51mNf73P6<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"saved_in_kubio":false,"footnotes":""},"class_list":["post-719","page","type-page","status-publish","hentry"],"kubio_ai_page_context":{"short_desc":"","purpose":"general"},"_links":{"self":[{"href":"https:\/\/dariiaklimuk.eu\/wp\/wp-json\/wp\/v2\/pages\/719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dariiaklimuk.eu\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dariiaklimuk.eu\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dariiaklimuk.eu\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dariiaklimuk.eu\/wp\/wp-json\/wp\/v2\/comments?post=719"}],"version-history":[{"count":0,"href":"https:\/\/dariiaklimuk.eu\/wp\/wp-json\/wp\/v2\/pages\/719\/revisions"}],"wp:attachment":[{"href":"https:\/\/dariiaklimuk.eu\/wp\/wp-json\/wp\/v2\/media?parent=719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}