mstdn.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A general-purpose Mastodon server with a 500 character limit. All languages are welcome.

Administered by:

Server stats:

8K
active users

#googlesheets

2 posts2 participants0 posts today

How-To Geek: How to Turn an Image Into Google Sheets Data With OCR in Google Drive. “Copying data from an image into a Google Sheets file manually can be time-consuming and increases the chances of typos. Luckily, you can extract the information into your spreadsheet in just a few simple steps using the Optical Character Recognition (OCR) tool in Google Drive. Here’s how.”

https://rbfirehose.com/2025/07/14/how-to-geek-how-to-turn-an-image-into-google-sheets-data-with-ocr-in-google-drive/

ResearchBuzz: Firehose | Individual posts from ResearchBuzz · How-To Geek: How to Turn an Image Into Google Sheets Data With OCR in Google Drive | ResearchBuzz: Firehose
More from ResearchBuzz: Firehose

Calishat: Temporary Obsessions RSS Feed Reader Updated and Now Available. “The Temporary Obsessions RSS Feed Reader is a Google Sheets-based tool that lets you schedule your RSS feeds and give them expiration dates. I have used TOFR for monitoring breaking news topics over the short-term, scheduling feeds in advance for a known business-/stock- related deadline, and to ‘audition’ keywords I […]

https://rbfirehose.com/2025/07/12/calishat-temporary-obsessions-rss-feed-reader-updated-and-now-available/

ResearchBuzz: Firehose | Individual posts from ResearchBuzz · Calishat: Temporary Obsessions RSS Feed Reader Updated and Now Available | ResearchBuzz: Firehose
More from ResearchBuzz: Firehose

Fun with #AI:
I have a spreadsheet containing assignees, with various values on each line. I needed to calculate the sum of certain values for one assignee. This would normally be a simple query in #LibreOffice, but let's try using AI instead. I uploaded the spreadsheet to #GoogleSheets and entered a simple prompt in #Gemini: 'Give me the sum of XY values for assignee "name"' No result.
So I tried a more algorithmic prompt: 'Go through each line, and if the value in column XX is "name", count the value in column XY to the sum, and give me the total sum for all lines'.
The result? 150.
That's nice, but the simple query in LibreOffice gave me 27, which was the correct answer.

No matter how much I try, Gemini is completely useless in Google Sheets.

🤖 #Anthropic виклала бібліотеку з готових промптів для #Claude 👇

🔹 Excel Formula Expert — формули для #Excel / #GoogleSheets
🔹 Simplifier — спрощення ідей, техописів чи текстів для ширшої аудиторії
🔹 Interview Question Generator — генерація питань для співбесід, адаптовані під вакансію
🔹 Tone Rewriter — підготовка текст у заданому тоні (дружній, офіційний, тощо)
🔹 Critique Generator — аналіз тексту і конструктивний фідбек
🔹 Lesson Planner — створення навчального плану
docs.anthropic.com/en/resource

AnthropicPrompt Library - Anthropic

MakeUseOf: This Google Sheets Function Shaved Hours Off My Week. “If you’re spending way too long on repetitive data tasks in Google Sheets, you’re not alone. I used to lose hours every week to the same old steps—until I stumbled on a single function that did the heavy lifting for me. Let me introduce you to the QUERY function.”

https://rbfirehose.com/2025/06/24/makeuseof-this-google-sheets-function-shaved-hours-off-my-week/

ResearchBuzz: Firehose | Individual posts from ResearchBuzz · MakeUseOf: This Google Sheets Function Shaved Hours Off My Week | ResearchBuzz: Firehose
More from ResearchBuzz: Firehose

Online Journalism Blog: Google Sheets has a new AI function — how does it perform on classification tasks?. “AI has been built into Google Sheets for some time now in the Clippy-like form of Gemini in Sheets. But Google Sheets’s AI function is different. Available to a limited number of users for now, it allows you to incorporate AI prompts directly into a formula rather than having to […]

https://rbfirehose.com/2025/04/13/online-journalism-blog-google-sheets-has-a-new-ai-function-how-does-it-perform-on-classification-tasks/

ResearchBuzz: Firehose | Individual posts from ResearchBuzz · Online Journalism Blog: Google Sheets has a new AI function — how does it perform on classification tasks? | ResearchBuzz: Firehose
More from ResearchBuzz: Firehose