# Displaying a google sheet

**URL:** <https://community.glideapps.com/t/displaying-a-google-sheet/80389>\
**Category:** Ask for Help\
**Created:** [February 27, 2025, 4:48pm UTC](https://community.glideapps.com/t/displaying-a-google-sheet/80389 "2025-02-27T16:48:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![RockRon](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@RockRon](https://community.glideapps.com/u/RockRon)\
**Post date:** [February 27, 2025, 4:48pm UTC](https://community.glideapps.com/t/displaying-a-google-sheet/80389/1 "2025-02-27T16:48:05Z")

</div>

I would like to know if I create a google spreadsheet using Make or Zapier and I want to retrieve it and edit it later on in an Iframe.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 28, 2025, 12:31am UTC](https://community.glideapps.com/t/displaying-a-google-sheet/80389/2 "2025-02-28T00:31:24Z")

</div>

> **[How To Embed An Editable Google Sheet Into A Webpage](https://3moons.io/how-to-embed-an-editable-google-sheet/)**
>
> This article explains how to set up and embed an editable Google Sheet so that other people viewing the page can make changes to the sheet from your website.

This is exactly what you need.

 ![CleanShot 2025-02-28 at 07.31.12@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/15e52f6473ee4cf6caa6efcd226b709314047d2a.jpeg)

---

<div class="post-metadata">

**Author:** ![RockRon](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@RockRon](https://community.glideapps.com/u/RockRon)\
**Post date:** [February 28, 2025, 11:43am UTC](https://community.glideapps.com/t/displaying-a-google-sheet/80389/3 "2025-02-28T11:43:27Z")

</div>

Thank you for the response but this will not work for us.  
When someone creates a project, each project might or might not have a unique spreadsheet.  
There are no configured spreadsheets ahead a time. It is more of a dynamic situation.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 28, 2025, 12:04pm UTC](https://community.glideapps.com/t/displaying-a-google-sheet/80389/4 "2025-02-28T12:04:26Z")

</div>

As I understand, to embed a sheet like that, you must at least go into the sheet to publish it.

Can you share what’s the use case? Why can’t users just edit their data in Glide?

---

<div class="post-metadata">

**Author:** ![RockRon](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@RockRon](https://community.glideapps.com/u/RockRon)\
**Post date:** [February 28, 2025, 4:13pm UTC](https://community.glideapps.com/t/displaying-a-google-sheet/80389/5 "2025-02-28T16:13:26Z")

</div>

We are creating a CRM with the ability to creating Proposals.  
Before we create a proposal for a potential project we use a spreadsheet to work up pricing scenarios for each project before we submit the proposal. Currently we use a shared excel spreadsheet for each proposal. Each project would have a separate excel

So my idea was once we created a Project Bid, we would use Zapier to create a google sheet. That sheet would be linked to that project bid so anyone going into that project bid would have accesss to see how we came up with the pricing by opening and viewing the spreadsheet

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 1, 2025, 4:57am UTC](https://community.glideapps.com/t/displaying-a-google-sheet/80389/6 "2025-03-01T04:57:47Z")

</div>

> <https://stackoverflow.com/questions/38533957/google-sheets-api-how-to-publish-to-web-for-embeddable-sheet>

Seems like this is the only documented way to do it via the API.

> **[Method: revisions.update  |  Google Drive  |  Google for...](https://developers.google.com/drive/api/reference/rest/v3/revisions/update)**

> **[REST Resource: revisions  |  Google Drive  |  Google for...](https://developers.google.com/drive/api/reference/rest/v3/revisions#Revision)**

So a cURL would look somewhat like this.

```auto
curl -X PATCH \
  'https://www.googleapis.com/drive/v3/files/FILE_ID/revisions/REVISION_ID' \
  -H 'Authorization: Bearer YOUR_ACCESS_TOKEN' \
  -H 'Content-Type: application/json' \
  -d '{
    "published": true,
    "publishedOutsideDomain": true
  }'

```

As I’ve been diving deeper into the Google Drive API documentation, I’ve learned that **revisions are automatically generated by Google Drive itself**. This means that every time a file is modified (e.g., a Google Sheet is edited), Google Drive creates a new revision of the file. These revisions are essentially snapshots of the file at different points in time, allowing you to track changes and restore previous versions if needed.

So looks like you have to either test with a revisionID = 1, or do a list call to list all revisions and get an ID to use in the patch.

Essentially what you’re doing here is updating a past revision to also include the information that the sheet has been published to web.