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
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
Sort a Range Matrix from Left to Right and Top to Bottom in Google Sheets
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
Sometimes we want to compare the difference between two arrays in JavaScript and return the remaining values in a new array.
This can be useful for inventory or purchase management where we could compare the selected items against the available stock. https://wp.me/p9ksIb-7fQ
How does MAKEARRAY work in #GoogleSheets? Let's build and shuffle a deck of cards and find out. 🃏♥♦♠♣
Need to convert a column of data to a 2d range or convert a 2d range to a column? In this tutorial, we cover how to stack and unstack data in Google Sheets
#GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdministration
Reverse Ranges by Columns or Rows in Google Sheets (Flip)
#GoogleSheets #GoogleWorkspace #spreadsheets #businessadministration
REVERSE_ROWS and REVERSE_COLS have now been added to the #GoogleSheets Named Function Pack. You can find out more here: https://yagisanatode.com/products/named-function-pack/
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
Get the average of a text-based rating system in Google Sheets
https://youtu.be/UgbrHR6QuiQ #GoogleSheets #spreadsheets
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
www.yagisanatode.com/list-all-files-and-folders-in-a-folders-directory-tree-in-google-drive-apps-script/
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/
Create a Dynamic Password Generator in Google Sheets. #GoogleSheets
https://yagisanatode.com/create-a-dynamic-password-generator-in-google-sheets/
Google Developer Expert & Google Cloud Champion Innovator in Google Workspace at Yagisanatode