const sheetID = “1hfyBHgPnQ7ENHDK31HAaXzHLT2pqtceMENRUZEUMndk”; const sheetName = “Sheet1”; const url = `https://docs.google.com/spreadsheets/d/${sheetID}/gviz/tq?sheet=${sheetName}`; fetch(url) .then(res => res.text()) .then(rep => { const jsonData = JSON.parse(rep.substr(47).slice(0, -2)); const rows = jsonData.table.rows.map(row => row.c[0]?.v || “”); const chunks = []; for (let i = 0; i < 5; i++) { chunks.push(rows.slice(i * 100, (i + 1) * 100).join("\n")); } [...]
Category Archives: Uncategorized
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!