Yagisanatode @yagisanatode@qoto.org

New Tutorial! Find and Inspect Google Apps Script-generated HTML in Chrome Dev Tools https://wp.me/p9ksIb-7pf #GoogleAppsScript #GoogleWorkspace @WorkspaceDev

Exciting Job Opportunity for Australian 🇦🇺 Google Apps Script and Google Sheets Developers! Reach out to Jimmy Flynn in the LinkedIn link for more details.
Network! Please share this around so no one misses out.

https://www.linkedin.com/feed/update/urn:li:activity:7340908539957190656/

Add Custom Queryable Properties to Any File in Google Drive with Apps Script
https://yagisanatode.com/add-custom-queryable-properties-to-any-file-in-google-drive-with-apps-script/ @GoogleWorkspaceDevs #GoogleDrive #GoogleAppsScript #GoogleWorkspace

Get Google Sheet Tab Name and ID with Google Sheets API Advanced Service with Apps Script https://yagisanatode.com/get-google-sheet-tab-name-and-id-with-google-sheets-api-advanced-service-with-apps-script/ @workspacedevs

Gemini Deep Research & Experimental Models Now Available

This is a clip from the Workspace After Dark live stream where we take a critical look at Google Gemini's new Depp Research & Experimental Model that are now available in Gemini Advanced.

I use the 1.5 Pro with Deep Research model to find opportunities for my Google Workspace Software Development business. I found that Gemini got a little disoriented along the way and tended to lean on a lot of 'fluff' language with little real content. There were some gems of information but it would require numerous further prompts to get better information out of it, if possible. #gemini #googleworkspace

https://youtu.be/YUHaqDjYgOo

Google Apps Script Rhino Runtime is deprecated - What's next?
https://youtu.be/yP0bqoKQ3X4 @workspaceDevs #GoogleAppsScript

Create and vote on polls directly in Google Chat with Google's Polls Chat App

https://youtu.be/wIFjUErAyoY

Reconsider Smart Chips when using Apps Script in Google Sheets. @GoogleWorspaceDev Google Developer Experts #GoogleAppsScript #GoogleSheets #GoogleWorkspace https://youtu.be/YQ5SFNXeULE

New Google Chat Quick Commands an alternative to Slash Commands. I give them a spin in Google Apps Script @WorkspaceDevs #GoogleAppsScript #GoogleChat Google Developer Experts

https://youtu.be/AvAYawLx5SU

We can also use the Google Docs API Advanced Service to retrieve text data from a Google Doc with Apps Script or indeed, with any other programming language. This returns a JSON Object for the current doc.

This tutorial is 4 of 4 approaches to programmatically extracting text from a Google Doc. There is no one complete approach, unfortunately, but each approach comes with its pros and cons. Check out the written tutorial for more details @WorkspaceDevs
https://youtu.be/BEtj42ufWhU

Sometimes, you need to focus on extracting the text of a Google Doc, including what is displayed on the 'Smart Chips'. In this tutorial, we use the Google Drive API OCR (Optical Character Recognition) to extract text from our Google Docs.

This tutorial is 3 of 4 approaches to programmatically extracting text from a Google Doc. There is no one complete approach, unfortunately, but each approach comes with its pros and cons. Check out the written tutorial for more details @WorkspaceDevs
https://youtu.be/7nTVFmfcNaI

Extract Google Docs body text, links and Chips (Person, Date, Rich Links) with Google Apps Script and the DocumentApp Service.

This tutorial is 2 of 4 approaches to programmatically extracting text from a Google Doc. There is no one complete approach, unfortunately, but each approach comes with its pros and cons. Check out the written tutorial for more details @WorkspaceDevs
https://youtu.be/ElwWk5oD4eM

Get a Google Docs Body Text with Apps Script (4 approaches)
https://yagisanatode.com/get-a-google-docs-body-text-with-apps-script/

Retrieve the body text of a Google Doc with Google Apps Script DocumentApp service

Offset Gradient Conditional Formatting in Google Sheets with Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace #GoogleSheets @WorkspaceDevs
https://youtu.be/4koWQysEJC8

+1 (or even comment) on this Apps Script API bug:
DocumentApp Text class setAttributes() displays unreliable results.

https://issuetracker.google.com/issues/383380992

A Simple Apps Script Class to Clear & Set Conditional Formatting in Google Sheets #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/coko7zUXsHk

+1 this Bug - Google Workspace Add-on Card Service does not maintain your primary and secondary colour preferences for a number of widgets like footer buttons, checkboxes, radio buttons, toggle buttons, text input borders and legends. https://issuetracker.google.com/issues/380912402 #googleAppsScript

Part 4: Add Conditional Formatting Rules to a Google Sheet Tab with Google Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/efKql-S5fXE

Part 2: Remove a conditional formatting rule WITHIN a range in Google Sheets with Google Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/eOkwBwm_76I