Authentication Modes
Google Apps Script Mode
Free Read and Write operations using Google Apps Script Web App proxies.
Google Apps Script mode allows both Read and Write (append, update, clear) operations without creating Google Cloud Platform (GCP) credentials or paying for API usage.
Setup & Deployment
- Open Google Sheet -> Extensions -> Apps Script.
- Paste the
Code.gshandler script:
Code.gs
function doGet(e) {
const sheetName = e.parameter.sheet || 'Sheet1';
const range = e.parameter.range || 'A1:Z100';
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
const values = sheet.getRange(range).getValues();
return ContentService.createTextOutput(JSON.stringify(values)).setMimeType(ContentService.MimeType.JSON);
}
function doPost(e) {
const data = JSON.parse(e.postData.contents);
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(data.sheet || 'Sheet1');
if (data.values) {
data.values.forEach(r => sheet.appendRow(r));
}
return ContentService.createTextOutput(JSON.stringify({ success: true })).setMimeType(ContentService.MimeType.JSON);
}
- Click Deploy -> New Deployment -> Select type Web App.
- Set Execute as: Me, Who has access: Anyone.
- Copy Web App URL to
.env:
.env
GSHEET_APPSCRIPT_URL=https://script.google.com/macros/s/.../exec
Example (Read & Write)
pages/feedback.vue
<script setup lang="ts">
const { data: items } = await useGSheetAsObject('A1:C50', { sheet: 'Feedback' })
const { append } = useGSheetWrite({ sheet: 'Feedback' })
const addFeedback = async () => {
await append('A1:C1', [['101', 'Alex', 'Great tool!']])
}
</script>