AppsScriptPulse

Official News, Solutions, Video Tutorial, Intermediate

Accelerate Google Workspace Add-on and chat bot development with the Card Builder tool | Demo

Tags:
| | 1 Comment |

Take a quick tour through the new Card Builder tool for Google Workspace Add-ons and see how it helps you quickly design and generate code for card-based interfaces.

We’ve mentioned the Card Builder tool in a couple of episodes of Totally Unscripted but if you’ve got come across it yet Steve Bazyl provides a quick overview. This tool can be used to help developing Workspace Add-ons that use the Card Service (https://gw-card-builder.web.app/) and also Google Chat bots (https://gw-card-builder.web.app/chat).

Solutions, Sheets, Video Tutorial, Intermediate

Telegram Bot with Inline Keyboard in Google Sheets [and Google Apps Script]

Tags:
| | 0 Comments |

Questa funzionalità permette di visualizzare, insieme al messaggio del bot, una tastiera virtuale con una serie di bottoni dove gli basterà cliccare su uno di essi per scegliere la sua risposta

[Google Translate: This feature allows you to view, together with the message of the bot, a virtual keyboard with a series of buttons where it will be enough to click on one of them to choose its response]

The accompanying video and post for this solution are in Italian and Google Translate might be required. This is a great resource and another example of a high quality video produced by the Apps Script community. The solution provides an overview of how you can display an inline keyboard within a Telegram Bot using a single Google Apps Script project.

Source: Telegram Bot with Inline Keyboard in Google Sheets

Video Tutorial, Beginner

Google App Script Properties and Cache Services

Tags:
| | 1 Comment |

Properties and Cache

Video showing the Properties and Cache Services available for Google Apps Script

  • The Properties and Cache Services are designed to hold data for use beyond a single run of a script.
  • The Legacy IDE had an option to see view and directly interact with the Script Properties. This is not available in the new IDE but the service still exists and can be interacted with via code.
  • The primary difference between the PropertiesService and CacheService is that key-value pairs in the Cache are automatically deleted after 25 minutes, while data in the PropertiesService persist until deleted via code (or manually from the Legacy IDE)

Interesting to see a growing number of video tutorials being produced by the App Script community. The latest we’ve come across comes from  Spencer Farris who in this post provides an overview of the Properties and Cache service. Click through to the source post to watch the video and access additional resources.

Source: Google App Script Properties and Cache Services

Solutions, Sheets, Video Tutorial, Beginner

Find and replace in a Google Sheet

Tags:
| | 0 Comments |

Cleanse Google Sheet data by searching for specific words in a columns and replacing them with an alternative. Colour any cell changes to highlight. This is one of many ways of performing the task simply using loops.

A list of words to find and their replacement equivalent.

A list of words to find and their replacement equivalent.

Source: The Gift of Script: Find and replace in a Google Sheet

Solutions, Sheets, YouTube, Video Tutorial, Beginner

Google Apps Script Example: Automated YouTube Stats Workflow

Tags:
| | 0 Comments |

Snippet, Video Tutorial, Calendar

Create a Google Calendar Event via the Calendar API

Tags:
| | 0 Comments |

Use the Calendar API to create an Event via Google Apps Script. Includes a tutorial video.

This is a simple Google Apps Script file that may look lengthy but in actual fact is just each possible item of an event that a user may wish to modify. Some of the items have default values which means you could remove them from the script and the Calendar API would use these defaults instead. My hope is that laying out the format like this allows you to then manipulate as you require and learn as I did.

Source: The Gift of Script: Create a Google Calendar Event via the Calendar API

Solutions, Calendar, Meet, Sheets, Video Tutorial

Bulk create Google Calendar events with optional Meet or Zoom

Tags:
| |

Bulk create Google Calendar events with optional video conferencing (Google Meet or Zoom) all from a Google Sheet.

Google Sheet columns allow for event details to be added

Google Sheet columns allow for event details to be added

Features of the tool

  • Performs an initial check that you have access to the provided Calendar to create events on.
  • Allows for events to be created on another Calendar that you have suitable access to (not just your own).
  • Uses toast popups to inform you of the progress as each creates each event per row.
  • Fast and efficient for creating a large number of events in one go.
  • Will not duplicate events if re-run, so you can continue to append further if you wish.
  • Provides a direct link to the created event from within the Google Sheet for easy access.
  • Performs a check of any missing ‘required’ information and informs the user via a popup so they can resolve this.
  • Includes ‘Log’ sheet to help output any error messages.
  • Has a ‘Reset’ option in the menu bar to remove all entered data and start from scratch.
  • Replicates 90%+ of the settings you can adjust when directly creating an event in Google Calendar.

Source: The Gift of Script: Bulk create Google Calendar events with optional Meet or Zoom – overview

Solutions, Calendar, Meet, Video Tutorial, Beginner

Bulk create Google Calendar events with optional Google Meet from a Google Sheet

Tags:
| |

Bulk create Google Calendar events with optional video conferencing (Google Meet) all from a Google Sheet.

Google Sheet columns allow for event details to be added

Google Sheet columns allow for event details to be added

Features of the tool

  • Performs an initial check that you have access to the provided Calendar to create events on.
  • Allows for events to be created on another Calendar that you have suitable access to (not just your own).
  • Uses toast popups to inform you of the progress as each creates each event per row.
  • Fast and efficient for creating a large number of events in one go.
  • Will not duplicate events if re-run, so you can continue to append further if you wish.
  • Provides a direct link to the created event from within the Google Sheet for easy access.
  • Performs a check of any missing ‘required’ information and informs the user via a popup so they can resolve this.
  • Includes ‘Log’ sheet to help output any error messages.
  • Has a ‘Reset’ option in the menu bar to remove all entered data and start from scratch.
  • Replicates 90%+ of the settings you can adjust when directly creating an event in Google Calendar.

Source: The Gift of Script: Bulk create Google Calendar events with optional Google Meet

Snippet, Solutions, Web App, Video Tutorial

Connect to Zoom API with Apps Script and OAuth

Tags:
| | 0 Comments |

How to connect to the Zoom API via OAuth. Using Google Apps Script and a Web App. An alternative to JSON Web Token. Includes a tutorial video.

Source: The Gift of Script: Connect to Zoom API with Apps Script and OAuth

Video Tutorial, AppSheet, No Code

Integrating AppSheet with Google Workspace – #BuildingWithAppSheet

Tags:
| | 0 Comments |

Did you know that AppSheet can integrate with Google Workspace? In this video, we speak to how AppSheet – Google Cloud’s no-code application platform – helps citizen developers streamline their workflows, and demo how you can create your own app in Google Sheets. Watch to explore the possibilities of AppSheet!