Follow the step-by-step tutorial below to learn how to set up and use the script to edit your existing SRTs in Google Sheets.
Step 1: Create a new document within Google Sheets.
Step 2: In the top bar, click "File" > "Import".
Step 3: Select "Upload" and then "Browse" to select your files.
Step 4: Import the "srt-tools.xlsx" template downloaded from this Repository.
Step 5: I would personally "Replace Current Spreadsheet" but ultimately this is up to you.
Step 6: Here's your template!
Step 7: Select from the top bar "Extensions" > "Apps Script"
Step 8: Here's your Apps Script interface.
Step 9: Navigate to "srt-tools.gs" within this Repository.
Step 10: Copy contents of "srt-tools.gs"
Step 11: Paste within your Apps Script and Save.
Step 12: Click "Run" to initialize your Apps Script.
Step 13: Authorization is required to allow your services within Google to access each other.
Step 14: Review and click "Allow" to continue once you've thoroughly reviewed and understand.
Step 15: Once you see this screen, you're all set and can return to Google Sheets.
Step 16: Refresh and you'll see this new custom menu option.
Step 17: Custom Menu Option - Show Upload Instructions
Step 18: Custom Menu Option - Process Uploaded SRTs
Step 19: Custom Menu Option - Export Active Sheet as SRT
Note: All of your files related to this will live in a directory called "SRT" on Google Drive.
