How do I schedule an API call?

Click the 'Schedule' button in the request builder, select your request source (current or saved), choose frequency (once, daily, weekly, monthly), set the time, and save. The tool will automatically execute your API calls at the specified intervals.

How do I export API responses to Google Sheets?

After making an API call, click the 'Write to Google Sheet' button in the response panel. Authenticate with Google, select or create a spreadsheet, and the response data will be automatically written to your sheet.

Can I import cURL commands?

Yes! Paste any cURL command into the request builder and it will automatically parse the URL, headers, method, and body. You can also export your requests as cURL commands for sharing.

How do I visualize API responses?

After receiving a response, click the 'Visualize' tab to see automatic charts and graphs. The tool detects chartable data and creates appropriate visualizations including bar charts, line charts, and pie charts.

What file formats can I export to?

You can export API responses as CSV files for spreadsheet analysis, or directly write data to Google Sheets for real-time collaboration and automation.

API Tool - Data Toolkit for Sheets | Test & Schedule API Calls

Key Features

Scheduled API Calls

Automate recurring requests

Response Visualization

Automatic charts & graphs

Google Sheets Integration

Direct data export

cURL Import/Export

Easy command conversion

API Tool Features & Capabilities

Request Building

HTTP Methods: GET, POST, PUT, DELETE, PATCH
Custom Headers Support
Request Body (JSON/Form Data)
cURL Import/Export
Query Parameters Builder

Response Handling

Raw Response View
Pretty JSON Formatting
Response Headers Display
Automatic Visualization
Response Time Tracking

Scheduling & Automation

One-time API Calls
Daily Recurring Schedules
Weekly Automation
Monthly Batch Processing
Schedule Management

Data Export & Integration

CSV Export
Google Sheets Integration
Response Copy to Clipboard
Request History
Saved Requests Library

How to Use the API Tool

Step 1: Build Your Request

Enter your API endpoint URL, select the HTTP method, and add any required headers or request body. You can also paste a cURL command to auto-populate all fields.

Step 2: Send & Analyze

Click "Send" to execute your API call. View the response in raw format, pretty-printed JSON, or as automatically generated charts and visualizations.

Step 3: Schedule Automation

Set up recurring API calls by clicking "Schedule". Choose frequency (once, daily, weekly, monthly) and the tool will automatically execute your requests.

Step 4: Export Results

Export your API responses as CSV files or directly write data to Google Sheets for further analysis and collaboration.

Popular Public APIs to Test

JSONPlaceholder

REST API for testing and prototyping

Dog API

Random dog images and facts

Cat API

Random cat images and facts

Quotable

Random quotes and sayings

IP Geolocation

IP address geolocation data

Date & Time API

Current date and time information