Google Sheets

Data Operations

• Read and write cell values with batch operations
• Insert, update, and delete rows and columns
• Format cells, ranges, and entire sheets
• Create and manage named ranges
• Apply data validation rules

Sheet Management

• Create new spreadsheets and worksheets
• Copy, move, and rename sheets
• Manage sheet permissions and sharing
• Duplicate spreadsheets with data

Analysis & Visualization

• Create charts and pivot tables
• Apply formulas and functions programmatically
• Generate data summaries and reports
• Export data to various formats (CSV, Excel, PDF)

How does Durable handle large datasets in Google Sheets?

Durable optimizes operations for large datasets using batch requests, range-based operations, and intelligent chunking. We automatically handle Google Sheets' API limits and provide progress tracking for large data operations.

Can I preserve formulas when writing data?

Yes. Durable can write both raw values and formulas to cells. Our system preserves existing formulas when updating adjacent cells and can dynamically generate formula references based on data structure.

What about data validation and formatting?

Durable respects existing data validation rules and can apply custom formatting including number formats, colors, borders, and conditional formatting. Invalid data is caught and reported with clear error messages.

How are permissions and sharing handled?

Durable works within Google Sheets' permission model and can programmatically share spreadsheets with specific users or groups. We validate permissions before operations and provide guidance for resolving access issues.

Can I work with charts and pivot tables?

Yes! Durable can create, update, and configure charts and pivot tables programmatically. This includes setting data ranges, customizing appearance, and updating chart data as underlying spreadsheet data changes.