Troubleshooting: Google Sheets & Notion Integration Errors

Routing routine findings into structured databases like Google Sheets or Notion allows your team to maintain a historical ledger of competitor prices, tenders, and regulatory shifts.

If your routine triggers but new rows fail to appear in your target spreadsheet or Notion database, check the following permission and schema configurations.

---

1. Google Sheets: Error 403 Forbidden / Script Authorization Failure

Google requires explicit user authorization before external webhook services can append data to your private spreadsheet.

┌────────────────────────────────┐     ┌───────────────────────────────────┐
│ Common Cause                   │ ──► │ Immediate Solution                │
├────────────────────────────────┤     ├───────────────────────────────────┤
│ Web App deployed as "Only me"  │ ──► │ Change "Who has access" to Anyone │
│ New version not redeployed     │ ──► │ Deploy -> Manage Deployments ->   │
│                                │     │ Edit -> New Version               │
└────────────────────────────────┘     └───────────────────────────────────┘

The 2-Minute Fix:

1. Open your Google Sheet and navigate to Extensions -> Apps Script.
2. Click the blue Deploy button in the top right -> Manage Deployments.
3. Click the pencil icon to edit your existing deployment.
4. Under “Who has access”, ensure it is set to “Anyone” (NOT “Only myself”).
5. Under “Execute as”, select “Me ([email protected])”.
6. Set Version to “New Version” and click Deploy.
7. Copy the fresh Web App URL and re-paste it into Tishtar Studio.

---

2. Notion: Error 404 Object Not Found / Unauthorized

Notion uses strict database sandboxing. Creating an integration secret is not enough; you must explicitly invite the integration bot into the specific database page.

The 2-Minute Fix:

1. Open the specific Notion Database page where you want rows inserted.
2. In the top-right corner of Notion, click the three dots menu (...).
3. Scroll down and click Connections (or Connect to).
4. Search for your Tishtar integration name and select it.
5. If prompted, confirm that the integration has Can edit or Insert permissions.
6. Verify your Database ID: It is the 32-character string in your Notion URL between your workspace name and the ? query parameter: https://notion.so/myworkspace/a812b7f9412e4b3e89123847a9821234?v=...

---

3. Schema Property Type Mismatches

If Tishtar sends data formatted as text into a column Notion expects as a Date or Number, the API rejects the record.

• Date Columns: Ensure dates match ISO-8601 format (YYYY-MM-DD).
• Number Columns: Strip currency symbols (e.g. send 1200 instead of $1,200).
• Multi-Select Columns: Ensure option names do not exceed 100 characters.

---

Test Dispatch

Inside Tishtar Studio, click “Test Row Append”. Check your spreadsheet or Notion database; a new row will populate within 3 seconds.