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", …

Did you know that you can specify the image dimensions of your Shopify product images via its URL?  This could come in handy for generating product feeds that require specific image dimensions.

For example, you may need to generate a product feed that requires a field for the image thumbnail URL.  Instead of re-uploading the thumbnail version of the images, you can actually just add a width and height parameter directly in the original full image URL.

To demonstrate this, …

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 …

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 …

As a Shopify merchant, you probably already know that when you perform a CSV export of your products via the Shopify Admin, the product description will include all the HTML tags in the data. Our EZ Exporter app can easily strip these out.

However, there may be more complex cases where you need to go even a step further, where you need to extract specific product attributes that were entered directly in the HTML product description in Shopify. You …