With educators consuming 3x more digital content than five years ago, the challenge isn’t finding information. Rather, it is transforming it into meaningful learning experiences. This hands-on workshop addresses teacher workload concerns by teaching participants to become “Learning Loop Architects,” mastering AI-powered workflows that turn chaotic content curation into streamlined, professional digital publications. You will see how to make KPI dashboards, save web-based data into Google Sheets via AI-generated AppScripts, and more.
Every example below works right now with built-in sample content — just click
a Open demo button. No account, no setup. When you're ready to use your own
content, open that example's setup.md for friendly, click-by-click steps.
Each is a self-contained website in its own folder, with a
readme.md, setup.md, the data connector, and a live demo that
works offline before you connect your own data. The content examples (Newsletter, Online
Magazine, Reading-List Digest, Resource Directory) also have a one-click bar to
Copy as Markdown / HTML / formatted-for-email — so you can paste a finished piece
straight into Gmail, Mailchimp, a CMS, or a doc.
A branded, print-ready newsletter (“The Learning Loop” style) built live from a spreadsheet — editors write in tabs, readers get a polished web issue.
createNewsletterTemplate() in code.gs to auto-build the Sheet.code.gs as a Web App; copy the /exec URL.WEB_APP_URL in index.html.A performance dashboard with KPI cards, trend & breakdown charts, and a sortable table — numbers pulled straight from a Google Sheet.
createDashboardTemplate() in code.gs to auto-build the Sheet.code.gs as a Web App; copy the /exec URL.WEB_APP_URL in index.html.An online magazine whose articles are authored in Google Docs. A script converts each Doc to clean HTML; the site lists and renders every issue.
FOLDER_ID in code.gs, deploy as a Web App./exec URL into index.html & article.html.A curated link digest rendered from plain Markdown files — no Google account, no
backend. Drop a .md file in content/ to add an issue.
content/.ISSUES array in index.html.A searchable, filterable catalog of tools and resources — full-text search, category & tag filters, and sorting, all from a single spreadsheet.
Resources tab (title, url, category, tags…).code.gs as a Web App; copy the /exec URL.WEB_APP_URL in index.html.Grab one project, or the whole kit. Each ZIP contains the ready-to-run
website plus its readme.md and setup.md.
All five examples, this menu page, and the Start-Here guide.
Prefer individual projects? Use the ⬇ ZIP button on any card above.
Every example is plain HTML/CSS/JS — no build step — so it runs on any static host. Two easy paths:
ai-powered-pubs), make it Public, Create.downloads folder,
index.html, and START-HERE.md), then Commit changes.
(Or use Git: git init, git add ., git commit -m "publish",
git remote add origin <repo-url>, git push -u origin main.)https://<your-username>.github.io/<repo-name>/.
The menu is the root index.html; each card links to its example./var/www/html/) or
upload via SFTP / your host’s file manager.index.html is at the path you want; the example folders sit beside it.python3 -m http.server 8000 in this folder and open
http://localhost:8000.)Why a server and not a double-click?
Browsers block fetch() of local files over file://, so the demos need
to be served over http(s). GitHub Pages and any web host do this for you.
The Google-powered examples (1, 2, 3, 5) need their code.gs
deployed as a Web App and the resulting /exec URL pasted into the page — see each
example’s setup.md. Until then, every demo runs on bundled sample data, so you can
host and explore the whole site before connecting any live data.