OVERALL CONTROL / 0.6-customer-control
Grades and scoring
Data access
25% of the overall score before applicability adjustment.
Scored answers and evidence
Read interface 7.5/10
Structured API for the declared product scope
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
batchGet retrieves selected ranges and chooses formatted values, raw values or formulas. A range response does not contain every workbook artifact.
Sheets batch range retrieval ↗
Ranges and value rendering · Checked 2026-10-16
Bulk delivery 8.8/10
Batched or iterable API requests
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
batchGet retrieves selected ranges and chooses formatted values, raw values or formulas. A range response does not contain every workbook artifact.
Sheets batch range retrieval ↗
Ranges and value rendering · Checked 2026-10-16
Query expressiveness 7.5/10
Fixed object or report retrieval
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
A1/R1C1 range selection retrieves cells. The assessed endpoint does not provide relational filtering, joins or aggregation queries.
Sheets batch range retrieval ↗
Ranges and value rendering · Checked 2026-10-16
Access cost barrier 10.0/10
Access is free, or included in the lowest paid plan with no fixed access fee; published usage-only charges are eligible
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Standard Sheets API use is available at no additional cost within the documented quota. Planned over-quota charging and other Google services require separate checks.
Google Sheets API usage limits ↗
Quotas, retry and pricing · Checked 2026-10-16
Third-party accessibility
20% of the overall score before applicability adjustment.
Scored answers and evidence
Third-party eligibility 7.5/10
Open registration under published review criteria
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
OAuth scopes and user file permissions authorize access. Sensitive public OAuth scopes can require Google verification; narrow drive.file access and broader spreadsheet scopes have different consent boundaries.
Google Sheets authorization scopes ↗
Sensitive scopes and OAuth verification · Checked 2026-10-16
Downstream permission -
-
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Applicable third-party processing, AI-use and redistribution terms require a separate contractual review.
Google Sheets authorization scopes ↗
Sensitive scopes and OAuth verification · Checked 2026-10-16
External action
15% of the overall score before applicability adjustment.
Scored answers and evidence
Write interface 2.5/10
Named operations in a limited domain
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
values.update replaces values in an existing selected range under spreadsheet write scope. This finding credits that documented range mutation; structural creation and append operations need separate endpoint evidence.
Sheets range update operation ↗
Request body and authorization scopes · Checked 2026-10-16
Custom application path 5.0/10
Approved third-party applications using fixed interfaces
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Third-party production applications use the documented provider approval route before the customer authorizes the fixed API interface.
Google Sheets authorization scopes ↗
Sensitive scopes and OAuth verification · Checked 2026-10-16
Continuity
15% of the overall score before applicability adjustment.
Scored answers and evidence
Refresh mechanism 7.5/10
Documented updated-since filters or webhooks
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Drive changes can indicate that a spreadsheet changed. Reread selected ranges and reconcile row/column shifts, formulas and deleted cells; file changes are not a cell-level CDC feed.
Google Drive change tracking ↗
Changes for files and start page tokens · Checked 2026-10-16
Limit visibility 10.0/10
Published numeric quotas and recovery instructions
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Read and write budgets each allow 300 requests/minute/project and 60/minute/user/project. Quotas refill each minute; 429 uses exponential backoff and requests can time out after 180 seconds.
Google Sheets API usage limits ↗
Quotas, retry and pricing · Checked 2026-10-16
CDC and deletion capture 2.5/10
Full snapshots permit customer reconciliation; native deltas unverified
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Repeated range snapshots support reconciliation; file-change identity does not identify every changed/deleted row or cell.
Google Drive change tracking ↗
Changes for files and start page tokens · Checked 2026-10-16
Replay and gap recovery 2.5/10
Rebuild from a fresh snapshot; no historical replay established
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Current selected ranges can be rebuilt. Drive change tokens do not reconstruct historical cell values after an outage.
Google Drive change tracking ↗
Changes for files and start page tokens · Checked 2026-10-16
Data exit
20% of the overall score before applicability adjustment.
Scored answers and evidence
Export custody 7.5/10
Customer-held structured files or API records
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Customers can download spreadsheets or retain API cell values/formulas. XLSX/CSV conversion and range extraction do not prove faithful transfer of Apps Script, permissions, revision history or every Google-specific formula.
Google spreadsheet downloads ↗
Download a copy of a file · Checked 2026-10-16
Post-cancellation access Disclosure
-
Disclosure only; does not reduce planned-exit credit.
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
The reviewed extraction guide does not establish contractual retrieval rights after cancellation.
Google spreadsheet downloads ↗
Download a copy of a file · Checked 2026-10-16
Planned migration fidelity 7.5/10
Portable structured records on documented routes; whole-product completeness unverified
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Customers can download spreadsheets or retain API cell values/formulas. XLSX/CSV conversion and range extraction do not prove faithful transfer of Apps Script, permissions, revision history or every Google-specific formula.
Google spreadsheet downloads ↗
Download a copy of a file · Checked 2026-10-16
Business logic and customization
5% of the overall score before applicability adjustment.
Scored answers and evidence
Logic authoring 2.5/10
External integration code; native business logic portability not established
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Customers can implement external logic against the assessed API. Ownership and reusable export of native workflow artifacts remain unresolved (customer integration code does not establish those rights).
Google Sheets authorization scopes ↗
Sensitive scopes and OAuth verification · Checked 2026-10-16
Rights to custom logic -
-
Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed.
Native workflow ownership, reusable export and independent execution rights remain unresolved.
Google Sheets authorization scopes ↗
Sensitive scopes and OAuth verification · Checked 2026-10-16
Scores are out of 10. * Incomplete evidence discounts verified capabilities (unknown answers stay unknown). Planned migration drives data exit. Scoring method ↗
CUSTOMER CHOICE
Third-party accessibility
OAuth scopes and user file permissions authorize access. Sensitive public OAuth scopes can require Google verification; narrow drive.file access and broader spreadsheet scopes have different consent boundaries.
Confirm who can connect, who owns the credentials and which uses are permitted. Customer consent and provider approval can be separate requirements; the selected plan and contract still matter.
READ / INTEGRATE
API and export routes
batchGet retrieves selected ranges and chooses formatted values, raw values or formulas. A range response does not contain every workbook artifact. A1/R1C1 range selection retrieves cells. The assessed endpoint does not provide relational filtering, joins or aggregation queries.
| Access route | Authentication | Credential owner | Provider approval | Access requirement | Last checked |
|---|---|---|---|---|---|
| Customer-authorized application | OAuth 2.0 | Integration provider | Yes | App review | 2026-10-16 |
Availability depends on your product, plan and agreement. See the documentation below for the requirements of each route.
ECONOMIC ACCESS
Cost, authentication and limits
Standard Sheets API use is available at no additional cost within the documented quota. Planned over-quota charging and other Google services require separate checks.
Check API entitlement, credential ownership and rate limits for the route you intend to use. Include review fees, customer-plan upgrades and ongoing access charges in the total.
ACT FROM OUTSIDE
External action
values.update replaces values in an existing selected range under spreadsheet write scope. This finding credits that documented range mutation; structural creation and append operations need separate endpoint evidence.
Validate the supported operation, acting identity and permission scope (read access does not imply write permission). Ambiguous retries and revoked credentials also affect whether an external workflow can run safely.
KEEP ACCESS USEFUL
Continuity
Drive changes can indicate that a spreadsheet changed. Reread selected ranges and reconcile row/column shifts, formulas and deleted cells; file changes are not a cell-level CDC feed. Read and write budgets each allow 300 requests/minute/project and 60/minute/user/project. Quotas refill each minute; 429 uses exponential backoff and requests can time out after 180 seconds.
CDC, deletions and recovery
| Question | Answer / applicable route | Evidence |
|---|---|---|
| Can ongoing extraction identify updates and deleted records on the declared route? | Full snapshots permit customer reconciliation; native deltas unverifiedGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Repeated range snapshots support reconciliation; file-change identity does not identify every changed/deleted row or cell. | Google Drive change tracking ↗Changes for files and start page tokensChecked 2026-10-16 |
| How can extraction recover after missed events or an interrupted consumer? | Rebuild from a fresh snapshot; no historical replay establishedGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Current selected ranges can be rebuilt. Drive change tokens do not reconstruct historical cell values after an outage. | Google Drive change tracking ↗Changes for files and start page tokensChecked 2026-10-16 |
Useful ongoing access includes corrections and deletions, not only the first export. A failed request, changed filter or lost resource permission should not be interpreted as a deleted record.
LEAVE WITH YOUR DATA
Data exit and portability
Customers can download spreadsheets or retain API cell values/formulas. XLSX/CSV conversion and range extraction do not prove faithful transfer of Apps Script, permissions, revision history or every Google-specific formula.
Test the output against the destination’s required fields and history. Check stable identifiers, relationships, attachments and extraction time; a sample file proves only the coverage of that sample.
BUILD / INSPECT / REUSE
Business logic and customization
Customers can implement external logic against the assessed API. Ownership and reusable export of native workflow artifacts remain unresolved (customer integration code does not establish those rights).
Custom API access, ownership of workflows and the right to export their definitions are separate questions. A custom-app capability alone does not establish that business rules can move to another system.
AGREEMENTS / API DOCS / PROGRAM REQUIREMENTS
Documented conditions
Answers below come from public provider materials. Every answer retains its source check date, scope (a partner agreement does not describe every customer route). Customer contracts and live behavior still need verification.
| Question | Answer / applicable route | Evidence |
|---|---|---|
| What structured read interface is documented? | Structured API for the declared product scopeGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. batchGet retrieves selected ranges and chooses formatted values, raw values or formulas. A range response does not contain every workbook artifact. | Sheets batch range retrieval ↗Ranges and value renderingChecked 2026-10-16 |
| How can customers retrieve data in bulk? | Batched or iterable API requestsGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. batchGet retrieves selected ranges and chooses formatted values, raw values or formulas. A range response does not contain every workbook artifact. | Sheets batch range retrieval ↗Ranges and value renderingChecked 2026-10-16 |
| What queries can a customer issue outside the provider UI? | Fixed object or report retrievalGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. A1/R1C1 range selection retrieves cells. The assessed endpoint does not provide relational filtering, joins or aggregation queries. | Sheets batch range retrieval ↗Ranges and value renderingChecked 2026-10-16 |
| Who decides whether a chosen third party may connect? | Open registration under published review criteriaGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. OAuth scopes and user file permissions authorize access. Sensitive public OAuth scopes can require Google verification; narrow drive.file access and broader spreadsheet scopes have different consent boundaries. | Google Sheets authorization scopes ↗Sensitive scopes and OAuth verificationChecked 2026-10-16 |
| What extra commercial condition applies to the routes supplying the assessed read capability, relative to the lowest paid plan? | Access is free, or included in the lowest paid plan with no fixed access fee; published usage-only charges are eligibleGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Standard Sheets API use is available at no additional cost within the documented quota. Planned over-quota charging and other Google services require separate checks. | Google Sheets API usage limits ↗Quotas, retry and pricingChecked 2026-10-16 |
| What permission is needed for the documented downstream use? | -Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Applicable third-party processing, AI-use and redistribution terms require a separate contractual review. | Google Sheets authorization scopes ↗Sensitive scopes and OAuth verificationChecked 2026-10-16 |
| Which external write operations are documented? | Named operations in a limited domainGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. values.update replaces values in an existing selected range under spreadsheet write scope. This finding credits that documented range mutation; structural creation and append operations need separate endpoint evidence. | Sheets range update operation ↗Request body and authorization scopesChecked 2026-10-16 |
| How can customers connect an application they build or choose? | Approved third-party applications using fixed interfacesGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Third-party production applications use the documented provider approval route before the customer authorizes the fixed API interface. | Google Sheets authorization scopes ↗Sensitive scopes and OAuth verificationChecked 2026-10-16 |
| What mechanism supports repeatable extraction of changes? | Documented updated-since filters or webhooksGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Drive changes can indicate that a spreadsheet changed. Reread selected ranges and reconcile row/column shifts, formulas and deleted cells; file changes are not a cell-level CDC feed. | Google Drive change tracking ↗Changes for files and start page tokensChecked 2026-10-16 |
| How are integration limits disclosed? | Published numeric quotas and recovery instructionsGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Read and write budgets each allow 300 requests/minute/project and 60/minute/user/project. Quotas refill each minute; 429 uses exponential backoff and requests can time out after 180 seconds. | Google Sheets API usage limits ↗Quotas, retry and pricingChecked 2026-10-16 |
| Where can a usable data copy be delivered? | Customer-held structured files or API recordsGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Customers can download spreadsheets or retain API cell values/formulas. XLSX/CSV conversion and range extraction do not prove faithful transfer of Apps Script, permissions, revision history or every Google-specific formula. | Google spreadsheet downloads ↗Download a copy of a fileChecked 2026-10-16 |
| What retrieval rights are documented at cancellation? | -Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. The reviewed extraction guide does not establish contractual retrieval rights after cancellation. | Google spreadsheet downloads ↗Download a copy of a fileChecked 2026-10-16 |
| How can customers define their own business logic? | External integration code; native business logic portability not establishedGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Customers can implement external logic against the assessed API. Ownership and reusable export of native workflow artifacts remain unresolved (customer integration code does not establish those rights). | Google Sheets authorization scopes ↗Sensitive scopes and OAuth verificationChecked 2026-10-16 |
| What rights or portability are documented for custom workflow artifacts? | -Google Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Native workflow ownership, reusable export and independent execution rights remain unresolved. | Google Sheets authorization scopes ↗Sensitive scopes and OAuth verificationChecked 2026-10-16 |
| What usable data or native definitions can leave before cancellation? | Portable structured records on documented routes; whole-product completeness unverifiedGoogle Sheets / user-authorized Sheets v4 ranges and spreadsheet writes, with Drive file-change hints and spreadsheet downloads; no row-level immutable identity or native cell change log is assumed. Customers can download spreadsheets or retain API cell values/formulas. XLSX/CSV conversion and range extraction do not prove faithful transfer of Apps Script, permissions, revision history or every Google-specific formula. | Google spreadsheet downloads ↗Download a copy of a fileChecked 2026-10-16 |
SOURCES / SCOPE / HISTORY
Sources and open questions
This review is based on the documentation below. Live account behavior and customer-specific agreements haven’t been tested.
Still to confirm
- Applicable downstream processing and redistribution terms
- Post-cancellation retrieval rights
- Native workflow artifact ownership and independent execution
- Whole-product completeness beyond the declared objects and routes
Documentation
Assessment checked 2026-10-16. Each answer retains its source and applicable route; the check date does not establish live account behavior.