Recommended API list

3 min readOct 7, 2019

Google Sheets API

Official: https://developers.google.com/sheets/api/reference/rest/
You can read and write tens of thousands of Google spreadsheets
If it is only reading, it can be done only by issuing APIkey, but writing requires OAuth authentication

Official: https://developers.google.com/youtube/v3/docs/
You can search YouTube to get a list of videos, playlists, channels, etc., and update it
Although it is possible to specify the region ( regionCode: US) and language ( relevanceLanguage: en) in the search conditions , other languages are also mixed.

Official: https://developers.google.com/maps/documentation/javascript/tutorial
It can be used to display a map on the web and to make a pin or display route guidance
In conjunction with Geolocation API, you can also display the current location and terminal direction on the map.

Official: https://cloud.google.com/vision/docs/quickstart
You can use Google’s image recognition AI to extract characters from images and obtain various analysis information
The free limit is only used up by just playing with the tutorial, so you need to consider the paid limit to use it as it is

Official: https://azure.microsoft.com/en-us/services/cognitive-services/computer-vision/
Like Google Cloud Vision API, you can use Microsoft’s image recognition AI to extract characters from images and obtain various analysis information.
Regarding performance such as Japanese support, Google feels slightly above, but the price is cheaper here, and it can be fully used even in the free frame

Official: https://azure.microsoft.com/en-us/services/cognitive-services/face/
Using face recognition AI specialized in human face recognition, you can acquire facial identification, analysis of features and emotions, etc.

Official: https://developers.facebook.com/docs/graph-api
Implement various processes using Facebook, such as reading and updating Facebook users and Facebook page information
Since access permissions are subdivided, it is necessary to make an application and apply for access permission individually for use
Also, there are various types of access tokens, so if you do not extend it, it will expire immediately, so be careful
A trial tool called Graph API Exproler is provided, so it is recommended that you touch it variously.

Official: https://developers.facebook.com/docs/instagram-api
The Instagram Platform API has been deprecated, so this is the new Instagram API. (Note that technical blogs often describe APIs that have been abolished)
Just like the Facebook Graph API, you need to create a demo app and apply for permissions in order to use it
In addition, using this API, Instagram information can be acquired and updated only for Instagram business accounts, and there is no current method for acquiring information by searching for personal accounts via the API.
Also, in order to transfer Instagram to a business account, it is necessary to prepare a Facebook page and link with Instagram
Only Facebook Marketing Partners or Instagram Partners are currently available for Instagram posts

Official: https://developer.twitter.com/en/docs
Previously, I like is feel free to make Bot, API examination has become severe or become necessary limit for, is expect too much can such unlikely future
If you pass the review, you will be able to perform normal Twiiter operations such as searching, obtaining, and posting tweets via the API.

Official: https://developers.line.me/en/docs/messaging-api/overview/
If you prepare a server that receives webhooks, you can create a bot that automatically responds with LINE.
You can also use special messages and functions such as Flex messages and quick reply
There is no need for review, but a trial or paid plan is required to use push messages (messages sent unilaterally apart from response messages).

Official: https://developer.foursquare.com/docs/api/endpoints
Foursquare can be used via the API to search various nearby spots from location information
Regular API Endpoints can be used more than 90,000 times a day even with free slots (Premium API Endpoints 500 times a day)