Google Sheets Connection Test

Step 1: Enter your Google Apps Script Web App URL

This is the URL you received after deploying your Apps Script as a web app.

Test Connection

Common Issues & Solutions

1. "Google hasn't verified this app" warning

This is normal for Apps Script you create yourself. Click "Advanced" and then "Go to [Project Name] (unsafe)" to proceed.

2. CORS errors

If you see CORS errors in the console, you need to open the Apps Script web app URL directly in your browser first and authorize it.

3. "Requires authorization" message

If opening the URL directly shows "requires authorization", your deployment settings may be incorrect:

• Make sure "Who has access" is set to "Anyone"
• Try opening the URL in an incognito window
• You might need to create a new deployment

4. URL format issues

The correct URL format should start with:

https://script.google.com/macros/s/[LONG-ID]/exec

5. Google Sheet Access

Make sure your Google Sheet is accessible:

• Go to your Sheet, click "Share" and set to "Anyone with the link can view"
• Make sure your column headers are spelled exactly: "Question_EN", "Question_DE", "Depth"