Hello !, friends
first we need a google sheet for making api fill with dummy data or take actual data , this google sheet will help to make create a api.
after that we have to create on account for creating api link go to sheet best after creating account we need a connection url of the google sheet for that we have to make google sheet public .
After making it public go to sheet best and put google sheet link to the connection Url
Click on the DETAILS button for the your new Connection.
Now Your custom api ready for use !.