We have released a major update to SheetFetch with many new features that make connecting, importing, and automating data with Google Sheets easier than ever. This update focuses on expanding supported data sources, improving API workflows, and providing more powerful automation tools.

New Data Sources

You can now import data from more sources directly into Google Sheets without writing any code.

MongoDB Data Import
Connect your MongoDB database and automatically import collections into Google Sheets.

MySQL Data Import
Easily fetch and sync data from MySQL databases into your spreadsheets.

CSV and JSON File Import
Upload CSV or JSON files and instantly convert them into structured data inside Google Sheets.

Google Search Console Integration
Pull SEO performance data such as queries, clicks, impressions, and rankings directly from Google Search Console.

API and Automation Improvements

SheetFetch now provides powerful tools for working with APIs and automating data workflows.

API Request Builder
A visual interface to easily create API requests without coding.

Saved API Requests
Save frequently used API requests and reuse them anytime.

Response Preview
Preview API responses before sending the data to your spreadsheet to ensure everything is correct.

Pagination Auto Fetch
Automatically fetch all pages of API data without manual configuration.

Scheduled Data Refresh
Set automatic refresh schedules such as every hour, daily, weekly, or at specific times.

Google Sheets as a Data Source

Google Sheets to API
Turn your Google Sheets into an API endpoint so other applications can access your spreadsheet data.

CRUD API for Sheets
Create, read, update, and delete rows in Google Sheets through API requests.

Authentication and Security

Managing API authentication is now much simpler.

Authentication Manager
Store and manage API credentials in one place.

Multiple Authentication Options
Support for common authentication methods such as API keys, Bearer tokens, and custom headers.

Summary

This update significantly expands the capabilities of SheetFetch by adding more data sources, better API tooling, and stronger automation features. With these improvements, you can connect databases, files, and APIs to Google Sheets faster and manage your data workflows more efficiently.

More updates are coming soon as we continue improving SheetFetch.