The Problem

Nonprofits track donations in spreadsheets but struggle to send receipts, thank donors promptly, or measure campaign success.

The Solution

SheetAPI turns your donation spreadsheet into an API. Accept donations online, trigger automatic thank-you emails, and track progress toward goals in real-time.

1

Set Up Your Google Sheet

Create a spreadsheet with columns like: Donation ID, Donor Name, Email, Amount, Date, Campaign, Receipt Sent, Notes

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 donation & fundraising tracking data.

Code Examples

Here's how simple it is to work with your donation & fundraising tracking 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 donation & fundraising tracking records

Create a New Record

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

// Using JavaScript (fetch)
const newRecord = {
  'Donation ID': 'Sample value',
  'Donor Name': '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 Donation & Fundraising Tracking

⚡ 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.

🔒 Secure Authentication

API keys keep your data protected. Only authorized users can access or modify your records.

Frequently Asked Questions

Can I accept donations on my website?

Yes! Integrate a payment processor and post donation data to the API to log contributions.

How do I send receipts automatically?

Use webhooks to trigger receipt emails when new donations are recorded.

Can I track campaign performance?

Absolutely! Filter donations by campaign via API to calculate totals and track progress.

Turn Google Sheets into a Donation & Fundraising Tracking API