TechHub

@990000@mstdn.socialAnyone know why Google Sheets API access requires both an API key as well as sharing the sheet with a service account? The API key is separate from the service account which doesn't make sense to me. Why would you need both and why doesn't a service account have its own key?<a href="https://mstdn.social/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a>

Mauricio CassemiroAutomação <a href="https://mastodon.social/tags/Pluga" class="mention hashtag" rel="nofollow noopener" target="_blank">#Pluga</a> 🔌 2 - <a href="https://mastodon.social/tags/GoogleForms" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleForms</a> & <a href="https://mastodon.social/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a> (Cadastros): <a href="https://youtu.be/NDCx5o9N4L0" rel="nofollow noopener" translate="no" target="_blank">https://youtu.be/NDCx5o9N4L0</a>

HonkerdownI know I am going to need this for something, someday. <a href="https://www.androidpolice.com/google-sheets-how-to-scrape-data/" rel="nofollow noopener" translate="no" target="_blank">https://www.androidpolice.com/google-sheets-how-to-scrape-data/</a><a href="https://mastodon.social/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a> <a href="https://mastodon.social/tags/scrape" class="mention hashtag" rel="nofollow noopener" target="_blank">#scrape</a>

Andrew MurrayI used Google Sheets as a free VA. Here's how:Read more 👉 <a href="https://lttr.ai/AgtvE" rel="nofollow noopener" translate="no" target="_blank">https://lttr.ai/AgtvE</a><a href="https://mastodon.social/tags/perplexityai" class="mention hashtag" rel="nofollow noopener" target="_blank">#perplexityai</a> <a href="https://mastodon.social/tags/perplexity" class="mention hashtag" rel="nofollow noopener" target="_blank">#perplexity</a> <a href="https://mastodon.social/tags/googlesheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#googlesheets</a>

Python Job SupportHYPERLINK! <a href="https://mastodon.social/tags/Tip77" class="mention hashtag" rel="nofollow noopener" target="_blank">#Tip77</a> <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#excel</a> <a href="https://mastodon.social/tags/spreadsheet" class="mention hashtag" rel="nofollow noopener" target="_blank">#spreadsheet</a> <a href="https://mastodon.social/tags/googlesheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#googlesheets</a> <a href="https://mastodon.social/tags/sheet" class="mention hashtag" rel="nofollow noopener" target="_blank">#sheet</a> <a href="https://mastodon.social/tags/cheat" class="mention hashtag" rel="nofollow noopener" target="_blank">#cheat</a> <a href="https://mastodon.social/tags/usefultips" class="mention hashtag" rel="nofollow noopener" target="_blank">#usefultips</a> <a href="https://mastodon.social/tags/exceltips" class="mention hashtag" rel="nofollow noopener" target="_blank">#exceltips</a> <a href="https://mastodon.social/tags/hyperlink" class="mention hashtag" rel="nofollow noopener" target="_blank">#hyperlink</a>Shorts HYPERLINK! <a href="https://mastodon.social/tags/Tip77" class="mention hashtag" rel="nofollow noopener" target="_blank">#Tip77</a> <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#excel</a> <a href="https://mastodon.social/tags/spreadsheet" class="mention hashtag" rel="nofollow noopener" target="_blank">#spreadsheet</a> <a href="https://mastodon.social/tags/googlesheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#googlesheets</a> <a href="https://mastodon.social/tags/sheet" class="mention hashtag" rel="nofollow noopener" target="_blank">#sheet</a> <a href="https://mastodon.social/tags/cheat" class="mention hashtag" rel="nofollow noopener" target="_blank">#cheat</a> <a href="https://mastodon.social/tags/usefultips" class="mention hashtag" rel="nofollow noopener" target="_blank">#usefultips</a> <a href="https://mastodon.social/tags/exceltips" class="mention hashtag" rel="nofollow noopener" target="_blank">#exceltips</a> <a href="https://mastodon.social/tags/hyperlink" class="mention hashtag" rel="nofollow noopener" target="_blank">#hyperlink</a> Welcome to our ... source<a href="https://quadexcel.com/wp/hyperlink-tip77-excel-spreadsheet-googlesheets-sheet-cheat-usefultips-exceltips-hyperlink/" rel="nofollow noopener" translate="no" target="_blank">https://quadexcel.com/wp/hyperlink-tip77-excel-spreadsheet-googlesheets-sheet-cheat-usefultips-exceltips-hyperlink/</a>

