NemoClaw Knowledge Wiki

Automating Client Onboarding with NotebookLM and Gemini AI

3 min read

Automating Client Onboarding with NotebookLM and Gemini AI

Clip title: How to Turn NotebookLM Into an Automated Customer Onboarding App Author / channel: Charles Terrence Harper URL: https://www.youtube.com/watch?v=qic1Wgk1P6o

Summary

This video provides a comprehensive guide on transforming an existing business “rulebook” stored in Google’s NotebookLM into an automated client onboarding application. The main objective is to leverage AI, specifically Google’s Gemini and NotebookLM, to extract pertinent onboarding questions, generate a customizable Google Form, and finally embed this form into a Google Sites webpage for seamless client interaction and data collection.

The process begins by establishing a comprehensive knowledge base within NotebookLM, which includes the business’s operating procedures, marketing strategies, and client interaction guidelines. The presenter then demonstrates how to use Google Gemini, attaching the NotebookLM as a source, to formulate an “engineered prompt.” This prompt instructs Gemini to act as an expert marketing strategist and client onboarding specialist, tasking it with extracting ten critical questions necessary for a client onboarding questionnaire. The resulting questions cover essential aspects like sales tracking, unique selling propositions, funnel structures, and affiliate programs, each accompanied by a brief justification for its inclusion.

Following the question extraction, the video moves to the automation phase. The extracted questions are used to generate a Google Apps Script via Gemini Canvas. The user pastes a specific prompt into Gemini Canvas, instructing it to act as an expert Google Apps Script developer to create a new Google Form titled “Client Intake Portal” populated with the synthesized onboarding questions, formatted with multiple-choice and short-answer fields. This generated script is then copied and run within script.google.com, which automatically creates the functional Google Form, providing both an editable and a published URL.

The final step involves deploying this automated onboarding form to a live website. The newly created Google Form is linked to a Google Sheet to automatically capture client responses. The form’s embed HTML code is then copied and used to embed the “Client Intake Portal” directly into a new or existing Google Sites webpage. This entire workflow allows businesses to efficiently generate a tailored client onboarding process, collect essential client data, and streamline their initial client engagement without requiring extensive manual setup or coding expertise, transforming their static knowledge base into a dynamic, interactive onboarding solution.

Graph View