Yagisanatode @yagisanatode@qoto.org

Update and Replace data in files like Text files, HTML, XML, JSON, and JS files in a Google Drive with Apps Script

#GoogleAppsScript #AppsScript #GoogleDrive #GoogleWorkspace @WorkspaceDevs

https://youtu.be/mi6Wb-da-GQ

Use HTML files stored on Google Drive in Apps Script web apps, dialogues and sidebars for Google Workspace. #GoogleAppsScript #GoogleWorkspace #WorkspaceDev
https://youtu.be/6o1VS23hNTo

Extract CELL Background & Font Colours in Google Sheets with Apps Script #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin #GoogleAppsScript @WorkspaceDevs
https://youtu.be/rD2S4cqyf1c

Copy and Paste Row Heights in Google Sheets with Apps Script. This is a surprisingly tricky and process-costly task. Learn how to do it efficiently while not falling for some common issues. @workspacedevs #GoogleAppsScript #GoogleSheets #GoogleWorkspace

https://youtu.be/HAx1LfcxdRA

Copying Ranges in Google Sheets with Apps Script - Part 4 in the beginner-friendly series on copying Sheets, Tabs and Ranges in #GoogleSheets with #GoogleAppsScript. Check it out!
@workspacedevs #googleworkspace #businessautomation

https://youtu.be/q6Zh3I9mjeg

CASA Tier 2 Assessment finally passed for the update of my free 'Sections to Sheets' Google Workspace Editor Add-on.
It was an unusual process. Not necessarily time-consuming, but it did take weeks to process so be prepared for that, developer. #GoogleAppsScript #GoogleWorkspace @WorkspaceDev #SAAS

Duplicate Google Sheets Tabs into other Spreadsheets with Apps Script.

Copy to:

1) a new Google Sheet,

2) an existing Google Sheet,

3) All tabs,

4) Selected tabs and

5) Except for certain tabs.

Beginner friendly. 🧸

@workspacedevs #GoogleAppsScript #GoogleSheets #GoogleWorkspace

https://youtu.be/te9bXK4DngE

Learn how to copy sheet tabs within the same Google Sheet with Google Apps Script.
This is a beginner-friendly series on duplicating Google Sheets, Sheet tabs and ranges with Apps Script.
@workspacedevs #GoogleAppsScript #GoogleSheets #GoogleDrive #Spreadsheets #SpreadhseetAutomation
https://youtu.be/xDwWA57kArI

Make a Copy of a Google Sheet with Apps Script.
Part of a series on duplicating Google Sheets, Sheet tabs and ranges with Apps Script.
If you are new to Apps Script this is ideal for you.
@workspacedevs #GoogleAppsScript #GoogleSheets #GoogleDrive #Spreadsheets #SpreadhseetAutomation

https://youtu.be/34ozx-6sv34

Adding Charts to Google Workspace Add-on Sidebar Apps with Apps Script

#googleappsscript #googleworkspace #addons #saas @workspacedevs
#GWAO @quickchart #GoogleCharts

https://yagisanatode.com/adding-charts-to-google-workspace-add-on-sidebar-apps-with-apps-script/

I've made a few updates in recent days to my Google Workspace Add-on Course. The biggest addition is that you can get answers to some common error codes in Card Service with the Common Errors Page.

@workspacedevs #GoogleAppsScript #GoogleWorkspace #GoogleWorkspaceAddons #Addons

https://yagisanatode.com/products/create-and-publish-google-workspace-add-ons-with-google-apps-script-master-class/

Add the Editor's Email when they Tick the Check Box in Google Sheets with Apps Script - This tutorial came from a discussion with an attendee at the Google Workspace Developer Summit 2023 in Singapore last week.

If you and your team are working in a Google Workspace Domain account (Paid Version) this handy onEdit() automation might shave some admin time off your work for you. Enjoy!

Contains a written and a video tutorial with a starter Google Sheet to play along.

@workspaceDevs #GoogleAppsScript #GoogleSheets #GoogleWorkspace #SpreadsheetAutomation #BusinessAdministration #GoogleWorkspaceDeveloperSummit

https://yagisanatode.com/add-the-editors-email-when-they-tick-the-check-box-in-google-sheets-with-apps-script/

Creating Webhooks for Google Chat App with Apps Script. Learn how to conduct a pirate raid in #GoogleChat. Message, Reply & Create visual Cards #GoogleAppsScript @workspacedevs #webhooks
https://yagisanatode.com/chat-app-webhooks/

I've torn myself away from Baldur's Gate 3 long enough to create this D&D-inspired tutorial on creating a Reduced Choice Dropdown Data Validation in Google Sheets with Apps Script. Enjoy!
#GoogleAppsScript #GoogleSheets #DataValidation @workspacedevs
https://www.youtube.com/watch?v=XFEvYlpK7nw

Prevent editors from modifying a dropdown list in Google Sheets with Apps Script https://youtu.be/SQIq99L8MXE @workspacedevs #googleappsscript #GoogleSheets #GoogleWorkspace

Learn how to retrieve existing Dropdown from a Range Data Validation rules in Google Sheets using Google Apps Script by creating a a macro that prevents other editors from modifying a dropdown list in Google Sheets with Apps Script.

Create Google Sheets Dropdowns with Google Apps Script https://youtu.be/rQXPl-hZxzQ?si=OjT1xeNld2R6jxSW via @YouTube @workspacedevs #GoogleSheets #GoogleAppsScript

Auto-Add Date and Time to an Adjacent Cell Upon Edit in Google Sheets with Apps Script. This a long-awaited update to a 5-year-old tutorial.

#GoogleSheets #GoogleAppsScript @workspacedevs

https://youtu.be/GrRmapAPdg4

List all files and folders in a folders directory tree in Google Drive: Apps Script. @WorkspaceDevs #GoogleAppsScript #GoogleDriveAPI #AppsScript #GoogleDrive

yagisanatode.com/list-all-files-and-folders-in-a-folders-directory-tree-in-google-drive-apps-script/

Find and hide Rows by Grouping Ranges in Google Sheets with Apps Script - A faster approach.
Got a large Google Sheets dataset that you want to hide rows by cell value on? #GoogleAppsScript #GoogleSheets #SpreadsheetAutomation @WorkspaceDevs
https://youtu.be/WTImNqHkl1k

Add a Row of Data Below the Header in Google Sheets with Apps Script

#GoogleAppsScript #GoogleSheets #GoogleWorkspace

https://yagisanatode.com/add-a-row-of-data-below-the-header-in-google-sheets-with-apps-script/