search

postman-open-technologies / collections

This is where we track everything collections.
Apache License 2.0
5 stars 1 forks source link

Pull Data From Google Sheet #3

Open kinlane opened 2 years ago

kinlane commented 2 years ago

We need a default collection for pulling data from a Google Sheet. Providing robust documentation of the steps for how to take any Google Sheet and pull it via the API. Then provide at least a basic HTML listing using Visualizer for the data.

arlemi commented 2 years ago

@Gbahdeyboh Here's the stackoverflow answer I refer to 100% of the time I want to work with any Google API: https://stackoverflow.com/questions/32076503/using-postman-to-access-oauth-2-0-google-apis

Gbahdeyboh commented 2 years ago

Thanks for sharing @arlemi!

kinlane commented 2 years ago

Interesting. I have a list of those types of Stack Overflows for various things I do to. How do we build more workspaces that support this reality that developers face?

arlemi commented 2 years ago

@kinlane Creating a collection and quick tutorial for an updated version of that SO answer has been on my list for a little while now... I'll create an issue for it on the devrel tracker and hopefully can pick it up in our next sprint!

Gbahdeyboh commented 1 year ago

@kinlane while working on this collection, I figured I could include requests for other operations that the spreadsheet API provides(the collection has just one request for fetching a single spreadsheet). I did some digging and saw that I could generate an Open API definition from a Google discovery document. It seemed too verbose to put in the Postman Answers workspace where this collection currently resides, so while I was checking around, and I saw that you already have a workspace for Google APIs.

I found it fascinating. Can I get access to that workspace so I can include the Open API document for spreadsheets and generate a collection for that in the workspace?