{"id":17115,"date":"2025-01-11T11:42:11","date_gmt":"2025-01-11T02:42:11","guid":{"rendered":"https:\/\/84office.jp\/?p=17115"},"modified":"2025-01-11T11:42:12","modified_gmt":"2025-01-11T02:42:12","slug":"googlesheets-time-stamp","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/googlesheets-time-stamp\/","title":{"rendered":"How to Insert Timestamps in Google Sheets and Practical Use Cases"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"\"><\/div>\n<p>Have you ever found yourself wondering, &#8220;When was this data entered?&#8221; or needing to track records of email sending or file deletion in your Google Sheets?<\/p>\n\n\n\n<p>Using timestamps can simplify your workflow by keeping a clear record of your activities, making it easier to track progress and monitor actions.<\/p>\n\n\n\n<p>In this article, we\u2019ll introduce how to insert timestamps in Google Sheets and explore practical use cases to help streamline your work.<\/p>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">Practical Use Cases for Timestamps<\/h2>\n\n\n\n<ul class=\"wp-block-list has-border -border02 u-mb-ctrl u-mb-40 has-swl-pale-03-background-color has-background\">\n<li><strong><strong>Recording Data Entry<\/strong><\/strong><\/li>\n\n\n\n<li><strong><strong>Tracking Progress in Approval Workflows<\/strong><\/strong><\/li>\n\n\n\n<li><strong><strong>Managing Attendance and Work Hours<\/strong><\/strong><\/li>\n\n\n\n<li><strong><strong>Addressing Errors or Troubleshooting Issues<\/strong><\/strong><\/li>\n<\/ul>\n\n\n\n<p>By using timestamps, you can maintain a clear activity history, making it easier to monitor the progress of tasks and manage your workflow efficiently.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Recording when data is entered or modified provides better clarity on the workflow, enabling more informed and timely decision-making.<\/p>\n\n\n\n<dl class=\"swell-block-dl\">\n<dt class=\"swell-block-dl__dt\"><strong>Recording Data Entry<\/strong><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>By logging the exact time of data entry, you can easily track who entered what information and when. This facilitates smoother progress management of tasks.<\/p>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong>Tracking Progress in Approval Workflows<\/strong><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>In approval processes, recording timestamps at each step of the workflow makes it easier to monitor the progress and identify how far along the process is.<\/p>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong>Managing Attendance and Work Hours<\/strong><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>Timestamps can be used to accurately log employee check-in and check-out times, enabling straightforward and efficient attendance management.<\/p>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong>Addressing Errors or Troubleshooting Issues<\/strong><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>When errors occur, recording timestamps provides valuable information that can aid in identifying and resolving problems effectively.<\/p>\n<\/dd>\n<\/dl>\n\n\n\n<h2 class=\"wp-block-heading\">Three Ways to Insert Timestamps<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><strong>Method 1: Manually Inserting Timestamps<\/strong><\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"408\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/74b0387420f99622d06c2721f8ff1bf4-1024x408.png\" alt=\"\" class=\"wp-image-16304\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/74b0387420f99622d06c2721f8ff1bf4-1024x408.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/74b0387420f99622d06c2721f8ff1bf4-300x120.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/74b0387420f99622d06c2721f8ff1bf4-768x306.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/74b0387420f99622d06c2721f8ff1bf4.png 1272w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-border -border02 u-mb-ctrl u-mb-50 has-swl-pale-03-background-color has-background\">Using keyboard shortcuts:<br>For Date: <strong><code>Ctrl<\/code> +<code>;<\/code><\/strong><br>For Time: <strong><code>Ctrl<\/code> + <code>Shift<\/code> <strong> + <\/strong> <code>;<\/code><\/strong><\/p>\n\n\n\n<p>Using keyboard shortcuts is convenient when you want to manually record a timestamp at a specific moment, such as for logging check-in and check-out times.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Methods 2 &amp; 3: Automatically Adding Timestamps (Using Google Apps Script)<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading u-mb-ctrl u-mb-30\"><strong>Method 2: Automatically Inputting Timestamps When a Cell is Edited<\/strong><\/h4>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"432\" height=\"122\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-153.png\" alt=\"\" class=\"wp-image-16305\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-153.png 432w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-153-300x85.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/figure>\n<\/div>\n\n\n<p>You can use Google Apps Script (GAS) to automate the insertion of timestamps. By leveraging the <code>onEdit<\/code> trigger, a timestamp is automatically added whenever a cell is edited.<\/p>\n\n\n\n<p>For example, the following script records a timestamp in column C whenever there is an entry in column B:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"function onEdit(e) {\n  var sheet = e.source.getActiveSheet();\n  var range = e.range;\n  if (range.getColumn() == 2) { \/\/ Checks if column B is edited\n    sheet.getRange(range.getRow(), 3).setValue(new Date()); \/\/ Adds timestamp in column C\n  }\n}\n\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #66D9EF; font-style: italic\">function<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">onEdit<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #FD971F; font-style: italic\">e<\/span><span style=\"color: #F8F8F2\">) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> sheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> e.source.<\/span><span style=\"color: #A6E22E\">getActiveSheet<\/span><span style=\"color: #F8F8F2\">();<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> range <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> e.range;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (range.<\/span><span style=\"color: #A6E22E\">getColumn<\/span><span style=\"color: #F8F8F2\">() <\/span><span style=\"color: #F92672\">==<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">2<\/span><span style=\"color: #F8F8F2\">) { <\/span><span style=\"color: #88846F\">\/\/ Checks if column B is edited<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    sheet.<\/span><span style=\"color: #A6E22E\">getRange<\/span><span style=\"color: #F8F8F2\">(range.<\/span><span style=\"color: #A6E22E\">getRow<\/span><span style=\"color: #F8F8F2\">(), <\/span><span style=\"color: #AE81FF\">3<\/span><span style=\"color: #F8F8F2\">).<\/span><span style=\"color: #A6E22E\">setValue<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #F92672\">new<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">Date<\/span><span style=\"color: #F8F8F2\">()); <\/span><span style=\"color: #88846F\">\/\/ Adds timestamp in column C<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">}<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"swell-block-accordion u-mb-ctrl u-mb-30\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Script Description<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<dl class=\"swell-block-dl\">\n<dt class=\"swell-block-dl__dt\"><strong>onEdit(e)<\/strong> function:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>This function is triggered automatically whenever a cell is edited in the sheet, thanks to the <code>onEdit<\/code> trigger.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong><code>e.source.getActiveSheet()<\/code><\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Retrieves the sheet where the edit occurred.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong><code>e.range<\/code><\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Captures the range of the edited cell (including its row and column).<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong><code>if (range.getColumn() === 2)<\/code><\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Ensures that the subsequent actions are executed only when a cell in column B is edited. This line checks if the edited cell belongs to column B.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong><code>timestampCell.setValue(new Date())<\/code><\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Records the current date and time as a timestamp in column C.<\/li>\n<\/ul>\n<\/dd>\n<\/dl>\n<\/div><\/details>\n<\/div>\n\n\n\n<div class=\"swell-block-accordion u-mb-ctrl u-mb-40\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">How to Run the Script<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<p class=\"u-mb-ctrl u-mb-30\">Since <code>onEdit<\/code> is an automatically triggered function, you don\u2019t need to manually execute the Google Apps Script after saving it. It will run automatically whenever a cell is edited.<\/p>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-40\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Open Apps Script Editor<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"933\" height=\"591\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d.png\" alt=\"\" class=\"wp-image-16537\" style=\"width:447px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d.png 933w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d-300x190.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d-768x486.png 768w\" sizes=\"(max-width: 933px) 100vw, 933px\" \/><\/figure>\n<\/div>\n\n\n<p>Open a Google Spreadsheet and click on \u201c<strong>Extensions<\/strong>\u201d in the menu, then \u201c<strong>Apps Script<\/strong>\u201d to open the Apps Script editor.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Create the Script<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"472\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-1024x472.png\" alt=\"\" class=\"wp-image-16191\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-1024x472.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-300x138.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-768x354.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662.png 1387w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Since the default <code>function myFunction() {}<\/code> is present, delete it and replace it with the script above.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Save the Script<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"400\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/1a46f346dd002424353351955a3bf90a-1024x400.png\" alt=\"\" class=\"wp-image-17116\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/1a46f346dd002424353351955a3bf90a-1024x400.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/1a46f346dd002424353351955a3bf90a-300x117.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/1a46f346dd002424353351955a3bf90a-768x300.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/1a46f346dd002424353351955a3bf90a-1536x600.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/1a46f346dd002424353351955a3bf90a.png 1545w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>After writing the script, save it with a descriptive name.<\/p>\n\n\n\n<p><em>(Example: &#8220;Timestamp (On Edit)&#8221;)<\/em><\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Data Entry and Timestamp Addition in the Spreadsheet<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"432\" height=\"122\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-153.png\" alt=\"\" class=\"wp-image-16305\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-153.png 432w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-153-300x85.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/figure>\n<\/div>\n\n\n<p>When you return to your spreadsheet, a timestamp will automatically be inserted into column C every time column B is edited.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div><\/details>\n<\/div>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">Since the timestamp is recorded simultaneously with the edit, this helps prevent any oversights in your workflow.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Method 3: Inserting Timestamps by Running Google Apps Script<\/h4>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-30\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"386\" height=\"231\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-154.png\" alt=\"\" class=\"wp-image-16309\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-154.png 386w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-154-300x180.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/figure>\n<\/div>\n\n\n<p>You can also run a Google Apps Script to insert timestamps for a specific range.<\/p>\n\n\n\n<p>For example, after entering data in column A, running the script will insert timestamps in column B.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"function addTimestamp() {\n  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1'); \/\/ Access the sheet named 'Sheet1'\n  const range = sheet.getRange('A2:A10'); \/\/ Define the range A2 to A10\n  const values = range.getValues(); \/\/ Retrieve the values in the range\n\n  for (let i = 0; i &lt; values.length; i++) {\n    if (values[i][0] !== '') { \/\/ Check if the cell in column A is not empty\n      sheet.getRange(i + 2, 2).setValue(new Date()); \/\/ Insert the current timestamp in column B\n    }\n  }\n}\n\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #66D9EF; font-style: italic\">function<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">addTimestamp<\/span><span style=\"color: #F8F8F2\">() {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> sheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> SpreadsheetApp.<\/span><span style=\"color: #A6E22E\">getActiveSpreadsheet<\/span><span style=\"color: #F8F8F2\">().<\/span><span style=\"color: #A6E22E\">getSheetByName<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&#39;Sheet1&#39;<\/span><span style=\"color: #F8F8F2\">); <\/span><span style=\"color: #88846F\">\/\/ Access the sheet named &#39;Sheet1&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> range <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> sheet.<\/span><span style=\"color: #A6E22E\">getRange<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&#39;A2:A10&#39;<\/span><span style=\"color: #F8F8F2\">); <\/span><span style=\"color: #88846F\">\/\/ Define the range A2 to A10<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> values <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> range.<\/span><span style=\"color: #A6E22E\">getValues<\/span><span style=\"color: #F8F8F2\">(); <\/span><span style=\"color: #88846F\">\/\/ Retrieve the values in the range<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #F92672\">for<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF; font-style: italic\">let<\/span><span style=\"color: #F8F8F2\"> i <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">; i <\/span><span style=\"color: #F92672\">&lt;<\/span><span style=\"color: #F8F8F2\"> values.length; i<\/span><span style=\"color: #F92672\">++<\/span><span style=\"color: #F8F8F2\">) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (values[i][<\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">] <\/span><span style=\"color: #F92672\">!==<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&#39;&#39;<\/span><span style=\"color: #F8F8F2\">) { <\/span><span style=\"color: #88846F\">\/\/ Check if the cell in column A is not empty<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      sheet.<\/span><span style=\"color: #A6E22E\">getRange<\/span><span style=\"color: #F8F8F2\">(i <\/span><span style=\"color: #F92672\">+<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">2<\/span><span style=\"color: #F8F8F2\">, <\/span><span style=\"color: #AE81FF\">2<\/span><span style=\"color: #F8F8F2\">).<\/span><span style=\"color: #A6E22E\">setValue<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #F92672\">new<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">Date<\/span><span style=\"color: #F8F8F2\">()); <\/span><span style=\"color: #88846F\">\/\/ Insert the current timestamp in column B<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">}<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"swell-block-accordion\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Script Description<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<dl class=\"swell-block-dl\">\n<dt class=\"swell-block-dl__dt\"><strong><code>getSheetByName('Sheet1')<\/code><\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Retrieves a specific sheet named &#8216;Sheet1&#8217; from the active spreadsheet.<\/li>\n\n\n\n<li>If your sheet has a different name, you need to replace <code>'Sheet1'<\/code> with the correct name.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong><code>sheet.getRange('A1:A')<\/code><\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Selects the entire range of column A in the sheet named <code>'Sheet1'<\/code>.<\/li>\n\n\n\n<li>This range is used to process all the data entered in column A.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong><code>values = range.getValues()<\/code><\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Fetches all the values in column A and stores them as a two-dimensional array.<\/li>\n\n\n\n<li>Each cell&#8217;s content is stored as an element of the array, which is then used in the loop.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong><code>for<\/code><\/strong>loop:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>Iterates through all the cells in column A to perform specific actions.<\/p>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong><code>if (values[i][0] !== '')<\/code><\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Executes the subsequent actions only if the cell in column A contains data.<\/li>\n\n\n\n<li>This ensures that timestamps are not added to empty cells.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong><code>sheet.getRange(i + 1, 2).setValue(new Date())<\/code><\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Inserts the current date and time as a timestamp into column B.<\/li>\n\n\n\n<li>The <code>i + 1<\/code> adjustment ensures that the correct row in column B corresponds to the row in column A being processed (since arrays in JavaScript are zero-indexed).<\/li>\n<\/ul>\n<\/dd>\n<\/dl>\n\n\n\n\n<\/div><\/details>\n<\/div>\n\n\n\n<div class=\"swell-block-accordion u-mb-ctrl u-mb-40\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">How to Run the Script<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<div class=\"swell-block-step\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Enter Data in the Spreadsheet<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"387\" height=\"251\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-156.png\" alt=\"\" class=\"wp-image-16315\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-156.png 387w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-156-300x195.png 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/figure>\n<\/div>\n\n\n<p>Input data into column A of the spreadsheet.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Open Apps Script Editor<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"933\" height=\"591\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d.png\" alt=\"\" class=\"wp-image-16537\" style=\"width:447px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d.png 933w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d-300x190.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d-768x486.png 768w\" sizes=\"(max-width: 933px) 100vw, 933px\" \/><\/figure>\n<\/div>\n\n\n<p>Open a Google Spreadsheet and click on \u201c<strong>Extensions<\/strong>\u201d in the menu, then \u201c<strong>Apps Script<\/strong>\u201d to open the Apps Script editor.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Create the Script<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"472\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-1024x472.png\" alt=\"\" class=\"wp-image-16191\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-1024x472.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-300x138.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-768x354.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662.png 1387w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Since the default <code>function myFunction() {}<\/code> is present, delete it and replace it with the script above.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Save the Script<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"409\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-1024x409.png\" alt=\"\" class=\"wp-image-17117\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-1024x409.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-300x120.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-768x307.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-1536x613.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b.png 1578w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>After writing the script, save it with a descriptive name.<\/p>\n\n\n\n<p><em>(Example: &#8220;Timestamp (On Script Execution)&#8221;)<\/em><\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Run the Script<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"409\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-1-1024x409.png\" alt=\"\" class=\"wp-image-17118\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-1-1024x409.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-1-300x120.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-1-768x307.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-1-1536x613.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/bcd07f7dfb56d40373b36daf4642d62b-1.png 1578w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>When you execute the script, timestamps will be added to column B.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Timestamps Added to the Spreadsheet<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-30\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"386\" height=\"231\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-154.png\" alt=\"\" class=\"wp-image-16309\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-154.png 386w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-154-300x180.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/figure>\n<\/div>\n\n\n<p>Timestamps will be added to column B for the corresponding cells with data in column A.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div><\/details>\n<\/div>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">This method is useful for bulk-inserting timestamps into a specific range.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Practical Use Case for Timestamps<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Adding Timestamps When Sending Emails with Apps Script<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"314\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-85-1024x314.png\" alt=\"\" class=\"wp-image-15980\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-85-1024x314.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-85-300x92.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-85-768x236.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-85-1536x471.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-85.png 1862w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30\">Using Google Apps Script, you can automate email sending and add timestamps after each email is sent. This allows you to keep a record of your email history, preventing duplicate sends and making it easy to track who received an email and when.<\/p>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-60\">\t\t\t<div class=\"p-blogCard -external\" data-type=\"type3\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u5408\u540c\u4f1a\u793e\u6a4b\u722a\u30aa\u30d5\u30a3\u30b9<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img decoding=\"async\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/1d36b191b935e2fb6a033cb4e78d867a.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/84office.jp\/en\/gas\uff70send-email\/\">Boost Productivity: Automate Gmail to Multiple Recipients with Google Sheets and Apps Script | \u5408\u540c&#8230;<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">Recommended for For those who find sending Gmail each time to be cumbersome For those who want to send emails to multipl<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n<h4 class=\"wp-block-heading\">Adding Timestamps When Bulk Deleting Files with Apps Script<\/h4>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"630\" height=\"266\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-32.png\" alt=\"\" class=\"wp-image-15766\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-32.png 630w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-32-300x127.png 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-30\">Using Google Apps Script, you can automate bulk file deletion and add timestamps after each file is deleted. This creates a deletion history, making it easy to track which files were deleted and when, simplifying file management.<\/p>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-60\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img decoding=\"async\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/00dff6888325c5ce6839aae1fd5ca3fb-300x158.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/84office.jp\/bulk-deletion-gas-files\/\">GAS\u3092\u4f7f\u3063\u305fGoogle\u30c9\u30e9\u30a4\u30d6\u5185\u306e\u30d5\u30a1\u30a4\u30eb\u4e00\u62ec\u524a\u9664\uff5c\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u6d3b\u7528\u3057\u305f\u30c9\u30e9\u30a4\u30d6\u6574\u7406<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">\u3053\u308c\u307e\u3067\u306b\u3001GAS\u3092\u4f7f\u3063\u305f\u30a2\u30af\u30bb\u30b9\u6a29\u9650\u306e\u5909\u66f4\u3084\u30d5\u30a9\u30eb\u30c0\u5185\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4e00\u62ec\u30b3\u30d4\u30fc\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u3066\u304d\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u306fGoogle\u30c9\u30e9\u30a4\u30d6\u5185\u306e\u30d5\u30a1\u30a4\u30eb\u4e00\u62ec\u524a\u9664\u3092\u3054\u7d39\u4ecb\u3057&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n<h4 class=\"wp-block-heading\">Adding Timestamps When Changing File Permissions<\/h4>\n\n\n\n<figure class=\"wp-block-image size-full is-resized u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"909\" height=\"265\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-24.png\" alt=\"\" class=\"wp-image-15741\" style=\"width:852px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-24.png 909w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-24-300x87.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-24-768x224.png 768w\" sizes=\"(max-width: 909px) 100vw, 909px\" \/><\/figure>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"870\" height=\"246\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-25.png\" alt=\"\" class=\"wp-image-15744\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-25.png 870w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-25-300x85.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-25-768x217.png 768w\" sizes=\"(max-width: 870px) 100vw, 870px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-60\">With Google Apps Script, you can use timestamps when bulk-changing file permissions directly from a spreadsheet. This helps you track when permissions were updated, ensuring proper and organized file access management.<\/p>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-40\">Conclusion<\/h2>\n\n\n\n<p>Timestamps are a powerful tool for recording data entry times and managing task history or progress tracking. From manual entry to automated solutions, there are various methods to choose from based on your workflow needs.<\/p>\n\n\n\n<p>By incorporating timestamps, you can achieve more efficient management and organization in your Google Sheets.<\/p>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-30\"><\/div>\n\n<div class=\"p-postListWrap u-mb-ctrl u-mb-30\"><ul class=\"p-postList -type-simple\"><li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/google-calendar-free-time-template\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-07-25\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e747\u670825\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">Google Calendar Free Time Finder Template\uff5cGoogle Sheets \u00d7 Apps Script<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/google-calendar-free-time-extraction\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-07-24\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e747\u670824\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">How to Find Common Free Time in Google Calendar: Manage Shared Schedules with Google Apps Script<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/google-calendar-to-sheet-template\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-07-23\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e747\u670823\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">Ready-to-Use Google Calendar to Sheets Export Template| Google Sheets &amp; Apps Script<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<\/ul><\/div>\n\n\n<p class=\"is-style-emboss_box has-swl-pale-02-background-color has-background\">Our company offers support for improving work efficiency through the use of Google Apps Script. <br>If you need assistance with Google Apps Script customization or error resolution, please feel free to contact us. <br>We are fully committed to supporting your business improvements.<br><br><a href=\"https:\/\/84office.jp\/contact\/\">Contact us here<br><\/a><\/p>\n\n\n\n<script src=\"https:\/\/codoc.jp\/js\/cms.js\" data-css=\"rainbow\" data-usercode=\"pQLZofrBiA\" charset=\"UTF-8\" defer><\/script>\n <div id=\"codoc-entry-9lNr9PuMXQ\" class=\"codoc-entries\" data-without-body=\"1\" data-support-button-text=\"Support with a Tip\" data-support-message=\"We will keep offering tools and information to boost work efficiency. Your support helps us provide even better content.\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever found yourself wondering, &#8220;When was this data entered?&#8221; or needing to track records  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17120,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=16303","footnotes":""},"categories":[12],"tags":[],"class_list":["post-17115","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=17115"}],"version-history":[{"count":1,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17115\/revisions"}],"predecessor-version":[{"id":17119,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17115\/revisions\/17119"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/17120"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=17115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=17115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=17115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}