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 Session 2. So far we can write structured prompts and save them as templates with variables. In this episode we focus on the one part that most decides whether AI output is ready to use: format. We ask the AI to answer as tables, checklists, and labeled formats, then paste them into Google Sheets.
Step 1: Why output format decides usefulness
In the previous episode we saw that the format part decides the length and shape of an answer. Now let's go deeper, because the right format makes AI output usable right away, with no extra processing. A table can be pasted straight into Google Sheets. A checklist can be ticked off right away by an admin. A summary with fixed headings can be skimmed by a manager. But first, let's see what happens when no format is requested. Dimas wants to recap today's orders. Dimas types the order notes into ChatGPT as they are and asks for a recap, without mentioning any format. The answer is correct, but it's a paragraph. To find out who ordered what, Dimas has to reread it sentence by sentence. Worse, this paragraph can't be pasted into Google Sheets. Dimas has to copy the names, products, and quantities one by one into the right columns. That's prone to typos. Notice too that there are no prices and no total. The AI doesn't know that what Dimas really needs is a recap for calculating revenue. The problem isn't the content of the answer, but its shape. So, choose the output shape by what it's for. First, a table. Use it for data recaps, comparisons, and anything that will later be pasted into Google Sheets. Second, a checklist. It's great for SOPs, event preparation, or checks before goods are shipped. Each item can be ticked off one by one. Third, numbered points, for steps that must be done in order, such as how to brew cold brew or how to fill in a registration form. Fourth, fixed headings, or labels. Good for summaries that always have the same sections, such as meeting minutes with decisions, follow-ups, and risks. We'll practice these four shapes one by one in this episode, and each becomes a new template for your Prompt Library.
Step 2: Tables ready to paste into Google Sheets
Let's fix this with an order recap template. The role block: a careful Sunset Coffee order clerk. The word careful isn't decoration here, because we'll be working with numbers. The task block: turn the order notes into a recap table. These two blocks are deliberately short. The star is the next block. The format block names the columns one by one: name, product, quantity, price, subtotal, and notes. The last row holds the total, with no intro text, so the table is clean when copied. The data block holds the official price of each product, plus one variable: the order notes. The AI doesn't need to remember prices, and has no reason to make them up. The limits block: if a product or quantity is unclear, write the CHECK marker and don't guess. The same rule as the order confirmation template in the previous episode. One small but very useful detail: numbers are written without Rp and without separators. That way Google Sheets reads them as numbers, not text, so they can be added up and calculated with formulas. Dimas pastes the template, then adds the same order notes as before. Nothing needs tidying first; they go in as they are. Now the result is a table with exactly the six columns requested. Each order takes one row, complete with price and subtotal. Important notes like deliver in the afternoon and sugar-free aren't lost; they go into the notes column. The last row shows a total of four hundred twenty-nine thousand rupiah. There's no opening line like of course, here's your recap. The table is clean and ready to copy. But remember, AI can make math mistakes, so we'll check these numbers in Sheets. Now paste it into Google Sheets. Select the table in the chat window, copy it, then paste it into cell A1. Many AI apps also have a copy button near the table. The columns split neatly right away: name, product, quantity, price, subtotal, and notes. If your pasted result is still messy, ask the AI to rewrite the table, or try pasting without formatting. Now the important part: double-check the AI's math. The formula bar shows quantity times price for Rina's row. The result is one hundred seventy thousand, matching the AI's subtotal. Do the same for the total with a sum formula. This habit is very important: let the AI tidy the data, but let spreadsheet formulas be the judge of the numbers. One more advantage of the table shape: today's and tomorrow's data can be pasted one after another in the same sheet, so at the end of the month Laras has a sales recap without ever retyping anything.
Step 3: Checklists you can tick right away
The second shape is a checklist. We'll build an SOP checklist template, meaning a standard operating procedure. The role block: someone who writes SOPs for small businesses using short command sentences. The context block: Sunset Coffee, a home-based coffee shop open from eight in the morning to nine at night. Who does the work is a variable. The task block is just one sentence: create a checklist for a certain activity. The activity is also a variable, so this template works for opening the shop, closing the shop, or preparing for a bazaar. The format block explains the shape: grouped by time, each item starting with an empty box and a verb, with five items at most per group. The limits block: one action per item, and the most important items are marked with the word must in brackets. Why one action per item? Because an item like clean the machine and check the stock and lock the door is hard to tick. If only two of the three actions are done, do you tick it or not? This time we try it in Claude, to show that the same template works in any AI app. The variable values: Dimas as the assignee, the activity is opening and closing the shop, split into two time blocks. The result has two groups, matching the requested times. Each item starts with an empty box and a verb: turn on, check, switch on, recap, clean, note. Two items are marked must: turning on the coffee machine before opening, and recapping orders in Sheets before closing. That recap uses the table template we just made, of course. Laras reads it over and adds one item specific to the shop. Remember, the AI writes a draft, and the business owner knows the details on the ground. The checklist is then saved in a notes app, or printed and stuck up near the cash register. Let's see how Dimas uses it on Monday. In the morning, the coffee machine is turned on. Tick. The milk, palm sugar, and cups are checked. Tick. WhatsApp Business is switched on, ready for orders. Tick. Then the extra item from Laras: put up this week's promo board. Tick. In the evening, the orders are recapped in Sheets. The second must item is done. The coffee machine is cleaned. Tick. The last item, noting ingredients that are running low, was missed and gets a red cross. That's what a checklist is for: anything missed shows up right away, so it can be fixed tomorrow, instead of being discovered only when the stock has run out.
Step 4: Labeled formats for summaries
The third shape is a labeled format, or fixed headings. The example comes from Dewi, operations manager at Maju Bersama Co., who leads a weekly meeting every Monday. The role block: a concise, tidy meeting note-taker. The task block: summarize the Maju Bersama Co. weekly meeting notes. The format block is the key. Use exactly three headings: decisions, follow-ups, and risks. Follow-ups are written in the pattern name, task, then deadline. Four items at most per heading. The limits block: don't add decisions or deadlines that aren't in the notes. AI tends to want to help by adding sensible deadlines. In meeting minutes, that's dangerous. And the data block holds just one variable: the meeting notes. Dewi just pastes the raw notes typed during the meeting, however messy they are. The result becomes an email draft for the team. The inbox shows supporting emails from Rudi in logistics and Ayu in the warehouse, which were discussed in the meeting. Open the draft. The three headings appear exactly as requested: decisions, follow-ups, and risks. Anyone who opens this email knows right away which section to read. Look at the follow-ups section. Each item follows the pattern name, task, and deadline. Rudi compares couriers by Friday at the latest, and Ayu updates the stock list by Thursday at the latest. Because the format is the same every week, Dewi's meeting summaries are now easy to compare from week to week. It also makes the next step easier: moving the follow-ups into Google Sheets or a calendar. As a cheat sheet, here are some powerful format phrases. For a Sheets-ready table: name the columns one by one, and ask for numbers without Rp and without separators. For a checklist: each item starts with an empty box and a verb, with one action per item. For a concise result: give the numbers. Five points at most, and each point fifteen words at most. The word concise alone is too vague for the AI. For a labeled format: write the exact headings, spelled exactly the way you want them. And for a result you'll paste straight away: ask for no intro or closing text. This simple phrase removes filler like of course, here's the result, or hope this helps.
Step 5: A weekly content calendar template
Tables aren't only for numbers. The next template is a weekly content calendar, which is very useful for business owners and for marketers like Nadia. The role block: an Instagram content planner for Sunset Coffee. The context block: customers are students and young workers in Bandung, plus a variable for this month's theme, such as rainy season or payday month. The task block: plan content ideas for a number of days, starting on a certain day. Both are variables, so this template works for one week or one month. The format block names four columns: day, content format, idea, and call to action. There's an extra rule: each cell is eight words at most, so the table stays compact and easy to read in Sheets. And the limits block: only use official products and prices, and avoid health claims like coffee helps you lose weight or keeps your heart healthy. Laras fills in the variables: rainy season theme, seven days, starting Monday. The resulting table is copied and pasted into Google Sheets. First row, Monday: a photo of iced coffee as a study buddy at the start of the week. Tuesday: a reel of cold brew brewing for eighteen hours. Wednesday: a carousel of three ways to enjoy a liter of iced coffee. Thursday: a photo telling a loyal customer's story. Notice the note, with permission. Laras added it, because customers' faces and stories must not be used without their consent. Friday to Sunday: sunset vibes at the shop, what's inside the hamper including the sugar-free option, and cold brew for a family picnic. The formats vary between photos, reels, and carousels. A week's content plan done in minutes, and because it's a table, Laras can add columns for status, posting date, or who's responsible. In Episode 9 we'll develop the ideas in this column into captions. This table pattern is easy to move to other kinds of work, just by changing the column names. Nadia, who manages accounts for several small businesses, adds client and status columns, so one table holds the content plans for four clients at once. Mr. Hendra uses lesson, topic, practice, and homework columns to build a one-month study plan for Cerdas Tutoring students. And Dewi uses vendor, price, delivery time, and notes columns to compare suppliers. The principle is the same: you decide the columns, the AI fills them in, and Sheets does the processing.
Step 6: Re-tidying and checking the output
Back to Dimas's order recap. The format doesn't have to be right from the start. In the same conversation, Dimas asks: remove the price column, add a status column that says not shipped, then sort by the largest subtotal. The AI rearranges the table right away. The price column is gone, the status column appears, and the order now runs from Rina, with the largest subtotal, down to Sari. No need to rewrite the prompt from scratch. Then Dimas needs a delivery list for the courier, and asks for yet another shape: one line per customer, just the name and items. The result is a short list that can be sent straight to the courier on WhatsApp. From the same data, we get three output shapes: a recap table, a status table, and a delivery list. Before using the output, check it with this checklist. First, the columns and headings match what you asked for. If a column is missing or renamed, ask the AI to fix it. Second, numbers are rechecked with formulas in Sheets. This is a must for money, stock, and scores. Third, unclear data is marked CHECK, not filled in with a guess. Fourth, no intro or closing text gets copied along with it. Fifth, there's no unnecessary personal data, such as customers' phone numbers or full addresses. And sixth, when you find a format that works, save its format phrase into the template so you don't have to ask for the same fix again tomorrow. Here's your homework for this episode. First, take one daily log from your work, such as orders, expenses, or attendance, and turn it into a table with columns you choose yourself. Second, paste that table into Google Sheets, then check the numbers with formulas. Third, create an SOP checklist for one routine activity, and ask a coworker to try it. Fourth, save three new templates to your Prompt Library: the order recap, the SOP checklist, and the content calendar. Your collection keeps growing toward ten templates by the end of this session.
Done!
Let's recap. Format decides whether AI output is ready to use. Name the shape, name the columns or headings one by one, ask for numbers without symbols, and remove intro text. Then let spreadsheet formulas check the numbers. In the next episode we get hands-on: writing prompts for Sunset Coffee's social media captions and product descriptions, complete with brand style, variations, and character limits. See you in Episode 9.
Practice exercises
Try these on your own after watching to lock in what you learned.
Turn one of your daily logs (orders, attendance, or expenses) into a table with columns you choose yourself, then paste it into Google Sheets and check the numbers with formulas.
Create an SOP checklist for one routine activity at your workplace, then ask a coworker to try using it for a week.
Save the order recap, SOP checklist, and content calendar templates to your Prompt Library document.
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,281 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.
