API Import lets you pull data from launch-ready APIs directly into Google Sheets™ — no coding required.

Just describe what data you want in plain English, and API Import handles the rest: it builds the API request, fetches the data, and writes the results straight into your sheet.

What you can do:

- Connect Shopify, HubSpot, YouTube Data API™, Google Analytics 4™, Google Search Console™, or a public/custom REST endpoint
- Describe your request in plain English — no need to know API syntax
- Get results mapped automatically into clean columns in your sheet
- Save your favourite API + prompt combinations as workflows
- Schedule workflows to run automatically and keep your data fresh

Who it's for:

E-commerce teams syncing Shopify orders or inventory. Sales and CRM teams pulling HubSpot contacts and deals. Content teams importing YouTube™ channel and video metrics. Marketing analysts pulling GA4 traffic reports or Search Console keyword performance. Operators who need JSON data from REST endpoints in a spreadsheet without writing code.

Supported APIs:

The add-on supports Shopify, HubSpot, YouTube Data API™, Google Analytics 4™, Google Search Console™, and Generic REST API.

How it works:

1. Install API Import from the Google Workspace™ Marketplace
2. Open the sidebar in any Google Sheets™ spreadsheet
3. Select a launch connector and connect credentials when needed
4. Describe what you want in plain English
5. Hit Run — your data appears in the sheet instantly

Save that configuration as a workflow and schedule it to run daily, hourly, or weekly — so your sheet always has fresh data without manual effort.

Google Sheets™, Google Workspace™, YouTube™, Google Analytics 4™, and Google Search Console™ are trademarks of Google LLC.