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.

Related

Start coding in V in just 90 minutes

‘Simple, fast, safe, compiled language for developing… 

  • 10

Still a handsome devil: Raspberry Pi 4

For those who don’t know, Raspberry Pi is a low cost… 

  • 9

A unicorn friend to finish your thoughts

In February, OpenAI introduced GPT-2 (Generative… 

  • 10

Why Bolivian clocks run anti-clockwise

Clockwise motion as forward movement of time is so… 

  • 9

Make better product decisions with this…

With shifting mindset in the internet industry, product… 

  • 11

Web design at lightning fast pace using this…

Bootstrap Shuffle is a tool to help you build a layout as… 

  • 9

A design tool to test palettes on your brand…

We came across this super awesome tool to automatically… 

  • 11

Is too many choices to your software…

Alvin Toffler’s Future Shock was a brilliant book. He… 

  • 10

Welded bike chains and art

Talented artists around the world always have something to… 

  • 9

Discover interesting things to explore and do

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