A lot of spreadsheets and dashboards to display data from platforms like Shopify, Mailchimp, VWO etc. are used across the analytics industry.

Earlier, this meant finding an existing integration or manually exporting data or writing a script to extract data from APIs of individual platforms.

Today, all of this has been made super easy. API Connector is a Google Sheets add-on, made by Ana Kravitz, that greatly simplifies this situation.

All you need to do now is enter the API url along with any credentials needed to support the API request and you can view all the data in your sheet.

It allows unlimited API requests free of cost. Scheduling data extracts needs a payment plan that you can check out here.

Credits: Product Hunt on Twitter

TO DO: Use API Connector to extract data from APIs into Google Sheets.

Get The Best of Twitter in Your Inbox

We curate authentic and awesome content. Sign up for our newsletter for your daily dose of inspiration !