Turn a Google Spreadsheet into a JSON API

Connect Google sheets to CRM, API, Website, WordPress, any application or tool.

SHEETS2API header image

Easy to use and implement

SHEETS2API will turn your sheets into a JSON API, easy to integrate with other tools and all programming languages.

If you want to use a different API, e.g. in your Customer Relationship Management (CRM), you can use our API to turn the spreadsheet into JSON API.

[{
"id": "1",
"name": "Tom",
"age": "15",
"comment": ""
},
{
"id": "2",
"name": "Alex",
"age": "24",
"comment": ""
}]

Google Sheets JSON API

You can read and edit your spreadsheet with GET, POST, PUT and DELETE requests with just a few lines of code.

Examples and code samples

fetch('http://sheets2api.com/api/v1/?apiId=617989cb51352')
	.then(response => response.json())
	.then(data => {
	    console.log(data);
	})
	.catch(error => {
	    console.error(error);
	});
fetch('http://sheets2api.com/api/v1/?apiId=617989cb51352')
	.then(response => response.json())
	.then(data => {
	    console.log(data);
	})
	.catch(error => {
	    console.error(error);
	});
$.ajax({
    url: "http://sheets2api.com/api/v1/?apiId=617989cb51352",
    success: function(data) {
        console.log(data);
    }
});
$options = [
    'http' => [
        'method' => 'GET'
    ]
];

$response = json_decode(
    file_get_contents('http://sheets2api.com/api/v1/?apiId=617989cb51352', false, stream_context_create($options))
);
import requests
import json

response = json.loads(
    requests.get('http://sheets2api.com/api/v1/?apiId=617989cb51352').content
)
axios.get('http://sheets2api.com/api/v1/?apiId=617989cb51352')
.then( response => {
    console.log(response.data);
});

// Get only 2 results and skip 3 rows
axios.get('http://sheets2api.com/api/v1/?apiId=617989cb51352&limit=2&offset=3')
.then( response => {
    console.log(response.data);
});
require 'net/http'
require 'json'

response = JSON.parse(
    Net::HTTP.get(
        URI('http://sheets2api.com/api/v1/?apiId=617989cb51352')
    )
)
const https = require('https');

https.get('http://sheets2api.com/api/v1/?apiId=617989cb51352', (resp) => {
  let data = '';

  // A chunk of data has been received.
  resp.on('data', (chunk) => {
    data += chunk;
  });

  // The whole response has been received. Print out the result.
  resp.on('end', () => {
    console.log(JSON.parse(data).explanation);
  });

}).on("error", (err) => {
  console.log("Error: " + err.message);
});

Friendly, personal support

Write to us via support ticket.

We are developers, we can assist with your integrations!

Ready to get started?

Create your free API now