⸻

🚀 How to Set It Up (Step-by-Step)

✅ Step 1: Create a Google Developer App
1. Go to the Google Cloud Console.
2. Click “Create a new project”.
3. Navigate to APIs & Services > Library.
4. Search for and enable the Google Sheets API.

✅ Step 2: Configure OAuth Consent Screen
1. Under APIs & Services, go to OAuth Consent Screen.
2. Choose External and click Create.
3. Fill out basic info (e.g., app name, email).
4. Add https://bubble.io as an authorized domain.

✅ Step 3: Generate OAuth 2.0 Credentials
1. Go to APIs & Services > Credentials.
2. Click Create Credentials > OAuth Client ID.
3. Choose Web Application.
4. Set authorized redirect URI to:
https://yourappname.bubbleapps.io/api/1.1/oauth_redirect
5. Copy your Client ID and Client Secret.

📥 Paste these into the plugin settings in your Bubble app.

⸻

🧪 Step 4: Test with a Sample Sheet

Create a sample sheet on Google Sheets, what you need:
1. Spreadsheet URL:
2. Spreadsheet ID
3. Range (for example, Sheet1!A1:Z1000)

⸻

🧱 Displaying in a Repeating Group
1. Use the plugin action:
GetSheetCellNames (OAuth)
2. Provide:
• Spreadsheet ID
• Range (like Sheet1!A1:Z1000)
3. Use the returned data as the data source of your repeating group
4. Inside each cell, access values like:
• Current cell's text:item #1 → First cell
• :item #2 → Second cell, etc.