> ## 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.

# Google Gemini: From Research to Pivot Table in 3 minutes
- URL: https://www.jeffsu.org/productivity-ping-122/
- Published: 2023-10-06T01:00:41.000Z
- Updated: 2025-09-05T13:01:45.000Z
- Description: #122
- Author: Jeff
- Tags: #newsletter, Gemini

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

### Quick update on your feedback 🤗

First up - Thanks to everyone who took the time [to vote](https://www.jeffsu.org/productivity-ping-114/) on whether you wanted to see more Google Bard tips:

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/10/image.png)

The feedback was overwhelmingly positive so here we go 😁

## From 30 minutes to 3 minutes

I recently started research on Fortune 500 companies for a project at work, and this was the prompt I started out with:

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/10/image-1.png)

And this is what Bard generated:

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/10/image-2.png)

After clicking into Google Sheets directly from Bard, I went ahead and opened up [Smart Menu](https://www.jeffsu.org/productivity-ping-121/) (OPTION + / or Alt + /) and typed in “Pivot table” with the highlighted data:

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/10/image-3.png)

**After a few more clicks to sort by Country and Company, boom!**

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/10/image-4.png)

I basically bypassed 30+ minutes of extra work (i.e. Googling the information > Copy and pasting into Sheets > Clear formatting, etc.)

💡

****Pro tip:** If you are worried about Bard making mistakes (or hallucinating), click the “Google” icon at the bottom to force Bard to double-check for accuracy

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/10/image-5.png)

[Would love to hear some of your use cases at work!](https://www.jeffsu.org/productivity-ping-122/#ghost-comments-root)

---

**I’m always looking for ways to improve** so give me anonymous feedback [here](https://forms.gle/4Dscq21VYF3fjCcn8?ref=jeffsu.org) 📝

**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!