API Connector by Mixed Analytics
Apipheny
Sheety
Sheetson
Stein
Sheet 2 Site
Funnel.io
Supermetrics
SheetDB
Sheety
SheetBest
Sheetsu
Sheet 2 Site
Stein
Sheet2api
SHEETS2API
API Connector is a Google Sheets add-on that lets you pull data from any API directly into your Google Sheets worksheet, without needing a line of code. Just enter the request URL and API key to connect and view this data in a spreadsheet.
API Connector for Sheets contains many powerful, easy-to-use features that turn your spreadsheet into a full-featured API integration tool. Build API requests based on the value in a cell, save requests for future access, choose report styles, filter for specific fields, and set automated data refreshes to populate reports and dashboards.
Transform google spreadsheet into a JSON API and use it as a data store in a matter of seconds. Create google spreadsheet, fill first row with column names, and the rest of data.
API Connector by Mixed Analytics SheetDBBased on our record, SheetDB should be more popular than API Connector by Mixed Analytics. It has been mentiond 9 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
Request body: { "inspectionUrl": "https://mixedanalytics.com/api-connector/", "siteUrl": "sc-domain:mixedanalytics.com" }. Source: about 3 years ago
I use "API connector" add-on for google sheets and just let the api-url (mentioned above) fill a whole sheet in google, from which I can drag the names. Source: about 4 years ago
Can you tell me how an app like https://sheetdb.io/? An app like that must send thousands of requests every minute. Source: over 3 years ago
What I would do is to use 'no code' methods here and some services like this https://sheetdb.io/ that connects me to google sheet. Source: almost 4 years ago
Good for you! I've actually read :) And for the future, you may get rid of the OAuth problems by using a third-party API. I recommend sheetdb.io. Here's a piece I wrote on this, you might find interesting: https://blog.sheetdb.io/google-spreadsheet-api-without-oauth-2-0-ffd572a06757. Source: almost 4 years ago
Try using sheetdb.io - this app will handle your credentials in the background whereas you'll only need to disclose an endpoint in your script with an API key, but it's only to the particular spreadsheet to which you can set permission READ only, if you don't want to let others make any changes there. Source: about 4 years ago
There are many ways to do this these days. One way being uploading said file into google sheet, then use a service like https://sheetdb.io/ or https://sheety.co/ to turn it into an API. Boom, consumable REST API in seconds. Source: about 4 years ago
Apipheny - Pull API data into Google Sheets, easily.
Sheety - Turn any Google sheet into an API instantly, for free. Power websites, apps, or whatever you like, all from a spreadsheet. Changes to your spreadsheet update your API in realtime. Neat
SheetBest - Turn a Google SpreadSheet into a JSON Database API
Sheetson - Instantly turn any Google Sheet into RESTful API
Sheetsu - Turn Google Spreadsheet into API
Stein - Use Google Sheets as your no-setup database
