← All integrations
Generic REST API

Generic REST API → Google Sheets™

Fallback connector for public or custom REST APIs.

API Import for Google Sheets™ lets you connect Generic REST API with the most popular apps, so you can automate your work and have more time for what matters most — no code required.

No auth required

Generic REST lets you connect any public or private JSON API that API Import doesn't have a built-in connector for. Describe the call you want to make in plain English — endpoint, parameters, headers, and authentication — and API Import generates the request for you. It works with internal company APIs, third-party tools, government data portals, and any service that returns JSON over HTTP. Once configured, you can save it as a reusable workflow and schedule automatic refreshes to keep your spreadsheet current.

Example prompts
“use Open-Meteo api and get weather for new york usa.”
Tested example
  1. Open API Import for Sheets from the Google Sheets™ Extensions menu.
  2. Select Generic REST API from the API selector.
  3. Enter this prompt: “use Open-Meteo api and get weather for new york usa.”
  4. Review the generated Open-Meteo request, then run it to write the weather data into Google Sheets™.
How to get credentials

Generic REST API uses public endpoints — no credentials needed. Open the add-on, select Generic REST API, and run your prompt directly.

→ View in docs

Ready to connect Generic REST API to Google Sheets™?

Install the free add-on and start pulling data in minutes.

Install Free on Google Sheets™