Google Workspace Integration

Connect your Google Docs and Sheets to create dynamic, auto-updating knowledge bases for your chatbot.

Setup Process

Open your Google Doc or Sheet
Click the "Share" button in the top right
Add view access for: chatleh@chatleh.iam.gserviceaccount.com
Copy the document URL
Paste the URL in your Chatleh dashboard under Knowledge → Google Workspace

Best Practices

Google Sheets Best Practices

Use clear column headers for structured data
Keep one topic per sheet
Avoid merged cells and complex formatting
Use plain numbers without currency symbols or commas
Remove empty rows between data

✓ Recommended Format

| Product ID | Name    | Price  | Stock | Category | Description   |
|------------|---------|--------|-------|----------|---------------|
| P001       | Laptop  | 999.99 | 10    | Tech     | High performance|
| P002       | Jeans   | 59.99  | 50    | Apparel  | Blue denim     |

Google Docs Best Practices

Use heading levels (H1, H2, H3) for clear hierarchy
Keep content concise and well-structured
Use bullet points and numbered lists for clarity
Avoid complex tables, images, or special formatting
Regular updates will automatically sync to your chatbot

✓ Recommended Structure

# Product Returns Policy

## Return Window
Returns are accepted within 30 days of purchase.

## Return Process
1. Contact customer service
2. Get return authorization
3. Ship item back

## Exceptions
* Sale items are final
* Custom orders non-returnable

Troubleshooting

Common Issues

⚠️
Access Denied Error
Verify you've shared the document with the correct service account email and it has view access.
⚠️
Document Not Processing
Ensure the document URL is correct and the document contains content in a supported format.
⚠️
Content Not Updating
Changes may take up to 5 minutes to reflect. Try disconnecting and reconnecting the document if issues persist.

Need Help?

If you're having trouble with Google Workspace integration: