Displaying a google sheet

Ask for Help
1

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.

2

This is exactly what you need.

CleanShot 2025-02-28 at 07.31.12@2x
CleanShot 2025-02-28 at 07.31.12@2x2262×1410 110 KB

1 Like
3

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.

4

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?

5

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

6

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

So a cURL would look somewhat like this.

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.

1 Like