home.social

#googlesheets — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #googlesheets, aggregated by home.social.

fetched live
  1. I built the dice game Pig in Google Sheets, as a transition from spreadsheets to Python.

    docs.google.com/spreadsheets/d

    You'll need to make a copy to play.

    Rules:

    en.wikipedia.org/wiki/Pig_(dic

    Crucial to getting the spreadsheet to work was turning on iterative calculation (File > Settings > Calculation; also had to set max iterations to 1), allowing circular references in formulas.

    #dicetodon #games #spreadsheet #GoogleSheets #programming #CSEd #ComputerScienceEducation

  2. Write Python data to Google Sheets via gspread. 211 lines, intermediate level. Handles OAuth2 and JSON input for cron jobs and pipelines.
    valtersit.com/python/google-sh
    #python #googlesheets #integrations

  3. Google Blog: Doubled cell limits in Google Sheets now generally available. “We’re committed to continuously improving Sheets to ensure it is a powerful, responsive, and scalable spreadsheet tool for your needs. To that end, we’ve increased the cell limit in Google Sheets from up to 10 million cells to up to 20 million cells. This limit applies to new, existing, and imported files.”

    https://rbfirehose.com/2026/09/13/google-blog-doubled-cell-limits-in-google-sheets-now-generally-available/
  4. How to Bulk Import Products to WooCommerce from Google Sheets
    -----------------
    Bulk import products to WooCommerce from Google Sheets using WP All Import. Connect via URL,[…]
     
    #WordPress #Guides #WooCommerce #dataimports #GoogleSheets #WPAllimport

    wpnews.io/how-to-bulk-import-p

  5. A thought on habit tracking: the useful output isn't the streak, it's the ranking.

    Score fifteen habits separately over a month and some land near 90%, some near 20%. The high ones have stopped being habits you're building. The low ones were never realistic this season.

    That's a subtraction list, and subtraction is what nobody does.

    Do you ever cut, or only add?

    dgclicks.etsy.com/in-en/listin

    #habits #habittracker #googlesheets

  6. ChatGPT for Excel and Google Sheets 2026 — Complete How-To Guide

    ChatGPT is now a native sidebar inside Excel and Google Sheets, powered by GPT-5.5 and generally available as of May 5, 2026 — here is how to install it, what it can actually do...

    wowhow.cloud/blogs/chatgpt-exc

    #wowhow #ChatGPT #Excel #GoogleSheets

  7. Hm, is there an equivalent in Calc for describing a range that goes all the way to the bounds of the sheet?
    For example in Google Sheets, A2:A for referring to the whole column or B2:2 for the whole row, even if you add more rows or columns respectively to the sheet after you write that reference.

    #LibreOffice #LibreOfficeCalc #GoogleSheets

  8. You know what? I don’t need shortcuts. I’ll just click through the menu, thanks

    #GoogleSheets #Menu #Shortcuts

  9. Things I learned today:

    - Websites can override Cmd+R
    - Google Sheets uses it to replace current cell with the cell on the LEFT

    #GoogleSheets #Shortcuts

  10. Gemini s'intègre dans Google Sheets pour corriger les formules directement dans la cellule : l'IA analyse la structure du doc, comprend l'intention, propose la correction avec une explication.

    Pour les équipes qui vivent dans les tableurs, ça change le temps passé à déboguer. Le tableur devient assistant permanent.

    Vous l'attendiez ou vous gérez autrement ? #GoogleSheets #IA

  11. Lonely Star: How I Use Google Sheets for My Games. “Weird Writer said that I should make a post on how I do spreadsheets, as she thinks I might have something valuable to say on the subject (bless her). I don’t think I do anything too crazy with them, but considering a lot of people have been asking me about my sheets for my Arden Vul campaign which I post occasionally, I figured why not […]

    https://rbfirehose.com/2026/06/20/lonely-star-how-i-use-google-sheets-for-my-games/
  12. Сквозная аналитика B2C на коленке: Google Sheets, Python и Claude Code за две недели

    Сквозная аналитика для B2C: связать клик в рекламе с оплатой и посчитать ROMI. Ядро MVP (реклама + веб + биллинг в Google Sheets, дашборд в BI) собирается за две недели с Claude Code. А честные цифры - атрибуция, когорты, грабли API - занимают месяцы и требуют головы, не LLM.

    habr.com/ru/articles/1047394/

    #сквознаяаналитика #romi #атрибуция #claudecode #etl #googlesheets

  13. Сквозная аналитика B2C на коленке: Google Sheets, Python и Claude Code за две недели Сквозная аналитика для B2C: связать клик в...

    #сквозная-аналитика #romi #атрибуция #claude-code #etl #google-sheets

    Origin | Interest | Match
  14. How to Use Remote Data Blocks to Display Google Sheets Data in WordPress
    ----------
    Remote Data Blocks can pull data from services like Google Sheets and display it in[…]
     
    #WordPress #Guides #GoogleDriveAPI #GoogleSheets

    wpnews.io/how-to-use-remote-da

  15. 🗂️ Use #GoogleSheets as a #Laravel database! laravel-google-sheets-database-driver maps spreadsheet = DB, tab = table, row 1 = columns. Full #Eloquent & Query Builder support. #PHP #opensource
    github.com/AmazingBV/laravel-g

  16. New Google Sheets "Chip" feature lets you extract data about people.

    My takeaway: if you view a shared Google Sheet while logged into a Google Account, the doc owner (maybe others) can extract your location & phone. 1/n

    support.google.com/docs/answer

    #Google #GoogleSheets #Privacy #Security #Infosec

  17. Ok so my #indieWeb plans to use #Dreamwidth for blogging, my #neocities as a less frequently updated collection or archive of art, presentations, 3D designs, vids, etc. Spent a lot of time this evening fashioning my DW to match my site's aesthetic. Really looking forward to this now!

    It's motivated me to revisit my choice for using #GoogleSheets & #notion for publishable charts & databases & web bookmarks tho. Any beloved free alternative recs for those things? (Remember #delicious? 🤌😭)

  18. Do I have lots of tasks to complete today? Sure. Do I instead fixate on creating a perfect spreadsheet once again? Of course I do.

    #spreadsheets #googlesheets #excel #microsoftexcel

  19. 🚀🤦‍♂️ Oh, joy! Another "revolutionary" tool turning a Google Sheet into a "database" because nothing screams cutting-edge tech like a glorified Excel spreadsheet. 📊🙄 Forget years of database expertise, just slap a link and voila, you're a backend wizard! 🧙‍♂️✨
    sheetninja.io #revolutionarytools #GoogleSheets #databasebackend #techhumor #techirony #HackerNews #ngated

Share on Mastodon

Enter the server where you have an account.