1. Creating the Spreadsheet
Creating a Copy
Prepare a spreadsheet to actually manage the playlist.
First, open the template below and click “File > Make a copy” from the menu.
Change the “Name” to your preferred name and “Folder” to your preferred save location, then click “Make a copy”.
Setting up as Web App
Next, configure settings so VRChat can access the playlist.
From the menu of the created sheet, click “Extensions > Apps Script”.
(You can’t open it until the page finishes loading. Wait if the tab icon is spinning)
Click “Deploy > New deployment” in the top right.
Set:
- Execute as: “Me (your mailaddress)”
- Who has access: “Anyone”
Then click “Deploy”.
You’ll be asked to authorize access to the sheet, so click “Authorize access”.
Select your account and proceed as shown in the image.
The following permissions will be requested:
- YouTube account viewing permission
- Access permission to the copied spreadsheet
Click “Allow”.
- YouTube permission is used to retrieve video titles and channel names.
- This is you granting read access to your own spreadsheet.
You are not directly granting read access to the gimmick author or VRChat visitors.
When successful, you’ll see a screen like below, so copy the web app URL.
This URL will be used in the next step.
After copying, you can close with “Done”.
If you want to copy the URL again after closing, you can open “Manage deployments” from “Deploy” in the top right to copy it.
