data.alterloop.dev

Google Spreadsheet API with Google Apps Script

This project allows you to use a Google Spreadsheet as a database and interact with it via a REST API. The API supports operations such as listing, inserting, updating, and deleting records.

Deployment Steps

$3

1. Go to Google Sheets.
2. Create a new spreadsheet.
3. Name the sheet (e.g., Database).
4. In the first row, define the column names (e.g., id, name, email).

$3

1. Click on Extensions → Apps Script.
2. Delete any existing code.
3. Copy and paste the provided Apps Script code.

$3

1. Click Deploy → New Deployment.
2. Select Web app as the deployment type.
3. Set Who has access to "Anyone".
4. Click Deploy and authorize the script.

$3

After deployment, you will get a URL like:
``
https://script.google.com/macros/s/your-script-id/exec
`
Use this URL to interact with your API.

$3

- GET /list → Retrieve all records
- POST /insert → Add a new record
- POST /update → Update an existing record
- POST /delete → Remove a record

$3

`bash
curl -X GET "https://script.google.com/macros/s/your-script-id/exec?action=list"
`

Now your Google Spreadsheet is a fully functional database API! 🚀

Proxy

This echo server is used to test the proxy server. It is hosted on Google Apps Script.

`
function doGet(request) {
const response = ContentService.createTextOutput(JSON.stringify(request, null, 2));
response.setMimeType(ContentService.MimeType.JSON);
return response
}

function doPost(request) {
const response = ContentService.createTextOutput(JSON.stringify(request, null, 2));
response.setMimeType(ContentService.MimeType.JSON);
return response
}
``