Use my Bingo Add-on to create individual Bingo sheets for each of your students.
alicekeeler.com/codedbyalice
#EduSky #googleEDU #googleSheets #appsScript
alicekeeler.com/codedbyalice
#EduSky #googleEDU #googleSheets #appsScript
March 16, 2024 at 1:46 PM
Use my Bingo Add-on to create individual Bingo sheets for each of your students.
alicekeeler.com/codedbyalice
#EduSky #googleEDU #googleSheets #appsScript
alicekeeler.com/codedbyalice
#EduSky #googleEDU #googleSheets #appsScript
What is Google Apps Script?
A low code way to extend the capabilities of Google Docs, Sheets, Slides, etc...
And now you can have AI write it for you!
#GoogleEDU #AppsScript #GoogleWorkspace
#ISTElive
#ISTE #ISTE25 #ISTElive25 #EduSky
A low code way to extend the capabilities of Google Docs, Sheets, Slides, etc...
And now you can have AI write it for you!
#GoogleEDU #AppsScript #GoogleWorkspace
#ISTElive
#ISTE #ISTE25 #ISTElive25 #EduSky
June 24, 2025 at 8:37 PM
What is Google Apps Script?
A low code way to extend the capabilities of Google Docs, Sheets, Slides, etc...
And now you can have AI write it for you!
#GoogleEDU #AppsScript #GoogleWorkspace
#ISTElive
#ISTE #ISTE25 #ISTElive25 #EduSky
A low code way to extend the capabilities of Google Docs, Sheets, Slides, etc...
And now you can have AI write it for you!
#GoogleEDU #AppsScript #GoogleWorkspace
#ISTElive
#ISTE #ISTE25 #ISTElive25 #EduSky
I have done the same with AI and AppsScript. Here are some resources and examples - bit.ly/curts-aicode
#EduSkyChat
#EduSkyChat
PD Agenda - Coding with AI for Schools
Coding with AI for Schools Session Agenda - bit.ly/curts-aicode 🧔 Presenter Eric Curts Technology Integration Specialist, Google Certified Trainer and Innovator 💡 Eric’s EdTech blog - controlaltac...
bit.ly
November 19, 2024 at 2:22 AM
I have done the same with AI and AppsScript. Here are some resources and examples - bit.ly/curts-aicode
#EduSkyChat
#EduSkyChat
Yesterday, I presented the "dark GCP Cloud" behind my Google Sheets apps, #PiwikPro Manager and #AdobeAnalytics Component Manager, at the #analytics.dev Conference in Copenhagen. Lots of Pub/Sub, Cloud Run Functions, Firestore and as little #AppsScript as possible...
April 30, 2026 at 9:23 AM
Yesterday, I presented the "dark GCP Cloud" behind my Google Sheets apps, #PiwikPro Manager and #AdobeAnalytics Component Manager, at the #analytics.dev Conference in Copenhagen. Lots of Pub/Sub, Cloud Run Functions, Firestore and as little #AppsScript as possible...
子供の語彙力向上のため、イラスト付きの「今日の単語」を表示してくれるTRMNLのプライベートプラグインを書いた。英語と日本語（ひらがな）を両方表示してくれる。画像はGeminiで生成。データはGoogle SpreadsheetにおいてAppsScriptで動作。画像データはGoogle Storageにアップロード保存している。
January 30, 2026 at 7:04 AM
子供の語彙力向上のため、イラスト付きの「今日の単語」を表示してくれるTRMNLのプライベートプラグインを書いた。英語と日本語（ひらがな）を両方表示してくれる。画像はGeminiで生成。データはGoogle SpreadsheetにおいてAppsScriptで動作。画像データはGoogle Storageにアップロード保存している。
⚗️ Exploring @notion.com's new webhook automations and
#AppsScript doPost triggers to initiate actions in Google Workspace. Example: Creating Calendar events from Notion database pages. Promising!
#AppsScript doPost triggers to initiate actions in Google Workspace. Example: Creating Calendar events from Notion database pages. Promising!
December 5, 2024 at 10:34 PM
⚗️ Exploring @notion.com's new webhook automations and
#AppsScript doPost triggers to initiate actions in Google Workspace. Example: Creating Calendar events from Notion database pages. Promising!
#AppsScript doPost triggers to initiate actions in Google Workspace. Example: Creating Calendar events from Notion database pages. Promising!
i've redone the logic for charadex's appsscript 100 times but finally i think i've overcome all obstacles
i want to have the beta sheet out this month, with or without documentation lol and then the actual website template the following month argargarg
i want to have the beta sheet out this month, with or without documentation lol and then the actual website template the following month argargarg
January 13, 2026 at 10:00 PM
i've redone the logic for charadex's appsscript 100 times but finally i think i've overcome all obstacles
i want to have the beta sheet out this month, with or without documentation lol and then the actual website template the following month argargarg
i want to have the beta sheet out this month, with or without documentation lol and then the actual website template the following month argargarg
SaaSの死と言う情報に踊らされてこれからはAIで内製だ！と勢いよく意思決定した経営者が、よくわからんままよくわからない社内の人にAI使って作らせたAppsScriptなどでリプレイスされた業務が壊れて誰もメンテできなくなって盛大に事故る世界! 世界!! 世界!! (会心の一撃的メロディで)
February 10, 2026 at 2:37 AM
SaaSの死と言う情報に踊らされてこれからはAIで内製だ！と勢いよく意思決定した経営者が、よくわからんままよくわからない社内の人にAI使って作らせたAppsScriptなどでリプレイスされた業務が壊れて誰もメンテできなくなって盛大に事故る世界! 世界!! 世界!! (会心の一撃的メロディで)
公式情報を垂れ流す部分を真っ先に移植してるんだけどたぶんそろそろ終わる
終わったら……github で history 管理されて TypeScript で書かれた AppsScript が……稼働する……！
なんて平和な世界🕊️
AppsScript GUI なんてXXXXXXまえ！🤬🤬🤬自主規制
終わったら……github で history 管理されて TypeScript で書かれた AppsScript が……稼働する……！
なんて平和な世界🕊️
AppsScript GUI なんてXXXXXXまえ！🤬🤬🤬自主規制
December 4, 2024 at 11:30 AM
公式情報を垂れ流す部分を真っ先に移植してるんだけどたぶんそろそろ終わる
終わったら……github で history 管理されて TypeScript で書かれた AppsScript が……稼働する……！
なんて平和な世界🕊️
AppsScript GUI なんてXXXXXXまえ！🤬🤬🤬自主規制
終わったら……github で history 管理されて TypeScript で書かれた AppsScript が……稼働する……！
なんて平和な世界🕊️
AppsScript GUI なんてXXXXXXまえ！🤬🤬🤬自主規制
"Highlight every row where the amount is over 1000."
const sh = SpreadsheetApp.getActive().getActiveSheet();
sh.getDataRange().getValues().forEach((r, i) => {
if (r[2] > 1000) sh.getRange(i+1, 1, 1, r.length).setBackground("#fde68a");
});
One pass, every matching row flagged. #AppsScript
const sh = SpreadsheetApp.getActive().getActiveSheet();
sh.getDataRange().getValues().forEach((r, i) => {
if (r[2] > 1000) sh.getRange(i+1, 1, 1, r.length).setBackground("#fde68a");
});
One pass, every matching row flagged. #AppsScript
July 18, 2026 at 6:16 PM
"Highlight every row where the amount is over 1000."
const sh = SpreadsheetApp.getActive().getActiveSheet();
sh.getDataRange().getValues().forEach((r, i) => {
if (r[2] > 1000) sh.getRange(i+1, 1, 1, r.length).setBackground("#fde68a");
});
One pass, every matching row flagged. #AppsScript
const sh = SpreadsheetApp.getActive().getActiveSheet();
sh.getDataRange().getValues().forEach((r, i) => {
if (r[2] > 1000) sh.getRange(i+1, 1, 1, r.length).setBackground("#fde68a");
});
One pass, every matching row flagged. #AppsScript
TIL (the hard way) that Gemini works 1000x better with Google AppsScript than Claude, if only because it avoids syntax errors out the wazoo.
Claude has been great with raw Python though.
Claude has been great with raw Python though.
August 5, 2025 at 9:39 PM
TIL (the hard way) that Gemini works 1000x better with Google AppsScript than Claude, if only because it avoids syntax errors out the wazoo.
Claude has been great with raw Python though.
Claude has been great with raw Python though.
Google Apps Script now supports data regions. You can finally specify the geographic location for script execution and storage to help with your compliance requirements.
#GoogleWorkspace #AppsScript
#GoogleWorkspace #AppsScript
Data regions for Google Apps Script now generally available
Take control of your Apps Script data residency. New Google Workspace updates now allow for geographic control of script execution and storage.
cloud-captains.com
September 18, 2026 at 3:20 PM
Google Apps Script now supports data regions. You can finally specify the geographic location for script execution and storage to help with your compliance requirements.
#GoogleWorkspace #AppsScript
#GoogleWorkspace #AppsScript
A Simple Apps Script Class to Clear & Set Conditional Formatting in Google Sheets #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs @googleworkspace.bsky.social
youtu.be/coko7zUXsHk
youtu.be/coko7zUXsHk
A Simple Apps Script Class to Clear & Set Conditional Formatting in Google Sheets
YouTube video by Yagisanatode -Scott-
youtu.be
November 27, 2024 at 6:34 AM
A Simple Apps Script Class to Clear & Set Conditional Formatting in Google Sheets #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs @googleworkspace.bsky.social
youtu.be/coko7zUXsHk
youtu.be/coko7zUXsHk
Try some Google Apps Script
This sample code will automatically add events from your Google Calendar in one account to another account you have.
https://alicekeeler.com/2021/06/17/automate-share-calendar-events-with-yourself/
#AppsScript #GoogleEDU
This sample code will automatically add events from your Google Calendar in one account to another account you have.
https://alicekeeler.com/2021/06/17/automate-share-calendar-events-with-yourself/
#AppsScript #GoogleEDU
Automate - Share Calendar Events With Yourself
https://youtu.be/sumhr59ys7Q Recently I started a new part time job at http://schoolytics.com I'm super excited about the new job, but this
alicekeeler.com
January 4, 2025 at 2:00 AM
Try some Google Apps Script
This sample code will automatically add events from your Google Calendar in one account to another account you have.
https://alicekeeler.com/2021/06/17/automate-share-calendar-events-with-yourself/
#AppsScript #GoogleEDU
This sample code will automatically add events from your Google Calendar in one account to another account you have.
https://alicekeeler.com/2021/06/17/automate-share-calendar-events-with-yourself/
#AppsScript #GoogleEDU
August 16, 2025 at 7:19 PM
Sympathies. Yesterday I spent a while trying to write an AppsScript to run some operations only to throw it in the bin and do it with vlookups and nested IF statements instead.
Ugly but ultimately ran quicker.
Ugly but ultimately ran quicker.
January 21, 2025 at 11:31 AM
Sympathies. Yesterday I spent a while trying to write an AppsScript to run some operations only to throw it in the bin and do it with vlookups and nested IF statements instead.
Ugly but ultimately ran quicker.
Ugly but ultimately ran quicker.
A fellow teacher pinged me this week on how to remove an option in a #GoogleForms multiple-choice question after n responses that chose it, with no addons.
It is rather simply using #AppsScript... albeit imperfect.
Anyway, the sample Form & GAS code I sent him:
➤ drive.google.com/drive/folder...
It is rather simply using #AppsScript... albeit imperfect.
Anyway, the sample Form & GAS code I sent him:
➤ drive.google.com/drive/folder...
December 6, 2024 at 5:46 PM
A fellow teacher pinged me this week on how to remove an option in a #GoogleForms multiple-choice question after n responses that chose it, with no addons.
It is rather simply using #AppsScript... albeit imperfect.
Anyway, the sample Form & GAS code I sent him:
➤ drive.google.com/drive/folder...
It is rather simply using #AppsScript... albeit imperfect.
Anyway, the sample Form & GAS code I sent him:
➤ drive.google.com/drive/folder...
1/2 | This afternoon I've been playing around with Project IDX, Google's advanced cloud-based code editor. As someone used to the #AppsScript IDE, it has blown me away. It's awesome, and of course, it incorporates multiple assists via Gemini that are perfectly integrated.
➤ lnkd.in/dGXFmEEi
➤ lnkd.in/dGXFmEEi
January 11, 2025 at 11:28 PM
1/2 | This afternoon I've been playing around with Project IDX, Google's advanced cloud-based code editor. As someone used to the #AppsScript IDE, it has blown me away. It's awesome, and of course, it incorporates multiple assists via Gemini that are perfectly integrated.
➤ lnkd.in/dGXFmEEi
➤ lnkd.in/dGXFmEEi
Do you have an Editor add-on that extends Sheets, Docs, Slides, or Forms powered by #AppsScript?
Then you'll want to check out the launch of the granular OAuth consent to learn about how this change will affect your add-on.
workspaceupdates.googleblog.com/2025/08/gran...
Then you'll want to check out the launch of the granular OAuth consent to learn about how this change will affect your add-on.
workspaceupdates.googleblog.com/2025/08/gran...
August 12, 2025 at 8:51 AM
Do you have an Editor add-on that extends Sheets, Docs, Slides, or Forms powered by #AppsScript?
Then you'll want to check out the launch of the granular OAuth consent to learn about how this change will affect your add-on.
workspaceupdates.googleblog.com/2025/08/gran...
Then you'll want to check out the launch of the granular OAuth consent to learn about how this change will affect your add-on.
workspaceupdates.googleblog.com/2025/08/gran...
Plain English → working Google Apps Script. Describe a Sheets, Gmail, Drive, Docs, or Calendar automation and get code you paste straight into the editor — quota, triggers, and edge cases handled. Free, no login. #AppsScript
bulldo.gs — Plain English to working Google Apps Script
Describe an automation; get working Apps Script you can paste and run. Free, no login.
bulldo.gs
June 10, 2026 at 5:40 PM
Plain English → working Google Apps Script. Describe a Sheets, Gmail, Drive, Docs, or Calendar automation and get code you paste straight into the editor — quota, triggers, and edge cases handled. Free, no login. #AppsScript
Want to see how I used Google Apps Script to do RAG with Poems in Google Doc? Check my tutorial :) #appsscript #genai #gemini
www.zzapps.nl/nl/appsscrip...
www.zzapps.nl/nl/appsscrip...
Semantic Poetry with Google Apps Script - Zzapps
Enter the realm of 'semantic' search, powered by advanced language models. 'Semantic' isn't just a fancy word; it's about understanding the meaning and context behind your words. Instead of a frustrat...
www.zzapps.nl
January 24, 2024 at 6:00 PM
Want to see how I used Google Apps Script to do RAG with Poems in Google Doc? Check my tutorial :) #appsscript #genai #gemini
www.zzapps.nl/nl/appsscrip...
www.zzapps.nl/nl/appsscrip...
Geminiくんを使ったバイブコーディング、AppsScript用にJavaScriptを書かせると比較的面倒が無くスムーズに行くことが判明。まあそりゃそうなんだが。
May 20, 2026 at 11:41 PM
Geminiくんを使ったバイブコーディング、AppsScript用にJavaScriptを書かせると比較的面倒が無くスムーズに行くことが判明。まあそりゃそうなんだが。
💡 #AppsScript tip
🤖 Apps Script isn't just useful for solving big automation problems. Today I needed to create lots of conditional formatting rules. I could have spent my time in the rule editor, but instead thought I'd rather write a tiny script to do it for me!
➤ gist.github.com/pfelipm/2f2e...
🤖 Apps Script isn't just useful for solving big automation problems. Today I needed to create lots of conditional formatting rules. I could have spent my time in the rule editor, but instead thought I'd rather write a tiny script to do it for me!
➤ gist.github.com/pfelipm/2f2e...
November 30, 2024 at 10:00 AM
💡 #AppsScript tip
🤖 Apps Script isn't just useful for solving big automation problems. Today I needed to create lots of conditional formatting rules. I could have spent my time in the rule editor, but instead thought I'd rather write a tiny script to do it for me!
➤ gist.github.com/pfelipm/2f2e...
🤖 Apps Script isn't just useful for solving big automation problems. Today I needed to create lots of conditional formatting rules. I could have spent my time in the rule editor, but instead thought I'd rather write a tiny script to do it for me!
➤ gist.github.com/pfelipm/2f2e...
#PiwikPro Manager user: "I’m about to start the process of renaming our entire tag manager, so I’m especially grateful for the tool you’ve created. It’s going to save us a lot of time and effort." Get it: github.com/loldenburg/p... & join free training next Wed analytics-pioneers.de/community-tr...
GitHub - loldenburg/piwik-manager-appsscript: Apps Script for the Piwik Pro Manager Google Sheets Add-on
Apps Script for the Piwik Pro Manager Google Sheets Add-on - loldenburg/piwik-manager-appsscript
github.com
March 13, 2025 at 3:52 PM
#PiwikPro Manager user: "I’m about to start the process of renaming our entire tag manager, so I’m especially grateful for the tool you’ve created. It’s going to save us a lot of time and effort." Get it: github.com/loldenburg/p... & join free training next Wed analytics-pioneers.de/community-tr...