Who Took the Drill? Build a Google Sheets Tool Loan Log

Quickchat has a step-by-step tutorial for building a Google Sheets tool loan log that an AI assistant can answer questions from. You ask "Where is DR-01?" and it replies with the last recorded holder, location and time.

The example is a three-tool workshop assistant called Bench Log. The sheet has a Tools tab for IDs and names, a Movements tab where every checkout and return is added as a new row, and a Status tab. Status uses a reverse XLOOKUP to pull each tool's most recent row, so the assistant only reads that short table. In the sample data, the drill shows Maya at Bench 3. After a return is logged, it shows Workshop, Cupboard A, and the earlier checkout stays in the history.

On the Quickchat side, you connect Google Sheets from Actions & MCPs, repurpose the starter spreadsheet it creates, and add a read Action that fetches the Status range. The guide has you test in the dashboard's AI Preview and turn off public widget and chat page access first. After that it adds checkout and return recording. The Google connection only asks for the limited drive.file scope, so it works with the new sheet and not the rest of your Drive.

The guide links a starter kit with the tab files, formulas, Action settings, prompt and test checklist. You paste these in yourself, because it isn't an automatic Agent import. AI replies and testing use Quickchat credits, so check your plan's allowance.