保存/导出到Excel也可以自动进行(使用Apps脚本预定的触发器每隔几分钟保存到Google Drive，并使用Drive API访问文件)，但是由于您说过似乎不想导出到Excel，因此可以尝试执行以下操作:

Saving/exporting to an Excel can also be automated (save to Google Drive every few mins using Apps Script Scheduled Triggers and access the file using the Drive API) but since you said you don't seem to want to export to Excel, you could try doing the following:

1. 从VBA中访问具有范围的Google Sheets API获取值"端点从需要数据的地方( https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get )[查看此线程:JSON VBA解析为Excel ].