---
title: "Discussion on \"Retrieving data from a public Google Spreadsheet and display it on a webpage\" | Hashnode"
description: "Discussion on \"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..."
url: "https://hashnode.com/posts/retrieving-data-from-a-public-google-spreadsheet-and-display-it-on-a-webpage/630049a574730d13020f0a8c"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Retrieving data from a public Google Spreadsheet and display it on a webpage](https://anjanesh.dev/retrieving-data-from-a-public-google-spreadsheet-and-display-it-on-a-webpage?utm_source=hashnode&utm_medium=feed)

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.dev  
Read the article

-   [#javascript](https://hashnode.com/tag/javascript)
-   [#google-sheets](https://hashnode.com/tag/google-sheets)

## Written by

[Anjanesh Lekshminarayanan](https://hashnode.com/@anjanesh)

@anjanesh · Navi Mumbai, MH

  
[View profile](https://hashnode.com/@anjanesh)

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

## Responses 1

Markdown supported · ⌘↵ to post

[CapsCode](https://hashnode.com/@capscode)

[Aug 20, 2022](https://hashnode.com/posts/retrieving-data-from-a-public-google-spreadsheet-and-display-it-on-a-webpage/630049a574730d13020f0a8c/comment/6300927f74730d13020f15d8)

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](https://hashnode.com/@anjanesh)

[Aug 20, 2022](https://hashnode.com/posts/retrieving-data-from-a-public-google-spreadsheet-and-display-it-on-a-webpage/630049a574730d13020f0a8c/comment/6300927f74730d13020f15d8#reply-63009b6374730d13020f1791)

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…](https://anjanesh.dev/retrieving-data-from-a-privately-owned-google-spreadsheet-via-api-without-oauth)) 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](https://developers.google.com/sheets/api/guides/values#writing)