At most one email a week. Unfollow anytime with one click.
Transcript
The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.
Show transcript
Introduction
Hi, and welcome back to Claude from Zero to Expert. In the previous episode we got to know connectors. Now we practice with the app people use most: Google Drive. We'll learn to find files precisely, pick the right version, ask questions of long documents, and combine several files into one report.
Step 1: The four most common Drive jobs
Imagine a coworker who knows every folder in your Drive by heart. You just ask, and they answer while showing you the file. That's what it feels like once the Google Drive connector is connected. But even the best coworker needs clear directions. In this episode we learn how to give them. Of everything you can do in Drive, four jobs come up most often. First, finding files scattered across many folders, especially old files whose names you've forgotten. Second, summarizing long documents such as contracts, meeting minutes, or monthly reports. Third, comparing two documents, or two versions of the same document, to see what changed. Fourth, combining the contents of several files into one new report. The good news: all four only need read permission. Claude doesn't have to change anything in your Drive, so this is a safe exercise to start with.
Step 2: Finding files precisely
Searching for files through Claude is like asking a coworker for help. The clearer the directions, the faster you find it. Start with the task: find the Sunset Coffee product price list. Then name the folder. Laras keeps all her prices in the Sunset Coffee folder, in the Prices subfolder. That narrows the search from the start. Add the time range and file type: changed in the last three months, and a spreadsheet. Old files and other documents are filtered out automatically. Finally, the most important limit: if there are several versions, show their dates and ask first. This stops Claude from guessing the wrong file. Here's how it looks in practice. Laras writes a request with those four elements, in one natural sentence. Claude searches the Prices folder. Notice that it doesn't roam the whole Drive, because Laras already named the folder. It turns out there are three similar files: v2, final, and final revised. A classic problem in many offices. Claude shows the dates and who changed each one last, then asks. Laras picks final revised, and also asks how it differs from the final version. Claude compares the two: only the gift hamper price changed, from one hundred forty thousand to one hundred fifty thousand rupiah. Laras immediately knows Dimas has updated the promo price.
Step 3: Asking questions of long documents
The second job is reading long documents. Dewi needs to understand an eighteen-page distributor contract before meeting the director. Instead of asking for a general summary, Dewi asks something specific: what are the obligations on payment and penalties, and in which clauses. Claude opens the document directly from Drive. The answer is focused: payment due in thirty days in clause six, late penalties in clause nine. Claude also flags clause twelve on automatic renewal, which is easy to miss. Then Dewi uses the third job, comparing. She asks Claude to compare this contract with last year's, which is in the same folder. Claude opens the second document. Dewi doesn't have to put two contracts side by side and read them line by line. The result is three important changes: shorter payment terms, a new penalty, and automatic renewal. These three points go straight into Dewi's discussion with the director. From that example, there are four habits to take with you. First, ask specific questions. Specific questions produce answers you can check. Second, ask for references: the clause number, page, or section title. That makes it easy to find the original wording. Third, open that section and read it yourself. A summary can lose important words such as except, or no later than. Fourth, for legal and financial decisions, Claude is the first reader, not the final adviser. Always involve the person with authority.
Step 4: Combining several files into one report
The next job is combining. Every month Mr. Hendra at Cerdas Tutoring writes a student progress report. His material is spread across three files. The first is this mock exam score spreadsheet. Each student has scores for math, science, and Indonesian, along with an average. The second file is the class notes with the teacher's observations, and the third is the attendance record. Usually Mr. Hendra opens all three in turn and copies everything by hand. This time he hands it to Claude. Before giving the instruction, three things make a combined report accurate. First, name the files exactly, not just that score file from yesterday. Second, choose a key that links the files. Here the key is the student's name, which must be the same in all three files. Third, ask Claude to report data that doesn't match, such as names spelled differently or missing scores. It's better to ask than to guess. With these three things, Claude doesn't quietly fill in the gaps, and you know exactly which parts need rechecking. Mr. Hendra names all three files clearly and asks for a short report per student. Claude reads the three files at once from Drive. Nothing is downloaded or uploaded by hand. The report appears in the Artifact panel: the class average, attendance rate, and a table per student. Claude also merges in the teacher's notes, then flags that Bima needs attention because of low scores and frequent absences. Before sharing it with parents, Mr. Hendra checks two random numbers against the original files. Remember too: take only the data you need. This report doesn't need students' addresses or phone numbers.
Step 5: Tidying Drive so Claude is more accurate
Claude searches by file name, content, and location. So a tidy Drive makes Claude more accurate. Start with file names: use a date and a clear name, not new prices final really. Second, versions. Keep one final file, and move old versions to an Archive folder. The three-similar-files problem won't happen again. Third, folders. Group files by type of work, such as prices, recipes, suppliers, and reports. Fourth, keep sensitive data such as employee records or bank details in a separate folder that isn't used for practicing with Claude. Let's sum up the flow. First, search with the four elements: folder, time, file type, and keywords. Second, read with specific questions and ask for section references. Third, build the result, for example an easy-to-read report in an Artifact. Fourth, check a few numbers in the original files, then save the result into your own document. The screens in this video are simulations, and connector abilities may grow, so check Anthropic's official page for the latest features.
Done!
We've practiced the Google Drive connector: finding files with four elements, choosing the right version, asking questions of a contract, and combining three files into one report. The key is always the same: clear directions, source references, and your own check. In the next episode we move to Gmail and Google Calendar: summarizing the inbox, preparing reply drafts, and finding meeting times. See you there!
Practice exercises
Try these on your own after watching to lock in what you learned.
Ask Claude to find one file in Drive using all four search elements
Ask three questions of one long document and request the section references
Combine two or three files into one summary, then check the numbers in the original files
Ask the class material
Type a question or keyword; we find the part of this episode that explains it and jump the video there.
My notes
Notes are saved with the current video time and are only visible to you.
Questions & answers
Stuck on a step? Ask here; the instructor and other learners can answer.
No questions yet.
Your instructor
Cerdas Inovasi Digital Team
Software developers, BIM & 3D engineers, and AI practitioners
53 video classes1,286 episodes
We build software, BIM models, games and AI automations for clients every day, and turn that hands-on work into step-by-step classes: every step is shown on screen and comes with a PDF guide you can keep.
