Sheet Auto Connector is a Google Sheets add-on.

It helps you connect to JSON/HTTP API and import data into your Google Sheets.

Features

• Call any HTTP/JSON API
• Automatically expand JSON data
• Persist data to sheet
• Unlimited saved requests
• Unlimited runs

Installation

Install the add-on from Google marketplace.

Start the add-on by clicking menu Extensions - Auto Connector - Open…

You should see the sidebar showing up shortly.

Getting started

1. Create a new connector.

2. Configure the source

3. Configure the destination

4. Run the connector

Once the connector is saved, it’s ready to run.

Contact