Is it possible to get data from web that use json api?
i mean i can make a script with json in the spreadsheet and get my results from a special website?(with permission from that site ofcourse)
i want to make my spreadsheet fully automatic
Is it possible to get data from web that use json api?
i mean i can make a script with json in the spreadsheet and get my results from a special website?(with permission from that site ofcourse)
i want to make my spreadsheet fully automatic
Without knowing the details, the general answer is; yes.....
You can get the JSon data into your Google Sheets by a script, if you can access the JSon data on the web.
Yes, before i try write the script i will ask for permission to get the data i need. Thank you!
Part I
Use a free ImportJSON Script
1. Open a Google Sheet
Open a new or existing Google Sheet.
Tip: You can go to sheets.new in your browser if you want to create a new Google Sheet
2. Open Script Editor
In your Google sheet, in the menu at the top, click Extensions > Apps Script
3. In the script editor, remove the placeholder content
If there is any placeholder code typed into the script editor, you can remove it.
4. Copy and paste an open-source script
Go to: gist.github
Copy all of the code for ?import_json_appsscript.js? and paste the code into the script editor of your Google Sheet.
This is a free, open-source script someone created to import JSON into a Google Sheet.
5. Save and name the script
After you copy and paste all of the script into the script editor, click the save button and name your project.
You can name the project anything you want, but naming it something like ?ImportJSON? will make it easy to remember.
6. Go back to your Google Sheet
After saving your project in the script editor, you can now close the script editor tab in your browser and go back to your Google Sheet.
Now, in any cell of your Google Sheet, start typing ?=import? (without the quotation marks) and you will see ?ImportJSON? pop-up as an option. This is the script you saved in the script editor.
Click on the ?ImportJSON? option.
7. Add your JSON API URL
After opening your Import JSON formula, you?ll need to add your JSON API URL.
8. Import your JSON data
Your last and final step to import JSON, after entering your JSON URL, is to your Google Sheet is to hit the enter button on your keyboard and wait for the JSON data to populate your spreadsheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks