Yagisanatode @yagisanatode@qoto.org

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

Scan success! On to the survey 🤞

CASA Tier 2 compliance for Google Workspace Add-ons is a PIA, but one good thing that came out of it was updating old code from JQuery to JavaScirpt. Dependencies are not recommended and honestly were never needed for this project.

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/

Sort a Range Matrix from Left to Right and Top to Bottom in Google Sheets

#GoogleSheets #Spreadsheets #BusinessAdministration

https://youtu.be/NdzTIq_nA-0

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. 🃏♥♦♠♣

#GoogleWorkspace #Spreadsheets

https://youtu.be/x9cJwx0E1vY

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

https://youtu.be/t2TBTQhQEuE

#GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdministration

Reverse Ranges by Columns or Rows in Google Sheets (Flip)
#GoogleSheets #GoogleWorkspace #spreadsheets #businessadministration

https://youtu.be/FQAz8_dnTSw

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

https://youtu.be/GrRmapAPdg4