{"id":3262,"date":"2020-08-02T08:51:00","date_gmt":"2020-08-02T08:51:00","guid":{"rendered":"http:\/\/the-codest.localhost\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/"},"modified":"2026-04-24T11:33:05","modified_gmt":"2026-04-24T11:33:05","slug":"%d8%ac%d8%af%d8%a7%d9%88%d9%84-%d8%a8%d9%8a%d8%a7%d9%86%d8%a7%d8%aa-%d8%ac%d9%88%d8%ac%d9%84-%d9%8a%d9%85%d9%83%d9%86-%d8%a3%d9%86-%d8%aa%d9%83%d9%88%d9%86-%d8%a3%d9%83%d8%ab%d8%b1-%d8%b0%d9%83%d8%a7","status":"publish","type":"post","link":"https:\/\/thecodest.co\/ar\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/","title":{"rendered":"\u0643\u064a\u0641 \u064a\u0645\u0643\u0646 \u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a Google \u062a\u0648\u0641\u064a\u0631 \u0648\u0642\u062a\u0643\u061f"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">In this article, I want to look closer at the Google Spreadsheets app and show you how to make it even smarter using the Google Apps Script<\/h2>\n\n\n\n<p>Imagine that your job is about supervising someone else&#8217;s work, which usually leads to writing some reports. You want to keep things standardized and generic, so you created a spreadsheet with the list of things you need to control and some cells for a comment. Let&#8217;s assume that you are responsible for the quality of a digital <a href=\"https:\/\/thecodest.co\/ar\/dictionary\/how-to-make-product\/\">product<\/a>. Then your Spreadsheet may look like this:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/app\/uploads\/2024\/05\/software-development.png\" alt=\"software development\"\/><\/figure>\n\n\n\n<p>In the example above, you can see several things:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>feature name (&#8220;User login form&#8221;) and number (e.g. from an ERP system),<\/li>\n\n\n\n<li>list of aspects you have to check and give feedback on (&#8220;Area\u201d column),<\/li>\n\n\n\n<li>some empty fields for your conclusions (&#8220;Comment&#8221; column).<\/li>\n<\/ul>\n\n\n\n<p>This sheet is called &#8220;Report generator&#8221;, because I&#8217;m going to show you how this document can evolve into a really useful tool, allowing you to assess the quality of someone&#8217;s work results.<\/p>\n\n\n\n<p>If you want to quantify some results, probably the best option would be to use a scale, e.g. 1-10 points, or something along these lines.<\/p>\n\n\n\n<p>Let&#8217;s create a new sheet in the same document, call it &#8220;Config&#8221; and define it as protected (or at least append a keylock emoji to its name). This sheet is only for keeping some predefined options, like the ones below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/app\/uploads\/2024\/05\/Codest-software-development.png\" alt=\"Codest software development\"\/><\/figure>\n\n\n\n<p>Now you can put these values into some dropdowns in the <em>Report generator<\/em> sheet by using the <strong><a href=\"https:\/\/thecodest.co\/ar\/blog\/app-data-collection-security-risks-value-and-types-explored\/\">Data<\/a> validation<\/strong> feature. <a href=\"https:\/\/support.google.com\/docs\/answer\/186103?co=GENIE.Platform%3DDesktop&amp;hl=en\">Here<\/a> you can find some instructions on how to achieve this:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/app\/uploads\/2024\/05\/software-house.png\" alt=\"software house\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Having done that, you can easily convert ratings to numeric values by using the <strong>IF<\/strong> formula. Your spreadsheet will stay human-friendly and your conclusions will be quantified (so measurable and comparable) at the same time.<\/p>\n<\/blockquote>\n\n\n\n<p>This document is neat, however, imagine what happens when the scope of your <a href=\"https:\/\/thecodest.co\/ar\/dictionary\/what-is-a-cyber-security-audit\/\">audit<\/a> grows and you have hundreds of things to check. You can save an empty form template and copy it every time you need to make a new report, but switching between document lists and the spreadsheet is very annoying. This is the point at which you start thinking about some automation.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/thecodest.co\/blog\"><img decoding=\"async\" src=\"\/app\/uploads\/2024\/05\/Swing-software-development-1024x512_2.png\" alt=\"Fronented Report for 2020\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>It\u2019s the perfect time to start your adventure with the Google Apps Script!<\/strong><\/h2>\n\n\n\n<p>Before we start coding, let&#8217;s prepare some buttons for bulk actions. According to the example above:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>mark all items as &#8220;Perfect,&#8221;<\/li>\n\n\n\n<li>mark all as &#8220;Improvements needed,&#8221;<\/li>\n\n\n\n<li>mark all as &#8220;Unacceptable,&#8221;<\/li>\n\n\n\n<li>reset all (set value to an empty string).<\/li>\n<\/ul>\n\n\n\n<p>Also, we will need one extra action to save a new file when the audit is done.<\/p>\n\n\n\n<p>First, let&#8217;s expand our <em>Report generator<\/em> with the functional area containing buttons.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/app\/uploads\/2024\/05\/software-house-Poland.png\" alt=\"software house Poland\"\/><\/figure>\n\n\n\n<p>Then, by using <strong>Insert -&gt; Drawing<\/strong>, let&#8217;s add our buttons, one by one.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/app\/uploads\/2024\/05\/Codest-software-house.png\" alt=\"Codest software house\"\/><\/figure>\n\n\n\n<p>Our sample document should look like this:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/app\/uploads\/2024\/05\/software-house-Europe.png\" alt=\"software house Poland\"\/><\/figure>\n\n\n\n<p>We&#8217;re ready to add some logic to this beautiful UI! It&#8217;s very easy to start \u2013 just choose <strong>Tools -&gt; Script editor<\/strong> in the top menu and the browser will jump to a new card.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/app\/uploads\/2024\/05\/software-development-agency.png\" alt=\"software development agency\"\/><\/figure>\n\n\n\n<p>The editor&#8217;s interface is very intuitive. If you are familiar with any <a href=\"https:\/\/thecodest.co\/ar\/dictionary\/what-is-code-refactoring\/\">code<\/a> editor, you should easily rename your file or create a new one (<em>File -&gt; New -&gt; Script file<\/em>).<\/p>\n\n\n\n<p><a href=\"https:\/\/developers.google.com\/apps-script\">Google Apps Script<\/a> is nothing more than a JavaScript&#8217;s cousin, so to say. If you know <a href=\"https:\/\/thecodest.co\/ar\/blog\/hire-vue-js-developers\/\">JS<\/a>, you can achieve GS proficiency, too!<\/p>\n\n\n\n<p>The very first step is to collect all possibly needed references in one place and give them some meaningful names. We&#8217;re starting with global variables by removing the default <em>myFunction<\/em> declaration and typing something more useful in the <strong><em>Code.gs<\/em><\/strong> file.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"javascript\" class=\"language-javascript\">var spreadsheet = SpreadsheetApp.getActiveSpreadsheet()\n\n\/\/ sheets references\n\nvar report = spreadsheet.getSheets()[0]\nvar config = spreadsheet.getSheets()[1]<\/code><\/pre>\n\n\n\n<p>The above code is quite self-explanatory, but to make it absolutely clear:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/spreadsheet-app\">SpreadsheetApp<\/a> class is available in a global context,<\/li>\n\n\n\n<li><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/spreadsheet-app#getActiveSpreadsheet()\">getActiveSpreadsheet<\/a> method allows <a href=\"https:\/\/thecodest.co\/ar\/blog\/why-us-companies-are-opting-for-polish-developers\/\">us<\/a> to get the reference to the spreadsheet we&#8217;re working on,<\/li>\n\n\n\n<li><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/spreadsheet#getSheets()\">getSheets<\/a> method called on the <em>Spreadsheet<\/em> instance returns the array of sheets from this spreadsheet; in our example, it returns the [<strong>Report generator<\/strong> sheet, <strong>Config<\/strong> sheet] array.<\/li>\n<\/ul>\n\n\n\n<p>Now we can go further and grab some useful data from our spreadsheet.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"javascript\" class=\"language-javascript\">\/\/ editable area (cells with dropdowns)\n\nvar dropdowns = report.getRange('C4:C13')\n\n\/\/ cell with subtitle (feature name)\n\nvar featureName = report.getRange('B2').getValue()\n\n\/\/ options from 'Config' sheet\n\/\/ notice that you can pass a single cell to getRange() method\n\/\/ and changing options doesn't affect your script's functionality\n\nvar values = {\nunacceptable: config.getRange('A2').getValue(),\nimprovements_needed: config.getRange('A3').getValue(),\nperfect: config.getRange('A4').getValue(),\nempty: ''\n};<\/code><\/pre>\n\n\n\n<p>The only thing left to code is the definition of functions we want to assign to our buttons.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"javascript\" class=\"language-javascript\">\/\/ button functions\n\nfunction allPerfect() {\ndropdowns.setValue(values.perfect)\n}\n\nfunction allNeedImprovements() {\ndropdowns.setValue(values.improvements_needed)\n}\n\nfunction allUnacceptable() {\ndropdowns.setValue(values.unacceptable)\n}\n\nfunction clear() {\ndropdowns.setValue(values.empty)\n}\n\nfunction copy() {\nvar copy = spreadsheet.copy(featureName + ' - report')\n\n\/\/ Now we have copied two sheets with same values\n\/\/ but changed names (with a \"copy\" suffix),\n\/\/ in this case, we have to give them original names\n\n\/\/ rename report sheet\ncopy.getSheets()[0].setName(report.getName())\n\n\/\/ rename config sheet\ncopy.getSheets()[1].setName(config.getName())\n}<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>The <strong><em>copy()<\/em><\/strong> method will automatically create a new spreadsheet named (in our example) <strong>&#8220;User login form \u2013 report\u201d<\/strong>, right next to the current one.<\/p>\n\n\n\n<p>Assign our methods to the buttons created before. Choose <em>Assign a script<\/em> after a right click on the button&#8230;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/app\/uploads\/2024\/05\/software-development-agency-Poland.png\" alt=\"software development agency Poland\"\/><\/figure>\n\n\n\n<p>&#8230;and type the method&#8217;s name, here it&#8217;s <em>allPerfect<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/app\/uploads\/2024\/05\/javascript-software-development.png\" alt=\"JavaScript software development\"\/><\/figure>\n\n\n\n<p>You don&#8217;t need to close your generator. Use your bulk actions to prepare the form for a new report, change the feature name and then save another copy!<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/camo.githubusercontent.com\/f49bd140d29ea561657f457c9555bcfa3f196e40\/68747470733a2f2f696d6775722e636f6d2f324469663149352e676966\" alt=\"\"\/><\/figure>\n\n\n\n<p>Possibilities of <strong>Google Apps Script<\/strong> are so wide that discussing them all would take a whole series of articles. If you are interested in optimizing your office work, feel free to check out the <a href=\"https:\/\/developers.google.com\/apps-script\">official docs<\/a> and make your sheets even smarter!<\/p>\n\n\n\n<p>There are some really useful hacks out there, like <a href=\"https:\/\/xfanatical.com\/blog\/print-google-sheet-as-pdf-using-apps-script\/\">this one<\/a> from <a href=\"https:\/\/xfanatical.com\">xfanatical.com<\/a> about exporting Google Spreadsheet to PDF.<\/p>\n\n\n\n<p>The example described in this article is <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1TEeCQR1-g2aO652Dc6rf1FDMgA132ToLoBLDVPfwMLw\/edit?usp=sharing\">here<\/a>. Hope you&#8217;ll love it. Have fun!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0641\u064a \u0627\u0644\u0648\u0642\u062a \u0627\u0644\u062d\u0627\u0636\u0631\u060c \u062a\u0637\u0631\u062d \u0627\u0644\u062d\u0644\u0648\u0644 \u0627\u0644\u0633\u062d\u0627\u0628\u064a\u0629 \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0633\u0637\u062d \u0627\u0644\u0645\u0643\u062a\u0628 \u0627\u0644\u0645\u062e\u0635\u0635\u0629 \u0644\u0644\u0623\u0639\u0645\u0627\u0644 \u0627\u0644\u0645\u0643\u062a\u0628\u064a\u0629. \u0648\u062a\u064f\u0642\u062f\u0650\u0651\u0645 Google \u0623\u062d\u062f \u0623\u0643\u0628\u0631 \u0627\u0644\u0645\u062c\u0645\u0648\u0639\u0627\u062a \u0627\u0644\u0645\u0643\u062a\u0628\u064a\u0629 \u0648\u062a\u062a\u0636\u0645\u0646 \u0627\u0644\u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0648\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0644\u0639\u0631\u0648\u0636 \u0627\u0644\u062a\u0642\u062f\u064a\u0645\u064a\u0629\u060c \u0623\u064a \u0645\u0639\u0638\u0645 \u0645\u0627 \u064a\u062d\u062a\u0627\u062c\u0647 \u0627\u0644\u0645\u0643\u062a\u0628 \u0627\u0644\u0639\u0627\u062f\u064a.<\/p>","protected":false},"author":2,"featured_media":3263,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-3262","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How Google Apps Can Save Your Time? - The Codest<\/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:\/\/thecodest.co\/ar\/\u0627\u0644\u0645\u062f\u0648\u0646\u0629\/\u062c\u062f\u0627\u0648\u0644-\u0628\u064a\u0627\u0646\u0627\u062a-\u062c\u0648\u062c\u0644-\u064a\u0645\u0643\u0646-\u0623\u0646-\u062a\u0643\u0648\u0646-\u0623\u0643\u062b\u0631-\u0630\u0643\u0627\/\" \/>\n<meta property=\"og:locale\" content=\"ar_AR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Google Apps Can Save Your Time?\" \/>\n<meta property=\"og:description\" content=\"Nowadays, cloud solutions are pushing out desktop apps dedicated to office work. One of the biggest office suites is provided by Google and includes Documents, Spreadsheets and Presentations, so the majority of what an average office needs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/thecodest.co\/ar\/\u0627\u0644\u0645\u062f\u0648\u0646\u0629\/\u062c\u062f\u0627\u0648\u0644-\u0628\u064a\u0627\u0646\u0627\u062a-\u062c\u0648\u062c\u0644-\u064a\u0645\u0643\u0646-\u0623\u0646-\u062a\u0643\u0648\u0646-\u0623\u0643\u062b\u0631-\u0630\u0643\u0627\/\" \/>\n<meta property=\"og:site_name\" content=\"The Codest\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-02T08:51:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-24T11:33:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/cover-image-79.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"thecodest\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"thecodest\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u062f\u0642\u0627\u0626\u0642\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/\"},\"author\":{\"name\":\"thecodest\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/#\\\/schema\\\/person\\\/7e3fe41dfa4f4e41a7baad4c6e0d4f76\"},\"headline\":\"How Google Apps Can Save Your Time?\",\"datePublished\":\"2020-08-02T08:51:00+00:00\",\"dateModified\":\"2026-04-24T11:33:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/\"},\"wordCount\":869,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/05\\\/cover-image-79.jpg\",\"articleSection\":[\"Software Development\"],\"inLanguage\":\"ar\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/\",\"url\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/\",\"name\":\"How Google Apps Can Save Your Time? - The Codest\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/05\\\/cover-image-79.jpg\",\"datePublished\":\"2020-08-02T08:51:00+00:00\",\"dateModified\":\"2026-04-24T11:33:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/#breadcrumb\"},\"inLanguage\":\"ar\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ar\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/#primaryimage\",\"url\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/05\\\/cover-image-79.jpg\",\"contentUrl\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/05\\\/cover-image-79.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/blog\\\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/thecodest.co\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Google Apps Can Save Your Time?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/#website\",\"url\":\"https:\\\/\\\/thecodest.co\\\/\",\"name\":\"The Codest\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/thecodest.co\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ar\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/#organization\",\"name\":\"The Codest\",\"url\":\"https:\\\/\\\/thecodest.co\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ar\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/03\\\/thecodest-logo.svg\",\"contentUrl\":\"https:\\\/\\\/thecodest.co\\\/app\\\/uploads\\\/2024\\\/03\\\/thecodest-logo.svg\",\"width\":144,\"height\":36,\"caption\":\"The Codest\"},\"image\":{\"@id\":\"https:\\\/\\\/thecodest.co\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/pl.linkedin.com\\\/company\\\/codest\",\"https:\\\/\\\/clutch.co\\\/profile\\\/codest\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/thecodest.co\\\/#\\\/schema\\\/person\\\/7e3fe41dfa4f4e41a7baad4c6e0d4f76\",\"name\":\"thecodest\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ar\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g\",\"caption\":\"thecodest\"},\"url\":\"https:\\\/\\\/thecodest.co\\\/ar\\\/author\\\/thecodest\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u0643\u064a\u0641 \u064a\u0645\u0643\u0646 \u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a Google \u062a\u0648\u0641\u064a\u0631 \u0648\u0642\u062a\u0643\u061f - The Codest","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:\/\/thecodest.co\/ar\/\u0627\u0644\u0645\u062f\u0648\u0646\u0629\/\u062c\u062f\u0627\u0648\u0644-\u0628\u064a\u0627\u0646\u0627\u062a-\u062c\u0648\u062c\u0644-\u064a\u0645\u0643\u0646-\u0623\u0646-\u062a\u0643\u0648\u0646-\u0623\u0643\u062b\u0631-\u0630\u0643\u0627\/","og_locale":"ar_AR","og_type":"article","og_title":"How Google Apps Can Save Your Time?","og_description":"Nowadays, cloud solutions are pushing out desktop apps dedicated to office work. One of the biggest office suites is provided by Google and includes Documents, Spreadsheets and Presentations, so the majority of what an average office needs.","og_url":"https:\/\/thecodest.co\/ar\/\u0627\u0644\u0645\u062f\u0648\u0646\u0629\/\u062c\u062f\u0627\u0648\u0644-\u0628\u064a\u0627\u0646\u0627\u062a-\u062c\u0648\u062c\u0644-\u064a\u0645\u0643\u0646-\u0623\u0646-\u062a\u0643\u0648\u0646-\u0623\u0643\u062b\u0631-\u0630\u0643\u0627\/","og_site_name":"The Codest","article_published_time":"2020-08-02T08:51:00+00:00","article_modified_time":"2026-04-24T11:33:05+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/cover-image-79.jpg","type":"image\/jpeg"}],"author":"thecodest","twitter_card":"summary_large_image","twitter_misc":{"Written by":"thecodest","Est. reading time":"6 \u062f\u0642\u0627\u0626\u0642"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/#article","isPartOf":{"@id":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/"},"author":{"name":"thecodest","@id":"https:\/\/thecodest.co\/#\/schema\/person\/7e3fe41dfa4f4e41a7baad4c6e0d4f76"},"headline":"How Google Apps Can Save Your Time?","datePublished":"2020-08-02T08:51:00+00:00","dateModified":"2026-04-24T11:33:05+00:00","mainEntityOfPage":{"@id":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/"},"wordCount":869,"commentCount":0,"publisher":{"@id":"https:\/\/thecodest.co\/#organization"},"image":{"@id":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/#primaryimage"},"thumbnailUrl":"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/cover-image-79.jpg","articleSection":["Software Development"],"inLanguage":"ar","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/","url":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/","name":"\u0643\u064a\u0641 \u064a\u0645\u0643\u0646 \u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a Google \u062a\u0648\u0641\u064a\u0631 \u0648\u0642\u062a\u0643\u061f - The Codest","isPartOf":{"@id":"https:\/\/thecodest.co\/#website"},"primaryImageOfPage":{"@id":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/#primaryimage"},"image":{"@id":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/#primaryimage"},"thumbnailUrl":"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/cover-image-79.jpg","datePublished":"2020-08-02T08:51:00+00:00","dateModified":"2026-04-24T11:33:05+00:00","breadcrumb":{"@id":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/#breadcrumb"},"inLanguage":"ar","potentialAction":[{"@type":"ReadAction","target":["https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/"]}]},{"@type":"ImageObject","inLanguage":"ar","@id":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/#primaryimage","url":"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/cover-image-79.jpg","contentUrl":"https:\/\/thecodest.co\/app\/uploads\/2024\/05\/cover-image-79.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/thecodest.co\/blog\/google-spreadsheets-can-be-even-smarter-let-the-google-apps-script-save-your-time\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/thecodest.co\/"},{"@type":"ListItem","position":2,"name":"How Google Apps Can Save Your Time?"}]},{"@type":"WebSite","@id":"https:\/\/thecodest.co\/#website","url":"https:\/\/thecodest.co\/","name":"The Codest","description":"","publisher":{"@id":"https:\/\/thecodest.co\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/thecodest.co\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ar"},{"@type":"Organization","@id":"https:\/\/thecodest.co\/#organization","name":"The Codest","url":"https:\/\/thecodest.co\/","logo":{"@type":"ImageObject","inLanguage":"ar","@id":"https:\/\/thecodest.co\/#\/schema\/logo\/image\/","url":"https:\/\/thecodest.co\/app\/uploads\/2024\/03\/thecodest-logo.svg","contentUrl":"https:\/\/thecodest.co\/app\/uploads\/2024\/03\/thecodest-logo.svg","width":144,"height":36,"caption":"The Codest"},"image":{"@id":"https:\/\/thecodest.co\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/pl.linkedin.com\/company\/codest","https:\/\/clutch.co\/profile\/codest"]},{"@type":"Person","@id":"https:\/\/thecodest.co\/#\/schema\/person\/7e3fe41dfa4f4e41a7baad4c6e0d4f76","name":"thecodest","image":{"@type":"ImageObject","inLanguage":"ar","@id":"https:\/\/secure.gravatar.com\/avatar\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5dbfe6a1e8c86e432e8812759e34e6fe82ebac75119ae3237a6c1311fa19caf4?s=96&d=mm&r=g","caption":"thecodest"},"url":"https:\/\/thecodest.co\/ar\/author\/thecodest\/"}]}},"_links":{"self":[{"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/posts\/3262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/comments?post=3262"}],"version-history":[{"count":6,"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/posts\/3262\/revisions"}],"predecessor-version":[{"id":8434,"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/posts\/3262\/revisions\/8434"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/media\/3263"}],"wp:attachment":[{"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/media?parent=3262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/categories?post=3262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thecodest.co\/ar\/wp-json\/wp\/v2\/tags?post=3262"}],"curies":[{"name":"\u062f\u0628\u0644\u064a\u0648 \u0628\u064a","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}