Home
Feed

Extend

Hashnode Pro
Hashnode for Agents

Resources

The foreword
Hashnode gql skill

Buildful - AI coding agent that delivers frontier-level results at a fraction of the cost Bug0 - The AI-native e2e QA regression testing Hackathons Changelog Brand @hashnode on X Hashnode on LinkedIn Support - hello+support@hashnode.com Code of Conduct Terms Privacy Sitemap

Search Hashnode

Search posts, tags, users, and pages

Discussion on "Retrieving data from a public Google Spreadsheet and display it on a webpage" | Hashnode

Feed/

Discussion

Retrieving data from a public Google Spreadsheet and display it on a webpage

One of the most sought after tasks to create for someone, is the backend for a simple, mostly-static website for which the website owner wants control over is, editing content. So the first thing that comes to mind to almost every developer is WordPr...

Aug 20, 2022·3 min read·anjanesh.devRead the article

#javascript
#google-sheets

Written by

Anjanesh Lekshminarayanan

@anjanesh · Navi Mumbai, MH

View profile

Web UI Engineer

I am a web consultant from Navi Mumbai. Mainly dealt with LAMP stack, now into Django and getting into Laravel and Cloud. Founder of nerul.in and gaali.in

Responses1

Markdown supported · ⌘↵ to post

CapsCode

Aug 20, 2022

This is amazing... thanks you for sharing this.

It would be more amazing If you can write something on how from a webpage we can post or make an entry on google sheet

Thanks once again

Anjanesh Lekshminarayanan

Aug 20, 2022

The example in this blog post is via client-side URL fetch - hence, no authentication etc. My next post (anjanesh.dev/retrieving-data-from-a-privately-own…) shows how to connect to a private sheet server-side.

To post an entry to the google sheet you need to use server-side using PHP or nodeJS and write to it - developers.google.com/sheets/api/guides/values