“NAaT Shotlist Numbering Tools” add-on for Google Docs

This is a little add-on to use with Google Docs that auto-numbers the comments.

My method for writing a shotlist for my videos is to paste a lightbulb emoji 💡wherever i want a new shot to happen, and then add a comment to it, and describe the shot in the comment. 

i give each comment a prefix to indicate which section of the game/batch of shots it belongs to.  So every “player board” shot begins with the prefix PB. Every common board shot begins with B.  Every closeup is CU, and so on. i split the shots into batches this way because it’s “expensive” to constantly move and refocus the camera doing a shoot. It’s much more efficient to just lock the camera into one position and bang out all the Player Board shots, and then lock it to another position and bang out all the common board shots.

Before this script existed, i then had to go back through my script and hand-number all of the shotlist comments, keeping track of the number i was on using tally marks on a little whiteboard. This was very time-consuming, especially for a long script. i tried time and again to write a script that would do this for me automatically, but i could never get access to the Google Drive API’s comments, because the API calls them something other than “comments,” and setting up all the OAuth permissions was a bit of voodoo in an egregiously complex developer backend that i didn’t understand.  ChatGPT wasn’t even smart enough to figure it out for me.

… Until now. At long last, ChatGPT was able to walk me through the process, all while referring to an outdated interface configuration… but i toughed it out and reached the deployment step.  Now i apparently i have to run around adding logos to it and exposing my email address as tech support if i want to deploy the thing live so that i can use it. So here we are.

Privacy Policy

i am only deploying this publicly so that i myself can use it.  i am not stealing your data or spying on you using this tool. And let’s be real: i wouldn’t know how to to that if i wanted to!  Here’s a boilerplate Privacy Policy that i had ChatGPT generate:

Effective Date: November 26 2024

Thank you for using the Comment Tools add-on. This Privacy Policy explains how we collect, use, and protect your information when you use our add-on. By using this add-on, you agree to the terms of this Privacy Policy.

Information We Collect

The Comment Tools add-on does not collect or store any of your personal data. The add-on interacts with your Google Docs environment to provide its functionality, but it does not transmit, share, or save any data outside of your Google account or document.

How the Add-On Works

The add-on operates within your Google Docs to provide the following features:

• Automatically numbers or removes numbering from comments in your Google Doc.
• Displays a summary of comment prefixes and counts in the document.

To perform these actions, the add-on requires access to:

• The content and metadata of your Google Docs and comments.
• The ability to modify the document content as directed by you.

How We Use Your Information

The add-on processes your data locally within your Google account. We do not store, share, or transmit your data to any external server or third party.

Permissions

To function correctly, the add-on requires the following permissions:

• Access to Google Drive and Documents: To read and modify your document’s content and comments.
• UI Interaction: To display custom menus within the Google Docs interface.

These permissions are solely used to provide the functionality of the add-on. No data is shared or stored outside your Google Workspace.

Data Security

We take your privacy seriously. The add-on runs within Google’s secure environment and does not interact with any external systems. Google manages the security of your data under its robust security and privacy policies.

Changes to This Privacy Policy

We may update this Privacy Policy periodically. If we make significant changes, we will notify users by updating the “Effective Date” above. Continued use of the add-on after changes implies acceptance of the updated Privacy Policy.

Contact Us

If you have any questions about this Privacy Policy or the add-on, please contact us at:
nightsaroundatable [the at symbol] gmail [the little dot thingy] com

Terms of Service

Effective Date: November 26 2024

Welcome to the NAaT Shotlist Numbering Tools add-on! By using this add-on, you agree to comply with and be bound by the following terms and conditions. Please read these Terms of Service carefully before using the add-on.

1. Acceptance of Terms

By installing and using the Comment Tools add-on, you agree to these Terms of Service. If you do not agree, please do not use the add-on.

2. Description of the Add-On

The Comment Tools add-on provides functionality within Google Docs, including:

• Numbering comments in a Google Doc.
• Removing numbering from comments.
• Generating summaries of comment prefixes.

This add-on is designed for personal and professional use within Google Docs.

3. Permissions and Access

To perform its functions, the add-on requires the following permissions:

• Read and write access to Google Docs and comments: To number, remove numbering, and summarize comments.
• User interface interaction: To add custom menus and provide interaction within the Google Docs environment.

These permissions are only used to enable the add-on’s functionality and are not used for any other purpose.

4. User Responsibilities

When using the Comment Tools add-on, you agree to:

• Use the add-on only for lawful purposes.
• Not attempt to copy, modify, or reverse-engineer the add-on’s functionality.
• Take responsibility for any changes made to your documents using the add-on.

5. Disclaimer of Warranties

The Comment Tools add-on is provided “as is” without warranties of any kind, express or implied, including but not limited to warranties of merchantability, fitness for a particular purpose, or non-infringement.

We do not guarantee that the add-on will always function as intended or be free from errors.

6. Limitation of Liability

To the fullest extent permitted by law, the creator(s) of this add-on shall not be held liable for any direct, indirect, incidental, or consequential damages arising out of the use or inability to use the add-on, including but not limited to document loss or unintended modifications.

7. Termination

We reserve the right to terminate or restrict your access to the Comment Tools add-on at any time without prior notice for violation of these Terms or other misuse.

8. Changes to These Terms

We may update these Terms of Service periodically. If significant changes are made, we will notify users by updating the “Effective Date” above. Continued use of the add-on after such changes constitutes acceptance of the updated Terms.

9. Contact Information

If you have questions or concerns regarding these Terms of Service, please contact us at:
nightsaroundatable [the at symbol] gmail [the little dot thingy] com