Google Sheets Integration

DejaSync enables seamless two-way synchronization with Google Sheets, allowing you to keep your spreadsheets in sync with Airtable, Notion, Monday.com, and other platforms.

Getting Started

Connecting Google Sheets

1. During sync creation, select Google Sheets as one of your apps
2. Click Connect to authorize DejaSync
3. You'll be redirected to Google's OAuth page
4. Sign in with your Google account
5. Grant DejaSync permission to access your spreadsheets
6. You'll be redirected back to complete your sync setup

Selecting Your Data

After connecting, you'll be able to:

• Choose a spreadsheet: Select from all spreadsheets in your Google Drive
• Select sheets: Pick specific sheet tabs within your spreadsheet to sync
• Map fields: DejaSync uses the first row as column headers for field mapping

Supported Field Types

DejaSync supports various Google Sheets data types and formats. The table below shows all supported field types and their sync capabilities.

Field Type Notes

Headers Required: DejaSync uses the first row of your sheet as column headers. Make sure your data has a header row.

Formula Fields: Formula cells can be synced, but DejaSync syncs the calculated value, not the formula itself.

Data Validation: Dropdown lists created with data validation are supported and mapped to select fields in other apps.

Boolean Values: TRUE/FALSE values are treated as checkboxes and are read-only in Google Sheets.

Best Practices

Sheet Structure

• Use headers: Always include a header row (row 1) with column names
• Consistent data types: Keep data types consistent within each column
• Avoid merged cells: Merged cells can cause sync issues
• No empty rows: Remove empty rows between data to ensure accurate syncing

Field Mapping

• Clear column names: Use descriptive, unique names for each column
• Match naming: Use the same column names across apps for automatic mapping
• Data formatting: Apply appropriate number, date, and currency formatting

Sync Direction

• Bidirectional sync: Best for collaborative editing across platforms
• One-way to Sheets: Use when Google Sheets is your reporting/analysis tool
• One-way from Sheets: Use when Sheets is your data entry point

Performance Tips

• Limit columns: Only include columns you need to sync
• Clean data: Remove unnecessary formatting and empty cells
• Reasonable size: Very large sheets (10,000+ rows) may sync more slowly

Common Use Cases

Google Sheets ↔ Airtable

Combine the simplicity of spreadsheets with Airtable's powerful database features.

Example: Maintain a Google Sheet for quick data entry, automatically syncing to Airtable for advanced views and automations.

Google Sheets ↔ Notion

Keep your spreadsheet data in sync with Notion's flexible databases.

Example: Sync financial data from Google Sheets to a Notion database for team-wide visibility and planning.

Google Sheets ↔ Monday

Integrate spreadsheet data with Monday's project management workflows.

Example: Sync a Google Sheets budget tracker to Monday boards for project cost tracking.

Troubleshooting

Connection Issues

Problem: "Failed to connect to Google Sheets"

• Solution: Ensure you've granted DejaSync the necessary permissions
• Try disconnecting and reconnecting your Google account
• Check that you have edit access to the spreadsheets you want to sync

Sync Errors

Problem: "Header row not found"

• Solution: Ensure row 1 contains column headers
• Headers must be text values, not formulas or empty cells

Problem: "Data type mismatch"

• Solution: Check that column data types are consistent
• Verify mapped fields have compatible types (e.g., don't map text to numbers)

Problem: "Permission denied"

• Solution: Ensure you have edit access to the spreadsheet
• Re-authorize DejaSync if permissions have changed

Data Not Syncing

Problem: Changes not appearing in Google Sheets

• Solution: Check your sync interval and manually trigger a sync
• Verify that field mappings are correct
• Ensure the sheet hasn't been renamed or deleted
• Review Activity logs for detailed error messages

Problem: Formulas being overwritten

• Solution: Don't map editable fields from other apps to formula cells in Sheets
• Use one-way sync FROM Sheets if you need to preserve formulas

API Rate Limits

Google Sheets has API quotas that DejaSync respects:

• Read requests: 100 per 100 seconds per user
• Write requests: 100 per 100 seconds per user
• DejaSync automatically manages requests to stay within limits
• Large syncs are batched to optimize performance

Permissions

DejaSync requires the following Google Sheets permissions:

• View and manage spreadsheets: To read and write data
• See and download spreadsheets: To access your data
• Create, edit, and delete spreadsheets: To update synced data

DejaSync only accesses spreadsheets you explicitly select for syncing.

Learn More

• Google Sheets Documentation
• Google Sheets API Documentation
• DejaSync Quick Start Guide

---

Need help? Check out our Quick Start Guide or contact support for assistance with your Google Sheets integration.