Stop Exporting CSVs. Your Spreadsheet Can Pull Live Data Now.

API Import for Google Sheets lets you describe what you want in plain English — the AI configures the full API request and writes results directly into your sheet. No API docs. No code. No developer needed.

It's Monday morning. You open a browser tab, log into HubSpot, navigate to the deals report, adjust the date filter, click export, wait for the email, download the CSV, open it, fix the column headers, paste it into Sheets, and start your week.

You've done this exact sequence so many times your fingers know the path by heart.

And here's the thing: none of that was your job. Your job was the analysis at the end — the part that takes judgment. The export ritual was just overhead. Necessary overhead, sure. But 20 minutes you'll never get back, every single week, forever.

There's a better way.

The real problem isn't that APIs are hard. It's that you shouldn't need to learn them.

APIs are how software talks to software. Every platform you use — Shopify, HubSpot, Google Analytics, Mailchimp — has one. And in theory, you could query any of them directly and get exactly the data you need, formatted exactly how you want it.

In practice, that means reading API documentation, figuring out the right endpoint, constructing a URL with the right query parameters, handling authentication headers, managing pagination so you don't only get the first 100 rows — and writing all of that in code you then have to maintain.

Most people don't do that. They export CSVs, copy-paste from dashboards, or put a ticket in the developer queue and wait.

None of those options are good. But until recently, they were the only ones.

What API Import does

API Import for Google Sheets is a Google Workspace addon from Codoha. The idea is simple: you describe what you want in plain English, and the AI configures the full API request for you — endpoint, query parameters, auth headers, pagination — and writes the results directly into your sheet.

No API documentation. No code. No developer.

Here's how it works:

1. Prompt. Pick a connector (Shopify, HubSpot, Google Analytics 4, and more) and type what you want. "List HubSpot deals opened this month by stage and owner." The AI figures out the rest.

2. Authenticate. Connect once with your API key or OAuth. Credentials are stored securely and reused on every future run.

3. Deliver. Results land in Google Sheets. You can also export to CSV or push rows to a Postgres database. Power BI, BigQuery, and Snowflake support is coming.

4. Flow (optional but worth it). Set a condition and attach an automated action. More on this below.

The connectors at launch

API Import ships with eight built-in connectors:

• Shopify — orders, products, customers, inventory
• HubSpot — contacts, companies, deals, pipeline data
• Google Analytics 4 — sessions, conversions, traffic sources
• Google Search Console — queries and pages, returning up to 25,000 rows (the Search Console UI caps at 1,000)
• YouTube Data API — channel stats, video performance
• Mailchimp — audience growth, campaign performance
• GitHub — repos, issues, pull requests, commits
• Generic REST API — any public or custom JSON endpoint

That last one deserves a mention. If you have an internal tool or a less-common platform, you're not blocked. Describe what you need from any JSON API and the AI handles the request the same way.

Flows: the part that changes how you think about monitoring

Pulling data into a sheet is useful. Knowing automatically when something important changes is better.

Flows attach conditional automation to any saved workflow. When your API data meets a condition you define, it triggers an action — an email, a Slack message, or a write to another sheet.

There are three trigger types:

Threshold — a numeric comparison. Revenue fell below $10,000. New deals this week dropped under five.

Always — fires on every scheduled run. Useful for keeping a summary sheet fresh or logging data over time.

Scout AI — the one that earns its name. You write a condition in plain English: "Has organic traffic dropped more than 20% compared to last week?" The AI reads the full API response, evaluates your condition, and triggers the action if true — along with a plain-English explanation of why.

Who's using it and how

Sales teams have replaced the Monday morning export ritual with a scheduled HubSpot workflow. Sarah Morrison, a Sales Ops manager at a SaaS company, put it plainly: "I used to export HubSpot deals manually every Monday morning. Now it just runs — and I get an email alert if any deal over $10k hasn't moved in two weeks. Set it once, forget it."

Ecommerce and marketing teams are using it to consolidate data from multiple platforms into a single report. James Kim, a Growth Manager at an ecommerce brand, built three API connections — Shopify, GA4, and Search Console — that refresh weekly on their own. "I haven't opened the sheet to check it in weeks," he said. "The Flows tell me when something needs attention."

Operations teams and agencies have found that Generic REST unlocks use cases nobody anticipated. Diane Larson, Head of Operations at an agency, used it to connect their internal API and add a Scout trigger for error rate spikes. "We replaced a whole monitoring dashboard with two prompts."

Where API Import came from

Codoha built this tool for themselves first. They needed to pull Paddle billing data and Google Cloud usage into Sheets for internal reporting. The options were: write and maintain a custom Apps Script, pay for a connector tool that didn't quite cover what they needed, or keep exporting CSVs by hand. None of those felt right for something they'd need to run every week. So they built API Import.

That backstory matters. This isn't a tool designed by someone who's never had to do a Monday morning export. It's a tool built by people who got tired of doing them.

Getting started

API Import for Google Sheets is free to install from the Google Workspace Marketplace. No credit card required.

Install it, open a sheet, pick a connector, and type what you want. If your first prompt doesn't pull exactly what you expected, tweak the description — the AI adjusts. Most people have data in their sheet within the first five minutes.

Get the Add-On - Free

Text To Table Converter

Install API Import for Google Sheets — it's free: Pull live data from Shopify, HubSpot, Google Analytics, and more directly into your spreadsheet with a plain-English description.

Install free

*API Import for Google Sheets is built by Codoha, the team behind Text To Table Converter and other Google Workspace tools. Questions? Reach out at support@apiimport.com.*