The Problem

Quilt guilds accumulate hundreds of patterns that members borrow. Tracking who has what, managing donations, and organizing challenges is scattered across notebooks.

The Solution

SheetAPI digitizes your pattern library. Members search and request patterns online, librarians track lending, and challenge coordinators manage submissions.

1

Set Up Your Google Sheet

Create a spreadsheet with columns like: Pattern Name, Designer, Category, Skill Level, Checked Out To, Due Date, Donated By, Location

2

Connect to SheetAPI.pro

Sign up (takes 10 seconds), authorize Google, and paste your sheet URL. Done.

3

Start Using Your API

Get instant REST API endpoints to create, read, update, and delete your quilt guild pattern library data.

Code Examples

Here's how simple it is to work with your quilt guild pattern library data:

Fetch All Records

# Using cURL
curl -H "Authorization: Bearer YOUR_API_KEY" \
  https://api.sheetapi.pro/v1/YOUR_SHEET_ID

// Using JavaScript (fetch)
const response = await fetch('https://api.sheetapi.pro/v1/YOUR_SHEET_ID', {
  headers: {
    'Authorization': 'Bearer YOUR_API_KEY'
  }
});

const data = await response.json();
console.log(data); // Your quilt guild pattern library records

Create a New Record

# Using cURL
curl -X POST \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"Pattern Name":"VALUE1","Designer":"VALUE2"}' \
  https://api.sheetapi.pro/v1/YOUR_SHEET_ID

// Using JavaScript (fetch)
const newRecord = {
  'Pattern Name': 'Sample value',
  'Designer': 'Another value'
};

const response = await fetch('https://api.sheetapi.pro/v1/YOUR_SHEET_ID', {
  method: 'POST',
  headers: {
    'Authorization': 'Bearer YOUR_API_KEY',
    'Content-Type': 'application/json'
  },
  body: JSON.stringify(newRecord)
});

Update a Record

// Update by row ID
const response = await fetch('https://api.sheetapi.pro/v1/YOUR_SHEET_ID/ROW_ID', {
  method: 'PATCH',
  headers: {
    'Authorization': 'Bearer YOUR_API_KEY',
    'Content-Type': 'application/json'
  },
  body: JSON.stringify({ 'Status': 'Updated' })
});

Key Features for Quilt Guild Pattern Library

⚡ Real-Time Sync

Changes in your Google Sheet reflect in the API instantly. No delays, no manual syncing.

🔔 Webhooks

Get notified instantly when data changes. Trigger automations, send emails, or update other systems.

📝 Full CRUD Operations

Create, Read, Update, and Delete records via REST API. Complete control over your data.

Frequently Asked Questions

Can members search patterns online?

Yes! Build a catalog where members filter by category or designer and request checkout via API.

How do I track overdue patterns?

Query items past due date and use webhooks to send reminder emails to borrowers.

Can we manage guild challenges?

Create challenge entries where members submit photos of completed quilts for voting and recognition.

Turn Google Sheets into a Quilt Guild Pattern Library API