ResearchBuzz: FirehoseCalishat: 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 […]<a href="https://rbfirehose.com/2025/07/12/calishat-temporary-obsessions-rss-feed-reader-updated-and-now-available/" class="" rel="nofollow noopener" target="_blank">https://rbfirehose.com/2025/07/12/calishat-temporary-obsessions-rss-feed-reader-updated-and-now-available/</a>

Jiří EischmannFun with <a href="https://social.vivaldi.net/tags/AI" class="mention hashtag" rel="nofollow noopener" target="_blank">#AI</a>: 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 <a href="https://social.vivaldi.net/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener" target="_blank">#LibreOffice</a>, but let's try using AI instead. I uploaded the spreadsheet to <a href="https://social.vivaldi.net/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a> and entered a simple prompt in <a href="https://social.vivaldi.net/tags/Gemini" class="mention hashtag" rel="nofollow noopener" target="_blank">#Gemini</a>: '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.

Andrii Kuznietsov🤖 <a href="https://social.kyiv.dcomm.net.ua/tags/Anthropic" class="mention hashtag" rel="nofollow noopener" target="_blank">#Anthropic</a> виклала бібліотеку з готових промптів для <a href="https://social.kyiv.dcomm.net.ua/tags/Claude" class="mention hashtag" rel="nofollow noopener" target="_blank">#Claude</a> 👇🔹 Excel Formula Expert — формули для <a href="https://social.kyiv.dcomm.net.ua/tags/Excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#Excel</a> / <a href="https://social.kyiv.dcomm.net.ua/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a> 🔹 Simplifier — спрощення ідей, техописів чи текстів для ширшої аудиторії 🔹 Interview Question Generator — генерація питань для співбесід, адаптовані під вакансію 🔹 Tone Rewriter — підготовка текст у заданому тоні (дружній, офіційний, тощо) 🔹 Critique Generator — аналіз тексту і конструктивний фідбек 🔹 Lesson Planner — створення навчального плану <a href="https://docs.anthropic.com/en/resources/prompt-library/library" rel="nofollow noopener" translate="no" target="_blank">https://docs.anthropic.com/en/resources/prompt-library/library</a>

Philip Thomas<a href="https://mastodon.social/tags/n8n" class="mention hashtag" rel="nofollow noopener" target="_blank">#n8n</a> mit <a href="https://mastodon.social/tags/Google" class="mention hashtag" rel="nofollow noopener" target="_blank">#Google</a> Diensten verbinden<a href="https://www.youtube.com/watch?v=GeEETbfK1v8" rel="nofollow noopener" translate="no" target="_blank">https://www.youtube.com/watch?v=GeEETbfK1v8</a><a href="https://mastodon.social/tags/automatisierung" class="mention hashtag" rel="nofollow noopener" target="_blank">#automatisierung</a> <a href="https://mastodon.social/tags/ki" class="mention hashtag" rel="nofollow noopener" target="_blank">#ki</a> <a href="https://mastodon.social/tags/gmail" class="mention hashtag" rel="nofollow noopener" target="_blank">#gmail</a> <a href="https://mastodon.social/tags/googlesheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#googlesheets</a> <a href="https://mastodon.social/tags/googledocs" class="mention hashtag" rel="nofollow noopener" target="_blank">#googledocs</a> <a href="https://mastodon.social/tags/googlecalendar" class="mention hashtag" rel="nofollow noopener" target="_blank">#googlecalendar</a> <a href="https://mastodon.social/tags/googledrive" class="mention hashtag" rel="nofollow noopener" target="_blank">#googledrive</a>

Kilian EvangStructured tables YES but INSTEAD OF spreadsheets please, not overlaid<a href="https://mastodon.social/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a>

Mela News :verified: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<a href="https://mastodon.uno/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a> <a href="https://mastodon.uno/tags/IntelligenzaArtificiale" class="mention hashtag" rel="nofollow noopener" target="_blank">#IntelligenzaArtificiale</a> <a href="https://mastodon.uno/tags/Produttivit%C3%A0" class="mention hashtag" rel="nofollow noopener" target="_blank">#Produttività</a>

