Gemini Notebook’s HUGE Upgrade: Build Custom Data Tables in Minutes!
Read the Portuguese translation →
Author: AI and Tech for Education · Watch on YouTube
Video authored by the channel shown, not by IANIA; all rights belong to the creator. Transcript and summary generated automatically; the original-language content is preserved.
Original language: English
Original video: Gemini Notebook’s HUGE Upgrade: Build Custom Data Tables in Minutes! · Channel: AI and Tech for Education · 05:42 · Watch on YouTube
Topics: Task and workflow automation, AI developer tools
Summary
Section titled “Summary”The video demonstrates how Gemini Notebook can turn information from official product pages and an internal business brief into a custom, source-backed comparison table. Using a fictional 25-person consulting company, it compares Asana, ClickUp, and monday.com against the company’s specific needs. The process includes checking sources for missing information, generating a tailored table, reviewing citations, and exporting the result to Google Sheets. The video also shows how to bring the spreadsheet back into Gemini Notebook to create a report, while emphasizing that changing details should be verified before a purchase.
Key points
Section titled “Key points”- Add an internal requirements document first to give Gemini Notebook the company’s decision context.
- Use official vendor pages for pricing, plan limits, features, integrations, security, and support information.
- Add each relevant webpage as a source; Gemini Notebook does not automatically read every page linked from a website.
- Ask Gemini Notebook to check whether the source collection covers the business requirements and identify gaps without relying on general knowledge.
- Specify the comparison criteria for the custom data table, including plans, pricing, user limits, features, and restrictions.
- Review the table’s supporting citations and how well the available evidence matches the company’s requirements.
- Export the table to Google Sheets to edit, filter, sort, and update it.
- Add the completed spreadsheet back into Gemini Notebook to generate a report or infographic.
- Verify changing information such as prices, plan limits, and security details before making a purchasing decision.
Chapters
Section titled “Chapters”| Start | Chapter | Summary |
|---|---|---|
| 00:00 | Introducing custom data tables | The video introduces Gemini Notebook’s custom data table feature and the goal of comparing business tools using information gathered from multiple sources. |
| 01:33 | Adding requirements and official sources | The presenter adds the company’s requirements document and official pages for Asana, ClickUp, and monday.com, then checks whether the sources cover the brief. |
| 03:06 | Generating and exporting the comparison | Gemini Notebook creates a tailored comparison table, which the presenter reviews and exports to Google Sheets for further editing. |
| 04:40 | Creating a report and verifying details | The completed spreadsheet is added back as a source to create a report, and the presenter advises verifying details that may change before making a purchase. |
Quotes
Section titled “Quotes”Gemini notebook can now take information scattered across all of those sources and organize it into one structured source back table. — 00:31
If something cannot be confirmed from the sources, it should tell us what additional official page we need. — 02:35
The table does not have to remain inside Gemini notebook. — 04:09
We should still confirm changing information, such as prices, plan limits, and security details before making a real purchasing decision. — 05:42
Concepts and entities
Section titled “Concepts and entities”Gemini Notebook, Google Sheets, Asana, ClickUp, monday.com, Northstar Consulting, tabela de dados personalizada, citações de fontes
Full transcript (original language)
Section titled “Full transcript (original language)”00:00 Hello everyone, and welcome to the Gemini notebook playbook. In this series, we use Gemini notebooks newest features to create finished practical work for business, research, and study. In the first episode, we created a branded, fully editable PowerPoint presentation. In the second, we used code, formulas, and charts to build a complete Excel workbook. Today, we are looking at custom data tables. Comparing business tools normally means moving between separate pages for pricing, features, integrations, security, and support, then copying everything into a spreadsheet and trying to make
00:31 completely different plans line up. Gemini notebook can now take information scattered across all of those sources and organize it into one structured source back table. I’ll show you how to add official product pages as sources, create and customize the comparison, check the supporting citations, and export the finished table to Google Sheets. So, let’s get started. For this example, we will use a fictional professional services company called Northstar Consulting. The company has 25 employees and currently manages projects through a mixture of spreadsheets, emails, and separate task
01:02 lists. As the company grows, this is making it harder to track responsibilities, deadlines, and progress across different teams. The company is considering three project management platforms: Asana, ClickUp, and monday.com. It needs to compare their pricing, collaboration tools, automations, integrations, reporting, mobile access, security, customer support, and important plan restrictions, but we do not want a generic list of features. We want the comparison to reflect what this particular company actually needs. So, the first source we will add is a short internal business requirements document.
01:33 It describes the team, the current problem, the budget, and the features that matter most. By adding this document first, we are giving Gemini notebook a clear decision context. Without it, we might receive a general comparison containing dozens of features that have little relevance to this company. I will add the requirements document to our notebook now. You will find this document, along with every prompt used in the video, in the resource folder linked in the description. Next, we need to add reliable information about each platform. I am going to use official vendor pages because prices, plan
02:04 limits, and product features can change. Let’s begin with Asana. I will open its official pricing page, copy the address, and return to Gemini notebook. From here, I’ll select add source, choose the website option, and paste the address. I will repeat this process with the relevant official feature, integration, security, and support pages. Now, I’ll do the same for ClickUp and monday.com. This is important because Gemini notebook imports the content of the specific webpage we provide. It does not automatically read all the pages linked from that website. I can paste the addresses together with each one on a
02:35 separate line and add them as website sources. By collecting these official pages inside one notebook, Gemini notebook can work across the full source collection. Before we create the table, I want Gemini notebook to check whether our source collection covers all the questions in the company brief. I will enter a short prompt asking it to review the sources against the business requirements and identify any missing or incomplete areas. I am also telling it not to fill gaps from general knowledge. If something cannot be confirmed from the sources, it should tell us what additional official page we need. Okay, so let’s enter that. And now we can see
03:06 that the source check has identified that everything is adequately covered. So, now we can create our custom data table. I’ll go to the studio panel and select data table. I will now create a customized version. In the instruction box, I will ask Gemini notebook to compare the three platforms against Northstar Consulting’s requirements. The table should include the relevant plan, monthly and annual pricing in US dollars, user limits, collaboration tools, automations, integrations, reporting, mobile access, and important restrictions. I also want it to identify how well the available evidence matches
03:37 the company’s requirements. Let’s generate the customized table. Okay, so our custom data table is now ready. If we look across the table, we can see that Gemini notebook has organized the three platforms using the same comparison areas. It brings the relevant plans and pricing information together, then compares the main project management, collaboration, and reporting features. It also gives us separate columns for automations, integrations, mobile access, security, and customer support. This makes the differences much easier to identify than they were across
04:09 the separate product pages. The table does not have to remain inside Gemini notebook. We can export it directly to Google Sheets and continue working with it there. I’ll select the export option and open the table in Google Sheets. We now have an editable spreadsheet containing the information from our custom data table. I can resize the columns, apply filters, sort the platforms, and add new internal columns. The team can continue updating the comparison as new information becomes available without rebuilding it from the beginning. One more useful option is to bring the completed comparison on Google
04:40 Sheets back into Gemini notebook. So, let’s copy the link to the Google Sheet, return to the notebook, and add it as a new source. I will then select only that spreadsheet, go to the studio panel, and choose what I want to create from it, such as a report or an infographic. For this example, I’ll create a report. You can see that Gemini notebook uses the completed table to summarize the main findings, highlight the differences between the platforms, and identify the areas that still need confirmation.
05:11 In this video, we saw how Gemini notebook can take information scattered across multiple product pages and turn it into a structured source-backed custom data table. We added official pages as sources, checked for missing information, defined the exact comparison criteria, reviewed the citations, and exported the finished table to Google Sheets. The main benefit is not simply that Gemini notebook created a table. It organized a complicated source collection around a real business question and produced an output that the team can continue using. We should still confirm changing
05:42 information, such as prices, plan limits, and security details before making a real purchasing decision. If you found this video useful, subscribe so you do not miss the next episode of the Gemini Notebook Playbook, where we will continue using Gemini Notebooks newest features to create practical work for business research and study. I’ll see you in the next one.