You may encounter a scenario where you need to convert data from your Google Sheets spreadsheet to JSON format.  You may need this to use as input to another app or system.

For example, our EZ Exporter app supports a function that takes a raw JSON string that can be used for looking up values (like a lookup table).

JSON data can have complex nested structure but a typical format you'll see is an array that looks like this:

["Alice", "Bob", "Eve", …

Using a comma-separated list of values is a fairly common format when entering multiple values as input to a form. You might have already encountered this while managing an ad campain where you can enter a list of keywords or when needing to send a marketing email to multiple recipients.

If you already have a spreadsheet where you maintain these types of data as rows in a column, you may be wondering whether there's an easy way to convert rows …

A direct Google Sheets integrations is one of our most requested features for EZ Exporter and we're happy to announce that it's finally here!

We've had a Google Drive integration for a long time now where our users can automatically export a CSV or Excel file to a Google Drive folder.  However, we have customers who use Google Sheets heavily and prefer to have all the data they need in the same spreadsheet.

With this update, you can now do the …

As a Google Sheets user, you've probably already used the option to download the entire spreadsheet into an Excel file or a specific sheet/tab as a CSV/TSV file (under File > Download).

Did you know that you can actually create a URL that will do this for you automatically?  This way, you can share this direct download URL with others or just create a shortcut on your browser that you can click so you can auto-export the data to CSV/TSV or Excel without having …

Many merchants rely on spreadsheets to help run their businesses for good reasons:

1. They're intuitive and easy to use.
2. Pretty much everyone is familiar with them.

While there are many sophisticated tools our there for managing inventory, sometimes all you need is a simple spreadsheet.

EZ Inventory lets you easily sync your Shopify inventory from a Google Sheets spreadsheet by acting as the bridge. EZ Inventory will read the data from Google Sheets and then use that data to update …