> ## Content Index
> Fetch the complete content index at: https://www.jeffsu.org/llms.txt
> Use this file to discover other available public pages before exploring further.

# Gemini: Clean Data, Boost Insights
- URL: https://www.jeffsu.org/newsletter-154/
- Published: 2024-04-05T01:00:28.000Z
- Updated: 2025-09-05T12:55:59.000Z
- Description: #154
- Author: Jeff
- Tags: #newsletter, Gemini

*(you can easily* [*filter previous issues*](https://www.jeffsu.org/filter-previous-editions-by-app/) *by application!)*

---

Before diving into today’s tip I have some good news: **my Workspace Toolkit is now live.** 

[You can get it for free here](https://academy.jeffsu.org/workspace-toolkit?ref=jeffsu.org)!

[![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2024/04/Sign-Up-Landing-Page-Image-Dark-Theme-2.png)](https://academy.jeffsu.org/workspace-toolkit?ref=jeffsu.org)

I’ve been using Google Workspace tools for \~10 years now and I thought it would be cool to distill a few of my favorite templates into a single toolkit for you all to download!

**It’s completely free for all of you** and my only ask is if you find it helpful, please give me feedback and share it with your friends and colleagues 😁

Onto today’s tip:

## Using Gemini to quickly extract useful data

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2024/04/CleanShot-2024-04-03-at-13.40.01@2x.png)

Here’s what you’re looking at in the screenshot above:

- **Column G =** A list of websites that referred traffic to my landing pages
- **Column F =** I would like to extract the “base url” to analyze where most of my sales are coming from

*(note: I had to do something like this for work recently, but I’m using my own data in this example so I don’t get fired)*

#### Here’s the Prompt I input into Gemini

I'm cleaning up data in Google Sheets.

In Column G, I have a list of websites that referred business to my page.

In Column F, I want to output the "Base URL"

For example, if the website URL is "[www.youtube.com/jeffsu](http://www.youtube.com/jeffsu?ref=jeffsu.org)", Column F should show "[www.youtube.com](http://www.youtube.com/?ref=jeffsu.org)" as the Base URL.

Your task is to write a formula I can input into Column F

## Structure > Specific use case

The main focus of today’s tip isn’t the prompt itself per se (since you’ll probably never encounter this exact situation), but rather the prompt structure.

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2024/04/CleanShot-2024-04-03-at-13.51.40@2x.png)

- **Extremely specific context:** The more specific you are (columns, rows, and even cells), the fewer manual edits you need to make to the end formula
- **Output example:** I’ve found this make the biggest difference between Gemini getting it right the first time vs having to follow up with additional prompts

## The end result

Just in case you were wondering, this was the final output, and as expected, it worked like a charm 😁

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2024/04/CleanShot-2024-04-03-at-13.57.19@2x.png)

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2024/04/CleanShot-2024-04-03-at-13.57.51@2x.png)

---

**Want to see more (or less) of this?** Tap the thumbs up or down to let me know ⬇️

**Want someone to be more productive?** Let them subscribe [here](https://www.jeffsu.org/#/portal/signup) 😉

Thanks for being a subscriber, and have a great day!