Your first import

Open the Google Workspace Marketplace listing and click Install. The add-on is free and requires no credit card.

Google will ask for permission to run as an add-on in your Sheets. Click Allow.

Open any Google Sheets spreadsheet. In the menu bar, click Extensions → API Import for Google Sheets™ → Open.

The API Import sidebar opens on the right side of your sheet. It stays open while you work.

Use the Select API dropdown at the top of the sidebar to choose a pre-configured connector (e.g. Shopify, GitHub, YouTube Data) or select Generic REST API to connect to any endpoint.

See the Connectors section for credential setup steps for each API.

Type what data you want in the Prompt field using plain English. Good prompts are specific about what you want returned:

Click Generate. The add-on uses AI to build the API request from your prompt — method, URL, headers, and query parameters.

The Preview panel shows the full request before it runs. Review it and adjust the prompt if needed, then click Run.

API Import writes the response directly into the active sheet, starting at the cell you specify (default: A1). Each field becomes a column with auto-generated headers.

Nested JSON objects are flattened automatically. See Output Settings to control the target range, filter columns, or export to PostgreSQL.

Once you have a working prompt, click Save as Workflow and give it a name. Saved workflows can be re-run in one click, or scheduled to run automatically on a hourly, daily, or weekly schedule.

See Workflows for scheduling and run history.