Google Sheets Setup

Not Connected

Connection Status

Not Connected
Configure your Google Sheets credentials below

1 Create Google Sheet

Create a new Google Sheet that will store all your project data.

  1. Go to sheets.google.com
  2. Create a new blank spreadsheet
  3. Name it "Project Command Centre Data"
  4. Copy the Sheet ID from the URL
URL format:
https://docs.google.com/spreadsheets/d/[SHEET_ID]/edit

2 Get Google API Key

Create a Google Cloud project and enable the Sheets API.

  1. Go to Google Cloud Console
  2. Create a new project (or select existing)
  3. Enable "Google Sheets API"
  4. Go to Credentials → Create API Key
  5. (Optional) Restrict key to Sheets API only
Open Google Cloud Console

3 Enter Your Credentials

The long string from your Google Sheet URL
Your Google Cloud API key
Deploy the Apps Script below as a Web App for full read/write access

★ Apps Script for Write Access (Optional)

To enable write access without OAuth, deploy this Google Apps Script as a Web App:

  1. Go to script.google.com
  2. Create a new project
  3. Paste the code below
  4. Update SHEET_ID with your Google Sheet ID
  5. Run the initializeSheets() function first
  6. Deploy → New deployment → Web app
  7. Execute as: Me, Who has access: Anyone
  8. Copy the Web App URL and paste above

            

          

        

        
        
        

          

            
Data Sync Controls