Query a Google Sheet
Our platform lets you read a write to a google sheet directly.
Package
const sheets = require("@googlesheets");
Reading a sheet
let rows = await sheets.readSheet(workBookId, sheetId)
rows.map(row => {
let first_name = row["First Name"]
});
Parameter
Description
workbookID
The ID of the google sheet, from its URL
sheetID
Index of your sheet starting from 0. To read first sheet in your google sheet, pass 0
Append a row in google sheet
let sheet = await sheets.getSheet(workbookID, sheetID);
const larryRow = await sheet.addRow({ name: 'Larry Page', email: '[email protected]' });
Last updated
Was this helpful?