Posts
GAS Lab
- Build a Free Wikipedia-Style Wiki with Google Sheets & Apps Script
- Run Python in Google Sheets at Sub-Second Speed: Supercharging Google Apps Script with Cloud Run Sandboxes (Zero Idle Cost)
- How the October Gemini Free Tier Shift to Flash-Lite Affects GAS Developers (And How to Keep Using Pro/Flash for Free)
- Google Apps Script Data Regions GA: The Complete IT Guide
- [GAS Beginner Series #80] Delete Google Calendar Events Automatically: CalendarEvent.deleteEvent() Tutorial
- [GAS Beginner Series #79] Invite Guests Automatically to Google Calendar Events: CalendarEvent.addGuest() Tutorial
- [GAS Beginner Series #78] Get This Week’s Schedule in Bulk: List Sapporo Office Meeting Room Bookings with Calendar.getEvents()
- [GAS Beginner Series #77] Create Google Calendar Events Automatically: How to Use Calendar.createEvent() and createAllDayEvent()
- [GAS Beginner Series #76] Get Specific Google Calendars: How to Use CalendarApp.getCalendarById()
- [GAS Beginner Series #75] Convert Google Slides to PDF Automatically: How to Use Presentation.getAs(‘application/pdf’)
- [GAS Beginner Series #74] Align Shapes and Images on Google Slides: Complete Guide to PageElement.setLeft() & setTop()
- [GAS Beginner Series #73] Auto-Add Speaker Notes to Google Slides: How to Use Slide.getNotesPage()
- [GAS Beginner Series #72] Batch Process All Slides: Presentation.getSlides() and Loops (for / forEach)
- [GAS Beginner Series #71] Organize Draft Slides Automatically: Polish Reports with Slide.remove() and moveSlide()
- [GAS Beginner Series #70] Insert Images into Google Slides: Slide.insertImage() Tutorial
- [GAS Beginner Series #69] Embed Spreadsheet Charts into Slides: Complete Slide.insertSheetsChart() Guide
- [GAS Beginner Series #68] Automatically Insert Tables in Google Slides: Slide.insertTable() Guide and Practical Automation
- [GAS Beginner Series #67] Format Slide Text and Font Size: Style “120% Achievement” Dynamically with TextRange.setText() & setFontSize()
- [GAS Beginner Series #66] Add Text Boxes to Slides Freely: How to Use Slide.insertTextBox()
- [GAS Beginner Series #65] Automate Google Slides Shape Styling: Master Fill Colors and Borders with Shape.getFill() and getBorder()
- [GAS Beginner Series #64] Insert Shapes in Google Slides Automatically: How to Create Topic Cards with Slide.insertShape()
- [GAS Beginner Series #63] Duplicate Google Slides Automatically: How to Multiply Template Pages with Slide.duplicate()
- [GAS Beginner Series #62] Find and Replace Text in Google Slides: Presentation.replaceAllText() and Template Automation
- [GAS Beginner Series #61] Google Slides Automation: How to Open Presentations and Target Slides with SlidesApp.openById()
- [GAS Beginner Series #60] Convert Google Docs to PDF: How to Automate Invoice Export with Document.getAs(‘application/pdf’) and Save to Drive
- [GAS Beginner Series #59] Add Headers, Footers & Page Numbers Automatically: Document.addHeader() and addFooter() Tutorial
- [GAS Beginner Series #58] Insert Images in Google Docs Automatically: How to Use Body.appendImage()
- [GAS Beginner Series #57] Populate and Style Table Cells in Google Docs: TableCell.setText() and setBackgroundColor() Tutorial
- [GAS Beginner Series #56] Insert Tables in Google Docs Automatically: How to Create Tables with Body.appendTable() and 2D Arrays
- [GAS Beginner Series #55] Make Invoice Amounts Stand Out: How to Style Google Docs with Paragraph.setFontSize() and setForegroundColor()
- [GAS Beginner Series #54] Format Google Docs Headings Automatically: How to Use Paragraph.setHeading()
- [GAS Beginner Series #53] Append Text to Google Docs: How to Use Body.appendParagraph()
- [GAS Beginner Series #52] Replace Text in Google Docs: How to Use Body.replaceText() and Template Automation
- [GAS Beginner Series #51] Automate Google Docs: How to Use DocumentApp.openById() and Understand the Document Hierarchy (Body & Paragraph)
- [GAS Beginner Series #50] Grant Google Drive View Access Automatically: How to Use File.addViewer() and Manage Permissions
- [GAS Beginner Series #49] Direct Download from Google Drive: How to Get Direct File Links with File.getDownloadUrl()
- [GAS Beginner Series #48] Create Folders Automatically: DriveApp.createFolder() Tutorial and Google Drive Organization
- [GAS Beginner Series #47] Clean Up Files Automatically: Move Old Files to Trash with File.setTrashed()
- [GAS Beginner Series #46] Move Files Automatically in Google Drive: File.moveTo() Tutorial
- [GAS Beginner Series #45] Rename Google Drive Files with Script: How to Use File.setName()
- [GAS Beginner Series #44] Duplicate Files Automatically: How to Copy Templates with File.makeCopy()
- [GAS Beginner Series #43] Automatically List Files in a Folder: Complete Guide to Folder.getFiles() and While Loops
- [GAS Beginner Series #42] Create Files in Specific Folders: Folder.createFile() Tutorial
- [GAS Beginner Series #41] Pinpoint Google Drive Folders: How to Use DriveApp.getFolderById()
- [GAS Beginner Series #40] Automatically Add Notes to Cells: How to Use Range.setNote() for Email Logging
- [GAS Beginner Series #39] Check Your Daily Email Limit: MailApp.getRemainingDailyQuota() Tutorial and Quota Error Prevention
- [GAS Beginner Series #38] Organize Gmail Automatically: How to Apply Labels with GmailThread.addLabel()
- [GAS Beginner Series #37] Mark Processed Emails as Read Automatically: GmailMessage.markRead() Tutorial
- [GAS Beginner Series #36] Extract Email Attachments Automatically: How to Use GmailMessage.getAttachments()
- [GAS Beginner Series #35] Extract Email Subject & Body: Complete Guide to GmailMessage.getSubject() and getBody()
- [GAS Beginner Series #34] Get All Emails in a Thread: How to Use GmailThread.getMessages() and Handle Arrays
- [GAS Beginner Series #33] Search Gmail Automatically: How to Use GmailApp.search() & Search Queries
- [GAS Beginner Series #32] Send HTML Formatted Business Trip Reports Automatically: How to Use GmailApp.sendEmail() with CC and BCC
- [GAS Beginner Series #31] Create HTML Business Trip Report Drafts in Gmail: GmailApp.createDraft() Tutorial
- [GAS Beginner Series #30] Prevent Script Crashes: Master try…catch Error Handling in Google Apps Script
- [GAS Beginner Series #29] Format Dates and Times Easily: How to Use Utilities.formatDate() and Format Patterns
- [GAS Beginner Series #28] Build Custom Sidebars in Google Sheets: Ui.showSidebar() Complete Guide
- [GAS Beginner Series #27] Display Custom HTML Dialogs in Google Sheets: How to Use Ui.showModalDialog()
- [GAS Beginner Series #26] Prompt User Input: How to Use Ui.prompt(), Retrieve Input Values, and Handle Conditional Branching
- [GAS Beginner Series #25] Display Popup Messages: Create Yes/No Confirmation Dialogs with Ui.alert()
- [GAS Beginner Series #24] Prepare Dialogs and Custom Menus: How to Use SpreadsheetApp.getUi()
- [GAS Beginner Series #23] Manage Triggers Programmatically: How to Use ScriptApp.newTrigger() and ScriptApp.deleteTrigger()
- [GAS Beginner Series #22] Trigger Scripts on Cell Edits: How to Use onEdit(e) & Event Objects
- [GAS Beginner Series #21] Automate on File Open: How to Use onOpen(e) and Create Custom Menus
- [GAS Beginner Series #20] Automate Google Sheets Data Sorting: How to Use Range.sort()
- [GAS Beginner Series #19] Delete Entire Rows: How to Use Sheet.deleteRow() and Avoid Multiple Row Pitfalls
- [GAS Beginner Series #18] Insert Rows at the Top of Google Sheets: How to Use Sheet.insertRowBefore()
- [GAS Beginner Series #17] Master String Manipulation: How to Use String.split() and String.replace()
- [GAS Beginner Series #16] Bulk Transform Array Data: Complete Guide to Array.map() and 2D Arrays
- [GAS Beginner Series #15] Filter Specific Data by Conditions: How to Use Array.filter() and Filter 2D Arrays in Google Apps Script
- [GAS Beginner Series #14] Bulk Write to Multiple Cells: Supercharge Google Sheets with Range.setValues()
- [GAS Beginner Series #13] Get All Spreadsheet Data at Once: Range.getValues() and 2D Arrays Explained
- [GAS Beginner Series #12] Detect Table Width Automatically: How to Use Sheet.getLastColumn()
- [GAS Beginner Series #11] Find the Last Row Automatically: How to Use Sheet.getLastRow()
- [GAS Beginner Series #10] Make Google Sheets Text Bold Automatically: How to Use Range.setFontWeight()
- [GAS Beginner Series #9] Change Cell Background Color in Google Sheets: Range.setBackground() Tutorial
- [GAS Beginner Series #8] Clear Cell Data Only: Range.clearContent() Tutorial & How It Differs from clear()
- [GAS Beginner Series #7] Automatically Append Data to the Bottom of Your Sheet: Complete Guide to Sheet.appendRow()
- [GAS Beginner Series #6] Automatically Write Text and Numbers to Specific Cells! How to Use Range.setValue()
- [GAS Beginner Series #5] Read Cell Text and Numbers with Code! How to Use Range.getValue() and Common Pitfalls
- [GAS Beginner Series #4] Pinpoint Specific Cells! Master Sheet.getRange() to Select Cells & Ranges
- [GAS Beginner Series #3] Target Your Open Sheet: Select the “Chuo Ward Area” Tab with Spreadsheet.getActiveSheet()
- [GAS Beginner Series #2] Your First Step: Access Google Sheets with SpreadsheetApp.getActiveSpreadsheet()
- [GAS Beginner Series #1] Output Your First Message: How to Use Logger.log()
Hokkaido Local
- Comparing Hokkaido Corned Beef for Furusato Nozei & Building a Slack Expiration Tracker with GAS
- Hokkaido Salmon for Furusato Nozei: Eastern vs. Central vs. Southern Regions
- Hokkaido Blueberries for Furusato Nozei: Comparing Shiribeshi, Central Hokkaido, and Furano-Tokachi
- Hokkaido Roast Beef for Furusato Nozei: Tokachi vs. Central Hokkaido vs. Iburi-Hidaka
- Hokkaido Crab for Furusato Nozei: Nemuro vs. Okhotsk vs. Soya
- Hokkaido Sweet Corn for Furusato Nozei: 3 Regions Compared + a GAS Tracker
- How to Pick Craft Butter for Furusato Nozei: 5 Hokkaido Favorites Compared by Method
- Hokkaido Uni for Furusato Nozei: North, East, or South?
- Hokkaido Kazunoko Showdown: Comparing 4 Regions for Furusato Nozei
- Cold-Climate Heat Pump vs. Kerosene vs. City Gas: Winter Heating Cost & Efficiency Battle in Hokkaido
- ANA to Acquire AIRDO: Why Hokkaido Locals Are Furious & What It Means for Travelers
- [2026 Latest] Hokkaido Tarako Showdown: 3 Major Regions Compared & Top 6 Furusato Nozei Picks
- What Changes with ANA’s SFC Policy Re-Revision? A Realistic Survival Strategy for a JAL-Leaning “Purple Team” Engineer Flying New Chitose–Haneda Twice a Month
- [2026 Latest] Explore Summer Hokkaido by Train! Complete “JR Hokkaido Rail Pass” Guide: How to Use, Cost-Saving Itineraries & Best Deals
- [2026 Latest] JAL vs ANA Domestic Flight Comparison: Comfort, Wi-Fi & Haneda Access
- [2026 Edition] The Complete Guide to New Chitose Airport Domestic Lounges
Sapporo Local
- Signs of Winter in Sapporo: Nakajima Park’s Upcoming Lights and ENESS Exhibition
- The Complete Sapporo Underground Walkway Guide: How to Walk from Sapporo Station to Susukino Indoors
- How to Survive Yukimushi: The Ultimate Snow Bug Guide for Sapporo in Autumn
- The Ultimate Sapporo Sushi Guide: 6 Budget Zones from ¥100 Conveyor Belts to Michelin Omakase
- [2026 Latest] Top 5 Next-Break Sapporo Souvenirs! “New Classics” & Real Buying Hacks Selected by a Sapporo Engineer
- Sapporo vs. Tokyo Nail Art Trends: Salon Usage Rates, “Non-Sanding” Gel Nails & Winter Care Secrets
- [2026 Latest] Top 4 Marriott Hotels Near Sapporo: Tackling the “Marriott Drought” & Best Stays by Travel Style
- [2026 Latest] 5 Must-Buy Classic Sapporo Souvenirs You Can’t Go Wrong With: Recommended by a Local Engineer
- [Sapporo Hidden Gem] 9-Min Walk from Sapporo Station! The Ultimate Peaceful Digital Detox at Historic “Seikatei”
- Where to Live in Sapporo: Best Neighborhoods Within 30 Mins of Sapporo Station
- How to Buy & Use Teigaku Kogawase in Japan: Complete Guide to Fees, Manners, and Official Requests
- How to Get from Sapporo to New Chitose Airport When JR Trains Are Suspended: Winter Alternative Guide