zenphi5 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 - <a href="https://zenphi.com/extract-table-data-from-pdf-to-crm-2025/" rel="nofollow noopener" translate="no" target="_blank">https://zenphi.com/extract-table-data-from-pdf-to-crm-2025/</a> <a href="https://mastodon.social/tags/extractdata" class="mention hashtag" rel="nofollow noopener" target="_blank">#extractdata</a> <a href="https://mastodon.social/tags/besttools" class="mention hashtag" rel="nofollow noopener" target="_blank">#besttools</a> <a href="https://mastodon.social/tags/gemini" class="mention hashtag" rel="nofollow noopener" target="_blank">#gemini</a> <a href="https://mastodon.social/tags/zenphi" class="mention hashtag" rel="nofollow noopener" target="_blank">#zenphi</a> <a href="https://mastodon.social/tags/5tools" class="mention hashtag" rel="nofollow noopener" target="_blank">#5tools</a> <a href="https://mastodon.social/tags/crm" class="mention hashtag" rel="nofollow noopener" target="_blank">#crm</a> <a href="https://mastodon.social/tags/googlesheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#googlesheets</a> <a href="https://mastodon.social/tags/automation" class="mention hashtag" rel="nofollow noopener" target="_blank">#automation</a> <a href="https://mastodon.social/tags/itautomation" class="mention hashtag" rel="nofollow noopener" target="_blank">#itautomation</a>

jhenningLost 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. <a href="https://support.google.com/docs/answer/3094123?hl=en" rel="nofollow noopener" translate="no" target="_blank">https://support.google.com/docs/answer/3094123?hl=en</a> <a href="https://mastodon.world/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a> <a href="https://mastodon.world/tags/Excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#Excel</a>

Orbeet📋 Vous utilisez <a href="https://mastodon.social/tags/Excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#Excel</a> ou <a href="https://mastodon.social/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a> pour vos rappels clients ?Gagnez du temps avec <a href="https://mastodon.social/tags/Odoo" class="mention hashtag" rel="nofollow noopener" target="_blank">#Odoo</a> <a href="https://mastodon.social/tags/CRM" class="mention hashtag" rel="nofollow noopener" target="_blank">#CRM</a> : automatisation, priorisation, <a href="https://mastodon.social/tags/relances" class="mention hashtag" rel="nofollow noopener" target="_blank">#relances</a> optimisées.👉 On vous explique comment : <a href="https://explore.orbeet.io/r/uks" rel="nofollow noopener" translate="no" target="_blank">https://explore.orbeet.io/r/uks</a>📊 Testez votre efficacité commerciale : <a href="https://explore.orbeet.io/r/odoo4sales" rel="nofollow noopener" translate="no" target="_blank">https://explore.orbeet.io/r/odoo4sales</a>

LavX NewsTransforming Workflows: Google's Gemini AI Revolutionizes Google SheetsGoogle'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...<a href="https://news.lavx.hu/article/transforming-workflows-google-s-gemini-ai-revolutionizes-google-sheets" rel="nofollow noopener" translate="no" target="_blank">https://news.lavx.hu/article/transforming-workflows-google-s-gemini-ai-revolutionizes-google-sheets</a><a href="https://ioc.exchange/tags/news" class="mention hashtag" rel="nofollow noopener" target="_blank">#news</a> <a href="https://ioc.exchange/tags/tech" class="mention hashtag" rel="nofollow noopener" target="_blank">#tech</a> <a href="https://ioc.exchange/tags/GeminiAI" class="mention hashtag" rel="nofollow noopener" target="_blank">#GeminiAI</a> <a href="https://ioc.exchange/tags/DataAutomation" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataAutomation</a> <a href="https://ioc.exchange/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a>

Hacker NewsCreate your own finetuned AI model using Google Sheets<a href="https://promptrepo.com/finetune/" rel="nofollow noopener" translate="no" target="_blank">https://promptrepo.com/finetune/</a><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#HackerNews</a> <a href="https://mastodon.social/tags/Create" class="mention hashtag" rel="nofollow noopener" target="_blank">#Create</a> <a href="https://mastodon.social/tags/your" class="mention hashtag" rel="nofollow noopener" target="_blank">#your</a> <a href="https://mastodon.social/tags/own" class="mention hashtag" rel="nofollow noopener" target="_blank">#own</a> <a href="https://mastodon.social/tags/finetuned" class="mention hashtag" rel="nofollow noopener" target="_blank">#finetuned</a> <a href="https://mastodon.social/tags/AI" class="mention hashtag" rel="nofollow noopener" target="_blank">#AI</a> <a href="https://mastodon.social/tags/model" class="mention hashtag" rel="nofollow noopener" target="_blank">#model</a> <a href="https://mastodon.social/tags/using" class="mention hashtag" rel="nofollow noopener" target="_blank">#using</a> <a href="https://mastodon.social/tags/Google" class="mention hashtag" rel="nofollow noopener" target="_blank">#Google</a> <a href="https://mastodon.social/tags/Sheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#Sheets</a> <a href="https://mastodon.social/tags/AI" class="mention hashtag" rel="nofollow noopener" target="_blank">#AI</a> <a href="https://mastodon.social/tags/Model" class="mention hashtag" rel="nofollow noopener" target="_blank">#Model</a> <a href="https://mastodon.social/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a> <a href="https://mastodon.social/tags/Finetuning" class="mention hashtag" rel="nofollow noopener" target="_blank">#Finetuning</a> <a href="https://mastodon.social/tags/TechInnovation" class="mention hashtag" rel="nofollow noopener" target="_blank">#TechInnovation</a> <a href="https://mastodon.social/tags/PromptRepo" class="mention hashtag" rel="nofollow noopener" target="_blank">#PromptRepo</a>

