public-google-sheets-parser
Advanced tools
It is a simple parser for browser that helps you use public Google sheets document as if they were a database.
The document to be used must be a Google Sheets document in the 'public' state and have a header in the first row. (e.g. Google sheets for example)
It does not work in browsers where the fetch API is not available.
Currently, it is only available in the browser through the distribution file.
<!-- http://fureweb.com/public-google-sheets-parser.html -->
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Public google sheets parser for browser</title>
</head>
<body>
<div class="for-input">
<input id="sheet-id" type="text" style="width: 300px" placeholder="insert your spreadsheet ID here">
<button class="get-items">GET ITEMS</button>
</div>
<div>
<p>Sample ID: 10WDbAPAY7Xl5DT36VuMheTPTTpqx9x0C5sDCnh4BGps</p>
<p><a target="_blank" href="https://docs.google.com/spreadsheets/d/10WDbAPAY7Xl5DT36VuMheTPTTpqx9x0C5sDCnh4BGps/edit#gid=1839148703">SpreadSheet URL</a></p>
</div>
<div class="result" style="padding: 16px; border: 1px solid #dedede; background-color: #eee"></div>
<script src="http://fureweb.com/public-google-sheets-parser.min.js"></script>
<script>
(() => {
const showResult = (string) => {
document.querySelector('.result').innerHTML = JSON.stringify(string)
}
const getItems = () => {
const spreadsheetIdElement = document.querySelector('#sheet-id')
if (!spreadsheetIdElement.value) {
window.alert('Please insert your public spreadsheet ID')
return spreadsheetIdElement.focus()
}
const parser = new PublicGoogleSheetsParser(spreadsheetIdElement.value.trim())
parser.parse().then((items) => {
// items should be [{ a :1, b :2, c :3 },{ a :4, b :5, c :6 },{ a :7, b :8, c :9 }]
showResult(items)
})
}
document.querySelector('.get-items').onclick = getItems
})()
</script>
</body>
That's it!
FAQs
Get JSONArray from public google sheets with using only spreadsheetId
The npm package public-google-sheets-parser receives a total of 5,614 weekly downloads. As such, public-google-sheets-parser popularity was classified as popular.
We found that public-google-sheets-parser demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
Security News
Malicious Go packages are impersonating popular libraries to install hidden loader malware on Linux and macOS, targeting developers with obfuscated payloads.
Security News
Bybit's $1.46B hack by North Korea's Lazarus Group pushes 2025 crypto losses to $1.6B in just two months, already surpassing all of 2024's $1.49B total.
Security News
OpenSSF has published OSPS Baseline, an initiative designed to establish a minimum set of security-related best practices for open source software projects.