Authentication Modes
CSV Export Mode
Fast, zero-config CSV stream parsing for public Google Sheets.
CSV mode streams raw CSV exports directly from Google Sheets endpoints for public spreadsheets.
It is lightweight and fast for dumping entire tables into arrays.
Setup
- Share your Google Sheet as Anyone with the link can view.
- Add to
.env:
.env
GSHEET_SPREADSHEET_ID=your-google-spreadsheet-id
Example
pages/catalog.vue
<script setup lang="ts">
const { data: rows } = await useGSheet('A1:Z100', {
sheet: 'Catalog'
})
</script>