Reproducible query — Product (shared drive)
LIST FILES WHERE IS_FOLDER IS "no" LIMIT 10
Anyone opening this link re-runs the same query against epoch 1, so it returns the same answer — that is what makes a number in a report checkable later.
| PATH | NAME | ID | DRIVE_ID | PARENT_ID | DEPTH | IS_FOLDER | ITEM_KIND | MIME_TYPE | SIZE_BYTES | OWNER_EMAIL | CREATED | MODIFIED | MODIFIED_BY | TRASHED | STARRED | NAME_IS_UNIQUE | WORD_COUNT | SECTION_COUNT | CONTENT_HASH | EXTRACT_STATUS | WEB_VIEW_LINK | LINK_VISIBILITY | SHARED_EXTERNALLY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| /Product/Roadmap/Roadmap 2026 | Roadmap 2026 | doc_roadmap26 | drv_product | fld_roadmap | 2 | no | document | application/vnd.google-apps.document | - | alice@acme.com | 2025-11-04T10:12:00Z | 2026-08-28T16:40:00Z | bob@acme.com | no | no | yes | 72 | 5 | b514ed617ee0a869 | exported_no_size | open in Drive ↗ | anyone_with_link | yes |
| /Product/Roadmap/Q3 Planning | Q3 Planning | doc_q3plan | drv_product | fld_roadmap | 2 | no | document | application/vnd.google-apps.document | - | bob@acme.com | 2026-05-18T08:30:00Z | 2026-07-02T13:05:00Z | bob@acme.com | no | no | yes | 41 | 4 | af4c1fbf58fb3d7a | exported_no_size | open in Drive ↗ | domain | no |
| /Product/Specs/Pricing Spec | Pricing Spec | doc_pricing | drv_product | fld_specs | 2 | no | document | application/vnd.google-apps.document | - | alice@acme.com | 2026-01-09T14:00:00Z | 2026-08-25T09:15:00Z | carol@acme.com | no | no | no | 80 | 5 | 6f55c3605dc4142c | exported_no_size | open in Drive ↗ | domain | yes |
| /Product/Specs/API Spec | API Spec | doc_api | drv_product | fld_specs | 2 | no | document | application/vnd.google-apps.document | - | carol@acme.com | 2026-02-20T11:45:00Z | 2026-06-11T17:22:00Z | carol@acme.com | no | no | yes | 45 | 4 | 594f908eefef444b | exported_no_size | open in Drive ↗ | domain | no |
| /Product/Specs/Archive/Pricing Spec | Pricing Spec | doc_pricing_v1 | drv_product | fld_archive | 3 | no | document | application/vnd.google-apps.document | - | alice@acme.com | 2025-08-14T09:20:00Z | 2026-03-01T10:00:00Z | alice@acme.com | no | no | no | 18 | 2 | f87118a8330e0654 | exported_no_size | open in Drive ↗ | domain | no |
| /Product/Specs_archive/Legacy Pricing Notes | Legacy Pricing Notes | doc_legacy | drv_product | fld_specs_old | 2 | no | document | application/vnd.google-apps.document | - | alice@acme.com | 2025-01-05T09:10:00Z | 2025-02-01T09:00:00Z | alice@acme.com | no | no | yes | 13 | 2 | 0825400fabf9143c | exported_no_size | open in Drive ↗ | domain | no |
| /Product/Metrics/KPI Dashboard | KPI Dashboard | sh_kpi | drv_product | fld_metrics | 2 | no | spreadsheet | application/vnd.google-apps.spreadsheet | - | alice@acme.com | 2025-04-11T09:10:00Z | 2026-08-31T07:50:00Z | dana@vendor.io | no | no | yes | 19 | 1 | 1242599fce644003 | exported_no_size | open in Drive ↗ | domain | yes |
| /Product/Metrics/Funnel Analysis | Funnel Analysis | sh_funnel | drv_product | fld_metrics | 2 | no | spreadsheet | application/vnd.google-apps.spreadsheet | - | alice@acme.com | 2026-02-02T15:00:00Z | 2026-05-30T12:00:00Z | alice@acme.com | no | no | yes | 12 | 1 | d96343df0de91e14 | exported_no_size | open in Drive ↗ | domain | no |
| /Product/Legal/Vendor MSA.pdf | Vendor MSA.pdf | pdf_msa | drv_product | fld_legal | 2 | no | application/pdf | 277.8 KB (284,500) | alice@acme.com | 2025-06-20T09:30:00Z | 2025-06-20T09:30:00Z | alice@acme.com | no | no | yes | 32 | 3 | 9dd2f7cfda470a4f | extracted | open in Drive ↗ | domain | yes | |
| /Product/Legal/DPA Template.pdf | DPA Template.pdf | pdf_dpa | drv_product | fld_legal | 2 | no | application/pdf | 117.0 KB (119,800) | alice@acme.com | 2026-04-18T10:30:00Z | 2026-04-18T10:30:00Z | alice@acme.com | no | no | yes | 28 | 3 | f0ce8cad630666d7 | extracted | open in Drive ↗ | domain | no |
Showing 10 of 12 matching rows — raise LIMIT for more.
Applied the source default TRASHED IS "no". Drive hides trashed items by default, so counting them would disagree with what any Drive user sees. Filter TRASHED explicitly to override it.
Showing 10 of 12 matching rows (LIMIT applies; count is not the true total - use COUNT FILES for that).
epoch 1source gdrive:filesas of 2026-09-14T21:44:11Ztransforms type-coercion, source-default-filtercache hit
Applied source default TRASHED IS "no" — Drive hides trashed items by default, so counting them would disagree with what any Drive user sees.
Raw envelope — what an app or agent receives
{
"ok": true,
"query": null,
"verb": "LIST",
"subject": "FILES",
"data": {
"rows": [
{
"ID": "doc_roadmap26",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_roadmap",
"PATH": "/Product/Roadmap/Roadmap 2026",
"NAME": "Roadmap 2026",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "document",
"MIME_TYPE": "application/vnd.google-apps.document",
"SIZE_BYTES": null,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2025-11-04T10:12:00Z",
"MODIFIED": "2026-08-28T16:40:00Z",
"MODIFIED_BY": "bob@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": 72,
"SECTION_COUNT": 5,
"CONTENT_HASH": "b514ed617ee0a869",
"EXTRACT_STATUS": "exported_no_size",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/doc_roadmap26/view",
"LINK_VISIBILITY": "anyone_with_link",
"SHARED_EXTERNALLY": "yes"
},
{
"ID": "doc_q3plan",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_roadmap",
"PATH": "/Product/Roadmap/Q3 Planning",
"NAME": "Q3 Planning",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "document",
"MIME_TYPE": "application/vnd.google-apps.document",
"SIZE_BYTES": null,
"OWNER_EMAIL": "bob@acme.com",
"CREATED": "2026-05-18T08:30:00Z",
"MODIFIED": "2026-07-02T13:05:00Z",
"MODIFIED_BY": "bob@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": 41,
"SECTION_COUNT": 4,
"CONTENT_HASH": "af4c1fbf58fb3d7a",
"EXTRACT_STATUS": "exported_no_size",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/doc_q3plan/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "no"
},
{
"ID": "doc_pricing",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_specs",
"PATH": "/Product/Specs/Pricing Spec",
"NAME": "Pricing Spec",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "document",
"MIME_TYPE": "application/vnd.google-apps.document",
"SIZE_BYTES": null,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2026-01-09T14:00:00Z",
"MODIFIED": "2026-08-25T09:15:00Z",
"MODIFIED_BY": "carol@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "no",
"WORD_COUNT": 80,
"SECTION_COUNT": 5,
"CONTENT_HASH": "6f55c3605dc4142c",
"EXTRACT_STATUS": "exported_no_size",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/doc_pricing/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "yes"
},
{
"ID": "doc_api",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_specs",
"PATH": "/Product/Specs/API Spec",
"NAME": "API Spec",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "document",
"MIME_TYPE": "application/vnd.google-apps.document",
"SIZE_BYTES": null,
"OWNER_EMAIL": "carol@acme.com",
"CREATED": "2026-02-20T11:45:00Z",
"MODIFIED": "2026-06-11T17:22:00Z",
"MODIFIED_BY": "carol@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": 45,
"SECTION_COUNT": 4,
"CONTENT_HASH": "594f908eefef444b",
"EXTRACT_STATUS": "exported_no_size",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/doc_api/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "no"
},
{
"ID": "doc_pricing_v1",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_archive",
"PATH": "/Product/Specs/Archive/Pricing Spec",
"NAME": "Pricing Spec",
"DEPTH": 3,
"IS_FOLDER": "no",
"ITEM_KIND": "document",
"MIME_TYPE": "application/vnd.google-apps.document",
"SIZE_BYTES": null,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2025-08-14T09:20:00Z",
"MODIFIED": "2026-03-01T10:00:00Z",
"MODIFIED_BY": "alice@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "no",
"WORD_COUNT": 18,
"SECTION_COUNT": 2,
"CONTENT_HASH": "f87118a8330e0654",
"EXTRACT_STATUS": "exported_no_size",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/doc_pricing_v1/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "no"
},
{
"ID": "doc_legacy",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_specs_old",
"PATH": "/Product/Specs_archive/Legacy Pricing Notes",
"NAME": "Legacy Pricing Notes",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "document",
"MIME_TYPE": "application/vnd.google-apps.document",
"SIZE_BYTES": null,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2025-01-05T09:10:00Z",
"MODIFIED": "2025-02-01T09:00:00Z",
"MODIFIED_BY": "alice@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": 13,
"SECTION_COUNT": 2,
"CONTENT_HASH": "0825400fabf9143c",
"EXTRACT_STATUS": "exported_no_size",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/doc_legacy/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "no"
},
{
"ID": "sh_kpi",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_metrics",
"PATH": "/Product/Metrics/KPI Dashboard",
"NAME": "KPI Dashboard",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "spreadsheet",
"MIME_TYPE": "application/vnd.google-apps.spreadsheet",
"SIZE_BYTES": null,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2025-04-11T09:10:00Z",
"MODIFIED": "2026-08-31T07:50:00Z",
"MODIFIED_BY": "dana@vendor.io",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": 19,
"SECTION_COUNT": 1,
"CONTENT_HASH": "1242599fce644003",
"EXTRACT_STATUS": "exported_no_size",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/sh_kpi/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "yes"
},
{
"ID": "sh_funnel",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_metrics",
"PATH": "/Product/Metrics/Funnel Analysis",
"NAME": "Funnel Analysis",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "spreadsheet",
"MIME_TYPE": "application/vnd.google-apps.spreadsheet",
"SIZE_BYTES": null,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2026-02-02T15:00:00Z",
"MODIFIED": "2026-05-30T12:00:00Z",
"MODIFIED_BY": "alice@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": 12,
"SECTION_COUNT": 1,
"CONTENT_HASH": "d96343df0de91e14",
"EXTRACT_STATUS": "exported_no_size",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/sh_funnel/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "no"
},
{
"ID": "pdf_msa",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_legal",
"PATH": "/Product/Legal/Vendor MSA.pdf",
"NAME": "Vendor MSA.pdf",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "pdf",
"MIME_TYPE": "application/pdf",
"SIZE_BYTES": 284500,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2025-06-20T09:30:00Z",
"MODIFIED": "2025-06-20T09:30:00Z",
"MODIFIED_BY": "alice@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": 32,
"SECTION_COUNT": 3,
"CONTENT_HASH": "9dd2f7cfda470a4f",
"EXTRACT_STATUS": "extracted",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/pdf_msa/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "yes"
},
{
"ID": "pdf_dpa",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_legal",
"PATH": "/Product/Legal/DPA Template.pdf",
"NAME": "DPA Template.pdf",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "pdf",
"MIME_TYPE": "application/pdf",
"SIZE_BYTES": 119800,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2026-04-18T10:30:00Z",
"MODIFIED": "2026-04-18T10:30:00Z",
"MODIFIED_BY": "alice@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": 28,
"SECTION_COUNT": 3,
"CONTENT_HASH": "f0ce8cad630666d7",
"EXTRACT_STATUS": "extracted",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/pdf_dpa/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "no"
}
],
"count": 10,
"total": 12,
"limited": true
},
"_meta": {
"epoch": 1,
"provenance": {
"source": "gdrive:files",
"sync_id": "sync-fbaf01faca",
"source_freshness": "2026-09-14T21:44:11Z",
"representation_freshness": "2026-09-14T21:44:11Z",
"resolved_fields": [],
"transforms": [
"type-coercion",
"source-default-filter"
],
"source_defaults": [
{
"field": "TRASHED",
"op": "IS",
"value": "no",
"rationale": "Drive hides trashed items by default, so counting them would disagree with what any Drive user sees."
}
]
},
"related": [
"COUNT FILES",
"COUNT FILES BY IS_FOLDER"
],
"hints": [
"Applied the source default TRASHED IS \"no\". Drive hides trashed items by default, so counting them would disagree with what any Drive user sees. Filter TRASHED explicitly to override it.",
"Showing 10 of 12 matching rows (LIMIT applies; count is not the true total - use COUNT FILES for that)."
],
"cache": "hit"
}
}