Easily pull data into Google Sheets

Use these spreadsheet add-ons to extract and store data from almost any source

API Connector for Google Sheets

Turn Google Sheets into a powerful, flexible API client that pulls API data directly into your spreadsheet.

  • Connects to almost any API
  • Runs directly through Google Sheets
  • Dynamic and customizable, without code
  • Free forever (for standard features)

Archive Data for Google Sheets

Automatically store snapshots of historical data in your Google Sheets reports and dashboards.

  • Save data on a schedule
  • Runs directly through Google Sheets
  • Customize destination and output settings
  • Free (all features)

Serving over half a million professionals at these great organizations & many more:

google logo iprospect logo stanford logo mckinsey logo uber logo zendesk logo ebay logo nyu logo
nfl logo netflix logo shopify logo cryptocom logo groupm logo orange logo discovery logo truedigital logo

Wow, importing JSON has never been easier. It’s nice to have a little GUI when working with shared docs and such since not everybody knows APIs. Also, scheduling repeated API calls is a great feature.

Information Security Officer

Awesome add-on that works perfectly! Couple of hours saved every month since I’m using it. Highly recommended for users who often deal with CSV exports from many platforms.

Digital CFO

API Connector is the easiest and fastest way to create an API-based website on WordPress. By pairing it with Toolset for custom fields and WP All Import to import the data, I launched a course discovery platform with no coding needed.

Founder, MadBright.com

Really nice add-on, I’m using it to pull data from iTunes and YouTube. Documentation is really clear and well-organized.


I’m using real-time data & needed a way to take a snapshot at a given time. This is perfect for what I needed. It’s very simple and user friendly to set up.


This tool is a lifesaver for our sales reporting — it saves us hours and hours. I automate our weekly reporting by connecting Google Sheets to this and then running a Tableau workbook off the automation.

Director of Digital Marketing

Connect thousands of data sources to Google Sheets. Schedule updates and automatically store historical data.

Step by Step Guides

Learn how to connect popular APIs to Google Sheets

Click here for a full listing of our step-by-step API guides and integrations.

API Connector Video Tutorials

Check out our YouTube tutorials:

Click here for the full set of YouTube tutorials.