📖 Complete Setup Guide

Click on the Google Sheet link provided with your file. The sheet will open in a new tab.

Follow these steps to copy the sheet:

• Click on File menu (top-left corner)
• Select Make a copy from the dropdown
• A dialog box will appear:
• • Change the name if desired (optional)
• • Select the folder in your Drive (optional)
• Click Make a copy button

After copying, you'll see:

• The sheet opens automatically with "Copy of" in the title
• You are now the owner of this copy
• Check your Google Drive - the sheet is saved there
• You have full edit permissions

In your copied Google Sheet:

• Click on Extensions menu
• Select Apps Script
• A new tab opens with the Apps Script editor
• You'll see the code that powers your sheet

Some scripts need configuration. Look for these in the code:

// Configuration - Update these IDs
const SHEET_ID = 'your-sheet-id-here';
const FOLDER_ID = 'your-folder-id-here';

How to find Sheet ID:

• Look at your Google Sheet URL
• URL format: https://docs.google.com/spreadsheets/d/SHEET_ID/edit
• Copy the long string between /d/ and /edit

How to find Folder ID:

• Open the Google Drive folder
• Look at the folder URL
• URL format: https://drive.google.com/drive/folders/FOLDER_ID
• Copy the string after /folders/

After making any required changes:

• Click the 💾 Save button (or press Ctrl+S / Cmd+S)
• Wait for "Saved" confirmation

In the Apps Script editor:

• Click Deploy button (top-right)
• Select New deployment
• Click the gear icon ⚙️ next to "Select type"
• Choose Web app

Set the following options:

• Description: Add a description (e.g., "Initial deployment")
• Execute as: Select Me
• Who has access: Choose based on your needs:
  • • Only myself - Private use only
  • • Anyone - Public access (most common)
  • • Anyone with Google account - Requires login

Complete the deployment:

• Click Deploy button
• If prompted, click Authorize access
• Select your Google account
• Review permissions and click Allow
• Copy the Web app URL provided

To see your deployments:

• Click Deploy button
• Select Manage deployments
• You'll see all active deployments with their URLs

After making code changes:

• Save your code changes first
• Go to Deploy → Manage deployments
• Click the ✏️ Edit button
• Select New version under Version
• Add a description of changes
• Click Deploy

Problem: "This app isn't verified" warning

Solution:

• Click "Advanced" link
• Click "Go to [Your App Name] (unsafe)"
• This is safe for your own scripts

Common fixes:

• Check Sheet/Folder IDs are correct
• Ensure you saved the code
• Verify deployment settings
• Check execution logs: View → Executions

Solutions:

• Ensure you're using the copied sheet (not original)
• Check folder permissions if using folders
• Re-authorize the script