Integrations

API integrations for Google Sheets

Pull data from popular APIs into Google Sheets with guided connectors, plain-English prompts, and saved workflows.

ExchangeRate.host
ExchangeRate.host

Foreign exchange rates and currency conversion.

“Get the latest exchange rate from USD to EUR”
FinanceAPI key
Exchange Rates API Australia
Exchange Rates API Australia

Official Reserve Bank of Australia exchange-rate data exposed through REST endpoints.

“Get the latest official RBA exchange rates”
FinanceBearer token
Coinbase
Coinbase

Cryptocurrency prices and Coinbase public market data.

“Get the Bitcoin spot price in USD from Coinbase”
FinanceOptional auth
Yahoo Finance
Yahoo Finance

Stock quotes, market summaries, and historical chart data through RapidAPI's YH Finance API.

“Get the current stock quote for AAPL from Yahoo Finance”
FinanceAPI key
Google Search Console
Google Search Console

Google Search Console search performance, site verification, sitemap, and inspection data.

“List my Google Search Console properties”
SEOOAuth
Google Ads API
Google Ads API

Read-only Google Ads account discovery and GAQL reporting data.

“List my accessible Google Ads customer accounts”
AdvertisingOAuth
YouTube Data API
YouTube Data API

YouTube Data API v3 channel, video, playlist, search, and public statistics data.

“Get my YouTube channel stats”
VideoOAuth
GitHub
GitHub

GitHub repository, issue, pull request, and user data.

“Get the latest 50 open issues from octocat/hello-world”
DeveloperBearer token
Stripe
Stripe

Stripe payments, customers, invoices, and billing data.

“List the latest 25 Stripe customers”
PaymentsSecret key
Shopify
Shopify

Shopify store orders, products, customers, and inventory data.

“List orders from mystore.myshopify.com”
E-commerceAPI key
AccuWeather
AccuWeather

Real-time weather data, forecasts, and conditions from AccuWeather — including Core Weather, MinuteCast™, and Lightning APIs.

“Get current weather conditions in Tokyo”
WeatherAPI key

How to connect an API

  1. 01
    Pick a connector

    Choose a listed connector for known APIs. Use Generic REST API for custom endpoints or APIs not yet listed.

  2. 02
    Connect credentials

    No auth: run public endpoints directly. API key or bearer token: save in API Import and select before running. Google OAuth: connect your account for Search Console or YouTube.

  3. 03
    Write a prompt

    Use plain English with the key resource, filters, dates, or IDs. E.g. "Get Google Search Console clicks by query for example.com."

  4. 04
    Review and run

    Review the generated request — URL, method, and headers for REST; endpoint, query, and variables for GraphQL. Results write into the active sheet.

  5. 05
    Save and schedule

    Save repeat requests as workflows. Schedule hourly, daily, or weekly refreshes to keep data fresh automatically.