Built on G Suite

The G Suite Solutions Gallery is a collection of sample solutions that demonstrates how you can solve common business challenges with G Suite Developer technologies. These samples showcase different ways to integrate and customize the productivity tools you're already using.

Browse the solutions below for inspiration on what to create to help your team collaborate and work faster together.

Sheets Gmail

Create a mail merge using Gmail and Google Sheets

Create and distribute visually rich mail merges with Gmail and Google Sheets.
  • Sheets
  • Gmail
Apps Script Sheets Calendar

Record time and activities in Calendar and Sheets

Create calendar events for your activities, and synchronise to your timesheet in sheets for reporting.
  • Apps Script
  • Sheets
  • Calendar
Apps Script Sheets Cloud Natural Language

Analyze sentiment of open-ended feedback

Analyze text data, such as open-ended feedback, at scale by performing entity and sentiment analysis directly in Google Sheets.
  • Apps Script
  • Sheets
  • Cloud Natural Language
Apps Script Sheets Gmail YouTube

Track YouTube video views and comments

Tracks views, likes, and comments for provided YouTube URLs in a Google Sheet with optional email notifications.
  • Apps Script
  • Sheets
  • Gmail
Apps Script Sheets Forms Calendar

Manage employee vacation time requests

Quickly approve employees' vacation time requests, and create calendar events or send notification emails accordingly.
  • Apps Script
  • Sheets
  • Forms
  • Calendar
Apps Script Hangouts Chat Gmail Calendar

Call in sick with a custom bot for Hangouts Chat

Update your calendar and auto-responder with a single message to your custom bot.
  • Apps Script
  • Hangouts Chat
  • Gmail
  • Calendar
Apps Script Sheets. Gmail

Create expense reports directly from email receipts

Allows employees to move information from email receipts into their spreadsheet expense reports without copying and pasting.
  • Apps Script
Apps Script Sheets Forms

Manage new employee equipment requests

Create a form-based workflow to request equipment from IT for new employees.
  • Apps Script
  • Sheets
  • Forms

Send follow-up emails automatically

Send users in an online community follow up content based on their interests.
Apps Script Calendar

Automatically populate a team vacation calendar

Quickly see when your colleagues are out of the office, with no manual entry required.
  • Apps Script
  • Calendar
Apps Script Sheets Forms

Collect timesheets from employees

Create a hands-free employee pay management system. Lets managers approve/disapprove employees' weekly timesheets & automatically notify them of this status.
  • Apps Script
  • Sheets
  • Forms
Apps Script Sheets Forms Docs Gmail

Sign up for sessions at an event

Allows event attendees to sign up for sessions at an event then creates and emails a personalized itinerary.
  • Apps Script
  • Sheets
  • Forms
  • Docs
  • Gmail
Apps Script Sheets Forms

Sign up for activities at an offsite or event

Create an offsite activity signup system. Lets attendees pick their preferred activities via a form and fairly assigns them based on availability.
  • Apps Script
  • Sheets
  • Forms

We are growing the gallery! If you have ideas or suggestions, please submit feedback .