NotebookLM and AppSheet for Work is a hands-on course in turning team documents into a searchable knowledge base with NotebookLM, with cited answers and summaries in several formats, then building no-code apps from Google Sheets with AppSheet. It suits office staff, supervisors and operations teams on Google Workspace, and you leave with repair request and inspection apps ready to adapt.
Every organisation keeps its knowledge in manuals, reports, slide decks and meeting notes, yet finding an answer still means opening one file after another. Meanwhile everyday work such as repair requests, equipment checks and approvals still runs on paper, group chats and spreadsheets that several people edit at once until nobody trusts the numbers. Two Google tools close this gap without any code: NotebookLM for managing knowledge, and AppSheet for turning spreadsheets into working apps.
On the first day learners use NotebookLM to build a knowledge base from their team's documents, ask questions and check every answer against its cited source, summarise material as reports, mind maps, flashcards and quizzes, create Audio and Video Overviews, and share notebooks safely in Google Workspace. On the second day they build an AppSheet app from Google Sheets, covering the data model, views and field data collection forms, actions, automation bots and user permissions, then install it on a phone. The course closes with a project that uses both tools together. (2 days, 6 hours per day, 12 hours in total, Beginner level.)
Course Details
This course runs for 2 days, 6 hours per day (12 hours in total, 09:00-16:00), as lectures with a lab in every topic. Beginner level, with no programming background required. Day one covers NotebookLM for managing knowledge from the team's documents, and day two covers AppSheet for building working apps from Google Sheets. All labs use a fictional organisation's data, so learners do not need to bring real company documents. Some capabilities, such as creating apps with Gemini or AI tasks in AppSheet, depend on the organisation's plan. Learners take home a lab guide, sample documents, starter Google Sheets and the apps they build during the course.
Section 1: Lab: Getting Started with NotebookLM
How NotebookLM differs from a general AI chat, and which tasks it suits
The Sources, Chat and Studio panels, and creating your first notebook
Structuring notebooks around the work: by project, topic or department
Lab: build an employee handbook notebook from sample policy documents
Section 2: Managing Sources
Add sources from PDFs, Google Docs, Google Slides, websites, YouTube and pasted text
Find further sources on the web from within NotebookLM and vet them before importing
Switch sources on or off to scope the answers, and refresh them when the originals change
Lab: combine reports, slides and video clips into a team knowledge base
Section 3: Lab: Grounded Q&A with Citations
Ask questions that get clear answers, and follow each citation back to the original text
Compare and summarise several documents and spot where they contradict each other
Adjust the role and length of answers, and save important answers as notes
The limits of the answers, and how to check accuracy before relying on them
Section 4: Summarising Knowledge with Studio
Create reports such as briefing docs and study guides focused on the points you need
Mind maps for an overview of the topics, and data tables that pull facts into rows and columns
Flashcards and quizzes for revision and for onboarding new staff
Workshop: produce a summary pack and a quiz from a work manual
Section 5: Audio and Video Overviews and Presentation Material
Conversational Audio Overviews: choose the format, length, language and focus
Join the conversation with questions in interactive mode
Video Overviews as narrated slides
Slide decks and infographics to brief managers or the team
Lab: turn one notebook into an audio, video and slide summary of a project
Section 6: Sharing Notebooks and Data Security
Share notebooks with colleagues as viewers or editors
NotebookLM in Google Workspace: data protection and the administrator's role
What should and should not be uploaded, and handling personal data under the PDPA
Workshop: draft guidelines for using NotebookLM in your own department
Section 7: Lab: Getting Started with AppSheet from Google Sheets
What AppSheet is, which jobs suit a no-code app, and a tour of the editor
Prepare Google Sheets properly: one sheet per table, clear headers and a key column
Create an app from Google Sheets or let Gemini draft the app structure from a description (where your account supports it)
Lab: build a repair request app and test it in the preview
Section 8: Data Model: Tables, Columns and Relationships
Common column types: Text, Number, Date, Enum, Image, LatLong and Ref
Set the key, label, initial value, Valid If and Required
Basic expressions such as IF, LOOKUP, SELECT and USEREMAIL, plus virtual columns
Lab: link equipment, owner and repair history tables with Ref columns
Section 9: Lab: Views and Field Data Collection Forms
Choose the right view: Deck, Table, Gallery, Detail, Calendar, Map and Dashboard
Mobile-friendly forms with photos, signatures, GPS location and barcode scanning
Slices to filter data, format rules to highlight status, and Show If to hide columns
Lab: an equipment inspection form with photos and the inspector's signature
Section 10: Actions and Automation Bots
Actions to change a job's status, jump to another view, or call and email from the app
How a bot is built from events, processes and tasks, including scheduled bots
Send emails or notifications and generate PDF files from templates automatically
AI tasks that read data from images or documents (where your plan supports it)
Lab: alert the supervisor about new repair jobs and issue a PDF work order on completion
Section 11: Users, Permissions and Security Filters
Require sign-in and choose which users or domains can open the app
Separate requester, technician and supervisor roles and limit adds, edits and deletes
Security filters so each person sees only the data that concerns them
Lab: test the app from the point of view of each role
Section 12: Deployment and Capstone Project
Deployment checks, installing the app on iOS and Android, and working offline
An overview of AppSheet licensing for creators and users in an organisation
Capstone: summarise a procedure manual into a checklist with NotebookLM, then build an inspection app with AppSheet
Present the work, review it together and plan how to roll it out
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
Built for Office staff and supervisors who handle large volumes of documents and data · HR, training and quality teams who look after manuals, policies and work procedures · Operations, maintenance and field teams who want to replace paper forms Background you should have: No programming background is required · Basic Google Drive and Google Sheets skills, such as creating a table, entering data and sharing files Not sure the fit is right? Talk to our team on LINE @itgenius or call 02-570-8449.
THB 6,900 (currently THB 6,210 on promotion). The course runs 12 hours. The price excludes 7% VAT (for payment in a company's name). Pay by bank transfer to the company account, confirm it on our payment page, and we can issue the receipt or tax invoice in your company's name.
Yes. Everyone who completes the course receives a Certificate of Completion from IT Genius Institute. Each certificate carries its own number, and anyone holding that number can verify it online on our certificate page, so you can add it to your portfolio or pass it to HR as evidence of training.
You can attend onsite at IT Genius Institute or arrange to join online, and we also run it as a private in-house session for your team. Ask about dates and venues on LINE @itgenius or call 02-570-8449.
Yes. You may retake the same course free of charge in a later round, under the institute's conditions. Tell our team which course and round you attended, and we will check it and offer you the rounds that still have seats. Ask us on LINE @itgenius or call 02-570-8449.
Enrol online with the registration form on this page. You can register several attendees at once and enter your tax ID and billing address for the tax invoice. Or request a company quotation straight from the quote button. For anything else call 02-570-8449 or reach us on LINE @itgenius.
Many organizations already use Google Workspace as their main work platform - Gmail, Google Docs, Sheets, Slides, Drive and Meet - but do not yet fully use the power of Google Gemini built into these tools, even though Gemini can help draft and summarize…
ChatGPT has become a tool many people open every working day, yet most still use it one question at a time. Today it can read files, analyze data, produce Word, Excel and PowerPoint files, connect to email and calendars, carry out in-depth research and run…
Many organizations already use ChatGPT fluently in daily work but remain stuck typing the same prompts every day, copying and pasting data between systems, and getting inconsistent output whenever a different person uses it. The next step that makes a real…
