Overview

As a non-technical user, it can be pretty perplexing when you get asked to provide your spreadsheet’s data in a JSON format. Like… How do you even begin to do that?

As a technical user, it can be pretty annoying to have to convert a spreadsheet’s data into a JSON format.

In both cases, there’s friction. Friction that can be easily solved with a Suite App Tool that will convert your Google Sheet’s data into JSON so that you can use it in API payloads to push data up from a Google Sheet and into another application. Hooray!

What You Get

With this Suite App Tool, you’ll gain the ability to select a tab in your Google Sheet and convert it into a JSON object. Your column headers become the object keys and each row in your tab will become an entry in the JSON array with each cell’s value set as the key value pair for its column header.

^ Did that make sense? It’s okay if it didn’t… Just know that you can run the converter and send it over to your software engineers. OR if you’re feeling up to it, send directly to an API!

Core Features

• Select any tab in a Google Sheet and convert it into a JSON Object Array
• One-click button to copy the entire payload into your clipboard

Premium Features

• Make an API POST request using the generated JSON Object as the payload
• Set up a daily or weekly job to automatically convert and send the data to an API endpoint

How It Works

It couldn’t be any more simple than this. Just open up the “Sheet Data to JSON Formatter” tool from your Google Sheet’s “Extensions” menu, select the tab you want to convert, and hit the convert button. Easy peezy.

If you want you send the data to an API endpoint as a POST request, that’ll require a few more steps and also authentication. Not to worry though, we’ve made that simple as well. As long as you know the API settings, you’ll be able to easily push any tab in your Google Sheet to the API endpoint.