This project embeds a Calendly form on a Google Apps Script web app page. Calendly can be pre-filled with data if the user is a returning customer. When the user completes the registration, a Calendly webhook calls the web app end point, which updates a Google Sheet with the registration data.
This Google Apps Script tracks meeting requests that are entered into a Google Sheet. The script creates Google Calendar event for every registration, and populates the invite with customizable title, description, guests, and more.
The project involved pulling information about YouTube channels and their videos and playlists, using the YouTube Data API. A Google Apps Script was built to take an arbitrary number of channel IDs, get their metadata, and then iterate through their videos and playlists and get their own metadata.
All information is to be pulled into a Google Sheet.