api2sheet

api2sheet allows you to retrieve the JSON content of a Restful API and import it into a Google Spreadsheet

Give it a try !

Enter the URL of a Google Spreadsheet below and the URL of an API endpoint and give it a try. Make sure the spreadsheet is empty !

The spreadsheet ID. Make sure the spreadsheet is empty.
The sheet name.
The API URL. For example https://jsonplaceholder.typicode.com/posts
The API Key will be added to the Authorization header, using "Bearer ". 


    
Let me know what you think about this by adding a comment in this related blog post.


    
Privacy Policy