Connect Google sheets to CRM, API, Website, WordPress, any application or tool.
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": "" }]
You can read and edit your spreadsheet with GET, POST, PUT and DELETE requests with just a few lines of code.
fetch('https://sheets2api.com/api/v1/?apiId=617989cb51352') .then(response => response.json()) .then(data => { console.log(data); }) .catch(error => { console.error(error); });
fetch('https://sheets2api.com/api/v1/?apiId=617989cb51352') .then(response => response.json()) .then(data => { console.log(data); }) .catch(error => { console.error(error); });
$.ajax({ url: "https://sheets2api.com/api/v1/?apiId=617989cb51352", success: function(data) { console.log(data); } });
$options = [ 'http' => [ 'method' => 'GET' ] ]; $response = json_decode( file_get_contents('https://sheets2api.com/api/v1/?apiId=617989cb51352', false, stream_context_create($options)) );
import requests import json response = json.loads( requests.get('https://sheets2api.com/api/v1/?apiId=617989cb51352').content )
axios.get('https://sheets2api.com/api/v1/?apiId=617989cb51352') .then( response => { console.log(response.data); }); // Get only 2 results and skip 3 rows axios.get('https://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('https://sheets2api.com/api/v1/?apiId=617989cb51352') ) )
const https = require('https'); https.get('https://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); });
Write to us via support ticket.
We are developers, we can assist with your integrations!
Create your free API now