Connecting to Google Sheets

​

Refer to Google Cloud documentation to learn more.

​​​

Step 1: Create a Google Cloud Project

​

1. Go to the Google Cloud Console.

2. Create a new project or select an existing one.

3. Take note of the Project ID.

 

Step 2: Enable Google Drive and Sheets API

​

1. In your project, go to APIs & Services > Library.

2. Search for Google Sheets API and click Enable.

3. Search for Google Drive API and click Enable.

​

Step 3: Configure OAuth Consent Screen

1. Go to APIs & Services > OAuth consent screen.

2. Choose Internal (this requires Google Workspace with your domain).

   • If you don't yet have Google Workspace, you’ll need to choose External for now.

3. Fill in:

   • App name

   • User support email

   • Authorized domain(s)

   • Developer contact information

4. Fill in: 

• Test User

5. Scopes:

• Add https://www.googleapis.com/auth/spreadsheets.readonly

• Add https://www.googleapis.com/auth/drive.metadata.readonly

• Optionally also https://www.googleapis.com/auth/cloud-platform

6. Save and Publish.

​

Step 4: Create OAuth 2.0 Client ID for iOS

​

1. Go to APIs & Services > Credentials.

2. Click Create Credentials > OAuth client ID.

3. Choose Application type: iOS.

4. Enter:

   • Name: e.g., Oneboard gSheets

   • Bundle ID: ai.sweeft.oneboard

5. Click Create and save the:

   • Client ID

   • Client Secret (not used directly in iOS, but useful for backend exchanges)