Google Sheets Tip: Generate a Comma-Separated List of Values From a Column

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 …

Read more

Automatically Export Your Data From Shopify to Google Sheets With EZ Exporter

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 …

Read more

How to Create a CSV or Excel Direct Download Link in Google Sheets

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 …

Read more

Manage Your Shopify Inventory From Google Sheets With EZ Inventory

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 …

Read more