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 — створення навчального плану
https://docs.anthropic.com/en/resources/prompt-library/library

#n8n mit #Google Diensten verbinden

https://www.youtube.com/watch?v=GeEETbfK1v8

Structured tables YES but INSTEAD OF spreadsheets please, not overlaid

Google introduce funzione AI in Sheets che genera testo basato su celle specifiche. Gli utenti possono:

Creare copy pubblicitarie personalizzate
Riassumere feedback dei clienti
Categorizzare dati automaticamente

5 Best Ways to Extract Table Data from PDFs (and Send It to Your CRM)

Looking for the best way to extract table data from PDFs in 2025? Discover 5 tools—including Zenphi + Gemini—to automate data extraction and send it to your CRM through Google Sheets.

Learn More - https://zenphi.com/extract-table-data-from-pdf-to-crm-2025/

#extractdata #besttools #gemini #zenphi #5tools #crm #googlesheets #automation #itautomation

Lost a half hour this morning troubleshooting what the client was seeing, due to Google Sheets not supporting Excel's CONCAT(AH2:AN2)-style formula. For Google Sheets, you have to use CONCATENATE. https://support.google.com/docs/answer/3094123?hl=en #GoogleSheets #Excel

Vous utilisez #Excel ou #GoogleSheets pour vos rappels clients ?

Gagnez du temps avec #Odoo #CRM : automatisation, priorisation, #relances optimisées.

On vous explique comment : https://explore.orbeet.io/r/uks

Testez votre efficacité commerciale : https://explore.orbeet.io/r/odoo4sales

Transforming Workflows: Google's Gemini AI Revolutionizes Google Sheets

Google's latest AI integration, Gemini, is set to redefine how users interact with Google Sheets, streamlining workflows and enhancing productivity. This upgrade promises to save hours of tedious repo...

https://news.lavx.hu/article/transforming-workflows-google-s-gemini-ai-revolutionizes-google-sheets

Create your own finetuned AI model using Google Sheets

https://promptrepo.com/finetune/

How to use Perplexity AI as a free research assistant.

Read more https://lttr.ai/Ad5Ys

Using Google Sheets to Catalog Expenses for Budgeting Considerations

This is how I catalog my planned expenses when reviewing personal budget scenarios. Google sheet and video demo attached. #googlesheets #budgeting #expenses

https://mikezornek.com/posts/2025/4/google-sheets-expense-budgeting/

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/

Ahorra horas de trabajo generando facturas automáticamente

#NoCode #Automatización #Productividad #Zapier
#GoogleSheets #Stripe #AutomateEverything
#AhorraTiempo #EmprendimientoDigital #TechForBusiness
#ProcesosAutomatizados #FacturaciónAutomática
#GrowthTools #TimeSavingTips

Google Workspace Gets Agentic AI with Flows As Gemini Expands Across Apps

#GoogleWorkspace #GeminiAI #GoogleAI #AI #GoogleDocs #GoogleSheets #GoogleMeet #GoogleChat #GoogleVids #AIAgents #Alphabet

https://winbuzzer.com/2025/04/10/google-workspace-gets-agentic-ai-with-flows-as-gemini-expands-across-apps-xcxwbn/

Want to build your own Levels FYI website?

Levels FYI was built on spreadsheets. No database backend to start!

Are you interested in using Google Drive and Google Sheets in your next CSharp application? Get started with the Google Sheets API to access spreadsheets in dotnet and maybe you can build your very own Levels FYI site!

... Or maybe something else entirely but tapping into spreadsheets makes it easier for you to start :)

Check out the article:
https://www.devleader.ca/2024/02/15/google-sheets-in-c-how-to-build-your-own-levels-fyi/

#GoogleSheets #GoogleDrive #CSharp.DotNet #GoogleCloud

Extract Internal & External Links
Are you linking out too much?
This script scans pages for internal & external links, helping with link-building strategies.

Bulk Google Indexing Checker
Are your pages even in Google’s index?
This script checks Google Search to see if your URLs are indexed.

Too many redirects? Your SEO is taking a hit!
This script checks if URLs have unnecessary redirect chains and logs the final destination.