Andrew MurrayHow to use Perplexity AI as a free research assistant.Read more 👉 <a href="https://lttr.ai/Ad5Ys" rel="nofollow noopener" translate="no" target="_blank">https://lttr.ai/Ad5Ys</a><a href="https://mastodon.social/tags/perplexityai" class="mention hashtag" rel="nofollow noopener" target="_blank">#perplexityai</a> <a href="https://mastodon.social/tags/perplexity" class="mention hashtag" rel="nofollow noopener" target="_blank">#perplexity</a> <a href="https://mastodon.social/tags/googlesheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#googlesheets</a>

Mike Zornek, looking for work✏️💸 Using Google Sheets to Catalog Expenses for Budgeting ConsiderationsThis is how I catalog my planned expenses when reviewing personal budget scenarios. Google sheet and video demo attached. <a href="https://jawns.club/tags/googlesheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#googlesheets</a> <a href="https://jawns.club/tags/budgeting" class="mention hashtag" rel="nofollow noopener" target="_blank">#budgeting</a> <a href="https://jawns.club/tags/expenses" class="mention hashtag" rel="nofollow noopener" target="_blank">#expenses</a> <a href="https://mikezornek.com/posts/2025/4/google-sheets-expense-budgeting/" rel="nofollow noopener" translate="no" target="_blank">https://mikezornek.com/posts/2025/4/google-sheets-expense-budgeting/</a>

ResearchBuzz: FirehoseOnline 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 […]<a href="https://rbfirehose.com/2025/04/13/online-journalism-blog-google-sheets-has-a-new-ai-function-how-does-it-perform-on-classification-tasks/" class="" rel="nofollow noopener" target="_blank">https://rbfirehose.com/2025/04/13/online-journalism-blog-google-sheets-has-a-new-ai-function-how-does-it-perform-on-classification-tasks/</a>

Alex Fonseca🕒 ⏳ Ahorra horas de trabajo generando facturas automáticamente<a href="https://mastodon.social/tags/NoCode" class="mention hashtag" rel="nofollow noopener" target="_blank">#NoCode</a> <a href="https://mastodon.social/tags/Automatizaci%C3%B3n" class="mention hashtag" rel="nofollow noopener" target="_blank">#Automatización</a> <a href="https://mastodon.social/tags/Productividad" class="mention hashtag" rel="nofollow noopener" target="_blank">#Productividad</a> <a href="https://mastodon.social/tags/Zapier" class="mention hashtag" rel="nofollow noopener" target="_blank">#Zapier</a> <a href="https://mastodon.social/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleSheets</a> <a href="https://mastodon.social/tags/Stripe" class="mention hashtag" rel="nofollow noopener" target="_blank">#Stripe</a> <a href="https://mastodon.social/tags/AutomateEverything" class="mention hashtag" rel="nofollow noopener" target="_blank">#AutomateEverything</a> <a href="https://mastodon.social/tags/AhorraTiempo" class="mention hashtag" rel="nofollow noopener" target="_blank">#AhorraTiempo</a> <a href="https://mastodon.social/tags/EmprendimientoDigital" class="mention hashtag" rel="nofollow noopener" target="_blank">#EmprendimientoDigital</a> <a href="https://mastodon.social/tags/TechForBusiness" class="mention hashtag" rel="nofollow noopener" target="_blank">#TechForBusiness</a> <a href="https://mastodon.social/tags/ProcesosAutomatizados" class="mention hashtag" rel="nofollow noopener" target="_blank">#ProcesosAutomatizados</a> <a href="https://mastodon.social/tags/Facturaci%C3%B3nAutom%C3%A1tica" class="mention hashtag" rel="nofollow noopener" target="_blank">#FacturaciónAutomática</a> <a href="https://mastodon.social/tags/GrowthTools" class="mention hashtag" rel="nofollow noopener" target="_blank">#GrowthTools</a> <a href="https://mastodon.social/tags/TimeSavingTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#TimeSavingTips</a>

Recent searches

Search options

Administered by:

Server stats:

#googlesheets